FPDS Query Library
About Us
Contact Us

Contract Administration Delegated

Human-readable value for NASA-specific contract administration delegated in the award record. This is typically a coded or abbreviated attribute that identifies the delegated contract administration arrangement associated with the award.

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

Variable Overview

FPDS Query Variable
content__award__agencySpecificAwardElements__NASASpecificAwardElements__listOfContractAdministrationsDelegated__contractAdministrationDelegated
Title
Contract Administration Delegated
FPDS Path
award/agencySpecificAwardElements/NASASpecificAwardElements/listOfContractAdministrationsDelegated/contractAdministrationDelegated
Description
Human-readable value for NASA-specific contract administration delegated in the award record. This is typically a coded or abbreviated attribute that identifies the delegated contract administration arrangement associated with the award.
Business Meaning
It helps analysts identify when NASA delegated contract administration responsibilities and to distinguish those awards from contracts administered directly by NASA. This can affect oversight, performance tracking, workload attribution, and interpretation of agency-specific award processing.
Example Value
J
Observed Non-Null Count
166,160

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter NASA awards with delegated contract administration
  • Group awards by delegated administration status
  • Support QA checks against NASA-specific award elements

Common Mistakes

  • Interpreting the value as a general contract administration narrative instead of a coded attribute
  • Using the field without checking the actual code/label set for the reporting period

Query Guidance

Use this field in WHERE clauses to isolate NASA awards with a specific delegated administration value, and in SELECT/GROUP BY when segmenting by administration arrangement. If the dataset includes a companion description field, join or display it alongside the code; otherwise, verify meaning through the observed distinct values before aggregating.

SQL Examples

Preview values

SELECT
    content__award__agencySpecificAwardElements__NASASpecificAwardElements__listOfContractAdministrationsDelegated__contractAdministrationDelegated AS contract_administration_delegated
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__listOfContractAdministrationsDelegated__contractAdministrationDelegated IS NOT NULL
LIMIT 25

Top values

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