FPDS Query Library
About Us
Contact Us

UEI

Unique Entity Identifier for the vendor or other transaction participant recorded on the award record. It is the government-used identifier that distinguishes the specific legal entity and supports linkage across procurement systems and award records.

Family: Other Transaction IDV
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__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__entityIdentifiers__vendorUEIInformation__UEI
Title
UEI
FPDS Path
OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/entityIdentifiers/vendorUEIInformation/UEI
Description
Unique Entity Identifier for the vendor or other transaction participant recorded on the award record. It is the government-used identifier that distinguishes the specific legal entity and supports linkage across procurement systems and award records.
Business Meaning
This field matters because it lets analysts track awards to the same vendor across actions, instruments, and time even when names vary or are inconsistently entered. It is essential for vendor-level spend analysis, entity matching, award consolidation, and identifying relationships among procurements tied to the same organization.
Example Value
Y8CWNJRCNN91
Observed Non-Null Count
13,417

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__entityIdentifiers__vendorUEIInformation__UEI
FPDS XML Path
OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/entityIdentifiers/vendorUEIInformation/UEI
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/entityIdentifiers/vendorUEIInformation/UEI' into the SQL-ready variable 'content__OtherTransactionIDV__contractDetail__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 spend rollups and award counts by entity
  • Cross-award linkage and duplicate vendor detection
  • Filtering records for a specific contractor or supplier

Common Mistakes

  • Assuming the UEI is interchangeable with vendor name or CAGE/NCAGE without validation
  • Using raw UEI values for analysis without handling nulls, format inconsistencies, or historical entity changes

Query Guidance

Use this field as a join key and filter key in SQL, for example in GROUP BY, DISTINCT, and WHERE clauses. Normalize case and trim whitespace if needed, and avoid substring or pattern matching unless you are explicitly searching for partial identifiers.

SQL Examples

Preview values

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

Top values

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