FPDS Query Library
About Us
Contact Us

Commercial Item Test Program Description

Human-readable description paired with the coded Commercial Item Test Program indicator. It provides the text label or explanation of the program value recorded for the award's competition data.

Family: Award
Category: Competition
Data Type: string
Semantic Type: description
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__competition__commercialItemTestProgram__description
Title
Commercial Item Test Program Description
FPDS Path
award/competition/commercialItemTestProgram/description
Description
Human-readable description paired with the coded Commercial Item Test Program indicator. It provides the text label or explanation of the program value recorded for the award's competition data.
Business Meaning
This field helps analysts interpret whether an award was associated with the Commercial Item Test Program without relying only on the underlying code or abbreviated value. It supports cleaner reporting on competition methods, acquisition policy application, and commercial-item-related procurement activity.
Example Value
NO
Observed Non-Null Count
108,542,454

FPDS Compare

FPDS Query Variable
content__award__competition__commercialItemTestProgram__description
FPDS XML Path
award/competition/commercialItemTestProgram/description
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/competition/commercialItemTestProgram/description' into the SQL-ready variable 'content__award__competition__commercialItemTestProgram__description'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Competition and sole-source analysis

Common Usage

  • Interpreting commercial item test program indicators
  • Validating coded competition fields
  • Filtering awards tied to specific acquisition policy conditions

Common Mistakes

  • Using the description field as if it were the authoritative code
  • Grouping values without checking the paired indicator field

Query Guidance

Use this field for display, validation, and text-based review; use the paired code field for joins, filters, and aggregations. In SQL, select it alongside the coded Commercial Item Test Program field, and standardize on the code when building metrics while retaining the description for QA or reporting output.

SQL Examples

Preview values

SELECT
    content__award__competition__commercialItemTestProgram__description AS commercial_item_test_program_description
FROM fpds.data
WHERE content__award__competition__commercialItemTestProgram__description IS NOT NULL
LIMIT 25

Top values

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