FPDS Query Library
About Us
Contact Us

IDV Type of Set Aside

Indicator or coded value describing the set-aside type applied to the IDV competition. It captures whether the requirement was competed under a particular socio-economic or small-business set-aside, or not set aside at all.

Family: IDV
Category: Competition
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__competition__idvTypeOfSetAside
Title
IDV Type of Set Aside
FPDS Path
IDV/competition/idvTypeOfSetAside
Description
Indicator or coded value describing the set-aside type applied to the IDV competition. It captures whether the requirement was competed under a particular socio-economic or small-business set-aside, or not set aside at all.
Business Meaning
This field is important for measuring how often government uses set-asides in indefinite delivery vehicle competitions and for assessing small-business participation and compliance with acquisition policy. It supports segmentation of awards by competition strategy and helps analysts evaluate access to federal contracting opportunities.
Example Value
NONE
Observed Non-Null Count
60,991

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter IDVs competed with a set-aside
  • Measure small-business or socio-economic procurement share
  • Compare competition patterns across acquisition strategies

Common Mistakes

  • Assuming blank values mean the same thing as explicit 'NONE'
  • Interpreting the field as a post-award socioeconomic status rather than a competition attribute

Query Guidance

Use it in WHERE clauses to isolate set-aside competitions, for example by selecting known code values or excluding 'NONE' when analyzing unrestricted awards. When aggregating, group by the coded value or map codes to readable labels first, and handle nulls explicitly so they do not distort counts.

SQL Examples

Preview values

SELECT
    content__IDV__competition__idvTypeOfSetAside AS i_d_v_type_of_set_aside
FROM fpds.data
WHERE content__IDV__competition__idvTypeOfSetAside IS NOT NULL
LIMIT 25

Flag distribution

SELECT
    content__IDV__competition__idvTypeOfSetAside AS flag_value,
    count() AS record_count
FROM fpds.data
WHERE content__IDV__competition__idvTypeOfSetAside IS NOT NULL
GROUP BY flag_value
ORDER BY record_count DESC

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.