FPDS Query Library
About Us
Contact Us

Organizational Type

Human-readable organization classification reported for the vendor site on an Other Transaction Award record. It identifies the vendor's organizational type, such as a corporate or tax-exempt form, rather than a transaction attribute.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorOrganizationFactors__organizationalType
Title
Organizational Type
FPDS Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorOrganizationFactors/organizationalType
Description
Human-readable organization classification reported for the vendor site on an Other Transaction Award record. It identifies the vendor's organizational type, such as a corporate or tax-exempt form, rather than a transaction attribute.
Business Meaning
This field helps analysts segment awards by vendor legal/organizational structure, which can affect eligibility, compliance review, subcontracting behavior, and interpretation of award patterns across supplier types. It is useful for comparing how Other Transaction Awards are distributed among organization categories and for supporting vendor profile analysis.
Example Value
CORPORATE TAX EXEMPT
Observed Non-Null Count
38,882

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorOrganizationFactors__organizationalType
FPDS XML Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorOrganizationFactors/organizationalType
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorOrganizationFactors/organizationalType' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__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

  • Grouping awards by vendor organization type
  • Filtering supplier populations for compliance or portfolio analysis
  • Comparing award activity across corporate, nonprofit, and other entity types

Common Mistakes

  • Confusing this with vendor name, socioeconomic status, or ownership type
  • Assuming exact spelling or casing is normalized across all records

Query Guidance

Use it as a dimension field in GROUP BY, DISTINCT, and WHERE clauses, but normalize values first if the dataset contains variants such as mixed case or alternate labels. When joining or filtering, prefer this field for descriptive analysis only; if a coded companion field exists, keep the code as the primary key and the description as display text.

SQL Examples

Preview values

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

Top values

SELECT
    content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorOrganizationFactors__organizationalType AS value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__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.