Performance Based Service Contract
Boolean or coded indicator showing whether the IDV is classified as a performance-based service contract. In FPDS, this field records the presence of that condition rather than a narrative description of the contract.
FPDS Compare
Paired Field
Use Cases
- Dictionary lookup and field explanation
- SQL filtering and grouping
- Analytical reporting and reusable query building
Common Usage
- Filter IDVs that are performance-based service contracts
- Calculate the share of service awards marked performance-based by agency or fiscal year
- Compare obligations and award counts across performance-based versus non-performance-based contracts
Common Mistakes
- Assuming a blank or null value always means 'No'
- Treating the flag as a full description of contract performance requirements
Query Guidance
In SQL, test for the populated code rather than the literal wording, for example `WHERE performanceBasedServiceContract = 'X'` or equivalent logic based on the extract. When building metrics, explicitly handle nulls separately from affirmative values so missing data is not counted as a negative response.
SQL Examples
Preview values
SELECT
content__IDV__contractData__performanceBasedServiceContract AS performance_based_service_contract
FROM fpds.data
WHERE content__IDV__contractData__performanceBasedServiceContract IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__IDV__contractData__performanceBasedServiceContract AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__IDV__contractData__performanceBasedServiceContract 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.