Search Results igs_en_atd_type_load_all




Overview
Explore in AI Chat

Overview

The table IGS_EN_ATD_TYPE_LOAD_ALL is a core configuration table within the Oracle E-Business Suite Student System (IGS) module. It functions as a mapping or relationship table, defining the permissible and logical associations between a student's academic load calendar type and their attendance types. This relationship is fundamental for enforcing business rules and ensuring data integrity when processing student enrollment, attendance, and workload calculations. As a multi-org enabled table (indicated by the "_ALL" suffix), it stores data for multiple operating units, allowing the Student System to be deployed in a shared-instance, multi-organization architecture common in EBS 12.1.1 and 12.2.2 implementations.

Key Information Stored

The table's structure is centered on the two key identifiers that form its primary key. The CAL_TYPE column stores the code for the calendar type associated with a student's academic load, such as a semester, trimester, or quarter. The ATTENDANCE_TYPE column stores the code for a specific mode of attendance, like full-time, part-time, or research. The primary key constraint (IGS_EN_ATD_TYPE_LOAD_ALL_PK) on these two columns ensures that each unique combination of a load calendar type and an attendance type is recorded only once, preventing duplicate mappings. This simple but critical structure acts as a validation reference for other transactional processes in the student lifecycle.

Common Use Cases and Queries

This table is primarily referenced during enrollment and reporting processes. A common use case is validating a student's enrollment attempt against the defined academic structure. For instance, when a student is being enrolled in a 'Standard Semester' (CAL_TYPE), the system can reference this table to determine which attendance types (e.g., 'Full-Time', 'Half-Time') are valid for that calendar. A typical query would retrieve all valid attendance types for a given load calendar for a user interface list of values (LOV).

SELECT attendance_type
FROM igs_en_atd_type_load_all
WHERE cal_type = :p_cal_type
AND org_id = :p_org_id;

Conversely, reporting on the configuration setup often involves joining to descriptive tables for the code meanings.

Related Objects

The table maintains a direct foreign key relationship to the master attendance types table, ensuring referential integrity. The documented relationship is:

  • Foreign Key to IGS_EN_ATD_TYPE_ALL: The ATTENDANCE_TYPE column in IGS_EN_ATD_TYPE_LOAD_ALL references the corresponding column in IGS_EN_ATD_TYPE_ALL. This ensures that every attendance type used in a load mapping is a valid, predefined attendance type within the system.

While not explicitly listed in the provided metadata, the CAL_TYPE column would logically reference a calendar type definition table (such as IGS_CA_TYPE). This table is also likely to be referenced by various enrollment and load calculation packages within the IGS product to enforce business rules during student registration and academic progress tracking.