FPDS Query Library
About Us
Contact Us

Mod Number

This field stores the modification number assigned to an IDV contract action. It identifies the specific amendment or revision sequence for the IDV record, with values such as "0" typically indicating the initial award version.

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

Variable Overview

FPDS Query Variable
content__IDV__contractID__IDVID__modNumber
Title
Mod Number
FPDS Path
IDV/contractID/IDVID/modNumber
Description
This field stores the modification number assigned to an IDV contract action. It identifies the specific amendment or revision sequence for the IDV record, with values such as "0" typically indicating the initial award version.
Business Meaning
Modification numbers let analysts distinguish the base IDV from later changes, which is essential for tracking award history, reconstructing contract evolution, and avoiding double counting when aggregating obligation or award data across actions.
Observed Non-Null Count
5,862,557

FPDS Compare

FPDS Query Variable
content__IDV__contractID__IDVID__modNumber
FPDS XML Path
IDV/contractID/IDVID/modNumber
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/contractID/IDVID/modNumber' into the SQL-ready variable 'content__IDV__contractID__IDVID__modNumber'.

Use Cases

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

Common Usage

  • Identify the initial IDV record versus later modifications
  • Deduplicate or sequence contract actions within the same IDV
  • Track award and amendment history over time

Common Mistakes

  • Summing values as if the field were a measure
  • Treating different modification numbers as separate contracts rather than versions of the same IDV

Query Guidance

Use it as a partitioning or ordering field with the IDV contract identifier, for example in window functions to rank the latest modification by action date or mod number. Filter on the desired version when building point-in-time analyses, and avoid aggregating across all modification numbers unless you intend to analyze the full modification history.

SQL Examples

Preview values

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

Top values

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