FPDS Query Library
About Us
Contact Us

Division Name

Human-readable name of the vendor division associated with the IDV award site details. It identifies the division-level label stored for the vendor record rather than a procurement code or numeric identifier.

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

Variable Overview

FPDS Query Variable
content__IDV__vendor__vendorSiteDetails__divisionName
Title
Division Name
FPDS Path
IDV/vendor/vendorSiteDetails/divisionName
Description
Human-readable name of the vendor division associated with the IDV award site details. It identifies the division-level label stored for the vendor record rather than a procurement code or numeric identifier.
Business Meaning
This field helps analysts distinguish which corporate division or operating unit is tied to an IDV vendor record, which can matter when aggregating awards, matching vendors across records, or separating parent-company activity from division-level activity. It is useful for vendor identity resolution, subcontractor or franchise analysis, and understanding how awards are attributed within a larger organization.
Example Value
NORTH AMERICAN RESCUE LLC
Observed Non-Null Count
38

FPDS Compare

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

Use Cases

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

Common Usage

  • Display the vendor division name in award or vendor extracts
  • Group records by division-level vendor identity
  • Support vendor normalization and entity resolution

Common Mistakes

  • Using it as a unique vendor identifier or join key
  • Assuming it always matches the legal business name or parent company name

Query Guidance

Select and group by this field only when you need a division label for reporting or deduplication support. In SQL, pair it with vendor name, DUNS/UEI-related fields, or other vendor identifiers for joins and validation, and use NULL/blank checks because the field may be missing or inconsistent across records.

SQL Examples

Preview values

SELECT
    content__IDV__vendor__vendorSiteDetails__divisionName AS division_name
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__divisionName IS NOT NULL
LIMIT 25

Top values

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