FPDS Query Library
About Us
Contact Us

Administrator Code

Code assigned within NASA-specific award elements to identify the award administrator associated with the procurement record. It is a coded identifier, not a narrative description, and values may be abbreviated or agency-defined.

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__administratorCode
Title
Administrator Code
FPDS Path
award/agencySpecificAwardElements/NASASpecificAwardElements/administratorCode
Description
Code assigned within NASA-specific award elements to identify the award administrator associated with the procurement record. It is a coded identifier, not a narrative description, and values may be abbreviated or agency-defined.
Business Meaning
This field helps analysts attribute awards to the correct NASA administrative office or responsible official, which supports workload tracking, oversight, and internal reporting. It can also be useful for segmenting NASA awards by administrative responsibility when reviewing execution patterns or management activity.
Example Value
AAA
Observed Non-Null Count
825,794

FPDS Compare

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

Use Cases

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

Common Usage

  • grouping NASA awards by administrator code
  • filtering records for a specific NASA administrative office or official
  • reviewing award administration patterns within NASA-specific reporting

Common Mistakes

  • interpreting the code as a descriptive category instead of an identifier
  • assuming the code has the same meaning outside NASA or across all FPDS data

Query Guidance

Use this field in WHERE clauses or GROUP BY operations as a coded identifier, and join to a lookup or code table if available to recover the human-readable meaning. When analyzing trends, validate distinct values first and avoid hard-coding assumptions about code semantics unless the mapping has been verified.

SQL Examples

Preview values

SELECT
    content__award__agencySpecificAwardElements__NASASpecificAwardElements__administratorCode AS administrator_code
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__administratorCode IS NOT NULL
LIMIT 25

Top values

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