Search Results hr_s_us_city_school_dsts_pk




Overview
Explore in AI Chat

Overview

The HR.HR_S_US_CITY_SCHOOL_DSTS table is a reference data table within the Oracle E-Business Suite Human Resources (HRMS) module, specifically for releases 12.1.1 and 12.2.2. It functions as a lookup table to store and maintain standardized codes and names for school districts within the United States, organized by their geographic hierarchy of state, county, and city. Its primary role is to support data integrity and validation in processes where school district information is required, such as in employee or dependent records for tax or benefits purposes. As indicated by its storage in the APPS_TS_INTERFACE tablespace and the associated warning, this table is part of the application's internal architecture. Direct data manipulation or querying outside of standard Oracle Applications programs is not supported by Oracle.

Key Information Stored

The table's structure is designed to uniquely identify a school district through a composite key and provide its descriptive name. The key columns form a geographic hierarchy: STATE_CODE, COUNTY_CODE, and CITY_CODE, culminating in the specific SCHOOL_DST_CODE. This design ensures each district is correctly scoped within its municipal boundaries. The SCHOOL_DST_NAME column holds the descriptive text for the district. The primary key constraint, HR_S_US_CITY_SCHOOL_DSTS_PK, is enforced on the combination of SCHOOL_DST_CODE, STATE_CODE, COUNTY_CODE, and CITY_CODE, guaranteeing uniqueness for this composite identifier.

  • SCHOOL_DST_CODE: The identifier for the school district.
  • STATE_CODE: The code for the U.S. state.
  • COUNTY_CODE: The code for the county within the state.
  • CITY_CODE: The code for the city within the county.
  • SCHOOL_DST_NAME: The full name of the school district (up to 15 characters).

Common Use Cases and Queries

This table is primarily referenced by Oracle EBS application code for validating and displaying school district information. A common use case is during the entry of an employee's work or tax location, where the system may validate the provided school district code against the defined geographic hierarchy. For reporting or data verification purposes, a typical query would select all districts within a specific state and county. The standard query pattern, as provided in the ETRM, is a straightforward selection of all columns.

Sample Query: To list all school districts for a given city (e.g., city code '001' in county '037' of state 'CA'), one would use:
SELECT SCHOOL_DST_CODE, SCHOOL_DST_NAME FROM HR.HR_S_US_CITY_SCHOOL_DSTS WHERE STATE_CODE = 'CA' AND COUNTY_CODE = '037' AND CITY_CODE = '001' ORDER BY SCHOOL_DST_CODE;

Related Objects

Based on the provided dependency information, the HR.HR_S_US_CITY_SCHOOL_DSTS table does not reference other objects but is itself referenced. The documented relationship is its primary key, HR_S_US_CITY_SCHOOL_DSTS_PK. The table is exposed through public synonyms (APPS.HR_S_US_CITY_SCHOOL_DSTS and PUBLIC.HR_S_US_CITY_SCHOOL_DSTS) for use within the application's standard programs. Other application tables, likely within the HR or Payroll schemas, would contain foreign key columns (e.g., SCHOOL_DST_CODE, STATE_CODE, COUNTY_CODE, CITY_CODE) that reference this table's composite primary key to enforce referential integrity for school district data.