Search Results igs_as_exam_instance_all




Overview
Explore in AI Chat

Overview

The IGS_AS_EXAM_INSTANCE_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS) for versions 12.1.1 and 12.2.2. It serves as a junction table that defines the specific logistical relationship between an examination session instance and a physical venue. Its primary role is to schedule and allocate a defined examination session—including its date, time, and calendar details—to a specific room or location (venue) for administration. This table is fundamental for managing the complex scheduling requirements of institutional examinations, ensuring that each scheduled exam event is linked to a concrete, bookable space. As indicated by the "_ALL" suffix, it is a multi-org table designed to store data partitioned by operating unit.

Key Information Stored

The table's composite primary key uniquely identifies a single exam instance at a venue by combining identifiers from related entities. The key columns and their significance are:

Additional notable columns include COLLECT_PERSON_ID, which is a foreign key to HZ_PARTIES and likely identifies the person responsible for collecting exam materials.

Common Use Cases and Queries

This table is central to operational and reporting processes concerning exam logistics. A primary use case is generating venue-specific exam timetables and seating arrangements. Administrators query this table to list all exam instances scheduled for a particular venue within a date range or to identify the venue allocated for a specific exam session. It is also critical for capacity planning and conflict resolution. A typical query pattern involves joining to assessment item and venue tables to produce a readable schedule:

SELECT aei.ass_id,
itm.assessment_item_name,
aei.venue_cd,
ven.venue_name,
aei.start_time,
aei.end_time
FROM igs_as_exam_instance_all aei,
igs_as_assessmnt_itm_all itm,
igs_gr_venue_all ven
WHERE aei.ass_id = itm.ass_id
AND aei.venue_cd = ven.venue_cd
AND aei.exam_ci_sequence_number = :p_session_num;

Another common scenario is validating data integrity, ensuring no student is assigned (via IGS_AS_STD_EXM_INSTN_ALL) to an exam instance that does not exist.

Related Objects

The table sits at the center of a key relationship model for exam scheduling. Based on the provided metadata, its documented relationships are:

  • Parent Tables (Foreign Key References):
    • IGS_AS_ASSESSMNT_ITM_ALL via ASS_ID.
    • IGS_AS_EXAM_SESSION_ALL via the composite key (EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER, DT_ALIAS, DAI_SEQUENCE_NUMBER, START_TIME, END_TIME).
    • HZ_PARTIES via COLLECT_PERSON_ID.
    • IGS_GR_VENUE_ALL via VENUE_CD.
  • Child Tables (Referenced by Foreign Keys):
    • IGS_AS_EXM_INS_SPVSR: Links exam instances to their supervisors. Joins on the full primary key of IGS_AS_EXAM_INSTANCE_ALL.
    • IGS_AS_STD_EXM_INSTN_ALL: The critical table assigning individual students to a specific exam instance at a venue. Joins on the full primary key of IGS_AS_EXAM_INSTANCE_ALL.

This structure confirms the table's role as the master record for a schedulable exam event at a location, from which supervisor assignments and student allocations are derived.