FPDS Query Library
About Us
Contact Us

Funding Requesting Agency Id Name

Human-readable name of the funding requesting agency associated with the Other Transaction Award record. This is the descriptive label for the agency identifier in the purchaser information section, such as "DEPT OF THE ARMY".

Family: Other Transaction Award
Category: Purchaser Information
Data Type: string
Semantic Type: label
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__name
Title
Funding Requesting Agency Id Name
FPDS Path
OtherTransactionAward/contractDetail/purchaserInformation/fundingRequestingAgencyID/name
Description
Human-readable name of the funding requesting agency associated with the Other Transaction Award record. This is the descriptive label for the agency identifier in the purchaser information section, such as "DEPT OF THE ARMY".
Business Meaning
This field identifies which federal organization requested or funded the transaction, allowing analysts to attribute spending, obligations, and award activity to the responsible agency. It is useful for portfolio analysis, agency-level reporting, and distinguishing the funding source from the awarding or contracting entity.
Example Value
DEPT OF THE ARMY
Observed Non-Null Count
38,062

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__name
FPDS XML Path
OtherTransactionAward/contractDetail/purchaserInformation/fundingRequestingAgencyID/name
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/purchaserInformation/fundingRequestingAgencyID/name' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__name'.

Use Cases

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

Common Usage

  • Agency-level rollups of OT award activity by funding source
  • Filtering records to a specific requesting agency using the readable agency name
  • Validating or interpreting the coded funding requesting agency identifier

Common Mistakes

  • Using the name as a stable join key instead of the underlying agency code
  • Assuming the field always matches the awarding agency or contracting office

Query Guidance

Use this field for display, grouping, or text-based filtering, but join and deduplicate on the paired agency ID when possible. In SQL, normalize case and trim whitespace for reporting, and prefer the coded identifier for exact matching while retaining this name for readable output.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__name AS funding_requesting_agency_id_name
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__name IS NOT NULL
LIMIT 25

Top values

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