FPDS Query Library
About Us
Contact Us

Construction Wage Rate Requirements

Indicates whether the award is subject to construction wage rate requirements under the applicable labor statute. In FPDS, the value is stored as a flag; a coded value such as "X" means the requirement is not applicable rather than a plain yes/no label.

Family: Award
Category: Legislative Mandates
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__legislativeMandates__constructionWageRateRequirements
Title
Construction Wage Rate Requirements
FPDS Path
award/legislativeMandates/constructionWageRateRequirements
Description
Indicates whether the award is subject to construction wage rate requirements under the applicable labor statute. In FPDS, the value is stored as a flag; a coded value such as "X" means the requirement is not applicable rather than a plain yes/no label.
Business Meaning
This field helps analysts identify construction awards that carry wage compliance obligations and separate them from awards where those requirements do not apply. It is useful for labor compliance review, policy analysis, and segmenting construction procurement activity by statutory coverage.
Example Value
X
Observed Non-Null Count
111,460,712

FPDS Compare

FPDS Query Variable
content__award__legislativeMandates__constructionWageRateRequirements
FPDS XML Path
award/legislativeMandates/constructionWageRateRequirements
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/legislativeMandates/constructionWageRateRequirements' into the SQL-ready variable 'content__award__legislativeMandates__constructionWageRateRequirements'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building

Common Usage

  • Filter construction awards subject to wage rate requirements
  • Exclude not-applicable awards from compliance analyses
  • Segment awards by labor mandate applicability

Common Mistakes

  • Assuming "X" means yes instead of not applicable
  • Using the field without checking for blanks or other coded values

Query Guidance

Use explicit value checks in SQL, for example WHERE constructionWageRateRequirements <> 'X' to identify records where the requirement may apply, and WHERE constructionWageRateRequirements = 'X' for not-applicable records. Include NULL handling and confirm the code set in the source extract before drawing compliance conclusions.

SQL Examples

Preview values

SELECT
    content__award__legislativeMandates__constructionWageRateRequirements AS construction_wage_rate_requirements
FROM fpds.data
WHERE content__award__legislativeMandates__constructionWageRateRequirements IS NOT NULL
LIMIT 25

Flag distribution

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