Search Results igs_ps_uso_facility_pk

Overview

The IGS_PS_USO_FACILITY table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It functions as a transactional junction table that establishes and maintains the relationship between a specific unit section occurrence and the physical or media facilities required to conduct it. A unit section occurrence represents a scheduled instance of a class, such as a lecture or tutorial. This table's role is to manage the assignment of resources, ensuring that the necessary rooms, equipment, or other facilities are linked to the correct teaching event within the academic scheduling framework of EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to map a facility to a specific class occurrence. Its primary columns include the surrogate key USO_FACILITY_ID, which uniquely identifies each assignment record. The critical foreign key columns are UNIT_SECTION_OCCURRENCE_ID, which links to the specific scheduled class in the IGS_PS_USEC_OCCURS_ALL table, and FACILITY_CODE, which references the defined facility or equipment item in the IGS_PS_MEDIA_EQUIP_ALL table. This design allows a single unit section occurrence to be associated with multiple facilities (e.g., a specific lecture hall and a projector), and a single facility to be scheduled for multiple class occurrences.

Common Use Cases and Queries

This table is central to resource scheduling and conflict reporting. Common operational use cases include generating room and equipment timetables, checking for double-booked facilities, and listing all resources assigned to a particular class for instructor or student information. A typical reporting query would join this table to the unit section occurrence and facility master tables. For example, to find all facilities booked for a given class section, one might use:

• SELECT uso_facility_id, mea.facility_code, mea.description FROM igs_ps_uso_facility uso_fac JOIN igs_ps_media_equip_all mea ON uso_fac.facility_code = mea.facility_code WHERE uso_fac.unit_section_occurrence_id = :p_occurrence_id;

Conversely, identifying all class occurrences scheduled in a particular room involves joining through the FACILITY_CODE to the media/equipment master where the facility type indicates a room.

Related Objects

The IGS_PS_USO_FACILITY table has defined dependencies on two primary master tables, as documented in the provided metadata. The relationship to IGS_PS_USEC_OCCURS_ALL via the UNIT_SECTION_OCCURRENCE_ID column anchors the facility assignment to a concrete scheduled event. The relationship to IGS_PS_MEDIA_EQUIP_ALL via the FACILITY_CODE column ensures that the assigned resource is a valid, predefined facility within the system. These foreign key relationships enforce data integrity, preventing the assignment of facilities to non-existent class occurrences or the use of undefined facility codes. The table's primary key, IGS_PS_USO_FACILITY_PK on USO_FACILITY_ID, is likely referenced by other transactional or reporting objects within the Student System that require details of specific facility bookings.