FPDS Query Library
About Us
Contact Us

Cfda Program Identification Number

Numeric NASA-specific CFDA program identifier recorded on the award. It identifies the assistance program associated with the award within NASA agency-specific award elements.

Family: Award
Category: General
Data Type: numeric
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__agencySpecificAwardElements__NASASpecificAwardElements__CFDAProgramIdentificationNumber
Title
Cfda Program Identification Number
FPDS Path
award/agencySpecificAwardElements/NASASpecificAwardElements/CFDAProgramIdentificationNumber
Description
Numeric NASA-specific CFDA program identifier recorded on the award. It identifies the assistance program associated with the award within NASA agency-specific award elements.
Business Meaning
This field helps analysts tie NASA awards to the underlying federal assistance program, enabling program-level rollups, compliance checks, and crosswalks to other federal spending datasets. It is useful for distinguishing awards that belong to different cataloged program lines when evaluating distribution, concentration, or mission-area funding patterns.
Example Value
43
Observed Non-Null Count
57,928

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter NASA awards by assistance program
  • Group awards for program-level spend analysis
  • Crosswalk NASA awards to CFDA/Catalog program references

Common Mistakes

  • Assuming the number is a dollar amount or award count
  • Using the code without validating the matching program description or reference table

Query Guidance

Use in WHERE clauses for program filtering and in GROUP BY for program rollups; join to a reference or description field when available to interpret the code. If the column is stored as numeric, preserve exact equality checks and avoid range logic unless the business definition explicitly supports it.

SQL Examples

Preview values

SELECT
    content__award__agencySpecificAwardElements__NASASpecificAwardElements__CFDAProgramIdentificationNumber AS cfda_program_identification_number
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__CFDAProgramIdentificationNumber IS NOT NULL
LIMIT 25

Aggregate total

SELECT
    sum(content__award__agencySpecificAwardElements__NASASpecificAwardElements__CFDAProgramIdentificationNumber) AS total_value
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__CFDAProgramIdentificationNumber IS NOT NULL

Distribution overview

SELECT
    min(content__award__agencySpecificAwardElements__NASASpecificAwardElements__CFDAProgramIdentificationNumber) AS min_value,
    avg(content__award__agencySpecificAwardElements__NASASpecificAwardElements__CFDAProgramIdentificationNumber) AS avg_value,
    max(content__award__agencySpecificAwardElements__NASASpecificAwardElements__CFDAProgramIdentificationNumber) AS max_value,
    count() AS record_count
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__CFDAProgramIdentificationNumber IS NOT NULL

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