FPDS Query Library
About Us
Contact Us

Primary Consortia Member Name

Human-readable name of the primary consortia member associated with an Other Transaction award. This is a label field used to identify the main member of a consortium when the award is structured around a consortia arrangement.

Family: Other Transaction Award
Category: General
Data Type: string
Semantic Type: label
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaMemberName
Title
Primary Consortia Member Name
FPDS Path
OtherTransactionAward/contractDetail/consortiaInformation/primaryConsortiaMemberName
Description
Human-readable name of the primary consortia member associated with an Other Transaction award. This is a label field used to identify the main member of a consortium when the award is structured around a consortia arrangement.
Business Meaning
This field helps analysts identify the lead organization within a consortium award structure, which is important for understanding award structure, participant attribution, and organizational relationships in OT agreements. It supports analysis of who is primarily associated with the consortium when obligations or responsibilities are distributed across members.
Example Value
MEMSEL INC.
Observed Non-Null Count
4,318

FPDS Compare

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

Use Cases

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

Common Usage

  • Identify the lead organization in a consortium-based Other Transaction award
  • Support normalization and matching to vendor/entity reference data
  • Review consortium composition in award-level analyses

Common Mistakes

  • Assuming the value is a unique entity identifier
  • Using the text alone for exact entity matching without normalization

Query Guidance

Use this field as a display or grouping label, and normalize text if comparing across records. In SQL, apply trimming, case standardization, and alias handling for entity matching; do not rely on it for joins unless no better identifier is available.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaMemberName AS primary_consortia_member_name
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaMemberName IS NOT NULL
LIMIT 25

Top values

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