FPDS Query Library
About Us
Contact Us

Primary Consortia Member UEI

Unique Entity Identifier (UEI) for the primary member of a consortium associated with an Other Transaction award. It identifies the lead or principal consortium participant recorded in the consortia information section.

Family: Other Transaction Award
Category: General
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaMemberUEI
Title
Primary Consortia Member UEI
FPDS Path
OtherTransactionAward/contractDetail/consortiaInformation/primaryConsortiaMemberUEI
Description
Unique Entity Identifier (UEI) for the primary member of a consortium associated with an Other Transaction award. It identifies the lead or principal consortium participant recorded in the consortia information section.
Business Meaning
This field supports attribution of awards to the correct organizational participant when an award is made through a consortium structure. It is useful for linking consortium activity to entity-level performance, concentration, and portfolio analysis across federal procurement records.
Example Value
HURHZFR8Y669
Observed Non-Null Count
4,318

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaMemberUEI
FPDS XML Path
OtherTransactionAward/contractDetail/consortiaInformation/primaryConsortiaMemberUEI
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/consortiaInformation/primaryConsortiaMemberUEI' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaMemberUEI'.

Use Cases

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

Common Usage

  • Linking consortium awards to entity master data
  • Identifying the lead organization in a multi-member award structure
  • Filtering awards by a specific consortium member UEI

Common Mistakes

  • Assuming the value is the award recipient name rather than an identifier
  • Using it alone to represent the full consortium instead of the primary member only

Query Guidance

Use this field in JOINs and WHERE clauses as an exact-match identifier. In SQL, compare it as a string value and pair it with other consortia fields when analyzing membership, role, or award structure.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaMemberUEI AS primary_consortia_member_u_e_i
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaMemberUEI IS NOT NULL
LIMIT 25

Top values

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