Search Results igs_en_atd_mode_all




Overview
Explore in AI Chat

Overview

The table IGS_EN_ATD_MODE_ALL is a core reference table within the Oracle E-Business Suite Student System (IGS) module. It functions as a master repository for defining and maintaining the various modes of attendance available for academic programs offered by an institution. An attendance mode describes the pattern of a student's participation in a course of study, such as full-time, part-time, distance learning, or online. This table is critical for configuring program offerings, processing student applications, managing student enrollments, and calculating associated fees and financial aid, as these processes often have logic dependent on the defined attendance mode. Its multi-org structure, indicated by the '_ALL' suffix, allows it to store data for multiple operating units within a single installation.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is documented as ATTENDANCE_MODE. This column is the unique identifier for each valid attendance mode, such as 'FULL_TIME' or 'PART_TIME'. Based on its role as a reference table, it typically contains descriptive columns like a meaning or description field (e.g., ATTENDANCE_MODE_DESC) to provide a clear label for each code. It may also include standard Oracle EBS columns for controlling data lifecycle, such as CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, and ORG_ID for multi-org support. The table's integrity is enforced by the primary key constraint IGS_EN_ATD_MODE_ALL_PK.

Common Use Cases and Queries

This table is primarily used in lookup and validation scenarios across the Student System. A common use case is to populate list of values (LOVs) in forms where users must select a valid attendance mode, such as when defining a new program offering or option. In reporting, it is frequently joined to transactional tables to translate code values into human-readable descriptions. For instance, a report on student enrollments would join this table to IGS_EN_STDNT_PS_ATT_ALL to display the derived attendance mode description. A typical query to retrieve all active attendance modes would be: SELECT attendance_mode, description FROM igs_en_atd_mode_all WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE) ORDER BY attendance_mode;. Administrators may also query it to audit which attendance modes are referenced in other system configurations.

Related Objects

The IGS_EN_ATD_MODE_ALL table is a central reference point, as evidenced by its numerous foreign key relationships. Key related transactional tables that reference its ATTENDANCE_MODE column include:

These relationships ensure data integrity by enforcing that attendance modes used throughout the system are valid entries defined in this master table.