Is Other Not for Profit Organization
Boolean or coded flag indicating whether the vendor is classified as another type of nonprofit organization in the IDV vendor site details structure. It captures the presence of that profit-structure condition for the vendor record rather than a descriptive profile of the organization. Example value 0 indicates the condition is not met.
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 involving nonprofit vendor classifications
- Segment vendor populations for organizational-type analysis
- Support compliance or audit checks on vendor structure fields
Common Mistakes
- Assuming the example value 0 always means false without checking the code definition
- Using the flag alone to classify the entire vendor when the record may contain nested or paired descriptive fields
Query Guidance
Use the field as a filter or grouping attribute after confirming its coded values in the source extract. In SQL, test explicitly for the value that represents the nonprofit condition, and if needed join or select the paired description field to validate interpretation; for example, filter on the affirmative code rather than relying on non-null checks.
SQL Examples
Preview values
SELECT
content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isOtherNotForProfitOrganization AS is_other_not_for_profit_organization
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isOtherNotForProfitOrganization IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isOtherNotForProfitOrganization AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isOtherNotForProfitOrganization 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.