FPDS Query Library
About Us
Contact Us

Ultimate Parent UEI

This field stores the UEI of the vendor's ultimate parent organization as reported in the award record. It is an identifier, not a name or descriptive label, and links the vendor to its highest-level parent entity when available.

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__ultimateParentUEI
Title
Ultimate Parent UEI
FPDS Path
award/vendor/vendorSiteDetails/entityIdentifiers/vendorUEIInformation/ultimateParentUEI
Description
This field stores the UEI of the vendor's ultimate parent organization as reported in the award record. It is an identifier, not a name or descriptive label, and links the vendor to its highest-level parent entity when available.
Business Meaning
Analysts use this value to roll vendor activity up to the parent-company level, especially when assessing market concentration, corporate affiliations, and total federal spend across subsidiaries. It is important for small business, responsibility, and organizational network analysis because awards may be recorded at the site or subsidiary level while ownership resides elsewhere.
Example Value
EK8GKRFQU3T4
Observed Non-Null Count
111,444,690

FPDS Compare

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

Use Cases

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

Common Usage

  • Aggregate obligations by ultimate corporate parent
  • Identify parent-level vendor concentration and dependency
  • Join award records to parent-company reference or hierarchy tables

Common Mistakes

  • Using it interchangeably with the vendor's own UEI
  • Assuming every record has a populated or valid parent identifier

Query Guidance

Use exact equality joins and group-by operations on this field when rolling awards up to the parent level. In SQL, filter out null or empty values before aggregation, and verify the field against other vendor identifiers to avoid double counting subsidiaries and parents separately.

SQL Examples

Preview values

SELECT
    content__award__vendor__vendorSiteDetails__entityIdentifiers__vendorUEIInformation__ultimateParentUEI AS ultimate_parent_u_e_i
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__entityIdentifiers__vendorUEIInformation__ultimateParentUEI IS NOT NULL
LIMIT 25

Top values

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