Search Results igs_as_suaai_ouhist




Overview
Explore in AI Chat

Overview

The IGS_AS_SUAAI_OUHIST table is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a historical audit table, designed to capture and maintain a time-based record of changes to key outcome attributes for student assessment items. Its primary role is to preserve the evolution of a student's performance result for a specific assessment, ensuring a complete audit trail. This is critical for academic integrity, grade dispute resolution, and historical reporting. The table is directly sourced from its base transaction table, IGS_AS_SU_ATMPT_ITM, which holds the current, active record.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each historical entry. This key combines the student and assessment identifiers with timestamps: PERSON_ID, COURSE_CD, UOO_ID (Unit Offering ID), ASS_ID (Assessment ID), CREATION_DT (the original creation date of the base record), and HIST_START_DT (the effective start date of this historical version). The core data columns track the state of an assessment item outcome at a point in time. As per the documentation, these specifically include the grading schema applied, the numerical mark, the awarded grade, the outcome date, and any outcome comments. The SUA_ASS_ITEM_GROUP_ID column links the history to a specific assessment item group.

Common Use Cases and Queries

This table is essential for generating audit reports and analyzing grade change history. A common operational use case is reviewing all modifications made to a student's grade for a particular assessment over time. For reporting, institutions may query this table to analyze trends in grade revisions or to fulfill regulatory audit requirements. A typical SQL pattern involves joining the history table back to the base attempt table or student demographic tables to produce a readable timeline.

  • Sample Query (Grade History for an Assessment): SELECT hist.person_id, hist.grade, hist.hist_start_dt, hist.outcome_dt FROM igs_as_suaai_ouhist hist WHERE hist.person_id = :stu_id AND hist.ass_id = :assessment_id ORDER BY hist.hist_start_dt DESC;
  • Use Case: Generating a complete audit trail for a grade appeal, showing every state of the outcome from initial entry to final result.

Related Objects

The IGS_AS_SUAAI_OUHIST table has defined foreign key relationships with other critical tables in the Student System schema, establishing its place in the data model.

  • IGS_AS_SU_ATMPT_ITM (Base Table): The history record originates from this table. The foreign key is defined on the columns PERSON_ID, COURSE_CD, UOO_ID, ASS_ID, and CREATION_DT, linking each historical version to its source transaction record.
  • IGS_AS_SUA_AI_GROUP (Assessment Item Group): The column SUA_ASS_ITEM_GROUP_ID in the history table references this table, linking the historical outcome to the specific assessment item group to which it belonged.