FPDS Query Library
About Us
Contact Us

Mod Number

Modification number assigned to an Other Transaction Award contract action. It identifies the specific amendment or change associated with the base award, such as the initial award, incremented modifications, or administrative updates.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__OtherTransactionAwardID__OtherTransactionAwardContractID__modNumber
Title
Mod Number
FPDS Path
OtherTransactionAward/OtherTransactionAwardID/OtherTransactionAwardContractID/modNumber
Description
Modification number assigned to an Other Transaction Award contract action. It identifies the specific amendment or change associated with the base award, such as the initial award, incremented modifications, or administrative updates.
Business Meaning
This field is essential for reconstructing award history, distinguishing the base transaction from subsequent changes, and analyzing how an Other Transaction evolves over time. It supports counting modifications, sequencing actions, and identifying whether obligations, scope, or terms changed across award versions.
Example Value
P00001
Observed Non-Null Count
38,894

FPDS Compare

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

Use Cases

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

Common Usage

  • Sequence award actions within an Other Transaction record
  • Count modifications per award or vendor
  • Distinguish base awards from subsequent modifications

Common Mistakes

  • Treating the value as a numeric field and dropping leading zeros
  • Assuming the highest value always means the latest action without checking record ordering or award lineage

Query Guidance

Use it as a string key in filters, joins, and window functions; do not cast unless you normalize the format first. For modification analysis, partition by the parent award identifier and order by this field alongside action date to identify the sequence of changes.

SQL Examples

Preview values

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

Top values

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