Search Results igs_st_unt_load_appo_pk

Overview

The IGS_ST_UNT_LOAD_APPO table is a core data entity within the now-obsolete Student System (IGS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to define the specific apportionment of academic load for a unit offering across different teaching periods within a broader academic calendar. This enables the precise distribution of a unit's credit or workload. For instance, a single unit might have 75% of its total load attributed to Semester 1 and the remaining 25% to Semester 2. This granular data is critical for accurate workload calculation, scheduling, and reporting at the unit offering level. It is important to note that the provided metadata explicitly states this object is "Not implemented in this database," indicating it may have been part of a data model that was not fully deployed in some instances.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies a load apportionment rule for a specific unit offering and teaching calendar. The key columns are DLA_CAL_TYPE and CI_SEQUENCE_NUMBER (likely referencing a default load apportionment calendar instance), UNIT_CD and VERSION_NUMBER (identifying the specific unit), and TEACH_CAL_TYPE (identifying the teaching calendar period to which a portion of the load is assigned). While the metadata does not list the non-key attribute columns, the description implies the existence of at least one column to store the numerical percentage or proportion of the total unit load assigned to the TEACH_CAL_TYPE.

Common Use Cases and Queries

This table supports administrative and academic processes requiring detailed workload analysis. A common use case is generating reports for departmental resource planning, showing how the teaching load for each unit is distributed across semesters or terms. Another is feeding data into student enrollment systems to calculate accurate workload for students enrolled in units with complex, multi-period delivery. A typical query would join this table to the unit offering details to retrieve the full apportionment schedule for a specific unit.

SELECT ula.unit_cd,
       ula.version_number,
       ula.teach_cal_type,
       ula.load_apportionment_percent -- Inferred column
FROM   igs_st_unt_load_appo ula
WHERE  ula.unit_cd = 'MATH101';

Related Objects

The table maintains defined foreign key relationships with two other entities in the Student System, as documented in the metadata:

• IGS_ST_DFT_LOAD_APPO: The relationship via columns DLA_CAL_TYPE, CI_SEQUENCE_NUMBER, and TEACH_CAL_TYPE suggests that the unit-specific apportionment (IGS_ST_UNT_LOAD_APPO) may inherit from or override a default load apportionment pattern defined at a higher level.
• IGS_PS_UNIT_OFR: The relationship via columns UNIT_CD, VERSION_NUMBER, and TEACH_CAL_TYPE ties the load apportionment rule directly to a specific offering of a unit (e.g., MATH101, version 3, offered in the 2024 academic year). This ensures the load rule is applied to the correct unit instance.

The table has two primary key constraints documented (IGS_ST_UNT_LOAD_APPO_PK and ULA_PK) with identical columns, which may indicate a historical naming discrepancy.