Search Results std_exm_instn_id

Overview

The table IGS_AS_STD_EXM_INSTN_ALL is a core data object within the Oracle E-Business Suite Student System (IGS) modules for versions 12.1.1 and 12.2.2. It serves as a critical junction table that establishes and manages the relationship between a student's specific unit attempt and a scheduled examination instance. Its primary role is to record which time-tabled exam a student is assigned to sit for a particular assessment item within a unit. This table is fundamental for examination scheduling, student attendance tracking, and the administration of assessment-related processes. The "_ALL" suffix indicates it is a multi-org enabled table designed to store data for multiple operating units.

Key Information Stored

The table stores a unique identifier for each student-exam instance relationship and the foreign keys necessary to link to the involved entities. The primary key is the surrogate key STD_EXM_INSTN_ID. A unique key enforces business rule integrity, combining the identifiers for the student unit attempt and the exam instance. Key columns include PERSON_ID, COURSE_CD, UOO_ID, and ASS_ID to link to the student's unit attempt assessment item (IGS_AS_SU_ATMPT_ITM). The columns EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER, DT_ALIAS, DAI_SEQUENCE_NUMBER, START_TIME, END_TIME, and VENUE_CD collectively form a foreign key to the specific time-tabled examination instance in the IGS_AS_EXAM_INSTANCE_ALL table, defining the exact calendar, date, time, and location of the exam.

Common Use Cases and Queries

This table is central to queries supporting examination logistics and student administration. Common use cases include generating student exam timetables, producing attendance registers for exam venues, identifying students assigned to a specific exam session, and managing changes to exam allocations. A typical reporting query would join this table to student personal details and exam instance details to list all assignments for a given exam. For example:

• Identifying all students assigned to a particular exam: SELECT * FROM igs_as_std_exm_instn_all WHERE exam_cal_type = :p_cal_type AND exam_ci_sequence_number = :p_ci_seq;
• Listing a student's full exam schedule: SELECT sei.*, ei.* FROM igs_as_std_exm_instn_all sei JOIN igs_as_exam_instance_all ei ON sei.ass_id = ei.ass_id WHERE sei.person_id = :p_person_id;

Related Objects

The table's integrity is defined by its relationships with two primary entities in the Student System, as documented by its foreign keys:

• IGS_AS_EXAM_INSTANCE_ALL: This table is referenced via a composite foreign key. The columns ASS_ID, EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER, DT_ALIAS, DAI_SEQUENCE_NUMBER, START_TIME, END_TIME, and VENUE_CD in IGS_AS_STD_EXM_INSTN_ALL link to the corresponding columns in IGS_AS_EXAM_INSTANCE_ALL. This relationship ties the student assignment to the specific scheduled exam instance.
• IGS_AS_SU_ATMPT_ITM: This table is referenced via a composite foreign key. The columns PERSON_ID, COURSE_CD, UOO_ID, ASS_ID, and CREATION_DT in IGS_AS_STD_EXM_INSTN_ALL link to the student's unit attempt assessment record, identifying the exact academic work for which the exam is scheduled.