Search Results subject_cd

Overview

The table IGS_AD_AUS_SEC_ED_SU is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Student System (IGS) module. It functions as a detailed repository for storing an applicant's or student's subject-level academic performance within the context of their Australian secondary education. This table is critical for managing granular academic history, enabling institutions to evaluate qualifications based on specific subjects and their corresponding results. Its role is to support the admissions and academic records processes by providing a normalized structure to link individual subject outcomes to a person's broader secondary education record.

Key Information Stored

The table's structure is designed to uniquely identify a subject result for a specific person and education record. The primary key is a composite of four columns: PERSON_ID, ASE_SEQUENCE_NUMBER, SUBJECT_RESULT_YR, and SUBJECT_CD. This ensures that for a given individual (PERSON_ID) and their associated Australian secondary education sequence (ASE_SEQUENCE_NUMBER), the system can store multiple subject results for different years and subject codes. Key columns include SUBJECT_CD, which holds the code identifying the specific subject studied (e.g., Mathematics, English), and SUBJECT_RESULT_YR, indicating the academic year the result pertains to. The SUBJECT_ASS_TYPE column is a foreign key linking to a lookup table (IGS_AD_AUSE_ED_AS_TY) that defines the type of assessment or result (e.g., final grade, standardized test score).

Common Use Cases and Queries

A primary use case is the comprehensive evaluation of an applicant's secondary school transcript for admission purposes. Admissions officers can query this table to assess performance in prerequisite subjects. Another common scenario is academic auditing and reporting for regulatory compliance or institutional research. A typical query pattern involves joining this table to the parent IGS_AD_AUS_SEC_EDU table to retrieve a person's full subject history alongside their general secondary education details.

• Retrieving All Subject Results for an Applicant: SELECT * FROM igs.igs_ad_aus_sec_ed_su WHERE person_id = <PERSON_ID> AND ase_sequence_number = <SEQ_NUM> ORDER BY subject_result_yr, subject_cd;
• Finding Applicants with Specific Subject Proficiency: SELECT su.person_id, su.subject_cd, su.subject_result_yr FROM igs.igs_ad_aus_sec_ed_su su JOIN igs.igs_ad_aus_sec_edu edu ON su.person_id = edu.person_id AND su.ase_sequence_number = edu.ase_sequence_number WHERE su.subject_cd = '<SUBJECT_CODE>' AND edu.completion_yr = <YEAR>;

Related Objects

The table maintains defined relational integrity through its foreign key constraints, linking it to critical parent tables in the IGS schema. These relationships are fundamental for accurate data management and reporting.

• IGS_AD_AUS_SEC_EDU: This is the primary parent table. IGS_AD_AUS_SEC_ED_SU references it via a composite foreign key on PERSON_ID and ASE_SEQUENCE_NUMBER. This links each subject result row to a specific person's overarching Australian secondary education record.
• IGS_AD_AUSE_ED_AS_TY: This lookup table is referenced via the SUBJECT_ASS_TYPE column. It provides the valid list of assessment types (e.g., 'Final Exam', 'Coursework') used to categorize the subject result stored in IGS_AD_AUS_SEC_ED_SU.