Search Results igs_as_exam_session_all




Overview
Explore in AI Chat

Overview

The IGS_AS_EXAM_SESSION_ALL table is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically for managing examination administration. It functions as the master definition table for available examination sessions. An examination session is a discrete time period within a specific date of an examination calendar during which one or more examinations can be scheduled. The table's role is to define the temporal boundaries and calendar context for all exam instances, enabling the system to organize and constrain the scheduling of individual exams. Its multi-org enabled structure, indicated by the "_ALL" suffix, allows it to store data for multiple operating units, which is essential for institutions with complex organizational hierarchies in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is a composite of six columns that uniquely identify an exam session within the EBS ecosystem. The key columns are EXAM_CAL_TYPE and EXAM_CI_SEQUENCE_NUMBER, which together reference a specific examination calendar instance (IGS_CA_INST_ALL). The DT_ALIAS and DAI_SEQUENCE_NUMBER columns link to a particular date alias instance within that calendar, defining the specific day for the session. Finally, the START_TIME and END_TIME columns define the precise time window on that date. While the provided metadata focuses on the key structure, typical supplementary columns would include attributes for session description, venue capacity rules, and system control information like creation date and last update details.

Common Use Cases and Queries

This table is central to examination scheduling and reporting processes. A primary use case is generating a master list of all available exam sessions for a given term or calendar, which is used by administrators to schedule exams. Another critical function is validating conflicts; before assigning an exam to a session, the system checks this table to confirm the session exists and is valid. Common reporting queries involve joining this table with the exam instance table to list all exams scheduled for specific sessions or to identify sessions with available capacity. A foundational query pattern retrieves session details for a calendar:

  • SELECT exam_cal_type, exam_ci_sequence_number, dt_alias, dai_sequence_number, start_time, end_time FROM igs_as_exam_session_all WHERE exam_cal_type = '&CAL_TYPE' AND exam_ci_sequence_number = &SEQ_NUM ORDER BY dt_alias, start_time;

Related Objects

The IGS_AS_EXAM_SESSION_ALL table sits at the center of key data relationships in the examination model. It has a mandatory foreign key relationship to IGS_CA_INST_ALL (Calendar Instance), ensuring every session belongs to a valid examination calendar. Crucially, it is referenced as a parent table by two important entities. First, the IGS_AS_EXAM_INSTANCE_ALL table, which stores the individual examinations, links directly to a session via all six primary key columns, tethering each exam to its scheduled time slot. Second, the IGS_AS_EXMVNU_SESAVL_ALL table, which likely manages session availability or venue linkage, also references this table's full primary key. These relationships enforce data integrity, ensuring that exams and their venue assignments cannot exist for undefined sessions.