Receives Contracts
Boolean or coded flag indicating whether the vendor associated with the IDV vendor site is marked as receiving contracts from the Federal Government. It represents a relationship attribute on the vendor site record rather than a contract award outcome.
FPDS Compare
Use Cases
- Dictionary lookup and field explanation
- SQL filtering and grouping
- Analytical reporting and reusable query building
- Contractor profiling and competitor analysis
Common Usage
- Filter vendor records by contract-receiving status
- Segment vendor populations for compliance or market analysis
- Validate vendor relationship attributes against other vendor/site fields
Common Mistakes
- Interpreting the field as an award-level indicator rather than a vendor relationship attribute
- Assuming the coded value set without checking the dataset’s actual stored values
Query Guidance
Use this field in WHERE clauses to isolate records where the flag indicates contract-receiving status, but first verify the encoded true/false values in your FPDS extract. When joining to other vendor tables, apply the filter at the vendor site level and account for nulls or nonstandard codes explicitly.
SQL Examples
Preview values
SELECT
content__IDV__vendor__vendorSiteDetails__vendorRelationshipWithFederalGovernment__receivesContracts AS receives_contracts
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorRelationshipWithFederalGovernment__receivesContracts IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__IDV__vendor__vendorSiteDetails__vendorRelationshipWithFederalGovernment__receivesContracts AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorRelationshipWithFederalGovernment__receivesContracts 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.