Search Results zip_end




Overview
Explore in AI Chat

Overview

The HR_S_US_ZIP_CODES table is a foundational data object within the Oracle E-Business Suite Human Resources (PER) module. Its primary role is to store valid United States postal (ZIP) code ranges specifically for cities integrated with the VERTEX tax service. This table acts as a critical reference dataset for validating the accuracy and tax jurisdiction of US addresses entered into the system. By maintaining a repository of valid ZIP code ranges mapped to specific state, county, and city codes, it ensures that address data conforms to known, taxable jurisdictions, which is essential for accurate payroll tax calculations and regulatory compliance.

Key Information Stored

The table is structured to define ZIP code ranges and their associated geographic hierarchies. The documented columns form a composite primary key, establishing the uniqueness of each record. The key columns are:

  • ZIP_START: The beginning value of a contiguous range of valid ZIP codes.
  • ZIP_END: The ending value of the same contiguous ZIP code range.
  • STATE_CODE: The code representing the US state for the ZIP code range.
  • COUNTY_CODE: The code representing the county within the specified state.
  • CITY_CODE: The code representing the city within the specified county and state.

This structure allows the system to efficiently validate if a given five-digit ZIP code falls within a known range and to immediately identify its corresponding city, county, and state for tax purposes.

Common Use Cases and Queries

The most frequent use case is the validation of a US address during data entry, typically in employee or supplier address forms. A common query pattern involves checking a single ZIP code against the defined ranges to retrieve its geographic breakdown. For example:

SELECT state_code, county_code, city_code FROM hr.hr_s_us_zip_codes WHERE '94105' BETWEEN zip_start AND zip_end;

Another critical use is in reporting and data integrity checks, where addresses may be analyzed to ensure they map to a valid VERTEX jurisdiction. Administrators might run queries to identify gaps in coverage or to audit the table's contents. The table is also central to batch processes that validate large volumes of existing address data for tax reporting readiness.

Related Objects

Based on the provided metadata, the primary defined relationship for this table is its own primary key constraint, HR_S_US_ZIP_CODES_PK, on the columns (ZIP_START, ZIP_END, STATE_CODE, COUNTY_CODE, CITY_CODE). This table is a reference source, meaning other tables or views within the HR or Financials modules likely hold foreign keys to these columns to enforce referential integrity for address data. While specific foreign key constraints are not listed in the excerpt, this table is intrinsically linked to any EBS component that stores or processes US addresses for tax purposes, such as payroll (PY), payables (AP), or receivables (AR) tables containing location or tax jurisdiction information. It serves as the authoritative source for the VERTEX city geographic hierarchy.