FPDS Query Library
About Us
Contact Us

Agency Id

Identifier for the agency associated with the referenced IDV contract in the award record. It is a coded agency value, not a narrative name, and should be treated as the key used to link the award to the issuing or referenced agency.

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__agencyID
Title
Agency Id
FPDS Path
award/awardID/referencedIDVID/agencyID
Description
Identifier for the agency associated with the referenced IDV contract in the award record. It is a coded agency value, not a narrative name, and should be treated as the key used to link the award to the issuing or referenced agency.
Business Meaning
This field supports analysis of which federal agency owns or issued the underlying IDV that an award points to. Analysts use it to attribute obligations, study interagency use of vehicles, and group related awards by agency for portfolio, sourcing, and competition analysis.
Example Value
9700
Observed Non-Null Count
82,604,590

FPDS Compare

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

Use Cases

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

Common Usage

  • Link referenced IDVs to the issuing agency
  • Group awards by agency of the parent vehicle
  • Filter awards for agency-level spending analysis

Common Mistakes

  • Treating the code as the awarding office instead of the referenced IDV agency
  • Aggregating without validating the code against the agency lookup or code set

Query Guidance

Use this field as a join key or filter on agency code values, and map it to an agency reference table for display or grouping. In SQL, compare on the exact code format stored in the source and avoid text matching unless you have already normalized the identifier.

SQL Examples

Preview values

SELECT
    content__award__awardID__referencedIDVID__agencyID AS agency_id
FROM fpds.data
WHERE content__award__awardID__referencedIDVID__agencyID IS NOT NULL
LIMIT 25

Top values

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