FPDS Query Library
About Us
Contact Us

Is Community Developed Corporation Owned Firm

Boolean or coded flag indicating whether the vendor site is identified as a community developed corporation owned firm in the FPDS Other Transaction Award record. It records the presence of this vendor-business classification at the site level, not a narrative description.

Family: Other Transaction 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__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__isCommunityDevelopedCorporationOwnedFirm
Title
Is Community Developed Corporation Owned Firm
FPDS Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorBusinessTypes/isCommunityDevelopedCorporationOwnedFirm
Description
Boolean or coded flag indicating whether the vendor site is identified as a community developed corporation owned firm in the FPDS Other Transaction Award record. It records the presence of this vendor-business classification at the site level, not a narrative description.
Business Meaning
This field supports socioeconomic and supplier-diversity analysis by identifying awards associated with a specific ownership category. Analysts use it to segment vendor populations, assess program reach, and evaluate compliance or reporting patterns tied to vendor business type attributes.
Example Value
0
Observed Non-Null Count
38,894

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__isCommunityDevelopedCorporationOwnedFirm
FPDS XML Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorBusinessTypes/isCommunityDevelopedCorporationOwnedFirm
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorBusinessTypes/isCommunityDevelopedCorporationOwnedFirm' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__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

  • socioeconomic vendor segmentation
  • supplier diversity reporting
  • award-level compliance analysis

Common Mistakes

  • assuming the field identifies the prime contractor rather than the vendor site
  • treating a coded flag as free-text without checking observed values or paired descriptions

Query Guidance

Filter for true/affirmative values using the observed code set in your extract, for example WHERE field = 1 or WHERE field IN ('Y','Yes','True'). If the dataset includes multiple vendor site rows per award, deduplicate or aggregate at the award/vendor level before counting.

SQL Examples

Preview values

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

Flag distribution

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