FPDS Query Library
About Us
Contact Us

Organizational Type

Human-readable organizational form reported for the vendor site, such as partnership, corporation, or sole proprietorship. It identifies the vendor’s legal/organizational structure rather than a measure of performance or size.

Family: IDV
Category: Vendor Site Details
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__organizationalType
Title
Organizational Type
FPDS Path
IDV/vendor/vendorSiteDetails/vendorOrganizationFactors/organizationalType
Description
Human-readable organizational form reported for the vendor site, such as partnership, corporation, or sole proprietorship. It identifies the vendor’s legal/organizational structure rather than a measure of performance or size.
Business Meaning
This field helps analysts segment awards by vendor structure and compare participation patterns across organizational types. It is useful for set-asides, supplier profiling, market research, and checking whether certain organizational forms are over- or under-represented in a procurement portfolio.
Example Value
PARTNERSHIP
Observed Non-Null Count
3,416,519

FPDS Compare

FPDS Query Variable
content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__organizationalType
FPDS XML Path
IDV/vendor/vendorSiteDetails/vendorOrganizationFactors/organizationalType
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/vendor/vendorSiteDetails/vendorOrganizationFactors/organizationalType' into the SQL-ready variable 'content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__organizationalType'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Contractor profiling and competitor analysis

Common Usage

  • Vendor segmentation by legal structure
  • Filtering awards for market research or supplier diversity analysis
  • Grouping and comparing obligation totals by organizational form

Common Mistakes

  • Assuming the value indicates business size, ownership, or socioeconomic status
  • Aggregating without normalizing spelling variants or unexpected codes

Query Guidance

Use it as a grouping or filter column in WHERE and GROUP BY clauses after normalizing case and trimming whitespace. If the dataset includes coded-and-described pairs elsewhere, prefer the human-readable label for reporting and verify distinct observed values before building joins or dashboards.

SQL Examples

Preview values

SELECT
    content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__organizationalType AS organizational_type
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__organizationalType IS NOT NULL
LIMIT 25

Top values

SELECT
    content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__organizationalType AS value,
    count() AS record_count
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorOrganizationFactors__organizationalType IS NOT NULL
GROUP BY value
ORDER BY record_count DESC
LIMIT 25

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.