Search Results igs_st_dft_load_appo




Overview
Explore in AI Chat

Overview

The IGS_ST_DFT_LOAD_APPO table is a core data entity within the Oracle E-Business Suite Student System (IGS) for versions 12.1.1 and 12.2.2. It serves a critical function in the management and reporting of student academic load for government compliance. Specifically, this table stores default apportionment rules, defining the percentage of a student's total academic load that is attributed to specific teaching periods within an academic calendar. This apportionment is essential for accurately determining the Equivalent Full-Time Student Load (EFTSL) or similar metrics required for government funding and statistical reporting. Where no explicit apportionment record exists for a given calendar and teaching period combination, the system assumes a default of 100%.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each apportionment rule. The key columns are CAL_TYPE and CI_SEQUENCE_NUMBER, which together identify the academic calendar instance (e.g., Semester 1, 2024), and TEACH_CAL_TYPE, which identifies the specific teaching period within that calendar. While the provided metadata does not list all columns explicitly, the description confirms the table stores a percentage value representing the portion of load attributed to the TEACH_CAL_TYPE. This percentage is the central data point for load calculation. The table's integrity is maintained through foreign key relationships to foundational calendar tables, IGS_CA_TYPE and IGS_CA_INST_ALL.

Common Use Cases and Queries

The primary use case is the automated derivation of a student's load for a teaching period during processes like enrollment reporting or government submission batch jobs. System logic queries this table using the relevant academic calendar keys to find the applicable apportionment percentage. A typical query pattern would retrieve the default load percentage for a specific calendar and teaching period, often joining to calendar description tables for reporting clarity. For example:

  • Identifying all apportionment rules for a given academic year to validate setup before a reporting cycle.
  • Troubleshooting load calculation discrepancies by verifying the apportionment percentage applied to a student's unit attempts via related tables like IGS_ST_UNT_LOAD_APPO.
  • Generating setup audit reports to find calendar instances where no explicit apportionment exists (implying the 100% default is in effect).

Related Objects

The IGS_ST_DFT_LOAD_APPO table is a central reference point within the Student System's load management framework. It is referenced by several other key entities, as documented by the foreign key relationships:

  • Referenced by IGS_AD_ADM_UT_STT_LD: Links admission unit attempt stated load records to the default apportionment rule (joined on CAL_TYPE, CI_SEQUENCE_NUMBER, TEACH_CAL_TYPE).
  • Referenced by IGS_ST_GVTSEMLOAD_OV: Links government semester load override records to the default rule (joined on CAL_TYPE, CI_SEQUENCE_NUMBER, TEACH_CAL_TYPE).
  • Referenced by IGS_ST_UNT_LOAD_APPO: Links unit-specific load apportionment records to the default rule (joined on DLA_CAL_TYPE, CI_SEQUENCE_NUMBER, TEACH_CAL_TYPE). This table allows for unit-level overrides of the default percentages stored in IGS_ST_DFT_LOAD_APPO.

Furthermore, this table itself references the calendar foundation tables IGS_CA_TYPE (for TEACH_CAL_TYPE) and IGS_CA_INST_ALL (for CAL_TYPE and CI_SEQUENCE_NUMBER).