Download Question: What is the format for the Unique Transaction Keys?

For Contract Award records, the unique transaction key is: 

• A concatenation of agencyID, Referenced IDV Agency Identifier, PIID, AwardModificationAmendmentNumber, ParentAwardId, and Transaction Number, with a single underscore ('_') character inserted in between each.
  If a field is blank, it is recorded as "-none-".
  agencyID is an FPDS field that captures the SubTier Agency that submitted the transaction to FPDS (often distinct from the awarding agency).
  
  Example: 9700_-none-FA440706C0001_P00007-none-_0.

For Contract IDV Award records, the unique transaction key is: 

• For contract IDV records, only agencyID, PIID, and AwardModificationAmendmentNumber are part of the unique key, even if additional fields in the key are present in the IDV record; the rest of the fields are recorded as "-none-" for unique key purposes.
  
  Example: 8000_-NONE-_80LARC17C0008_P00019_-NONE-_-NONE-

For Financial Assistance Award records, the unique transaction key is: 

• A concatenation of AwardingSubTierAgencyCode, FAIN, URI, CFDA_Number, and AwardModificationAmendmentNumber with a single underscore ('_') character inserted in between each. If a field is blank, it is recorded as "-none-".
  
  Example: 4900_1600823_5678_10.567_007