Search Results igs_as_exm_ins_spvsr




Overview
Explore in AI Chat

Overview

The table IGS_AS_EXM_INS_SPVSR is a core data object within the Oracle E-Business Suite Student System (IGS) module. It serves as a junction table that establishes the critical link between examination supervisors and the specific examination instances they are assigned to proctor. Its primary role is to manage the many-to-many relationship between examination personnel and scheduled exam sittings, enabling the detailed scheduling and tracking of supervisory responsibilities. This table is essential for the logistical planning and execution of examinations, ensuring that each exam instance has the appropriate supervisory coverage as defined by institutional policies.

Key Information Stored

The table stores the composite key that uniquely identifies a supervisor's assignment, which is a combination of the supervisor's identifier and the full key of the examination instance. The primary key columns are PERSON_ID, ASS_ID, EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER, DT_ALIAS, DAI_SEQUENCE_NUMBER, START_TIME, END_TIME, and VENUE_CD. This structure indicates that a supervisor is assigned to a very specific exam occurrence, defined not just by the assessment and calendar, but also by the exact date, time, and venue. A crucial attribute, EXAM_SUPERVISOR_TYPE, references a lookup to categorize the supervisor's role (e.g., head supervisor, invigilator).

Common Use Cases and Queries

This table is central to operations involving exam scheduling and personnel management. Common use cases include generating invigilation timetables for staff, verifying supervisor coverage for audit purposes, and identifying all exams a specific person is supervising in a given period. A typical reporting query would join this table to the examination instance (IGS_AS_EXAM_INSTANCE_ALL) and person (IGS_AS_EXM_SUPRVISOR_ALL) tables to produce a schedule. For example, to find all assignments for a supervisor in a given exam calendar, one might use a SQL pattern such as: SELECT eia.* FROM IGS_AS_EXM_INS_SPVSR spv INNER JOIN IGS_AS_EXAM_INSTANCE_ALL eia ON spv.ass_id = eia.ass_id AND spv.exam_cal_type = eia.exam_cal_type WHERE spv.person_id = :p_person_id AND spv.exam_cal_type = :p_cal_type.

Related Objects

The table maintains defined foreign key relationships with several key entities in the Student System schema, as documented in the ETRM metadata:

  • IGS_AS_EXAM_INSTANCE_ALL: Links to the master examination instance via the composite key (ASS_ID, EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER, DT_ALIAS, DAI_SEQUENCE_NUMBER, START_TIME, END_TIME, VENUE_CD). This ensures every supervisor assignment is tied to a valid, scheduled exam.
  • IGS_AS_EXM_SUPRVISOR_ALL: Links to the supervisor's master person record via PERSON_ID, validating the assigned individual is an authorized examination supervisor.
  • IGS_AS_EXM_SPRVSRTYP: Links to the lookup of supervisor types via EXAM_SUPERVISOR_TYPE, classifying the role (e.g., chief, assistant) for the assigned instance.

These relationships enforce data integrity and are fundamental for any joins in reports or interfaces that consume supervisory assignment data.