FPDS Query Library
About Us
Contact Us

Mod Number

Modification number for the referenced IDV associated with the award. It identifies the specific version of the umbrella/interagency vehicle being cited in the award record.

Family: Award
Category: Award Identification
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__awardID__referencedIDVID__modNumber
Title
Mod Number
FPDS Path
award/awardID/referencedIDVID/modNumber
Description
Modification number for the referenced IDV associated with the award. It identifies the specific version of the umbrella/interagency vehicle being cited in the award record.
Business Meaning
This field helps analysts tie an order or other award action back to the correct modification state of the underlying IDV, which is important for lineage, timeline reconstruction, and determining which contract version was in effect when the award was made.
Observed Non-Null Count
82,604,590

FPDS Compare

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

Use Cases

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

Common Usage

  • Linking awards to the correct IDV version
  • Reconstructing modification history for umbrella vehicles
  • Filtering or grouping awards by referenced IDV version

Common Mistakes

  • Confusing this value with the award's own modification number
  • Using it alone without the referenced IDV identifier

Query Guidance

Use this field as a join or grouping key only in combination with the referenced IDV ID. In SQL, compare it as a text/code value rather than a numeric measure unless the source data is consistently numeric; when deduplicating or versioning records, include both the referenced IDV and mod number in the key.

SQL Examples

Preview values

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

Top values

SELECT
    content__award__awardID__referencedIDVID__modNumber AS value,
    count() AS record_count
FROM fpds.data
WHERE content__award__awardID__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.