Search Results uso_facility_id




Overview
Explore in AI Chat

Overview

The IGS_PS_USO_FACILITY table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or Campus Solutions modules, owned by the IGS schema. It functions as a junction or intersection table, establishing a many-to-many relationship between unit section occurrences and the facilities or equipment required for their delivery. Its primary role is to manage the logistical assignment of specific resources, such as classrooms, laboratories, or specialized media equipment, to scheduled instances of academic course sections. This enables precise scheduling and resource planning within the academic operations of an institution.

Key Information Stored

The table stores a minimal set of columns focused on the relationship itself and standard audit data. The primary data columns are:

Common Use Cases and Queries

This table is central to queries supporting academic scheduling, room booking, and resource conflict resolution. A common operational use case is generating a schedule of facility usage for a given time period or identifying all resources assigned to a particular class section. For reporting, it is frequently joined to section and facility master tables.

A foundational query to retrieve all facility assignments for a specific unit section occurrence would be:

SELECT f.facility_code, f.creation_date
FROM igs.igs_ps_uso_facility f
WHERE f.unit_section_occurrence_id = :p_occurrence_id
ORDER BY f.facility_code;

For a more comprehensive report linking assignments to section details and facility descriptions, a three-table join is typical:

SELECT occ.unit_section_occurrence_id,
       fac.facility_code,
       -- Additional columns from occurrence and facility master tables
FROM igs.igs_ps_uso_facility fac_assign,
     igs.igs_ps_usec_occurs_all occ,
     igs.igs_ps_media_equip_all fac
WHERE fac_assign.unit_section_occurrence_id = occ.unit_section_occurrence_id
  AND fac_assign.facility_code = fac.facility_code
  AND occ.start_date BETWEEN :p_start_date AND :p_end_date;

Related Objects

The IGS_PS_USO_FACILITY table maintains defined foreign key relationships with master data tables, ensuring referential integrity. The documented relationships are:

  • Primary Key: IGS_PS_USO_FACILITY_PK on the USO_FACILITY_ID column.
  • Foreign Key Reference (Parent): The UNIT_SECTION_OCCURRENCE_ID column references the IGS_PS_USEC_OCCURS_ALL table, linking the facility to a specific scheduled class instance.
  • Foreign Key Reference (Parent): The FACILITY_CODE column references the IGS_PS_MEDIA_EQUIP_ALL table (or a similar facility master table), linking to the definition of the physical or equipment resource.
  • Referenced By: The table is referenced by other objects within the APPS and IGS schemas, indicating it is a source for views, forms, or program units that consume facility assignment data.