Search Results pay_us_county_school_dsts




Overview
Explore in AI Chat

Overview

The PAY_US_COUNTY_SCHOOL_DSTS table is a core reference data object within the Oracle E-Business Suite Payroll (PAY) module, specifically for the US localization. It is designed to support the accurate calculation of school district taxes in jurisdictions where a single school district spans multiple counties. The table's primary function is to store VERTEX geocodes, which are standardized geographic identifiers used by the Vertex tax calculation engine integrated within Oracle EBS. This table ensures that payroll tax processing can correctly associate an employee's work location with the appropriate school district tax rules, even when those districts cross traditional county boundaries. Its existence is critical for maintaining compliance with complex, geographically-dependent tax regulations in the United States.

Key Information Stored

The table's structure is defined by a composite primary key and columns that establish precise geographic relationships. The primary key consists of SCHOOL_DST_CODE, STATE_CODE, and COUNTY_CODE, uniquely identifying a school district's presence within a specific county. The SCHOOL_DST_CODE holds the identifier for the school district itself. The STATE_CODE and COUNTY_CODE columns work together to specify the county (within a state) that a portion of the school district occupies. Collectively, these columns map the multi-county coverage of a school district to the corresponding VERTEX geocode, which is the system's authoritative reference for tax calculation logic.

Common Use Cases and Queries

The primary use case is during the payroll calculation process, where the system references this table to determine the correct school district tax jurisdiction for an employee based on their assigned work location's state and county. A typical query would retrieve all school districts applicable to a given county for validation or reporting purposes. For example:

SELECT SCHOOL_DST_CODE FROM HR.PAY_US_COUNTY_SCHOOL_DSTS WHERE STATE_CODE = 'CA' AND COUNTY_CODE = '075';

This would list all school districts spanning the specified California county. Data in this table is typically maintained through seeded data provided by Oracle or via dedicated tax update processes, rather than through direct application user entry. Reporting use cases include audits of tax jurisdiction setups and validating the geographic coverage of school districts for implementation or upgrade projects.

Related Objects

This table has a direct and documented foreign key relationship with the PAY_US_COUNTIES table, which is the master reference for county definitions within the system. The relationship ensures referential integrity, guaranteeing that any state and county code combination stored in PAY_US_COUNTY_SCHOOL_DSTS exists as a valid record in the counties master table.

  • Foreign Key to PAY_US_COUNTIES: The columns PAY_US_COUNTY_SCHOOL_DSTS.STATE_CODE and PAY_US_COUNTY_SCHOOL_DSTS.COUNTY_CODE reference the corresponding columns in PAY_US_COUNTIES. This is a critical relationship for validating geographic hierarchy.
  • Primary Key Constraint: The PAY_US_COUNTY_SCHOOL_DSTS_PK constraint enforces uniqueness on the combination of SCHOOL_DST_CODE, STATE_CODE, and COUNTY_CODE.

This table is also intrinsically linked to the underlying Vertex tax engine logic and other payroll tax calculation tables that utilize the school district codes it provides.