FPDS Query Library
About Us
Contact Us

Subcontract Plan Description

Human-readable description for the subcontract plan requirement associated with the IDV. It explains the subcontract plan status or requirement in text form, rather than as a code or abbreviated value.

Family: IDV
Category: Preference Programs
Data Type: string
Semantic Type: description
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__preferencePrograms__subcontractPlan__description
Title
Subcontract Plan Description
FPDS Path
IDV/preferencePrograms/subcontractPlan/description
Description
Human-readable description for the subcontract plan requirement associated with the IDV. It explains the subcontract plan status or requirement in text form, rather than as a code or abbreviated value.
Business Meaning
This field helps analysts interpret subcontracting obligations attached to federal procurement actions and distinguish awards that require a subcontracting plan from those that do not. It is useful for reviewing small business participation requirements, compliance-related reporting, and understanding procurement terms without relying only on coded values.
Example Value
PLAN NOT REQUIRED
Observed Non-Null Count
4,398,587

FPDS Compare

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

Use Cases

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

Common Usage

  • Identify whether a contract includes a subcontracting plan requirement
  • Support reporting on small business and subcontracting compliance
  • Decode or validate the meaning of paired subcontract plan codes

Common Mistakes

  • Using the description field as if it were the authoritative code
  • Grouping on free-text descriptions without standardizing observed values

Query Guidance

Use this field for display, validation, and text-based review; filter on the paired coded subcontract plan field when available. In SQL, standardize case and trim whitespace before comparing values, and inspect distinct descriptions to map abbreviations or variant phrasings.

SQL Examples

Preview values

SELECT
    content__IDV__preferencePrograms__subcontractPlan__description AS subcontract_plan_description
FROM fpds.data
WHERE content__IDV__preferencePrograms__subcontractPlan__description IS NOT NULL
LIMIT 25

Top values

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