FPDS Query Library
About Us
Contact Us

UEI

Unique Entity Identifier assigned to the vendor entity recorded in the award's vendor site details. It is a coded identifier used to represent the contractor or grantee entity in FPDS, rather than a descriptive name.

Family: Award
Category: Vendor Site Details
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__vendor__vendorSiteDetails__entityIdentifiers__vendorUEIInformation__UEI
Title
UEI
FPDS Path
award/vendor/vendorSiteDetails/entityIdentifiers/vendorUEIInformation/UEI
Description
Unique Entity Identifier assigned to the vendor entity recorded in the award's vendor site details. It is a coded identifier used to represent the contractor or grantee entity in FPDS, rather than a descriptive name.
Business Meaning
This field supports entity-level tracking across awards, enabling analysts to aggregate obligations, identify repeat vendors, and link FPDS awards to other federal datasets that use the UEI. It is essential for vendor concentration, spend analysis, and de-duplication when names vary across records.
Example Value
FLYECQD5E3G9
Observed Non-Null Count
111,495,893

FPDS Compare

FPDS Query Variable
content__award__vendor__vendorSiteDetails__entityIdentifiers__vendorUEIInformation__UEI
FPDS XML Path
award/vendor/vendorSiteDetails/entityIdentifiers/vendorUEIInformation/UEI
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/vendor/vendorSiteDetails/entityIdentifiers/vendorUEIInformation/UEI' into the SQL-ready variable 'content__award__vendor__vendorSiteDetails__entityIdentifiers__vendorUEIInformation__UEI'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Contractor profiling and competitor analysis

Common Usage

  • Vendor-level spend and obligation rollups
  • Cross-award entity matching and de-duplication
  • Linking FPDS records to external vendor master data

Common Mistakes

  • Using the value as a human-readable vendor name
  • Assuming it is always populated or stable across all historical records

Query Guidance

Filter and join on the exact UEI string after standardizing formatting, for example using UPPER(TRIM(UEI)). Use it as a primary vendor key when available, and test for null or blank values before relying on it in joins or counts.

SQL Examples

Preview values

SELECT
    content__award__vendor__vendorSiteDetails__entityIdentifiers__vendorUEIInformation__UEI AS u_e_i
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__entityIdentifiers__vendorUEIInformation__UEI IS NOT NULL
LIMIT 25

Top values

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