FPDS Query Library
About Us
Contact Us

Is Veteran Owned

Boolean or coded flag indicating whether the vendor associated with the IDV is reported as veteran-owned in the vendor socio-economic indicators section. A value such as 0 typically means the record does not indicate veteran-owned status, while other observed values should be checked against the source system’s code set.

Family: IDV
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__IDV__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isVeteranOwned
Title
Is Veteran Owned
FPDS Path
IDV/vendor/vendorSiteDetails/vendorSocioEconomicIndicators/isVeteranOwned
Description
Boolean or coded flag indicating whether the vendor associated with the IDV is reported as veteran-owned in the vendor socio-economic indicators section. A value such as 0 typically means the record does not indicate veteran-owned status, while other observed values should be checked against the source system’s code set.
Business Meaning
This field supports socioeconomic vendor analysis, set-aside monitoring, and reporting on participation by veteran-owned businesses in federal procurement. Analysts use it to measure vendor mix, assess compliance with small business and socioeconomic objectives, and segment awards by ownership status.
Example Value
0
Observed Non-Null Count
5,862,557

FPDS Compare

FPDS Query Variable
content__IDV__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isVeteranOwned
FPDS XML Path
IDV/vendor/vendorSiteDetails/vendorSocioEconomicIndicators/isVeteranOwned
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/vendor/vendorSiteDetails/vendorSocioEconomicIndicators/isVeteranOwned' into the SQL-ready variable 'content__IDV__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 IDVs awarded to veteran-owned vendors
  • Count or trend veteran-owned participation by agency, vendor, or time period
  • Segment socioeconomic analyses across vendor ownership categories

Common Mistakes

  • Assuming a 0 value always means false without confirming the source code definition
  • Using this field as award-level socioeconomic status instead of vendor-site status

Query Guidance

Use this field in WHERE clauses only after confirming its coding conventions, for example `WHERE isVeteranOwned = 1` or `WHERE isVeteranOwned IN ('Y','Yes','1')` depending on observed values. When aggregating, de-duplicate at the vendor or IDV level as needed because the indicator may repeat across site records.

SQL Examples

Preview values

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

Flag distribution

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