FPDS Query Library
About Us
Contact Us

Support Services Type Contract

Binary NASA award indicator showing whether the contract is classified as a support services type contract. A value of 1 means true and 0 means false.

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__supportServicesTypeContract
Title
Support Services Type Contract
FPDS Path
award/agencySpecificAwardElements/NASASpecificAwardElements/supportServicesTypeContract
Description
Binary NASA award indicator showing whether the contract is classified as a support services type contract. A value of 1 means true and 0 means false.
Business Meaning
This flag helps analysts identify NASA awards that are structured as support services contracts, which is useful for mission support spend analysis, contract-type segmentation, and reviewing trends in outsourced operational support. It can also help isolate awards for compliance, portfolio management, and workload classification within NASA-specific procurement reporting.
Example Value
1
Observed Non-Null Count
697,115

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter NASA awards that are support services contracts
  • Segment awards for mission support spend analysis
  • Group NASA procurement records by support services classification

Common Mistakes

  • Interpreting the numeric value as an amount or count
  • Using the field outside NASA-specific award analysis without checking applicability

Query Guidance

Use equality predicates such as `= 1` or `= 0` on this numeric flag. If you need a clean boolean measure, map 1 to true and 0 to false, and exclude or explicitly handle nulls when computing rates or counts.

SQL Examples

Preview values

SELECT
    content__award__agencySpecificAwardElements__NASASpecificAwardElements__supportServicesTypeContract AS support_services_type_contract
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__supportServicesTypeContract IS NOT NULL
LIMIT 25

Aggregate total

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

Distribution overview

SELECT
    min(content__award__agencySpecificAwardElements__NASASpecificAwardElements__supportServicesTypeContract) AS min_value,
    avg(content__award__agencySpecificAwardElements__NASASpecificAwardElements__supportServicesTypeContract) AS avg_value,
    max(content__award__agencySpecificAwardElements__NASASpecificAwardElements__supportServicesTypeContract) AS max_value,
    count() AS record_count
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__supportServicesTypeContract 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.