Search Results subject_ass_type

Overview

The IGS_AD_AUS_SEC_ED_SU table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the IGS (Oracle Student Management) product family. It serves as the detailed repository for storing an applicant's or student's individual subject-level results as part of their broader Australian Secondary Education (ASE) record. Its primary role is to support the admissions and academic records processes by maintaining a granular history of secondary education achievements, which is critical for eligibility assessments, credit transfers, and compliance reporting within the Australian educational context.

Key Information Stored

The table stores a comprehensive set of attributes for each subject result. The record is uniquely identified by a composite primary key combining PERSON_ID, ASE_SEQUENCE_NUMBER, SUBJECT_RESULT_YR, and SUBJECT_CD. Key descriptive columns include SUBJECT_DESC, SUBJECT_MARK, and SUBJECT_MARK_LEVEL. Crucially for the user's search context, the SUBJECT_ASS_TYPE column defines the type of assessment or curriculum framework (e.g., VCE, IB, YR12) under which the subject was completed. Other significant columns are SUBJECT_WEIGHTING for state-recognized weightings and NOTES for free-text details. The table includes standard EBS "Who" columns (CREATED_BY, LAST_UPDATED_BY, etc.) and concurrent program tracking fields.

Common Use Cases and Queries

This table is central to generating transcripts, evaluating admission prerequisites, and performing academic analytics. A common reporting use case is to list all subject results for a specific person and their Australian Secondary Education sequence. The column SUBJECT_ASS_TYPE is frequently used in queries to filter or categorize results by assessment type, such as identifying all International Baccalaureate (IB) subjects.

• Sample Query by Person and Assessment Type:
  SELECT subject_cd, subject_desc, subject_mark, subject_result_yr
  FROM igs.igs_ad_aus_sec_ed_su
  WHERE person_id = :p_person_id
  AND subject_ass_type = 'IB';
• Use Case: Admission officers may run queries to verify if an applicant meets specific subject-based entry requirements for a course, often grouping by SUBJECT_ASS_TYPE to understand the context of the marks.

Related Objects

The table maintains defined relational integrity through foreign key constraints, linking it to parent entities in the schema.

• Primary Key: IGS_AD_AUS_SEC_ED_SU_PK on (PERSON_ID, ASE_SEQUENCE_NUMBER, SUBJECT_RESULT_YR, SUBJECT_CD).
• Foreign Key (Parent: IGS_AD_AUS_SEC_EDU): The PERSON_ID column references the IGS_AD_AUS_SEC_EDU table, which stores the header-level Australian Secondary Education information for a person. This links detailed subject results to their overarching education record.
• Foreign Key (Parent: IGS_AD_AUSE_ED_AS_TY): The SUBJECT_ASS_TYPE column references a lookup or validation table for assessment types (IGS_AD_AUSE_ED_AS_TY). This ensures data integrity for the assessment type code used in queries and reporting.