Is for Profit Organization
Boolean or coded flag indicating whether the vendor is organized as a for-profit entity in the award record's vendor site details. A value such as 0 typically means no, while 1 typically means yes; confirm the observed encoding in the dataset before filtering.
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 awards to for-profit vendors
- Segment spending by vendor organizational type
- Support compliance and eligibility analyses
Common Mistakes
- Assuming the code meaning without checking observed values
- Using the field alone to infer tax status, legal form, or nonprofit registration
Query Guidance
Use explicit comparisons against the observed code set, for example WHERE isForProfitOrganization = 1 for for-profit vendors. If the field is stored as text or mixed codes, normalize values first and handle nulls separately to avoid misclassification.
SQL Examples
Preview values
SELECT
content__award__vendor__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isForProfitOrganization AS is_for_profit_organization
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isForProfitOrganization IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__award__vendor__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isForProfitOrganization AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__award__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.