FPDS Query Library
About Us
Contact Us

Subcontract Plan

Human-readable value for the subcontract plan indicator within the award-level Preference Programs section. It records the subcontracting plan status or type associated with the award, using a short coded value rather than a free-text narrative.

Family: Award
Category: Preference Programs
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__preferencePrograms__subcontractPlan
Title
Subcontract Plan
FPDS Path
award/preferencePrograms/subcontractPlan
Description
Human-readable value for the subcontract plan indicator within the award-level Preference Programs section. It records the subcontracting plan status or type associated with the award, using a short coded value rather than a free-text narrative.
Business Meaning
This field helps analysts identify awards that trigger subcontracting obligations and evaluate contractor compliance, socioeconomic participation, and award structure under federal procurement rules. It is useful for filtering awards with subcontracting requirements and for comparing subcontracting-related patterns across agencies, contract types, and vendors.
Example Value
C
Observed Non-Null Count
69,592,053

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter awards with subcontracting plan requirements
  • Group awards by subcontracting plan status
  • Analyze compliance-related procurement patterns

Common Mistakes

  • Assuming the single-character value is self-explanatory without checking the code set
  • Using the field as a measure of actual subcontracting performance

Query Guidance

Use equality or IN filters against known code values, and join to any lookup or description table if available. Handle NULL, empty string, and unknown codes separately so counts do not mix missing data with valid statuses.

SQL Examples

Preview values

SELECT
    content__award__preferencePrograms__subcontractPlan AS subcontract_plan
FROM fpds.data
WHERE content__award__preferencePrograms__subcontractPlan IS NOT NULL
LIMIT 25

Top values

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