Search Results result_obtained_yr




Overview
Explore in AI Chat

Overview

The IGS_AD_AUSE_ED_OT_SC table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) product module. It functions as a detailed subsidiary table, storing state-specific or region-specific secondary education scores that supplement a student's primary academic records. Its primary role is to capture and manage additional scoring metrics, such as the WA Murdoch aggregate or TES, which are required by various Australian states for tertiary admissions processes. The table ensures these supplementary scores are uniquely and persistently associated with a student's core secondary education record.

Key Information Stored

The table's structure is designed to uniquely identify a score record and its contextual details. The primary key is a composite of four columns, ensuring uniqueness for a student's specific score type. Critical columns include:

  • PERSON_ID and ASE_SEQUENCE_NUMBER: Together, these form a foreign key link to the primary Australian Secondary Education (ASE) record, uniquely identifying the student and their specific education entry.
  • RESULT_OBTAINED_YR and SCORE_TYPE: Complete the primary key, defining the year the score was obtained and the categorization of the score (e.g., 'WA Murdoch aggregate').
  • SCORE: Stores the actual score value, as recognized by the individual state, in a VARCHAR2 format to accommodate alphanumeric results.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Provide essential audit trail information for compliance and data governance.

Common Use Cases and Queries

This table is central to reporting and processes related to state-based university admissions in Australia. Common use cases include generating detailed transcripts that include all requisite state scores, validating applicant eligibility against specific state requirements, and performing historical analysis of scoring trends. A fundamental query to retrieve all additional scores for a specific student's secondary education record would leverage the foreign key relationship:

SELECT score_type, result_obtained_yr, score FROM igs.igs_ad_ause_ed_ot_sc WHERE person_id = :p_person_id AND ase_sequence_number = :p_ase_seq_num ORDER BY result_obtained_yr, score_type;

For reporting, a join to the main secondary education table is typical to provide student context. Data integrity is enforced by the unique index IGS_AD_AUSE_ED_OT_SC_U1 on the primary key columns, preventing duplicate score entries of the same type for the same academic record and year.

Related Objects

The IGS_AD_AUSE_ED_OT_SC table has a direct and critical dependency relationship within the IGS schema. As documented in the relationship data:

  • Foreign Key Reference: The table references the main Australian Secondary Education table via its composite foreign key. Specifically, the columns PERSON_ID and ASE_SEQUENCE_NUMBER in IGS_AD_AUSE_ED_OT_SC reference the corresponding columns in IGS_AD_AUS_SEC_EDU. This ensures every additional score record is tied to a valid, pre-existing core education record.
  • Primary Key: The table's primary key constraint, IGS_AD_AUSE_ED_OT_SC_PK, is defined on (PERSON_ID, ASE_SEQUENCE_NUMBER, RESULT_OBTAINED_YR, SCORE_TYPE). This key is likely referenced by other application objects or user interfaces for data validation and navigation, though specific referencing objects are not listed in the provided excerpt.