Search Results igf_aw_loan_limit_all

Overview

The table IGF_AW_LOAN_LIMIT_ALL is a core data repository within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It is a multi-organization table (indicated by the _ALL suffix and the ORG_ID column) designed to store the statutory loan limits for Federal Stafford Loans. These limits are critical for calculating the maximum loan amounts a student is eligible to receive within a specific award year. The limits are defined by key regulatory parameters: the Award Year (represented by the Calendar Instance), the student's Grade Level (with separate columns for FFELP and Direct Loan programs), and the student's Dependency Status. This table serves as a master reference, ensuring that automated award packaging and manual overrides comply with federal regulations.

Key Information Stored

The table's structure is centered around defining the maximum loan amounts for specific student profiles. Key columns include ALLT_ID (the primary key surrogate identifier), CI_CAL_TYPE and CI_SEQUENCE_NUMBER (which together identify the Award Year calendar instance), and DEPEND_STAT for dependency status. The grade level is captured in two separate columns: FFELP_GRADE_LEVEL and DL_GRADE_LEVEL, accommodating the different grade level codings that may exist between the Federal Family Education Loan Program (FFELP) and the William D. Ford Federal Direct Loan (Direct Loan) program. The ORG_ID column partitions the data by operating unit. The table would also contain numeric columns (not explicitly listed in the provided metadata but inherent to its purpose) for storing the actual annual and aggregate subsidized and unsubsidized loan limit amounts.

Common Use Cases and Queries

The primary use case is during the financial aid award packaging process. When packaging a Stafford Loan for a student, the system queries this table to determine the applicable annual limit based on the student's award year, dependency status, and grade level. This prevents over-awarding. A typical lookup query would be:

• SELECT subsidized_limit, unsubsidized_limit FROM igf_aw_loan_limit_all WHERE ci_cal_type = :1 AND ci_sequence_number = :2 AND depend_stat = :3 AND (ffelp_grade_level = :4 OR dl_grade_level = :4) AND org_id = :5;

This table is also central to regulatory reporting and audits, as it provides a verifiable record of the loan limits applied during an award year. Administrators use maintenance screens to update these limits annually or when federal regulations change.

Related Objects

IGF_AW_LOAN_LIMIT_ALL has defined relationships with other EBS tables. Its primary foreign key relationship is with the IGS_CA_INST_ALL table, which stores calendar instances. This relationship validates that the award year (CI_CAL_TYPE, CI_SEQUENCE_NUMBER) used in the loan limit table is a valid calendar within the system. The table is referenced by various financial aid award and packaging entities, though the specific foreign keys are not listed in the provided excerpt. In practice, it is a parent table to award detail tables (like IGF_AW_AWD_DISB) and packaging setup tables, which store the actual awarded amounts against these limits. The unique key constraint ensures that duplicate limit rules cannot be defined for the same combination of award year, dependency status, grade level, and operating unit.