FPDS Query Library
About Us
Contact Us

Primary Consortia Member Cage Code

CAGE code for the primary member of a consortia associated with an Other Transaction Award. It is an identifier used to name the lead or main participant in the consortia structure, not a free-text organization name.

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__primaryConsortiaMemberCageCode
Title
Primary Consortia Member Cage Code
FPDS Path
OtherTransactionAward/contractDetail/consortiaInformation/primaryConsortiaMemberCageCode
Description
CAGE code for the primary member of a consortia associated with an Other Transaction Award. It is an identifier used to name the lead or main participant in the consortia structure, not a free-text organization name.
Business Meaning
This field helps analysts identify which entity is serving as the primary consortia member in OT awards, supporting vendor profiling, team structure analysis, and award mapping across related records. It is useful for distinguishing the lead participant from other consortium members when assessing competition, award concentration, and organizational relationships.
Example Value
8K2V7
Observed Non-Null Count
4,309

FPDS Compare

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

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 consortia-based OT award
  • Join award records to vendor/entity reference tables using CAGE code
  • Analyze award patterns involving consortium structures

Common Mistakes

  • Assuming the field is the full legal name of the organization
  • Using it without accounting for missing values or consortium records with multiple members

Query Guidance

Use this field as a join key or filter on the coded value, for example in WHERE clauses or joins to CAGE reference data. When aggregating, group by the code rather than a name string, and validate against companion consortium fields to avoid misidentifying the primary entity.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaMemberCageCode AS primary_consortia_member_cage_code
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaMemberCageCode IS NOT NULL
LIMIT 25

Top values

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