FPDS Query Library
About Us
Contact Us

Consortia Flag

Boolean or coded indicator showing whether the Other Transaction Award record identifies the vendor as part of a consortia. It is a flag-level field, so the stored value represents the presence or absence of that condition rather than a narrative description.

Family: Other Transaction Award
Category: General
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__consortiaInformation__consortiaFlag
Title
Consortia Flag
FPDS Path
OtherTransactionAward/contractDetail/consortiaInformation/consortiaFlag
Description
Boolean or coded indicator showing whether the Other Transaction Award record identifies the vendor as part of a consortia. It is a flag-level field, so the stored value represents the presence or absence of that condition rather than a narrative description.
Business Meaning
This field helps analysts isolate awards involving consortium-based vendors, which can affect competition, contracting structure, pricing, and oversight considerations. It is useful for analyzing Other Transaction Awards where consortium participation may indicate a multi-party teaming arrangement or specialized acquisition vehicle.
Example Value
N
Observed Non-Null Count
10,845

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter Other Transaction Awards involving consortium vendors
  • Segment awards for compliance or oversight review
  • Compare award patterns for consortium versus non-consortium vendors

Common Mistakes

  • Assuming the flag means the award was made to a consortium rather than that the vendor is part of one
  • Filtering on text assumptions without checking the actual coded values present in the extract

Query Guidance

Use equality filters on the observed indicator values, such as WHERE consortiaFlag = 'Y' or the applicable coded equivalent. In SQL, validate the domain first with DISTINCT or COUNT BY value, and avoid treating the field as a boolean unless the extract consistently stores true/false semantics.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__consortiaInformation__consortiaFlag AS consortia_flag
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__consortiaInformation__consortiaFlag IS NOT NULL
LIMIT 25

Flag distribution

SELECT
    content__OtherTransactionAward__contractDetail__consortiaInformation__consortiaFlag AS flag_value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__consortiaInformation__consortiaFlag IS NOT NULL
GROUP BY flag_value
ORDER BY record_count DESC

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.