FPDS Query Library
About Us
Contact Us

System Equipment Code Description

Human-readable description associated with the System Equipment Code on the award record. It is the label text that explains the coded value stored in the paired System Equipment Code field.

Family: Award
Category: Product Or Service Information
Data Type: string
Semantic Type: description
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__productOrServiceInformation__systemEquipmentCode__description
Title
System Equipment Code Description
FPDS Path
award/productOrServiceInformation/systemEquipmentCode/description
Description
Human-readable description associated with the System Equipment Code on the award record. It is the label text that explains the coded value stored in the paired System Equipment Code field.
Business Meaning
This field helps analysts translate coded procurement data into understandable equipment categories for reporting, spend segmentation, and program analysis. It is useful when reviewing awards that involve systems, equipment, or hardware and when the underlying code alone is not self-explanatory.
Example Value
NONE
Observed Non-Null Count
61,631,701

FPDS Compare

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

Use Cases

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

Common Usage

  • Display the label for a coded equipment category in reports
  • Validate the meaning of the paired System Equipment Code
  • Support descriptive filtering or QA checks on coded award data

Common Mistakes

  • Using the description field as a surrogate key for grouping instead of the code
  • Assuming the description is standardized if the observed values vary across records

Query Guidance

Join or select this field alongside the paired System Equipment Code. In SQL, group and filter on the code when possible, and use the description for display, validation, or troubleshooting; if the code appears abbreviated or inconsistent, compare the observed descriptions before hard-coding logic.

SQL Examples

Preview values

SELECT
    content__award__productOrServiceInformation__systemEquipmentCode__description AS system_equipment_code_description
FROM fpds.data
WHERE content__award__productOrServiceInformation__systemEquipmentCode__description IS NOT NULL
LIMIT 25

Top values

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