FPDS Query Library
About Us
Contact Us

PSC Code

Coded product or service code associated with the Other Transaction IDV contract detail. It identifies the primary goods or services category represented in the record, using a standardized procurement classification code such as an FPDS PSC value.

Family: Other Transaction IDV
Category: General
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__PSCCode
Title
PSC Code
FPDS Path
OtherTransactionIDV/contractDetail/PSCCode
Description
Coded product or service code associated with the Other Transaction IDV contract detail. It identifies the primary goods or services category represented in the record, using a standardized procurement classification code such as an FPDS PSC value.
Business Meaning
PSC codes are used to classify awards into product and service categories for spend analysis, market research, competition reviews, and trend reporting. They help analysts compare procurement activity across portfolios, agencies, and time periods at a consistent level of detail.
Example Value
AC12
Observed Non-Null Count
13,417

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__PSCCode
FPDS XML Path
OtherTransactionIDV/contractDetail/PSCCode
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/PSCCode' into the SQL-ready variable 'content__OtherTransactionIDV__contractDetail__PSCCode'.

Use Cases

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

Common Usage

  • Categorizing obligations by product or service group
  • Building PSC-based spend or award summaries
  • Filtering records for market or category analysis

Common Mistakes

  • Assuming the code itself is human-readable without a reference lookup
  • Aggregating across records with inconsistent code normalization or truncated values

Query Guidance

Use this field as a grouping and join key to a PSC reference table, and filter with exact matches or controlled code prefixes only when the classification hierarchy supports it. In SQL, compare on the stored code value and derive descriptions through a lookup rather than hard-coding labels.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__PSCCode AS p_s_c_code
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__PSCCode IS NOT NULL
LIMIT 25

Top values

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