FPDS Query Library
About Us
Contact Us

Agency Identifier

A coded identifier for the federal agency associated with the Treasury account linked to the IDV. It is a component of the treasury account symbol and typically appears as a short numeric or alphanumeric code rather than a full agency name.

Family: IDV
Category: Contract Data
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__contractData__listOfTreasuryAccounts__treasuryAccount__treasuryAccountSymbol__agencyIdentifier
Title
Agency Identifier
FPDS Path
IDV/contractData/listOfTreasuryAccounts/treasuryAccount/treasuryAccountSymbol/agencyIdentifier
Description
A coded identifier for the federal agency associated with the Treasury account linked to the IDV. It is a component of the treasury account symbol and typically appears as a short numeric or alphanumeric code rather than a full agency name.
Business Meaning
This field helps analysts attribute obligations and funding relationships to the correct agency when reviewing interagency activity, shared funding arrangements, and IDV structure. It is useful for grouping awards by funding agency, reconciling Treasury account information, and separating the awarding office from the agency tied to the account.
Example Value
19
Observed Non-Null Count
748,285

FPDS Compare

FPDS Query Variable
content__IDV__contractData__listOfTreasuryAccounts__treasuryAccount__treasuryAccountSymbol__agencyIdentifier
FPDS XML Path
IDV/contractData/listOfTreasuryAccounts/treasuryAccount/treasuryAccountSymbol/agencyIdentifier
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/contractData/listOfTreasuryAccounts/treasuryAccount/treasuryAccountSymbol/agencyIdentifier' into the SQL-ready variable 'content__IDV__contractData__listOfTreasuryAccounts__treasuryAccount__treasuryAccountSymbol__agencyIdentifier'.

Use Cases

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

Common Usage

  • Group IDVs by funding or account-holding agency
  • Join to agency reference tables for label expansion
  • Filter awards tied to specific Treasury account agency codes

Common Mistakes

  • Using it as the contracting agency name without validation
  • Interpreting the code without the rest of the treasury account symbol

Query Guidance

Use this field as a join key or filter on the agency code value, and combine it with the full treasury account symbol when possible. In SQL, keep it as a string to preserve leading zeros or formatting, and do not compare it directly to agency names unless you have a lookup table.

SQL Examples

Preview values

SELECT
    content__IDV__contractData__listOfTreasuryAccounts__treasuryAccount__treasuryAccountSymbol__agencyIdentifier AS agency_identifier
FROM fpds.data
WHERE content__IDV__contractData__listOfTreasuryAccounts__treasuryAccount__treasuryAccountSymbol__agencyIdentifier IS NOT NULL
LIMIT 25

Top values

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