FPDS Query Library
About Us
Contact Us

Is Community Developed Corporation Owned Firm

Boolean or coded flag indicating whether the vendor is identified as a community developed corporation owned firm in the IDV vendor site details. A value of 1/true means the record is marked as meeting this business-type condition; 0/false means it is not.

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__vendorBusinessTypes__isCommunityDevelopedCorporationOwnedFirm
Title
Is Community Developed Corporation Owned Firm
FPDS Path
IDV/vendor/vendorSiteDetails/vendorBusinessTypes/isCommunityDevelopedCorporationOwnedFirm
Description
Boolean or coded flag indicating whether the vendor is identified as a community developed corporation owned firm in the IDV vendor site details. A value of 1/true means the record is marked as meeting this business-type condition; 0/false means it is not.
Business Meaning
This field helps analysts identify awards going to vendors with a specific ownership or socioeconomic-related business classification. It is useful for set-aside analysis, supplier diversity reviews, and monitoring how often this vendor type appears in IDV award populations.
Example Value
0
Observed Non-Null Count
5,862,557

FPDS Compare

FPDS Query Variable
content__IDV__vendor__vendorSiteDetails__vendorBusinessTypes__isCommunityDevelopedCorporationOwnedFirm
FPDS XML Path
IDV/vendor/vendorSiteDetails/vendorBusinessTypes/isCommunityDevelopedCorporationOwnedFirm
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/vendor/vendorSiteDetails/vendorBusinessTypes/isCommunityDevelopedCorporationOwnedFirm' into the SQL-ready variable 'content__IDV__vendor__vendorSiteDetails__vendorBusinessTypes__isCommunityDevelopedCorporationOwnedFirm'.

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 to vendors marked as community developed corporation owned firms
  • Count awards or obligations associated with this vendor type
  • Compare award patterns for this classification against other business types

Common Mistakes

  • Assuming null or blank means false rather than missing or unreported
  • Using the flag without checking whether the dataset encodes booleans as 0/1, Y/N, or text

Query Guidance

Use explicit boolean or code comparisons such as = 1, = 'Y', or the dataset's documented true value, and exclude nulls separately if you need a clean population. When grouping, standardize the flag to a consistent binary definition before counting or joining.

SQL Examples

Preview values

SELECT
    content__IDV__vendor__vendorSiteDetails__vendorBusinessTypes__isCommunityDevelopedCorporationOwnedFirm AS is_community_developed_corporation_owned_firm
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorBusinessTypes__isCommunityDevelopedCorporationOwnedFirm IS NOT NULL
LIMIT 25

Flag distribution

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