FPDS Query Library
About Us
Contact Us

Type of Set Aside Source Description

Human-readable description paired with the coded "Type of Set Aside Source" field in the IDV competition segment. It identifies the source or basis of the set-aside in plain language rather than a code or abbreviated value.

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__typeOfSetAsideSource__description
Title
Type of Set Aside Source Description
FPDS Path
IDV/competition/typeOfSetAsideSource/description
Description
Human-readable description paired with the coded "Type of Set Aside Source" field in the IDV competition segment. It identifies the source or basis of the set-aside in plain language rather than a code or abbreviated value.
Business Meaning
This field helps analysts interpret set-aside reporting correctly by translating procurement codes into readable labels. It supports analysis of small business, socio-economic, and other competition-related set-aside patterns without relying on opaque source codes.
Example Value
This Action
Observed Non-Null Count
1,675,110

FPDS Compare

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

  • Classifying IDVs by set-aside source in competition analysis
  • Decoding coded procurement records into analyst-readable labels
  • Supporting joins, filters, and QA checks against the paired source code field

Common Mistakes

  • Using the description as a stable code instead of the paired coded field
  • Assuming identical wording always means identical underlying set-aside meaning across records

Query Guidance

Select this field for reporting and display, but filter or group on the paired code field when possible. In SQL, join or compare it with the corresponding source code field to validate mappings, and use DISTINCT on observed values to check for label variations before building aggregations.

SQL Examples

Preview values

SELECT
    content__IDV__competition__typeOfSetAsideSource__description AS type_of_set_aside_source_description
FROM fpds.data
WHERE content__IDV__competition__typeOfSetAsideSource__description IS NOT NULL
LIMIT 25

Top values

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