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 Other Transaction IDV record. The field captures a specific vendor business-type status at the site level rather than a contract action attribute.

Family: Other Transaction 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__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__isCommunityDevelopedCorporationOwnedFirm
Title
Is Community Developed Corporation Owned Firm
FPDS Path
OtherTransactionIDV/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 Other Transaction IDV record. The field captures a specific vendor business-type status at the site level rather than a contract action attribute.
Business Meaning
This flag helps analysts isolate awards associated with a specific socioeconomic or organizational vendor category for reporting, compliance review, and market segmentation. It can support analysis of participation patterns, award concentration, and whether transactions involve firms with designated community-development characteristics.
Example Value
0
Observed Non-Null Count
13,417

FPDS Compare

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

  • Filter transactions involving community developed corporation-owned firms
  • Segment award data by vendor business type
  • Support compliance and socioeconomic participation analysis

Common Mistakes

  • Interpreting the flag as a contract-level characteristic instead of a vendor site attribute
  • Assuming null, blank, or 0 all mean the same thing without checking the source encoding

Query Guidance

In SQL, filter on the expected affirmative code after confirming the source encoding, for example WHERE field = 1 or WHERE field = 'Y'. If the dataset includes paired description fields or multiple code values, test distinct values first and apply explicit null handling to avoid misclassification.

SQL Examples

Preview values

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

Flag distribution

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