FPDS Query Library
About Us
Contact Us

Division Number or Office Code

A code or label that identifies the vendor’s division, office, or similar organizational unit as recorded on the IDV vendor site details record. It is an organizational identifier rather than a procurement action number or contract identifier.

Family: IDV
Category: Vendor Site Details
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__vendor__vendorSiteDetails__divisionNumberOrOfficeCode
Title
Division Number or Office Code
FPDS Path
IDV/vendor/vendorSiteDetails/divisionNumberOrOfficeCode
Description
A code or label that identifies the vendor’s division, office, or similar organizational unit as recorded on the IDV vendor site details record. It is an organizational identifier rather than a procurement action number or contract identifier.
Business Meaning
This field helps analysts distinguish which vendor office, branch, or division is associated with an IDV award, which can matter for vendor profiling, market concentration analysis, and matching awards to the correct corporate entity or operating location. It can also support duplicate detection and segmentation when a parent vendor has multiple offices or divisions in FPDS.
Example Value
NORTH AMER
Observed Non-Null Count
5

FPDS Compare

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

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 IDVs by vendor office or division
  • Matching awards to vendor site records for entity resolution
  • Filtering awards tied to a specific branch, region, or operating unit

Common Mistakes

  • Assuming it is the vendor's legal name or CAGE/UEI
  • Treating abbreviated values as standardized across all vendors without validation

Query Guidance

Use it as a categorical filter or grouping key, and normalize casing/spacing if you need exact matching across records. In SQL, prefer `TRIM()` and `UPPER()` for comparisons, and inspect distinct values before building joins because the field may contain free-text abbreviations or office labels rather than a controlled code set.

SQL Examples

Preview values

SELECT
    content__IDV__vendor__vendorSiteDetails__divisionNumberOrOfficeCode AS division_number_or_office_code
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__divisionNumberOrOfficeCode IS NOT NULL
LIMIT 25

Top values

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