Fed Biz Opps

Indicates whether the award record references Federal Business Opportunities (Fed Biz Opps) as part of the competition information. The value is typically a short code such as Y/N rather than a narrative description.

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

Variable Overview

FPDS Query Variable
content__award__competition__fedBizOpps
Title
Fed Biz Opps
FPDS Path
award/competition/fedBizOpps
Description
Indicates whether the award record references Federal Business Opportunities (Fed Biz Opps) as part of the competition information. The value is typically a short code such as Y/N rather than a narrative description.
Business Meaning
This field helps analysts assess how the solicitation or opportunity was publicly posted and whether the award was associated with a competitive synopsis process. It is useful when comparing competition patterns, public notice practices, and compliance with procurement posting requirements.
Example Value
Y
Observed Non-Null Count
103,713,351

FPDS Compare

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

Use Cases

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

Common Usage

  • Identify awards associated with Fed Biz Opps postings
  • Compare competition posting patterns across agencies or time periods
  • Filter award records for competition compliance reviews

Common Mistakes

  • Assuming the field contains the full solicitation text or opportunity narrative
  • Using the code without checking whether missing, blank, or legacy values are present

Query Guidance

Use equality filters on the stored code value, for example WHERE content__award__competition__fedBizOpps = 'Y'. If the column is sparsely populated or inconsistently coded, normalize blanks and review distinct values before building aggregates.

SQL Examples

Preview values

SELECT
    content__award__competition__fedBizOpps AS fed_biz_opps
FROM fpds.data
WHERE content__award__competition__fedBizOpps IS NOT NULL
LIMIT 25

Top values

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