Search Results igs_ps_unit_ofr




Overview
Explore in AI Chat

Overview

The table IGS_PS_UNIT_OFR is a core data entity within the Oracle E-Business Suite Student System (IGS), specifically designed for academic management. It represents the offering or scheduling of a specific version of a unit (or course module) within a particular academic calendar type. This table establishes the critical link between the definition of a unit (its curriculum, credits, etc.) and the temporal context in which it is taught, enabling institutions to manage when and how often a unit is available for enrollment. Its role is foundational for scheduling, timetabling, and student enrollment processes. Notably, the provided ETRM metadata explicitly labels the IGS - Student System as "Obsolete," indicating this table belongs to a legacy product line that may have been superseded by later applications like Oracle Student Management or Campus Solutions in more recent EBS deployments.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies a unit offering. The key columns are UNIT_CD, representing the unique code for the unit; VERSION_NUMBER, specifying the particular iteration of the unit's content and rules; and CAL_TYPE, denoting the type of academic calendar (e.g., Semester, Trimester, Quarter) in which the unit is offered. While the ETRM excerpt does not list all descriptive columns, the table's purpose implies it would typically store data relevant to a specific offering instance. This likely includes attributes such as offering status, maximum enrollment capacity, location, and links to teaching staff responsibilities. The table's foreign keys enforce critical referential integrity with master data tables for calendar types (IGS_CA_TYPE) and unit definitions (IGS_PS_UNIT_VER_ALL).

Common Use Cases and Queries

This table is central to operational and reporting queries related to academic scheduling. A common use case is generating a course catalog for a given term, which involves joining unit offering data with its descriptive version details. Administrators would query this table to determine all units offered in a specific calendar period, assess teaching load allocations, or validate enrollment prerequisites against available offerings. A typical reporting query might follow this pattern:

  • SELECT uo.unit_cd, uo.version_number, uo.cal_type, uv.unit_title FROM igs_ps_unit_ofr uo JOIN igs_ps_unit_ver_all uv ON uo.unit_cd = uv.unit_cd AND uo.version_number = uv.version_number WHERE uo.cal_type = 'SEMESTER_1_2024';

Another critical use case is supporting the assignment of teaching loads (IGS_ST_UNT_LOAD_APPO) and the association of assessment patterns (IGS_PS_UNIT_OFR_PAT_ALL) to a specific unit offering.

Related Objects

IGS_PS_UNIT_OFR sits at a nexus within the Student System schema. Its primary relationships, as defined by foreign keys, are with the unit definition table (IGS_PS_UNIT_VER_ALL) and the calendar type table (IGS_CA_TYPE). Furthermore, it is a parent table to several important transactional and configuration entities. These include IGS_ST_UNT_LOAD_APPO for staff teaching load appointments, IGS_PS_UNIT_OFR_NOTE for offering-specific notes, and IGS_PS_UNIT_OFR_PAT_ALL for linking assessment patterns to the offering. Any customization or data fix involving unit scheduling must consider these dependencies to maintain data integrity across the module.