FPDS Query Library
About Us
Contact Us

Consortia Flag

Boolean or coded indicator showing whether the contractor is identified as part of a consortium in the Other Transaction IDV record. It flags consortia participation at the contract-detail level rather than describing the consortium itself.

Family: Other Transaction IDV
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__OtherTransactionIDV__contractDetail__consortiaInformation__consortiaFlag
Title
Consortia Flag
FPDS Path
OtherTransactionIDV/contractDetail/consortiaInformation/consortiaFlag
Description
Boolean or coded indicator showing whether the contractor is identified as part of a consortium in the Other Transaction IDV record. It flags consortia participation at the contract-detail level rather than describing the consortium itself.
Business Meaning
This field helps analysts identify awards structured through consortia, which can affect competition patterns, vendor concentration, acquisition strategy, and oversight of alternative contracting vehicles. It is useful for separating consortium-based awards from individual-vendor transactions in compliance, market analysis, and portfolio reviews.
Example Value
N
Observed Non-Null Count
5,091

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter awards involving consortium participation
  • Segment Other Transaction IDVs for market or vendor analysis
  • Support compliance and oversight reporting on consortium-based structures

Common Mistakes

  • Assuming a negative value means the record is invalid rather than simply not consortium-based
  • Using the field without checking actual stored code values or related description fields

Query Guidance

Use exact-value filters based on the observed code set, for example WHERE consortiaFlag = 'Y' for consortium records. If the dataset stores mixed encodings, normalize the field in SQL with CASE logic before aggregation, and do not compare it as free text unless the source values confirm that behavior.

SQL Examples

Preview values

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

Flag distribution

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