Search Results igs_ad_aus_sec_ed_sc_pk

Overview

The table IGS_AD_AUS_SEC_ED_SC is a data object within the Oracle E-Business Suite (EBS) Student System (IGS). As indicated by its description, it serves as a reference table designed to store descriptive information about secondary education schools within Australia. Its primary role is to provide a standardized, normalized list of schools, likely used during the student admissions process to ensure consistent recording of an applicant's educational background. Critically, the provided ETRM metadata explicitly states this table is part of an "Obsolete" module and was "Not implemented in this database" for the specific instance documented. This indicates that while the table structure exists in the data dictionary, it may not contain active data in all deployments, and its associated functionality may be deprecated or superseded in versions 12.1.1 and 12.2.2.

Key Information Stored

Based on the documented structure, the table's central piece of information is a school code identifier. The primary key constraint IGS_AD_AUS_SEC_ED_SC_PK is defined on the column SECONDARY_SCHOOL_CD. This implies this column is the unique key for each record, typically storing a standardized code for an Australian secondary school. While the full column list is not provided in the excerpt, a table with this description would logically contain additional columns to "describe" the schools, such as school name, address, state, and potentially status or type. The SECONDARY_SCHOOL_CD is the critical foreign key column referenced by other tables in the system.

Common Use Cases and Queries

The primary use case for this table is to validate and enrich data entry during the admission process for applicants with Australian secondary education. A typical query would involve joining this reference table to an applicant's educational history to retrieve the school's descriptive details for forms or reports. For example, to list applicants and their schools, one might use a SQL pattern such as: SELECT a.applicant_id, a.secondary_school_cd, s.school_name FROM igs_ad_aus_sec_edu a, igs_ad_aus_sec_ed_sc s WHERE a.secondary_school_cd = s.secondary_school_cd;. However, given the "Obsolete" and "Not implemented" status notes, direct operational use in reporting or processes may be limited or redirected to successor tables in active deployments.

Related Objects

The documented relationship data specifies one foreign key dependency for this table. The table IGS_AD_AUS_SEC_EDU references IGS_AD_AUS_SEC_ED_SC via its SECONDARY_SCHOOL_CD column. This relationship confirms that IGS_AD_AUS_SEC_EDU (which likely stores details of an applicant's Australian secondary education) uses the school codes defined in IGS_AD_AUS_SEC_ED_SC as a validated foreign key. There are no other documented foreign keys referencing this table in the provided metadata.

• Referencing Table: IGS_AD_AUS_SEC_EDU
• Join Column: IGS_AD_AUS_SEC_EDU.SECONDARY_SCHOOL_CD → IGS_AD_AUS_SEC_ED_SC.SECONDARY_SCHOOL_CD