FPDS Query Library
About Us
Contact Us

Interagency Contracting Authority

Boolean or coded flag indicating whether the IDV involves use of interagency contracting authority. In FPDS, this captures whether the award is associated with an authorized interagency contracting arrangement rather than describing the contract action itself.

Family: IDV
Category: Legislative Mandates
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__legislativeMandates__interagencyContractingAuthority
Title
Interagency Contracting Authority
FPDS Path
IDV/legislativeMandates/interagencyContractingAuthority
Description
Boolean or coded flag indicating whether the IDV involves use of interagency contracting authority. In FPDS, this captures whether the award is associated with an authorized interagency contracting arrangement rather than describing the contract action itself.
Business Meaning
This field helps analysts identify procurements executed through interagency vehicles, which can affect oversight, fee structures, competition dynamics, and responsibility allocation. It is useful for tracking policy use of governmentwide or cross-agency acquisition authority and for segmenting awards that may follow different approval or compliance rules.
Example Value
B
Observed Non-Null Count
5,862,055

FPDS Compare

FPDS Query Variable
content__IDV__legislativeMandates__interagencyContractingAuthority
FPDS XML Path
IDV/legislativeMandates/interagencyContractingAuthority
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/legislativeMandates/interagencyContractingAuthority' into the SQL-ready variable 'content__IDV__legislativeMandates__interagencyContractingAuthority'.

Use Cases

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

Common Usage

  • Filter IDVs associated with interagency contracting arrangements
  • Segment awards for compliance or policy analysis
  • Compare use of interagency authority across agencies or time periods

Common Mistakes

  • Treating the field as a free-text description instead of a coded flag
  • Assuming any non-null value has the same meaning without checking the code legend

Query Guidance

Use the field as a filter on the specific code or boolean indicator present in your data extract, and verify whether the stored value is a literal true/false, Y/N, or another code such as 'B'. In SQL, test for the documented code set and preserve null handling explicitly so missing values are not confused with 'no'.

SQL Examples

Preview values

SELECT
    content__IDV__legislativeMandates__interagencyContractingAuthority AS interagency_contracting_authority
FROM fpds.data
WHERE content__IDV__legislativeMandates__interagencyContractingAuthority IS NOT NULL
LIMIT 25

Flag distribution

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