FPDS Query Library
About Us
Contact Us

Recovered Material Clauses

Indicates whether recovered material clauses apply to the IDV record. The value is a boolean or coded flag rather than a narrative description, so the stored value may represent a yes/no condition or a short code such as the observed example 'C'.

Family: IDV
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__IDV__productOrServiceInformation__recoveredMaterialClauses
Title
Recovered Material Clauses
FPDS Path
IDV/productOrServiceInformation/recoveredMaterialClauses
Description
Indicates whether recovered material clauses apply to the IDV record. The value is a boolean or coded flag rather than a narrative description, so the stored value may represent a yes/no condition or a short code such as the observed example 'C'.
Business Meaning
This field helps analysts identify instruments subject to recovered material requirements and evaluate compliance with sustainability or statutory procurement provisions. It is useful for market segmentation, policy reporting, and measuring the prevalence of environmentally directed contract clauses across IDVs.
Example Value
C
Observed Non-Null Count
2,492,007

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter IDVs that include recovered material clauses
  • Measure compliance-related clause adoption rates
  • Segment awards by environmental or sustainability requirements

Common Mistakes

  • Assuming the example code 'C' is a universal meaning across all extracts
  • Using string comparisons against a description when the field is stored as a flag or code

Query Guidance

In SQL, filter on the specific code or normalized flag values present in your dataset, for example WHERE recoveredMaterialClauses = 'C' only if that code is confirmed in your extract. Prefer joining or mapping to any associated description table/field and use CASE logic to standardize the field into a boolean indicator before aggregating.

SQL Examples

Preview values

SELECT
    content__IDV__productOrServiceInformation__recoveredMaterialClauses AS recovered_material_clauses
FROM fpds.data
WHERE content__IDV__productOrServiceInformation__recoveredMaterialClauses IS NOT NULL
LIMIT 25

Flag distribution

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