Search Results pay_us_city_school_dsts




Overview
Explore in AI Chat

Overview

The PAY_US_CITY_SCHOOL_DSTS table is a core data structure within the Oracle E-Business Suite Payroll (PAY) module, specifically for U.S. localization. It functions as a reference table that stores Vertex-supplied geocodes to uniquely identify school districts that exist within a specific city. Its primary role is to support the accurate calculation and withholding of local taxes, particularly school district taxes, which can vary significantly within a single city or county. By maintaining this precise geographic mapping, the table ensures payroll tax calculations adhere to the correct jurisdictional rules, a critical requirement for U.S. payroll compliance in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to uniquely identify a school district through a composite key and link it to a parent geographic location. The critical columns form the primary key (PAY_US_CITY_SCHOOL_DSTS_PK) and establish a foreign key relationship to city-level data.

  • SCHOOL_DST_CODE: The unique identifier for the school district within the specified city.
  • STATE_CODE: The standard code (e.g., 'CA', 'NY') for the U.S. state.
  • COUNTY_CODE: The code identifying the county within the state.
  • CITY_CODE: The code identifying the city within the county.

Together, STATE_CODE, COUNTY_CODE, and CITY_CODE form a foreign key to the PAY_US_CITY_GEOCODES table, anchoring the school district record to its correct municipal location.

Common Use Cases and Queries

This table is primarily accessed during payroll processing to determine the applicable school district tax rules for an employee's work or residence location. It is essential for generating accurate tax withholdings on payslips and for year-end reporting. A typical query would involve joining this table to employee address or assignment tables via the city geocode relationship to retrieve the valid SCHOOL_DST_CODE for tax calculation logic.

Sample Query Pattern:
SELECT school_dst_code
FROM hr.pay_us_city_school_dsts
WHERE state_code = 'OH'
AND county_code = '035'
AND city_code = '12345';

This table is also central to setup and maintenance tasks within the "US Local Tax Rules" or similar geocode maintenance forms in the EBS HRMS Payroll responsibility, where administrators define and validate the mapping of school districts to cities.

Related Objects

The PAY_US_CITY_SCHOOL_DSTS table has a direct and critical dependency on the PAY_US_CITY_GEOCODES table, as defined by its foreign key. This relationship ensures referential integrity, meaning a school district record cannot exist without a valid parent city record. The table is also fundamentally related to other Vertex geocode tables in the HR schema, such as PAY_US_COUNTY_GEOCODES and PAY_US_STATE_GEOCODES, forming a hierarchy for geographic tax jurisdiction setup. Ultimately, data from this table is referenced by the core payroll calculation engine and tax rules to perform withholding calculations, and it may be joined to employee tax records (e.g., in PAY_US_EMP_TAX_INFO_F) for reporting purposes.