Search Results allt_id




Overview
Explore in AI Chat

Overview

The IGF_AW_LOAN_LIMIT_ALL table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Grants and Awards module (IGF). Its primary function is to store federally defined Stafford Loan limits, which are critical for calculating and enforcing maximum loan amounts a student can receive. These limits are determined by a combination of the award year, the student's grade level, and their dependency status. As a multi-organization table (indicated by the '_ALL' suffix and the ORG_ID column), it supports the definition of unique loan limits for each operating unit within an enterprise deployment, ensuring compliance with federal regulations across different organizational entities.

Key Information Stored

The table's structure is designed to capture the precise parameters and corresponding financial limits for federal loans. The ALLT_ID column serves as the unique primary key identifier for each limit record. Key configuration columns include CI_CAL_TYPE and CI_SEQUENCE_NUMBER, which together define the award year calendar, and DEPEND_STAT, FFELP_GRADE_LEVEL, and DL_GRADE_LEVEL, which define the student's characteristics. The core financial data is stored in four critical limit columns: SUBS_ANNUAL_LT (Subsidized Annual Limit), TOT_ANNUAL_LT (Total Annual Limit), SUBS_AGGR_LT (Subsidized Aggregate Limit), and TOT_AGGR_LT (Total Aggregate Limit). Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, etc.) and the ORG_ID for multi-org support complete the table's structure.

Common Use Cases and Queries

This table is central to the automated packaging of student financial aid. During the award packaging process, the system queries this table to determine the maximum allowable Stafford Loan amounts for a given student based on their award year, grade level, and dependency status. A typical query to retrieve applicable limits for a specific operating unit and award year would be:

SELECT ffelp_grade_level,
       depend_stat,
       subs_annual_lt,
       tot_annual_lt
  FROM igf.igf_aw_loan_limit_all
 WHERE ci_cal_type = '&Award_Year_Type'
   AND ci_sequence_number = &Sequence_Number
   AND org_id = &Org_ID
 ORDER BY ffelp_grade_level;

This data is also essential for compliance reporting, audit trails, and configuring annual loan limit updates as federal regulations change. The unique index (IGF_AW_LOAN_LIMIT_ALL_U2) on the combination of ORG_ID, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, FFELP_GRADE_LEVEL, DL_GRADE_LEVEL, and DEPEND_STAT enforces business rules preventing duplicate limit definitions for the same criteria.

Related Objects

The IGF_AW_LOAN_LIMIT_ALL table has defined relationships with other EBS objects. Its primary key, ALLT_ID, is enforced by the constraint IGF_AW_LOAN_LIMIT_ALL_PK. Furthermore, the table references the IGS_CA_INST_ALL table via the CI_CAL_TYPE column (and implicitly CI_SEQUENCE_NUMBER) to validate the award year calendar instance. This foreign key relationship ensures that loan limits are defined only for valid and existing academic calendars within the system, maintaining referential integrity across the student information and financial aid modules.