FPDS Query Library
About Us
Contact Us

Receives Contracts and Grants

Boolean or coded flag indicating whether the vendor receives both federal contracts and federal grants. It reflects the vendor relationship category recorded on the award and may be stored as a simple yes/no value or a coded indicator depending on the extract.

Family: Other Transaction Award
Category: Vendor Site Details
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__vendor__vendorSiteDetails__vendorRelationshipWithFederalGovernment__receivesContractsAndGrants
Title
Receives Contracts and Grants
FPDS Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorRelationshipWithFederalGovernment/receivesContractsAndGrants
Description
Boolean or coded flag indicating whether the vendor receives both federal contracts and federal grants. It reflects the vendor relationship category recorded on the award and may be stored as a simple yes/no value or a coded indicator depending on the extract.
Business Meaning
This field helps analysts distinguish vendors with mixed federal funding relationships from those engaged only in contracting or only in grant activity. It is useful for vendor profiling, compliance review, portfolio segmentation, and assessing how procurement dollars intersect with broader federal financial support.
Example Value
1
Observed Non-Null Count
38,894

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorRelationshipWithFederalGovernment__receivesContractsAndGrants
FPDS XML Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorRelationshipWithFederalGovernment/receivesContractsAndGrants
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorRelationshipWithFederalGovernment/receivesContractsAndGrants' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorRelationshipWithFederalGovernment__receivesContractsAndGrants'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Contractor profiling and competitor analysis

Common Usage

  • Segment vendors that have both contract and grant relationships with the federal government
  • Filter awards for compliance, conflict review, or vendor portfolio analysis
  • Compare procurement activity for mixed-funding vendors versus contract-only vendors

Common Mistakes

  • Assuming the flag means the current record is a grant or a contract rather than a vendor relationship indicator
  • Treating every non-1 value as a definitive no without checking for nulls, blanks, or coded responses

Query Guidance

Use explicit value checks such as = 1 for true/yes after confirming the stored code set. In SQL, isolate nulls separately from false or no, and if the extract includes coded text, map the observed codes before aggregation or filtering.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorRelationshipWithFederalGovernment__receivesContractsAndGrants AS receives_contracts_and_grants
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorRelationshipWithFederalGovernment__receivesContractsAndGrants IS NOT NULL
LIMIT 25

Flag distribution

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