Search Results sequence_txt




Overview
Explore in AI Chat

Overview

IGF.IGF_GR_REG_AMTS is a standalone configuration table in the Oracle E-Business Suite 12.1.1 and 12.2.2 Financial Aid module (IGF schema). It stores the Regular Pell Grant award amounts applicable to a given combination of cost of attendance (COA) ranges and Expected Family Contribution (EFC) ranges, segmented by system award year and the student's enrollment status code. Functionally it serves as the lookup matrix the Pell Grant calculation engine consults to determine the correct scheduled award for a student, replacing what historically would be a printed Pell payment schedule with a queryable, maintainable table.

The table is documented as standalone. Applying a Data Vault modeling heuristic, it is best characterized as a reference or lookup hub keyed on its business identity; because it does not reference any other database object and carries no foreign keys, there is no upstream link or parent hub to model against. If modeled in Data Vault terms, it would reasonably be treated as a hub anchored on the award year and enrollment status combination, with a degenerate keyed business identifier, and no satellite dependency chain inherited from other IGF objects.

Key Information Stored

The table contains thirteen columns. The most significant are:

Two unique indexes enforce business identity: IGF_GR_REG_AMTS_U1 on SEQUENCE_TXT, and IGF_GR_REG_AMTS_U2 on the composite of SYS_AWD_YR, ENROLLMENT_STAT_CODE, COA_RANGE_START, COA_RANGE_END, EFC_RANGE_START, and EFC_RANGE_END. The composite index is the true business-key candidate, ensuring no overlapping COA/EFC band definitions exist for the same award year and enrollment status.

Common Use Cases and Queries

Typical uses include maintaining the annual Pell schedule, verifying the award amount returned for a specific student profile, and auditing band coverage to detect gaps or overlaps in COA and EFC ranges.

Retrieve the full schedule for an award year:

  • SELECT sequence_txt, sys_awd_yr, enrollment_stat_code, coa_range_start, coa_range_end, efc_range_start, efc_range_end, pell_amount FROM igf.igf_gr_reg_amts WHERE sys_awd_yr = :p_award_year ORDER BY enrollment_stat_code, coa_range_start;

Look up the scheduled award for a specific student profile using range containment:

  • SELECT pell_amount FROM igf.igf_gr_reg_amts WHERE sys_awd_yr = :p_award_year AND enrollment_stat_code = :p_enroll AND :p_coa BETWEEN coa_range_start AND coa_range_end AND :p_efc BETWEEN efc_range_start AND efc_range_end;

Detect configuration gaps and overlaps by comparing consecutive band endpoints within an award year and enrollment status.

Related Objects

The metadata documents IGF_GR_REG_AMTS as standalone: it references no database object, and its only listed dependent is the APPS synonym APPS.IGF_GR_REG_AMTS, which permits application-tier code to query the table without schema qualification. There are no foreign-key relationships to other IGF tables to enumerate. Consequently, runtime joins are driven by shared business attributes rather than referential integrity — principally SYS_AWD_YR and ENROLLMENT_STAT_CODE, which link logically to other award-year and enrollment-status driven objects in the Financial Aid schema (such as COA and EFC data used during packaging). Because no explicit FK targets are documented, integration and reporting joins should be constructed on SYS_AWD_YR and ENROLLMENT_STAT_CODE and validated against the actual IGF schema in the target instance.