FPDS Query Library
About Us
Contact Us

Foreign Funding

Indicates whether the award involves foreign funding support in the purchaser information section. In this data element, "X" means the condition is not applicable, so the field functions as a flag rather than a simple yes/no label in every record.

Family: Award
Category: Purchaser Information
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__purchaserInformation__foreignFunding
Title
Foreign Funding
FPDS Path
award/purchaserInformation/foreignFunding
Description
Indicates whether the award involves foreign funding support in the purchaser information section. In this data element, "X" means the condition is not applicable, so the field functions as a flag rather than a simple yes/no label in every record.
Business Meaning
This field helps analysts identify awards affected by foreign financial participation, which can be relevant to compliance review, sourcing analysis, and oversight of funding restrictions. It is useful for segmenting awards that may carry different reporting, legal, or eligibility considerations than fully domestic-funded procurements.
Example Value
X
Observed Non-Null Count
111,474,919

FPDS Compare

FPDS Query Variable
content__award__purchaserInformation__foreignFunding
FPDS XML Path
award/purchaserInformation/foreignFunding
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/purchaserInformation/foreignFunding' into the SQL-ready variable 'content__award__purchaserInformation__foreignFunding'.

Use Cases

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

Common Usage

  • Filter awards with foreign funding involvement
  • Exclude not-applicable records from compliance counts
  • Segment procurement records for funding-source analysis

Common Mistakes

  • Assuming X means yes instead of not applicable
  • Using the field without checking how null or blank values are stored

Query Guidance

Use explicit value logic in SQL, for example `WHERE foreignFunding IN ('Y','1')` only if those codes are confirmed in your extract, and separately handle `X`, null, and blank as non-positive or not-applicable states. Do not rely on truthy/falsey evaluation; map observed codes to business meanings before aggregating.

SQL Examples

Preview values

SELECT
    content__award__purchaserInformation__foreignFunding AS foreign_funding
FROM fpds.data
WHERE content__award__purchaserInformation__foreignFunding IS NOT NULL
LIMIT 25

Flag distribution

SELECT
    content__award__purchaserInformation__foreignFunding AS flag_value,
    count() AS record_count
FROM fpds.data
WHERE content__award__purchaserInformation__foreignFunding IS NOT NULL
GROUP BY flag_value
ORDER BY record_count DESC

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.