Search Results pay_us_county_school_dsts_pk




Overview
Explore in AI Chat

Overview

The HR.PAY_US_COUNTY_SCHOOL_DSTS table is a seed data table within the Oracle E-Business Suite Human Resources (HR) and Payroll modules, specifically for the U.S. localization. Its primary role is to support accurate tax calculations by maintaining a master list of VERTEX geocodes for school districts that span multiple counties. This geocode data is critical for the system's tax engine, particularly when interfacing with third-party tax calculation services like VERTEX, to determine the correct jurisdictional tax rules for employees based on their work location. The table is stored in the APPS_TS_SEED tablespace, indicating it is part of the foundational, static data provided by Oracle for application setup.

Key Information Stored

The table is structured to uniquely identify a school district within the context of a specific state and county. The key columns are:

  • SCHOOL_DST_CODE (VARCHAR2): The core data element, storing the official VERTEX geocode for the county school district.
  • STATE_CODE (VARCHAR2): A foreign key to the PAY_US_COUNTIES table, identifying the U.S. state.
  • COUNTY_CODE (VARCHAR2): A foreign key to the PAY_US_COUNTIES table, identifying the specific county within the state.
  • SCHOOL_DST_NAME (VARCHAR2(15)): The descriptive name of the school district.

The combination of SCHOOL_DST_CODE, STATE_CODE, and COUNTY_CODE forms the primary key (PAY_US_COUNTY_SCHOOL_DSTS_PK), ensuring each record is unique. This composite key structure is necessary because a single school district geocode can be associated with multiple counties.

Common Use Cases and Queries

This table is primarily referenced during payroll processing for U.S. employees. When calculating county-level taxes, the system uses this data to map an employee's work location to the correct school district tax jurisdiction. A typical query involves retrieving the geocode for reporting or validation purposes. The standard query pattern, as indicated in the ETRM, is:

SELECT SCHOOL_DST_CODE, STATE_CODE, COUNTY_CODE, SCHOOL_DST_NAME FROM HR.PAY_US_COUNTY_SCHOOL_DSTS;

For integration or data validation, a common join is to the PAY_US_COUNTIES table to get full county names. For example, to list all school districts with their full county and state information, a query would join on both STATE_CODE and COUNTY_CODE. This table is not typically subject to high-volume transactional DML operations by end-users; it is maintained as part of tax code updates delivered by Oracle or applied during implementation.

Related Objects

The table has defined relationships with other seed data tables in the HR schema, forming a hierarchy for U.S. geographic tax data.

  • Primary Key: PAY_US_COUNTY_SCHOOL_DSTS_PK on (SCHOOL_DST_CODE, STATE_CODE, COUNTY_CODE). This is the key referenced by the user's search term.
  • Foreign Key (PAY_US_COUNTY_SCHOOL_DSTS_FK1): The table references the HR.PAY_US_COUNTIES table twice.
    • Column STATE_CODE references PAY_US_COUNTIES
    • Column COUNTY_CODE references PAY_US_COUNTIES
    This ensures that every school district record is linked to a valid, existing state and county combination in the system.
  • Dependencies: The ETRM notes that the table is referenced by public synonyms (APPS.PAY_US_COUNTY_SCHOOL_DSTS, PUBLIC.PAY_US_COUNTY_SCHOOL_DSTS), allowing other schemas and modules within EBS to access this data seamlessly through the standard APPS synonym.