FPDS Query Library
About Us
Contact Us

Undefinitized Action Description

Human-readable text that explains the coded "Undefinitized Action" value recorded for an award. It is the descriptive label paired with the underlying code or abbreviated source value, not the code itself.

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

Variable Overview

FPDS Query Variable
content__award__contractData__undefinitizedAction__description
Title
Undefinitized Action Description
FPDS Path
award/contractData/undefinitizedAction/description
Description
Human-readable text that explains the coded "Undefinitized Action" value recorded for an award. It is the descriptive label paired with the underlying code or abbreviated source value, not the code itself.
Business Meaning
This field helps analysts interpret whether an award includes an undefinitized action and understand the specific meaning of the coded procurement entry. It is useful for validating contract actions, reviewing award status, and distinguishing substantive undefinitized action records from other contract data entries.
Example Value
NO
Observed Non-Null Count
111,326,600

FPDS Compare

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

Use Cases

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

Common Usage

  • Decoding the underlying Undefinitized Action code
  • Filtering awards with undefinitized action-related contract data
  • Displaying a readable label in reports and dashboards

Common Mistakes

  • Using the description field as if it were the authoritative code
  • Assuming short values like 'NO' are complete business definitions without checking the paired field

Query Guidance

Use this field primarily for joins, decoding, and presentation. In SQL, filter on the associated coded Undefinitized Action field when identifying records, and select this description field for human-readable output; avoid relying on free-text matching unless you have normalized observed values.

SQL Examples

Preview values

SELECT
    content__award__contractData__undefinitizedAction__description AS undefinitized_action_description
FROM fpds.data
WHERE content__award__contractData__undefinitizedAction__description IS NOT NULL
LIMIT 25

Top values

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