FPDS Query Library
About Us
Contact Us

Agency Id Name

Human-readable name of the agency associated with the referenced IDV contract in the nested contract identification structure. This is the label portion of a coded agency reference, not the underlying agency code or identifier.

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

Variable Overview

FPDS Query Variable
content__IDV__contractID__referencedIDVID__agencyID__name
Title
Agency Id Name
FPDS Path
IDV/contractID/referencedIDVID/agencyID/name
Description
Human-readable name of the agency associated with the referenced IDV contract in the nested contract identification structure. This is the label portion of a coded agency reference, not the underlying agency code or identifier.
Business Meaning
This field lets analysts attribute the referenced IDV to the correct agency in reporting, portfolio analysis, and cross-agency spending reviews. It is useful for grouping obligations and award relationships by agency name when the coded agency key is not directly analyst-friendly.
Example Value
FEDERAL ACQUISITION SERVICE
Observed Non-Null Count
133,244

FPDS Compare

FPDS Query Variable
content__IDV__contractID__referencedIDVID__agencyID__name
FPDS XML Path
IDV/contractID/referencedIDVID/agencyID/name
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/contractID/referencedIDVID/agencyID/name' into the SQL-ready variable 'content__IDV__contractID__referencedIDVID__agencyID__name'.

Use Cases

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

Common Usage

  • Display the contracting or referenced agency name in reports
  • Group IDV records by agency for spend or award analysis
  • Validate the readable label against the agency code or identifier

Common Mistakes

  • Using the name field as a stable join key instead of the agency code or ID
  • Assuming the text is standardized across all records and time periods

Query Guidance

Select this field for labeling, filtering, or aggregation by agency name, but join and de-duplicate on the related agency identifier fields when possible. In SQL, normalize case and trim whitespace if comparing text values, and expect multiple textual variants for the same agency.

SQL Examples

Preview values

SELECT
    content__IDV__contractID__referencedIDVID__agencyID__name AS agency_id_name
FROM fpds.data
WHERE content__IDV__contractID__referencedIDVID__agencyID__name IS NOT NULL
LIMIT 25

Top values

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