Search Results igs_en_atd_type_all




Overview
Explore in AI Chat

Overview

The IGS_EN_ATD_TYPE_ALL table is a core reference table within the Oracle E-Business Suite Student System (IGS) module. It serves as a master repository for defining and managing all valid attendance types for university programs. An attendance type categorizes a student's mode of participation in an academic program, such as full-time, part-time, distance learning, or co-op. This table is central to numerous student lifecycle processes, including admissions, enrollment, program offering configuration, and financial aid eligibility. Its data is referenced by a wide array of transactional and setup tables across the Student System, Admissions, and Financial Aid modules, making it a critical component for ensuring data integrity and consistent business rule application in both EBS 12.1.1 and 12.2.2 environments.

Key Information Stored

The primary data stored in this table is the attendance type code and its associated descriptive information. While the full column list is not detailed in the provided metadata, the structure typically includes a code column (e.g., ATTENDANCE_TYPE) acting as the primary key, along with descriptive name, effective dates, and control flags. These flags may govern whether the attendance type is active, system-reserved, or applicable for specific business functions. The table supports multi-organization access control through the standard `_ALL` table convention, indicated by a column such as ORG_ID, allowing it to store institution-specific attendance types within a single installation.

Common Use Cases and Queries

This table is primarily used for validation, reporting, and setup. A common operational use case is validating the attendance type selected during a student's course application or program enrollment against the list of active types defined in this table. For reporting, it is frequently joined to student enrollment records to analyze population distributions by attendance mode. Administratively, it is queried and maintained via the application's front-end forms to configure available options for academic programs. A typical SQL query to retrieve active attendance types for reporting would be:

  • SELECT attendance_type, description FROM igs_en_atd_type_all WHERE sysdate BETWEEN start_date AND NVL(end_date, sysdate) AND org_id = :org_id;

Another critical use case, directly relevant to the user's search for "igf_ap_fa_ant_data," is in financial aid processing. The attendance type is a key determinant in cost of attendance calculations and award packaging, as evidenced by the foreign key relationship with the IGF_AP_FA_ANT_DATA table.

Related Objects

The IGS_EN_ATD_TYPE_ALL table has extensive relationships across the IGS and Financial Aid (IGF) modules, as documented by its foreign key constraints. Its primary key (ATTENDANCE_TYPE) is referenced by numerous tables. Key relationships include:

These relationships enforce that attendance types used in transactional data must be predefined in this master table, ensuring referential integrity.