FPDS Query Library
About Us
Contact Us

Labor Standards

Boolean or coded flag indicating whether labor standards apply to the award. In FPDS, a value of Y means the action is subject to labor standards; N means it is not.

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__laborStandards
Title
Labor Standards
FPDS Path
award/legislativeMandates/laborStandards
Description
Boolean or coded flag indicating whether labor standards apply to the award. In FPDS, a value of Y means the action is subject to labor standards; N means it is not.
Business Meaning
This field helps identify awards that trigger labor-related compliance requirements, such as wage determinations or other statutory labor protections. Analysts use it to segment contracts subject to labor standards, assess compliance exposure, and compare award populations with and without labor obligations.
Example Value
N
Observed Non-Null Count
111,459,828

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter awards subject to labor standards
  • Measure the share of awards with labor compliance obligations
  • Compare obligation patterns across regulated and unregulated awards

Common Mistakes

  • Treating any non-Y value as definitively no without checking for nulls or other codes
  • Using the flag as a measure of compliance status rather than applicability

Query Guidance

In SQL, filter explicitly on the coded value, for example WHERE laborStandards = 'Y'. If data quality is uncertain, include NULL handling and validate observed distinct values before aggregating.

SQL Examples

Preview values

SELECT
    content__award__legislativeMandates__laborStandards AS labor_standards
FROM fpds.data
WHERE content__award__legislativeMandates__laborStandards IS NOT NULL
LIMIT 25

Flag distribution

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