FPDS Query Library
About Us
Contact Us

Multi Year Contract Description

Human-readable description for the paired coded field indicating whether the IDV is a multi-year contract. It records the explanatory label for the multi-year contract status rather than the underlying code itself.

Family: IDV
Category: Contract Data
Data Type: string
Semantic Type: description
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__contractData__multiYearContract__description
Title
Multi Year Contract Description
FPDS Path
IDV/contractData/multiYearContract/description
Description
Human-readable description for the paired coded field indicating whether the IDV is a multi-year contract. It records the explanatory label for the multi-year contract status rather than the underlying code itself.
Business Meaning
This field helps analysts interpret the contract structure reported in FPDS, especially when assessing funding profile, obligation timing, and award term characteristics. It provides readable context for a coded procurement attribute that can affect how long the government is committed and how award data should be segmented.
Example Value
NO
Observed Non-Null Count
4,355,975

FPDS Compare

FPDS Query Variable
content__IDV__contractData__multiYearContract__description
FPDS XML Path
IDV/contractData/multiYearContract/description
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/contractData/multiYearContract/description' into the SQL-ready variable 'content__IDV__contractData__multiYearContract__description'.

Use Cases

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

Common Usage

  • Translate the multi-year contract indicator into readable output for reports
  • Validate whether an IDV is reported as multi-year when analyzing award terms
  • Join with the coded multi-year field to present code plus description in dashboards

Common Mistakes

  • Using the description field as if it were the authoritative code for filtering
  • Assuming a short value like NO is the full business rule rather than the label for the paired indicator

Query Guidance

Use this field for display and validation, not primary filtering. In SQL, filter on the paired coded multi-year indicator when possible, and select this description alongside it for readability; when values are inconsistent or abbreviated, review distinct values and pair them with the source code before analysis.

SQL Examples

Preview values

SELECT
    content__IDV__contractData__multiYearContract__description AS multi_year_contract_description
FROM fpds.data
WHERE content__IDV__contractData__multiYearContract__description IS NOT NULL
LIMIT 25

Top values

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