FPDS Query Library
About Us
Contact Us

Primary Consortia Member Cage Code

CAGE code for the primary member of a consortium recorded under an Other Transaction IDV. It is an identifier value, not a descriptive name, and points to the specific entity designated as the primary consortia participant in the award record.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__consortiaInformation__primaryConsortiaMemberCageCode
Title
Primary Consortia Member Cage Code
FPDS Path
OtherTransactionIDV/contractDetail/consortiaInformation/primaryConsortiaMemberCageCode
Description
CAGE code for the primary member of a consortium recorded under an Other Transaction IDV. It is an identifier value, not a descriptive name, and points to the specific entity designated as the primary consortia participant in the award record.
Business Meaning
This field helps analysts identify which legal entity is acting as the lead or anchor member in a consortium-based transaction. It is useful for vendor profiling, entity-level aggregation, network analysis, and distinguishing consortium-led awards from single-awardee records.
Example Value
7DN48
Observed Non-Null Count
282

FPDS Compare

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

Use Cases

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

Common Usage

  • Link consortium awards to the lead entity using the primary member CAGE code
  • Aggregate obligations or award counts by primary consortia participant
  • Filter or segment Other Transaction IDVs involving consortium structures

Common Mistakes

  • Assuming the code is the full legal entity name or a unique award identifier
  • Using it as the only basis for vendor matching without normalizing CAGE formats

Query Guidance

Use this field for grouping, joining, and filtering on the primary consortium member identifier. In SQL, compare it as a text code, trim whitespace, and standardize case if needed; pair it with name fields or other entity identifiers when available to confirm matches and avoid false joins.

SQL Examples

Preview values

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

Top values

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