FPDS Query Library
About Us
Contact Us

Mod Number

Modification number assigned to the referenced IDV within an Other Transaction Award record. It identifies the specific revision or amendment sequence for that base instrument, such as an incremented award modification code.

Family: Other Transaction Award
Category: Referenced IDV
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__OtherTransactionAwardID__referencedIDVID__modNumber
Title
Mod Number
FPDS Path
OtherTransactionAward/OtherTransactionAwardID/referencedIDVID/modNumber
Description
Modification number assigned to the referenced IDV within an Other Transaction Award record. It identifies the specific revision or amendment sequence for that base instrument, such as an incremented award modification code.
Business Meaning
This field is used to distinguish one modification of a referenced IDV from another, which is essential for reconstructing award history, identifying the latest action, and linking transactions to the correct version of the underlying agreement. In procurement analysis, it supports timeline analysis, obligation tracking, and de-duplication of related award records.
Example Value
P00008
Observed Non-Null Count
7,585

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__OtherTransactionAwardID__referencedIDVID__modNumber
FPDS XML Path
OtherTransactionAward/OtherTransactionAwardID/referencedIDVID/modNumber
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/OtherTransactionAwardID/referencedIDVID/modNumber' into the SQL-ready variable 'content__OtherTransactionAward__OtherTransactionAwardID__referencedIDVID__modNumber'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building

Common Usage

  • Identify the specific modification of a referenced IDV
  • Group or sequence award history for the same base instrument
  • Join to other award fields that reference the same IDV and modification

Common Mistakes

  • Treating the value as a number and stripping leading zeros or letters
  • Assuming it is the award number rather than the modification identifier

Query Guidance

Use exact string matching for joins, filters, and deduplication. In SQL, compare this field as VARCHAR/TEXT, and when determining the latest modification for an IDV, pair it with the base IDV identifier and a date field or parsed sequence logic instead of relying on this field alone.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__OtherTransactionAwardID__referencedIDVID__modNumber AS mod_number
FROM fpds.data
WHERE content__OtherTransactionAward__OtherTransactionAwardID__referencedIDVID__modNumber IS NOT NULL
LIMIT 25

Top values

SELECT
    content__OtherTransactionAward__OtherTransactionAwardID__referencedIDVID__modNumber AS value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__OtherTransactionAwardID__referencedIDVID__modNumber IS NOT NULL
GROUP BY value
ORDER BY record_count DESC
LIMIT 25

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.