FPDS Query Library
About Us
Contact Us

Is Veteran Owned

Boolean or coded indicator showing whether the vendor identified in the award record is veteran-owned. It is a vendor socio-economic status flag at the vendor site level within the award data. Example values may appear as numeric codes such as 0/1 rather than a plain-text label.

Family: 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__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isVeteranOwned
Title
Is Veteran Owned
FPDS Path
award/vendor/vendorSiteDetails/vendorSocioEconomicIndicators/isVeteranOwned
Description
Boolean or coded indicator showing whether the vendor identified in the award record is veteran-owned. It is a vendor socio-economic status flag at the vendor site level within the award data. Example values may appear as numeric codes such as 0/1 rather than a plain-text label.
Business Meaning
This field supports analysis of awards to veteran-owned businesses, including set-aside performance, small business and socio-economic contracting metrics, and supplier diversity reporting. It helps analysts segment award activity and assess compliance or progress against procurement goals tied to veteran-owned participation.
Example Value
0
Observed Non-Null Count
111,509,025

FPDS Compare

FPDS Query Variable
content__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isVeteranOwned
FPDS XML Path
award/vendor/vendorSiteDetails/vendorSocioEconomicIndicators/isVeteranOwned
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/vendor/vendorSiteDetails/vendorSocioEconomicIndicators/isVeteranOwned' into the SQL-ready variable 'content__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isVeteranOwned'.

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 awards to veteran-owned vendors
  • Calculate obligation share to veteran-owned businesses
  • Compare socio-economic contracting across agencies or periods

Common Mistakes

  • Assuming 0 always means false without confirming the query encoding
  • Counting vendor status as award status without checking the record level and join grain

Query Guidance

Use this field in WHERE clauses after confirming the code mapping for true/false in your dataset. For example, filter for the veteran-owned condition explicitly rather than relying on non-null tests, and group by this flag only when the analysis is intended to compare veteran-owned versus non-veteran-owned awards. If the extract stores coded values, inspect distinct values first and align them with any companion description field before writing SQL.

SQL Examples

Preview values

SELECT
    content__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isVeteranOwned AS is_veteran_owned
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isVeteranOwned IS NOT NULL
LIMIT 25

Flag distribution

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