Search Results igs_as_exm_sprvsrtyp




Overview
Explore in AI Chat

Overview

The IGS_AS_EXM_SPRVSRTYP table is a reference data table within the Oracle E-Business Suite (EBS) Student System (IGS) module, which is documented as obsolete. Its primary function is to define and categorize the distinct types of individuals who can supervise examinations. This table serves as a master list of valid supervisor types, enforcing data integrity and providing descriptive context for examination administration. The table's existence is critical for standardizing how supervisory roles are recorded and referenced across related examination entities, such as individual supervisors and session venue assignments. The metadata indicates this specific object was "Not implemented in this database," suggesting it may have been defined in the data model but not populated or actively used in some deployments of EBS 12.1.1 or 12.2.2.

Key Information Stored

Based on the provided metadata, the table's structure centers on a code or short identifier for the supervisor type. The primary key column is EXAM_SUPERVISOR_TYPE. While the full column list is not detailed, typical reference tables in EBS also include descriptive columns (e.g., DESCRIPTION, CLOSED_IND) and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER) for auditing and versioning. The core data stored would be rows defining types such as "PRIMARY_INVIGILATOR," "ASSISTANT_SUPERVISOR," or "EXTERNAL_MODERATOR," providing a controlled vocabulary for the examination process.

Common Use Cases and Queries

The primary use case is to validate and describe the supervisor type assigned to examination personnel. In reporting, it is used to join descriptive labels to transactional data. Common queries would involve listing all active supervisor types or generating reports that categorize supervisory assignments by type. A typical SQL pattern would join this table to its related transactional tables to enrich the data with descriptions.

SELECT esv.exam_supervisor_type,
       est.description,
       COUNT(*) AS assignment_count
FROM igs_as_exm_ses_vn_sp esv,
     igs_as_exm_sprvsrtyp est
WHERE esv.exam_supervisor_type = est.exam_supervisor_type
GROUP BY esv.exam_supervisor_type, est.description;

Given its status as a reference table, data manipulation would typically be performed via the application's administrative forms to maintain referential integrity.

Related Objects

The IGS_AS_EXM_SPRVSRTYP table is referenced as a parent table via foreign key constraints in at least two other examination-related tables, as documented in the ETRM metadata:

  • IGS_AS_EXM_INS_SPVSR (likely "Examination Instructor Supervisor"): This table references IGS_AS_EXM_SPRVSRTYP via the column IGS_AS_EXM_INS_SPVSR.EXAM_SUPERVISOR_TYPE. It associates a specific supervisor (instructor) with a supervisor type.
  • IGS_AS_EXM_SES_VN_SP (likely "Examination Session Venue Supervisor"): This table references IGS_AS_EXM_SPRVSRTYP via the column IGS_AS_EXM_SES_VN_SP.EXAM_SUPERVISOR_TYPE. It assigns a supervisor type to a supervisor for a specific examination session at a venue.

These relationships confirm the table's role as a central code lookup for the examination supervision hierarchy within the obsolete Student System module.