FPDS Query Library
About Us
Contact Us

Fed Biz Opps Description

Human-readable description tied to the award competition field "Fed Biz Opps." It functions as the descriptive label for the underlying coded value and states the federal business opportunities status in text form.

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__fedBizOpps__description
Title
Fed Biz Opps Description
FPDS Path
award/competition/fedBizOpps/description
Description
Human-readable description tied to the award competition field "Fed Biz Opps." It functions as the descriptive label for the underlying coded value and states the federal business opportunities status in text form.
Business Meaning
This field helps analysts interpret competition-related procurement records without depending only on abbreviated or coded source values. It is useful for validating whether an opportunity was posted or exempted and for grouping awards by public notice status in competition analysis.
Example Value
NOT APPLICABLE
Observed Non-Null Count
103,711,208

FPDS Compare

FPDS Query Variable
content__award__competition__fedBizOpps__description
FPDS XML Path
award/competition/fedBizOpps/description
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/competition/fedBizOpps/description' into the SQL-ready variable 'content__award__competition__fedBizOpps__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 the coded Fed Biz Opps indicator
  • Reviewing whether an opportunity was publicly described or exempted
  • Validating competition-related data quality in award records

Common Mistakes

  • Using the description field as a filter instead of the paired code
  • Assuming the text is standardized across all records without checking observed values

Query Guidance

Use this field for display, validation, and text-based review. In SQL, filter on the paired coded field when possible, and select this description alongside the code for auditing or reporting, for example to check unexpected values with DISTINCT or GROUP BY.

SQL Examples

Preview values

SELECT
    content__award__competition__fedBizOpps__description AS fed_biz_opps_description
FROM fpds.data
WHERE content__award__competition__fedBizOpps__description IS NOT NULL
LIMIT 25

Top values

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