FPDS Query Library
About Us
Contact Us

Funding Requesting Agency Id

Identifier for the agency that is requesting or funding the requirement associated with an Other Transaction award. It is a coded value, not a narrative name, and should be treated as a reference key to an agency entity or reporting structure.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID
Title
Funding Requesting Agency Id
FPDS Path
OtherTransactionAward/contractDetail/purchaserInformation/fundingRequestingAgencyID
Description
Identifier for the agency that is requesting or funding the requirement associated with an Other Transaction award. It is a coded value, not a narrative name, and should be treated as a reference key to an agency entity or reporting structure.
Business Meaning
This field helps analysts trace which federal organization originated or supported the funding request behind an Other Transaction action. It is useful for attributing demand, understanding interagency funding arrangements, and grouping awards by originating agency rather than by the awarding organization alone.
Example Value
1700
Observed Non-Null Count
38,062

FPDS Compare

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

Use Cases

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

Common Usage

  • Group awards by requesting or funding agency
  • Join to agency reference or crosswalk tables
  • Filter transactions involving a specific originating agency

Common Mistakes

  • Treating the code as the agency name
  • Confusing the funding/requesting agency with the awarding agency

Query Guidance

Use this field as a join key or filter predicate, for example in WHERE clauses and GROUP BY operations. When presenting results, map the code to an agency label through a lookup table so output is interpretable and consistent.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID AS funding_requesting_agency_id
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID IS NOT NULL
LIMIT 25

Top values

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