FPDS Query Library
About Us
Contact Us

Use of EPA Designated Products

Indicates whether the award record reflects use of EPA-designated products. It is a compliance-oriented flag, and the value may be coded; for example, "E" indicates the requirement is not applicable or not required.

Family: Award
Category: Product Or Service Information
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__productOrServiceInformation__useOfEPADesignatedProducts
Title
Use of EPA Designated Products
FPDS Path
award/productOrServiceInformation/useOfEPADesignatedProducts
Description
Indicates whether the award record reflects use of EPA-designated products. It is a compliance-oriented flag, and the value may be coded; for example, "E" indicates the requirement is not applicable or not required.
Business Meaning
This field supports environmental compliance analysis and reporting on procurement alignment with EPA-designated product requirements. Analysts use it to identify awards that should be counted in sustainability, green procurement, or statutory compliance reviews.
Example Value
E
Observed Non-Null Count
96,531,274

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter awards for green procurement or environmental compliance reviews
  • Measure the share of awards involving EPA-designated products
  • Segment obligations by compliance status or requirement applicability

Common Mistakes

  • Assuming "E" means yes instead of not required/not applicable
  • Counting blank or coded values as equivalent without checking the code set

Query Guidance

Use explicit code handling in SQL, for example `CASE WHEN field IN ('Y','Yes','1') THEN 1 WHEN field = 'E' THEN 0 ELSE NULL END`, after confirming the actual code set in the source. Exclude or separately label not-required cases so compliance rates are not overstated.

SQL Examples

Preview values

SELECT
    content__award__productOrServiceInformation__useOfEPADesignatedProducts AS use_of_e_p_a_designated_products
FROM fpds.data
WHERE content__award__productOrServiceInformation__useOfEPADesignatedProducts IS NOT NULL
LIMIT 25

Flag distribution

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