FPDS Query Library
About Us
Contact Us

Product or Service Code

Coded value that identifies the product or service classification associated with the award. It records the FPDS product or service code used to categorize what was acquired, rather than a narrative description.

Family: Award
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__award__productOrServiceInformation__productOrServiceCode
Title
Product or Service Code
FPDS Path
award/productOrServiceInformation/productOrServiceCode
Description
Coded value that identifies the product or service classification associated with the award. It records the FPDS product or service code used to categorize what was acquired, rather than a narrative description.
Business Meaning
This field is central to spend categorization, portfolio analysis, and reporting by commodity or service type. Analysts use it to identify contracting patterns, compare obligations across acquisition categories, and support policy or market research reviews.
Example Value
AJ31
Observed Non-Null Count
111,242,543

FPDS Compare

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

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Market segmentation by industry or PSC

Common Usage

  • categorizing obligations by commodity or service
  • filtering awards for a specific procurement category
  • joining to a code reference table for label reporting

Common Mistakes

  • assuming the code is a human-readable description
  • aggregating without checking whether the code set changed across periods

Query Guidance

Use exact matching for targeted extraction, and group by the code for portfolio summaries. When building reports, join to a lookup table for the descriptive label and avoid free-text comparisons unless the source system normalizes the value.

SQL Examples

Preview values

SELECT
    content__award__productOrServiceInformation__productOrServiceCode AS product_or_service_code
FROM fpds.data
WHERE content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
LIMIT 25

Top values

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