FPDS Query Library
About Us
Contact Us

Type of Set Aside

Human-readable value indicating the set-aside designation recorded for the IDV. It describes the competition or sourcing status applied to the orderable vehicle, such as no set-aside or a specific socioeconomic or small business set-aside.

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__typeOfSetAside
Title
Type of Set Aside
FPDS Path
IDV/competition/typeOfSetAside
Description
Human-readable value indicating the set-aside designation recorded for the IDV. It describes the competition or sourcing status applied to the orderable vehicle, such as no set-aside or a specific socioeconomic or small business set-aside.
Business Meaning
This field helps analysts evaluate how federal requirements and competition preferences were applied at the IDV level. It is useful for measuring set-aside usage, assessing market access for small and disadvantaged businesses, and distinguishing competed vehicles from records routed through restricted sourcing conditions.
Example Value
NONE
Observed Non-Null Count
3,800,521

FPDS Compare

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

Use Cases

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

Common Usage

  • Measure the share of IDVs awarded with a set-aside designation
  • Compare competition patterns across socioeconomic categories
  • Filter vehicles with no set-aside versus restricted set-aside status

Common Mistakes

  • Assuming NONE means full and open competition without checking other competition fields
  • Counting text labels as equivalent across agencies without normalizing observed value variants

Query Guidance

Use exact-value filters or CASE normalization on this string field, and group by the observed set-aside labels to produce competition summaries. When combining with award counts or obligations, de-duplicate at the IDV record grain to avoid inflating totals.

SQL Examples

Preview values

SELECT
    content__IDV__competition__typeOfSetAside AS type_of_set_aside
FROM fpds.data
WHERE content__IDV__competition__typeOfSetAside IS NOT NULL
LIMIT 25

Top values

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