FPDS Query Library
About Us
Contact Us

Contract Administration Delegated

A NASA-specific string field that records the contract administration delegated for the IDV. The example value "A" indicates the field may store a coded or abbreviated value rather than a free-text description.

Family: IDV
Category: NASA Specific Fields
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__listOfContractAdministrationsDelegated__contractAdministrationDelegated
Title
Contract Administration Delegated
FPDS Path
IDV/agencySpecificIDVElements/NASASpecificIDVElements/listOfContractAdministrationsDelegated/contractAdministrationDelegated
Description
A NASA-specific string field that records the contract administration delegated for the IDV. The example value "A" indicates the field may store a coded or abbreviated value rather than a free-text description.
Business Meaning
This field helps analysts identify whether and how contract administration responsibilities were delegated within NASA-related IDVs. It supports segmentation of awards, workload allocation analysis, and interpretation of administrative responsibility across contracting entities.
Example Value
A
Observed Non-Null Count
10,519

FPDS Compare

FPDS Query Variable
content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__listOfContractAdministrationsDelegated__contractAdministrationDelegated
FPDS XML Path
IDV/agencySpecificIDVElements/NASASpecificIDVElements/listOfContractAdministrationsDelegated/contractAdministrationDelegated
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/agencySpecificIDVElements/NASASpecificIDVElements/listOfContractAdministrationsDelegated/contractAdministrationDelegated' into the SQL-ready variable 'content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__listOfContractAdministrationsDelegated__contractAdministrationDelegated'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • NASA-specific IDV record interpretation

Common Usage

  • Filter NASA IDVs by delegated contract administration status
  • Group awards by delegation pattern for workload analysis
  • Join to code descriptions or reference tables for readable reporting

Common Mistakes

  • Interpreting the raw string as a full narrative description
  • Using the field without checking whether blank values mean not reported or not applicable

Query Guidance

Use this field as a categorical filter or grouping key in SQL, and join to a code reference or decode logic when producing analyst-facing outputs. If values are abbreviated, map them to their meanings before aggregating; otherwise, counts will be technically correct but not operationally interpretable.

SQL Examples

Preview values

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

Top values

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