Search Results igs_ad_adm_ut_stt_ld

Overview

The table IGS_AD_ADM_UT_STT_LD is a core data object within the Oracle E-Business Suite Student System (IGS), versions 12.1.1 and 12.2.2. It functions as a configuration and control table that defines the relationship between an administrative unit's status and specific academic calendar types to determine the associated student load. This table is essential for accurately calculating the academic load incurred by a student based on their enrollment status within a particular administrative unit (such as a college or department) during a defined teaching calendar period. Its role is to provide the foundational rules that link administrative structures with the academic calendar, enabling precise load reporting and compliance tracking.

Key Information Stored

The table's structure is defined by a composite primary key, which highlights the critical pieces of information it stores. The key columns are ADMINISTRATIVE_UNIT_STATUS, CAL_TYPE, CI_SEQUENCE_NUMBER, and TEACH_CAL_TYPE. These fields collectively store a unique rule mapping a specific administrative status to a particular calendar instance. The ADMINISTRATIVE_UNIT_STATUS links to valid statuses defined in the system. The CAL_TYPE, CI_SEQUENCE_NUMBER, and TEACH_CAL_TYPE together identify a precise load calendar entry, establishing which academic period the load rule applies to. While the provided metadata does not list non-key columns, the table's description implies it likely contains attributes to quantify or qualify the load, such as a load value or an indicator for how the load should be applied or calculated.

Common Use Cases and Queries

This table is primarily used in backend processes for student load calculation and reporting. A common use case is determining the full-time equivalency (FTE) or credit load for a cohort of students based on their administrative unit enrollment status. For instance, when generating enrollment reports for regulatory compliance, the system queries this table to apply the correct load factor. A typical query would join this table to student enrollment records via the administrative unit status and the teaching calendar. A sample SQL pattern for retrieving all load rules for a specific administrative status would be: SELECT * FROM igs.igs_ad_adm_ut_stt_ld WHERE administrative_unit_status = '<STATUS_CODE>';. Another critical use case is during the student enrollment process, where the system references these rules to automatically calculate the anticipated load for a student in a given term.

Related Objects

The table IGS_AD_ADM_UT_STT_LD has documented foreign key relationships with two other key tables in the Student System, ensuring referential integrity and defining its place in the data model.

• IGS_AD_ADM_UNIT_STAT_ALL: The ADMINISTRATIVE_UNIT_STATUS column in IGS_AD_ADM_UT_STT_LD references this table. This relationship validates that the status used in a load rule is a defined and active administrative unit status within the system.
• IGS_ST_DFT_LOAD_APPO: The combination of CAL_TYPE, CI_SEQUENCE_NUMBER, and TEACH_CAL_TYPE columns in IGS_AD_ADM_UT_STT_LD references this table. This relationship ties the load rule to a specific, valid load calendar entry, which defines the academic period and its default load appointment parameters.

These relationships mean that any data manipulation or reporting involving student load typically requires joining these three tables to get a complete picture of the status, calendar, and defined load rule.