FPDS Query Library
About Us
Contact Us

Contract Fund Code

NASA-specific code recorded on the award to identify the contract fund designation used for that action. It is an identifier/code field, not a free-text description, and the displayed value may be abbreviated or single-character coded.

Family: Award
Category: General
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__agencySpecificAwardElements__NASASpecificAwardElements__contractFundCode
Title
Contract Fund Code
FPDS Path
award/agencySpecificAwardElements/NASASpecificAwardElements/contractFundCode
Description
NASA-specific code recorded on the award to identify the contract fund designation used for that action. It is an identifier/code field, not a free-text description, and the displayed value may be abbreviated or single-character coded.
Business Meaning
This field helps analysts segment NASA awards by fund source or funding designation for compliance review, funding analysis, and portfolio reporting. It can support identification of which obligations are tied to a specific NASA fund structure when standard FPDS fields are not sufficient.
Example Value
F
Observed Non-Null Count
703,055

FPDS Compare

FPDS Query Variable
content__award__agencySpecificAwardElements__NASASpecificAwardElements__contractFundCode
FPDS XML Path
award/agencySpecificAwardElements/NASASpecificAwardElements/contractFundCode
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/agencySpecificAwardElements/NASASpecificAwardElements/contractFundCode' into the SQL-ready variable 'content__award__agencySpecificAwardElements__NASASpecificAwardElements__contractFundCode'.

Use Cases

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

Common Usage

  • Filter NASA awards by funding designation
  • Join to a NASA code reference table or lookup
  • Group awards for funding source analysis

Common Mistakes

  • Assuming the code is a plain-language description
  • Using the field without validating the agency-specific code set

Query Guidance

Use exact-match filtering or joins on the coded value, and preserve the raw code in group-by logic. If the dataset includes both code and description fields, select and display the paired description for interpretation; otherwise, map the code through an external NASA lookup table before reporting.

SQL Examples

Preview values

SELECT
    content__award__agencySpecificAwardElements__NASASpecificAwardElements__contractFundCode AS contract_fund_code
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__contractFundCode IS NOT NULL
LIMIT 25

Top values

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