Search Results pay_us_counties

Overview

The PAY_US_COUNTIES table is a core reference table within the Oracle E-Business Suite (EBS) Payroll module, specifically for the United States localization. Owned by the HR schema, its primary function is to store a validated list of U.S. counties and their associated VERTEX geocodes. This table is essential for ensuring accurate address validation and is a foundational component for calculating and reporting jurisdictional taxes. It serves as a master data source for county-level information, enabling the system to correctly associate employee addresses with specific tax authorities, school districts, and other geographic-based rules within the payroll and HRMS applications.

Key Information Stored

The table's structure is designed to uniquely identify each county within the context of its state. The primary key (PAY_US_COUNTIES_PK) is a composite of STATE_CODE and COUNTY_CODE, ensuring a unique record for each county. A unique key (PAY_US_COUNTIES_UK2) on COUNTY_NAME and STATE_CODE further enforces data integrity for naming. While the full column list is not detailed in the provided metadata, the core columns logically include STATE_CODE (references PAY_US_STATES), COUNTY_CODE (the identifier, often numeric), COUNTY_NAME, and fields for VERTEX geocode data. These geocodes are critical for interfacing with third-party tax calculation services.

Common Use Cases and Queries

The primary use case is the validation and enrichment of U.S. addresses during employee data entry or batch processing. It is also queried extensively during payroll calculations to determine applicable county-level tax rules. Common reporting involves listing counties within a state for setup or audit purposes. A typical query to retrieve all counties for a state, such as California, would be:

• SELECT county_code, county_name FROM hr.pay_us_counties WHERE state_code = 'CA' ORDER BY county_name;

Another frequent pattern is joining to related tax tables to verify setup, for example, linking counties to their defined tax rules via PAY_US_EMP_COUNTY_TAX_RULES_F.

Related Objects

As indicated by its foreign key relationships, PAY_US_COUNTIES is a central hub in the US payroll geography hierarchy. Key related objects include:

• PAY_US_STATES: The parent table, referenced by STATE_CODE.
• PAY_US_CITY_GEOCODES: References this table to associate cities with their correct county.
• PAY_US_COUNTY_SCHOOL_DSTS: Depends on it for defining school districts within counties.
• PAY_US_EMP_COUNTY_TAX_RULES_F: Perhaps the most critical dependency, this table holds the actual taxability rules and rates that are applied based on the employee's assigned county from PAY_US_COUNTIES.

These relationships underscore the table's role in ensuring a consistent and accurate geographic framework for U.S. payroll tax processing in both EBS 12.1.1 and 12.2.2.