Search Results igs_ps_usec_occurs_all




Overview
Explore in AI Chat

Overview

The IGS_PS_USEC_OCCURS_ALL table is a core data entity within the Oracle E-Business Suite's Student System (IGS), specifically within the Product/Module designated as "Obsolete." It formally describes the Occurrences of a Unit Section. An occurrence represents a specific instance or offering of a unit section, typically defined by unique scheduling, location, or instructor details within an academic term. Its primary role is to manage the granular scheduling and resource allocation for individual class offerings, linking a unit section to physical facilities, instructors, and specific timetables. The metadata explicitly states this table was "Not implemented in this database," indicating it may have been part of a data model that was not fully deployed in certain instances of EBS 12.1.1 or 12.2.2.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which reveal the critical data points it manages. The primary identifier is the UNIT_SECTION_OCCURRENCE_ID. The table uniquely identifies each record through a composite key (UOO_ID, OCCURRENCE_IDENTIFIER), tying the occurrence to a specific Unit Offering Option (UOO). Key descriptive columns, inferred from foreign key relationships, include identifiers for dedicated and preferred buildings (DEDICATED_BUILDING_CODE, PREFERRED_BUILDING_CODE) and rooms (DEDICATED_ROOM_CODE, PREFERRED_ROOM_CODE), as well as an INSTRUCTOR_ID linking to the HZ_PARTIES table. This structure allows the system to track both assigned and requested resources for a given class occurrence.

Common Use Cases and Queries

This table supports critical academic operations related to class scheduling and resource management. Common use cases include generating detailed class timetables, assigning instructors to specific section offerings, managing classroom allocation, and reporting on facility utilization. A typical query might join this table to building, room, and instructor tables to produce a schedule report. For example:

  • Identifying all occurrences for a unit section to view scheduling options: SELECT * FROM IGS_PS_USEC_OCCURS_ALL WHERE UOO_ID = <value>;
  • Reporting on room assignments: SELECT uso.OCCURRENCE_IDENTIFIER, b.BUILDING_NAME, r.ROOM_NUMBER FROM IGS_PS_USEC_OCCURS_ALL uso JOIN IGS_AD_BUILDING_ALL b ON uso.DEDICATED_BUILDING_CODE = b.BUILDING_CODE JOIN IGS_AD_ROOM_ALL r ON uso.DEDICATED_ROOM_CODE = r.ROOM_CODE;

Given its "Obsolete" and "Not implemented" status, direct operational use in active systems may be limited, but the table remains important for understanding the data model and for potential data migration or historical reporting.

Related Objects

The table maintains integral relationships with several other entities in the Student System, primarily through foreign key constraints. The documented relationships are as follows:

  • Parent Table (IGS_PS_UNIT_OFR_OPT_ALL): The UOO_ID column references this table, linking the occurrence to its parent Unit Offering Option.
  • Resource Tables (IGS_AD_BUILDING_ALL, IGS_AD_ROOM_ALL): Multiple columns (BUILDING_CODE, DEDICATED_BUILDING_CODE, PREFERRED_BUILDING_CODE, ROOM_CODE, DEDICATED_ROOM_CODE, PREFERRED_ROOM_CODE) reference these tables to define physical locations.
  • Instructor Table (HZ_PARTIES): The INSTRUCTOR_ID column links to the Trading Community Architecture to identify the assigned instructor.
  • Child Tables: Several tables reference IGS_PS_USEC_OCCURS_ALL.UNIT_SECTION_OCCURRENCE_ID, including: