FPDS Query Library
About Us
Contact Us

Local Area Set Aside Description

Human-readable description paired with the coded Local Area Set Aside value in the IDV competition record. It identifies the narrative label or explanation used for the local area set-aside indicator rather than the coded flag itself.

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__localAreaSetAside__description
Title
Local Area Set Aside Description
FPDS Path
IDV/competition/localAreaSetAside/description
Description
Human-readable description paired with the coded Local Area Set Aside value in the IDV competition record. It identifies the narrative label or explanation used for the local area set-aside indicator rather than the coded flag itself.
Business Meaning
This field helps analysts interpret whether an IDV included a local area set-aside and how that decision was recorded in the source data. It is useful for analyzing geographic preference policies, socio-economic targeting, and award competition patterns when the underlying code is abbreviated or ambiguous.
Example Value
NO
Observed Non-Null Count
3,001,826

FPDS Compare

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

  • Labeling local area set-aside records in reports
  • Validating the meaning of the paired coded flag
  • Summarizing geographic preference usage across IDVs

Common Mistakes

  • Using the description field as if it were the actual set-aside indicator
  • Assuming all values are free text rather than short coded labels

Query Guidance

Select this field alongside the paired Local Area Set Aside code when interpreting records. Filter on exact observed values only after confirming the source mapping, and use COALESCE or CASE logic if the description is blank or inconsistent across records.

SQL Examples

Preview values

SELECT
    content__IDV__competition__localAreaSetAside__description AS local_area_set_aside_description
FROM fpds.data
WHERE content__IDV__competition__localAreaSetAside__description IS NOT NULL
LIMIT 25

Top values

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