FPDS Query Library
About Us
Contact Us

Type of IDC Description

Human-readable text that describes the coded IDC type stored in the paired 'Type of IDC' field. It is the label version of the underlying code, such as 'INDEFINITE DELIVERY / INDEFINITE QUANTITY,' and is used to make the contract type understandable without decoding abbreviations.

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__typeOfIDC__description
Title
Type of IDC Description
FPDS Path
IDV/contractData/typeOfIDC/description
Description
Human-readable text that describes the coded IDC type stored in the paired 'Type of IDC' field. It is the label version of the underlying code, such as 'INDEFINITE DELIVERY / INDEFINITE QUANTITY,' and is used to make the contract type understandable without decoding abbreviations.
Business Meaning
This field helps analysts classify indefinite delivery contract vehicles consistently across awards and reporting extracts. It supports contract-type analysis, portfolio segmentation, and validation of coded procurement data when reviewing IDVs.
Example Value
INDEFINITE DELIVERY / INDEFINITE QUANTITY
Observed Non-Null Count
2,049,371

FPDS Compare

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

Use Cases

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

Common Usage

  • Display readable contract type labels in reports and dashboards
  • Validate or interpret the paired 'Type of IDC' code
  • Group IDVs by contract vehicle description for summary analysis

Common Mistakes

  • Using the description as if it were the primary coded key
  • Grouping solely on free-text labels without checking the paired code or source variations

Query Guidance

Select this field when you need a readable label for the IDC type, and join or filter on the paired code field when possible. If the dataset contains inconsistent capitalization, spacing, or punctuation, normalize the text or aggregate by the coded field first, then use this description for presentation.

SQL Examples

Preview values

SELECT
    content__IDV__contractData__typeOfIDC__description AS type_of_i_d_c_description
FROM fpds.data
WHERE content__IDV__contractData__typeOfIDC__description IS NOT NULL
LIMIT 25

Top values

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