FPDS Query Library
About Us
Contact Us

Extent Competed Description

Human-readable text that describes the value recorded for the paired Extent Competed field on an Other Transaction IDV record. It is the descriptive label, not the underlying code, and captures how the competition extent was reported in the source data.

Family: Other Transaction IDV
Category: Competition
Data Type: string
Semantic Type: description
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__competition__extentCompeted__description
Title
Extent Competed Description
FPDS Path
OtherTransactionIDV/contractDetail/competition/extentCompeted/description
Description
Human-readable text that describes the value recorded for the paired Extent Competed field on an Other Transaction IDV record. It is the descriptive label, not the underlying code, and captures how the competition extent was reported in the source data.
Business Meaning
This field helps procurement analysts interpret competition data without relying only on abbreviated or coded values. It supports validation of competition reporting and improves the readability of analysis on how broadly an award was competed.
Example Value
COMPETED
Observed Non-Null Count
13,417

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__competition__extentCompeted__description
FPDS XML Path
OtherTransactionIDV/contractDetail/competition/extentCompeted/description
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/competition/extentCompeted/description' into the SQL-ready variable 'content__OtherTransactionIDV__contractDetail__competition__extentCompeted__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

  • Decoding competition-related records for reporting
  • Validating coded Extent Competed values against source text
  • Grouping awards by reported competition status

Common Mistakes

  • Using the description as the authoritative code instead of the paired Extent Competed value
  • Assuming identical wording across agencies or records

Query Guidance

Use this field for display, filtering, or quality checks on the competition label, but join or aggregate on the paired Extent Competed code when a stable category is needed. In SQL, normalize case and trim whitespace, and consider grouping by the coded field while retaining this description for presentation.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__competition__extentCompeted__description AS extent_competed_description
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__competition__extentCompeted__description IS NOT NULL
LIMIT 25

Top values

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