FPDS Query Library
About Us
Contact Us

Ultimate Parent UEI Name

Human-readable name of the entity identified as the award recipient's ultimate parent in the UEI hierarchy. It is the label counterpart to the coded ultimate parent UEI information in the vendor site details structure.

Family: Award
Category: Vendor Site Details
Data Type: string
Semantic Type: label
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__vendor__vendorSiteDetails__entityIdentifiers__vendorUEIInformation__ultimateParentUEIName
Title
Ultimate Parent UEI Name
FPDS Path
award/vendor/vendorSiteDetails/entityIdentifiers/vendorUEIInformation/ultimateParentUEIName
Description
Human-readable name of the entity identified as the award recipient's ultimate parent in the UEI hierarchy. It is the label counterpart to the coded ultimate parent UEI information in the vendor site details structure.
Business Meaning
This field helps analysts identify the top-level corporate parent behind an awarded vendor, which is useful for market concentration analysis, affiliation review, and rollups across subsidiaries or operating units. It supports visibility into who ultimately controls the awarded entity rather than only the immediate vendor on the contract.
Example Value
BURNS & ROE GROUP INC
Observed Non-Null Count
110,641,468

FPDS Compare

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

Use Cases

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

Common Usage

  • Link awards to a parent-company view for vendor concentration analysis
  • Group subsidiary awards under a common corporate owner
  • Validate and interpret the ultimate parent UEI identifier in FPDS records

Common Mistakes

  • Using the name as a unique key instead of the UEI or another identifier
  • Assuming the prime awardee name and ultimate parent name are always the same

Query Guidance

Use this field for display, filtering, or name-based rollups only after normalizing text. In SQL, join or group by the associated UEI field when possible, and use this column as a label in SELECT clauses rather than as the sole basis for deduplication or entity matching.

SQL Examples

Preview values

SELECT
    content__award__vendor__vendorSiteDetails__entityIdentifiers__vendorUEIInformation__ultimateParentUEIName AS ultimate_parent_u_e_i_name
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__entityIdentifiers__vendorUEIInformation__ultimateParentUEIName IS NOT NULL
LIMIT 25

Top values

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