FPDS Query Library
About Us
Contact Us

IDV Type of Set Aside Description

Human-readable description of the set-aside type applied to an IDV competition. This is the text label paired with the coded FPDS field for IDV Type of Set Aside, such as "NO SET ASIDE USED."

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

Variable Overview

FPDS Query Variable
content__IDV__competition__idvTypeOfSetAside__description
Title
IDV Type of Set Aside Description
FPDS Path
IDV/competition/idvTypeOfSetAside/description
Description
Human-readable description of the set-aside type applied to an IDV competition. This is the text label paired with the coded FPDS field for IDV Type of Set Aside, such as "NO SET ASIDE USED."
Business Meaning
This field helps analysts interpret set-aside treatment in interagency or indefinite-delivery vehicle competition without relying on abbreviated codes. It supports analysis of socioeconomic procurement policy application, competition patterns, and compliance reporting at the IDV level.
Example Value
NO SET ASIDE USED.
Observed Non-Null Count
60,991

FPDS Compare

FPDS Query Variable
content__IDV__competition__idvTypeOfSetAside__description
FPDS XML Path
IDV/competition/idvTypeOfSetAside/description
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/competition/idvTypeOfSetAside/description' into the SQL-ready variable 'content__IDV__competition__idvTypeOfSetAside__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

  • Identify whether an IDV competition had a set-aside and what type
  • Group awards by set-aside category for policy analysis
  • Display a readable label alongside the coded set-aside field

Common Mistakes

  • Using the description as the authoritative code instead of the paired coded field
  • Assuming identical wording across records without checking for variation

Query Guidance

Filter or group on the paired set-aside code when possible, and use this description field for reporting, validation, or user-facing labels. When matching text, normalize case and whitespace, and be prepared for nulls or alternate labels in historical data.

SQL Examples

Preview values

SELECT
    content__IDV__competition__idvTypeOfSetAside__description AS i_d_v_type_of_set_aside_description
FROM fpds.data
WHERE content__IDV__competition__idvTypeOfSetAside__description IS NOT NULL
LIMIT 25

Top values

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