Is Service Related Disabled Veteran Owned Business
Boolean or coded flag indicating whether the vendor is identified as a service-connected disabled veteran-owned business in the vendor socio-economic indicators section of the Other Transaction IDV record. It captures the vendor’s self-reported or recorded small business classification for that contract detail.
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
- Count or sum awards associated with service-disabled veteran-owned businesses
- Filter vendor portfolios by socioeconomic ownership status
- Support compliance and reporting for veteran-owned business participation
Common Mistakes
- Assuming a 0 value always means the vendor is not eligible rather than not flagged
- Mixing this indicator with other veteran-related business classifications
Query Guidance
Use this field as a boolean or coded filter in WHERE clauses, normalizing its values to a consistent true/false mapping before analysis. In SQL, test for the affirmative code(s) or true value, and separately handle nulls so absent data is not counted as negative classification.
SQL Examples
Preview values
SELECT
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isServiceRelatedDisabledVeteranOwnedBusiness AS is_service_related_disabled_veteran_owned_business
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isServiceRelatedDisabledVeteranOwnedBusiness IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isServiceRelatedDisabledVeteranOwnedBusiness AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isServiceRelatedDisabledVeteranOwnedBusiness 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.