Search Results igs_ps_anl_load




Overview
Explore in AI Chat

Overview

The IGS_PS_ANL_LOAD 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. It serves a fundamental role in academic program administration by defining the standard annual student load for each year of a specific program version. This definition of annual load is critical for calculating Equivalent Full-Time Student Unit (EFTSU) values for course units, which is essential for workload measurement, government reporting, and funding models in educational institutions. The table's design links the annual load parameters directly to a program's curriculum version and its effective dates, ensuring historical accuracy for load calculations over time.

Key Information Stored

The table's structure centers on uniquely identifying an annual load record and its associated load value. The primary key is a composite of four columns, ensuring a unique record per program, version, year, and effective date. Key columns include COURSE_CD and VERSION_NUMBER, which together identify the specific program version from the IGS_PS_VER_ALL table. The YR_NUM column specifies the academic year number within the program sequence (e.g., Year 1, Year 2). The EFFECTIVE_START_DT enables the table to maintain a history of load definitions for a program year as they change over time. While the provided metadata does not list the specific column for the load value itself, its description confirms the table's purpose is to store the annual load figure to which individual units are linked for EFTSU derivation.

Common Use Cases and Queries

The primary use case for this table is the systematic configuration and retrieval of standard annual load data for reporting and operational calculations. A common query would involve joining this table to the program version and unit tables to generate a report of EFTSU factors for a curriculum. For example, an institution might need to audit the standard load for all active programs. A typical SQL pattern would select from IGS_PS_ANL_LOAD, joined to IGS_PS_VER_ALL on course code and version number, filtered by a specific EFFECTIVE_START_DT to get the current definition. Another critical use case is during the student enrollment process, where the system may reference the defined annual load for a student's program year as a benchmark for assessing a student's actual enrolled load against the standard full-time load.

Related Objects

The IGS_PS_ANL_LOAD table exists within a defined relationship hierarchy. Its primary parent table is IGS_PS_VER_ALL (Program Version), as enforced by a foreign key constraint. This establishes that an annual load definition cannot exist without a corresponding program version. A significant child object is the IGS_PS_ANL_LOAD_U_LN table, which links individual academic units to a specific annual load record. This relationship is how units inherit their standard load context for EFTSU calculation. The foreign key from the child table back to IGS_PS_ANL_LOAD uses all four primary key columns, ensuring a precise link. It is important to note the metadata explicitly states this table was "Not implemented in this database," indicating it may exist in the data dictionary but was not deployed in all EBS instances, or its functions were superseded in later releases.