FPDS Query Library
About Us
Contact Us

Claimant Program Code

Code identifying the claimant program associated with the IDV line of business or product/service classification. It is an internal coded value, not a free-text description, and typically appears as an abbreviated program key such as C9E.

Family: IDV
Category: Product Or Service Information
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__productOrServiceInformation__claimantProgramCode
Title
Claimant Program Code
FPDS Path
IDV/productOrServiceInformation/claimantProgramCode
Description
Code identifying the claimant program associated with the IDV line of business or product/service classification. It is an internal coded value, not a free-text description, and typically appears as an abbreviated program key such as C9E.
Business Meaning
This field helps analysts group and compare indefinite delivery vehicle activity by the program claiming or managing the requirement. It is useful for portfolio analysis, program-level spend tracking, and identifying which claimant organizations are driving awards within a category.
Example Value
C9E
Observed Non-Null Count
1,229,423

FPDS Compare

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

Use Cases

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

Common Usage

  • Program-level filtering of IDV awards
  • Grouping obligations by claimant organization or mission area
  • Validating classification consistency across procurement records

Common Mistakes

  • Interpreting the code as a human-readable program name
  • Filtering on unvalidated codes without checking the allowed value set

Query Guidance

Use this field as a categorical code in WHERE, GROUP BY, or JOIN clauses, ideally against a maintained lookup of claimant program codes and descriptions. In SQL, compare on exact code values and normalize case/whitespace if source quality is inconsistent; do not use pattern matching unless you are intentionally exploring unknown codes.

SQL Examples

Preview values

SELECT
    content__IDV__productOrServiceInformation__claimantProgramCode AS claimant_program_code
FROM fpds.data
WHERE content__IDV__productOrServiceInformation__claimantProgramCode IS NOT NULL
LIMIT 25

Top values

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