Is for Profit Organization
Boolean or coded flag indicating whether the vendor organization associated with the IDV is classified as a for-profit entity. It captures the organization’s profit structure rather than a contract action attribute. Example values may be stored as 0/1 or equivalent code representations depending on the FPDS extract.
FPDS Compare
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 for-profit vendors only
- Compare award volumes by vendor organization type
- Support compliance or socioeconomic segmentation
Common Mistakes
- Treating the flag as a contract-level profitability measure
- Assuming 0 always means false without checking the extract’s code conventions
Query Guidance
Use the field as a WHERE filter or grouping dimension after confirming the dataset’s code mapping. In SQL, test explicitly for the values that represent for-profit status, and handle nulls separately; for example, compare against the observed true code rather than relying on implicit casting.
SQL Examples
Preview values
SELECT
content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isForProfitOrganization AS is_for_profit_organization
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isForProfitOrganization IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isForProfitOrganization AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isForProfitOrganization 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.