Search Results secondary_school_cd




Overview
Explore in AI Chat

Overview

The IGS_AD_AUS_SEC_ED_SC table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, as indicated by the IGS (iGrad Student) schema. Its primary function is to serve as a master repository for secondary education schools within Australia. This table is essential for maintaining data integrity in the admissions and student records processes, enabling the system to consistently validate and reference Australian secondary schools using standardized codes. It acts as a lookup table for other transactional entities, ensuring accurate and consistent recording of a student's prior educational background.

Key Information Stored

The table stores descriptive and administrative attributes for each school. The primary identifier is the SECONDARY_SCHOOL_CD, a mandatory 10-character code. The SECONDARY_SCHOOL_NAME column holds the full school name. Critical geographical and categorical data is captured via STATE_CD (e.g., NSW, VIC) and S_SCNDRY_SCHOOL_TYPE (e.g., State, Independ). The operational status of a school record is controlled by the CLOSED_IND flag, which, when set, prevents the code from being used in new records. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit history for each row.

Common Use Cases and Queries

A primary use case is the validation and population of school information during the student application or enrollment process. When an applicant enters their prior secondary school, the system validates the code against this table. Reporting on applicant demographics by state or school type also relies on this data. Common queries include fetching active schools for a specific state or locating a school by name fragment. For example, to find all active secondary schools in New South Wales (NSW), one might use:

SELECT SECONDARY_SCHOOL_CD, SECONDARY_SCHOOL_NAME, S_SCNDRY_SCHOOL_TYPE
FROM IGS.IGS_AD_AUS_SEC_ED_SC
WHERE STATE_CD = 'NSW'
  AND (CLOSED_IND IS NULL OR CLOSED_IND != 'Y')
ORDER BY SECONDARY_SCHOOL_NAME;

Another typical query involves joining this table to student records to generate a list of enrolled students with their prior schools.

Related Objects

The table has a defined relationship as a parent table in a foreign key constraint. It is referenced by:

  • TABLE: IGS.IGS_AD_AUS_SEC_EDU via the column SECONDARY_SCHOOL_CD. This table likely stores detailed secondary education records for individual applicants or students, with the SECONDARY_SCHOOL_CD foreign key ensuring that only valid, master school codes from IGS_AD_AUS_SEC_ED_SC are used.

The table's primary key, IGS_AD_AUS_SEC_ED_SC_PK, is defined on the SECONDARY_SCHOOL_CD column, guaranteeing uniqueness. The unique index IGS_AD_AUS_SEC_ED_SC_U1 also enforces this on the same column.