FPDS Query Library
About Us
Contact Us

Product or Service Type

Human-readable label for the product-or-service classification associated with the other transaction award's PSC/CLIN-related detail. It typically names the category of what is being acquired, such as a service or product type, rather than serving as the underlying numeric or alphanumeric code.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__PSCCode__productOrServiceType
Title
Product or Service Type
FPDS Path
OtherTransactionAward/contractDetail/PSCCode/productOrServiceType
Description
Human-readable label for the product-or-service classification associated with the other transaction award's PSC/CLIN-related detail. It typically names the category of what is being acquired, such as a service or product type, rather than serving as the underlying numeric or alphanumeric code.
Business Meaning
This field helps analysts group and compare awards by what was purchased, supporting spend categorization, portfolio analysis, and trend reviews across product and service lines. It is useful for identifying whether other transaction activity is concentrated in services, supplies, or other acquisition categories.
Example Value
SERVICE
Observed Non-Null Count
38,894

FPDS Compare

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

Use Cases

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

Common Usage

  • Classify awards into product versus service groupings
  • Filter other transaction awards by acquisition category
  • Summarize spending or award counts by product/service type

Common Mistakes

  • Using it as the authoritative code instead of a label
  • Assuming all records use the same vocabulary or level of detail

Query Guidance

Use for grouping, filtering, and display, but prefer exact-value predicates on the observed domain values. If a separate code field exists, join or filter on the code and select this field for readable output; normalize values before aggregation when multiple spellings or abbreviations appear.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__PSCCode__productOrServiceType AS product_or_service_type
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__PSCCode__productOrServiceType IS NOT NULL
LIMIT 25

Top values

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