FPDS Query Library
About Us
Contact Us

Reason Not Competed

Human-readable reason the action was recorded as not competed within the IDV competition record. It is typically the descriptive label for a coded value indicating the noncompetitive justification or recorded procurement condition, such as an abbreviated reason code. If the underlying record stores codes, this field represents the readable explanation tied to that code.

Family: IDV
Category: Competition
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__competition__reasonNotCompeted
Title
Reason Not Competed
FPDS Path
IDV/competition/reasonNotCompeted
Description
Human-readable reason the action was recorded as not competed within the IDV competition record. It is typically the descriptive label for a coded value indicating the noncompetitive justification or recorded procurement condition, such as an abbreviated reason code. If the underlying record stores codes, this field represents the readable explanation tied to that code.
Business Meaning
This field supports competition and justification analysis by showing why an IDV was not competed. Analysts use it to classify noncompetitive awards, assess compliance patterns, and distinguish statutory or policy-based exceptions from other recorded sourcing conditions. It is especially useful for trend analysis across agencies, contract types, and periods.
Example Value
OTH
Observed Non-Null Count
671,293

FPDS Compare

FPDS Query Variable
content__IDV__competition__reasonNotCompeted
FPDS XML Path
IDV/competition/reasonNotCompeted
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/competition/reasonNotCompeted' into the SQL-ready variable 'content__IDV__competition__reasonNotCompeted'.

Use Cases

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

Common Usage

  • classify noncompetitive awards by recorded reason
  • aggregate counts of not competed actions by agency or year
  • validate competition reporting against justification fields

Common Mistakes

  • treating the field as a full justification narrative
  • grouping codes without confirming the coded value set or paired description

Query Guidance

Use this field in SELECTs and GROUP BYs to summarize noncompetitive reasons, but normalize values first if codes and labels vary across records. Filter carefully for nulls and blank strings, and join to related competition or justification fields when distinguishing true noncompetitive actions from missing or incomplete data. Example pattern: SELECT reasonNotCompeted, COUNT(*) ... GROUP BY reasonNotCompeted.

SQL Examples

Preview values

SELECT
    content__IDV__competition__reasonNotCompeted AS reason_not_competed
FROM fpds.data
WHERE content__IDV__competition__reasonNotCompeted IS NOT NULL
LIMIT 25

Top values

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