Search Results igf_ap_attend_map_all




Overview
Explore in AI Chat

Overview

The table IGF_AP_ATTEND_MAP_ALL is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its primary role is to serve as a critical mapping and translation layer between user-defined attendance types and the standardized attendance types required for federal financial aid processing. Specifically, it maps institution-specific attendance classifications, defined within the Oracle Student System (OSS), to the official enrollment statuses mandated for Pell Grants, FFELP Loans, and application processing. This mapping ensures that an institution's internal academic tracking aligns with the regulatory definitions required for accurate aid calculation, disbursement, and reporting to governmental bodies.

Key Information Stored

The table stores the relationships that define the attendance type mapping, with key columns enforcing business rules and data integrity. The primary identifier is the ATM_ID column. The unique business key is a composite of ATTENDANCE_TYPE (the user-defined OSS type), ORG_ID (the operating unit), CAL_TYPE (the academic calendar type), and SEQUENCE_NUMBER (the sequence within that calendar). This structure allows for distinct mappings per operating unit and academic calendar. The table also contains a column for the target financial aid attendance type, which is the standardized value used internally by the aid system, though its specific column name is implied by the context of the foreign key relationships and the table's described purpose.

Common Use Cases and Queries

The primary use case is during the packaging and disbursement of federal aid, where the system must resolve a student's enrollment status. A common operational query would retrieve the financial aid attendance type for a specific student based on their institutional enrollment record. For reporting and setup verification, administrators often query the full mapping setup for an operating unit. Sample SQL patterns include joining to student enrollment tables via the OSS attendance type and filtering by the current academic calendar to determine a student's aid eligibility status. Another critical use is during batch processes for Pell Grant calculation, where the mapping table is referenced to translate enrollment loads into the correct attendance categories for award schedules.

Related Objects

IGF_AP_ATTEND_MAP_ALL has documented foreign key relationships with other EBS tables, primarily within the student system calendar architecture. As per the provided metadata:

  • IGS_CA_INST_ALL: The table is linked to the calendar instance table via the columns CAL_TYPE and SEQUENCE_NUMBER. This ensures that attendance type mappings are valid only for defined academic calendar periods.
Furthermore, this table is logically a parent to various financial aid transactional and setup tables (such as award and disbursement tables) that utilize the mapped financial aid attendance type. It is also a child table to the OSS setup tables where the source ATTENDANCE_TYPE is defined, though these specific OSS table names are not listed in the provided excerpt.