Results for “coa_end”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGF_GR_PELL_RNG_AMT_ALL is a Financial Aid (IGF) module table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the cost of attendance (COA) ranges mapped against expected family contribution (EFC) amounts to determine the Pell Grant award amount a student qualifies for, stratified further by enrollment status. In effect, it is the institutional "Pell chart" reference data that drives need-based award calculation for the U.S. federal Pell Grant program.

Each row defines a discrete band bounded by COA_START / COA_END and EFC_START / EFC_END, together with an associated AMOUNT and the applicable ENROLLMENT_STAT. The table is owned by the IGF schema and is documented as VALID in ETRM metadata. Heuristically, the foreign key structure classifies this object as satellite-leaning — that is, it behaves as a dependent child or attribute-bearing table hanging off a parent reference table rather than as a standalone hub or a pure link. This classification is a modeling suggestion, not an enforced constraint.

Key Information Stored

The table contains 14 documented physical columns. The most significant are:

• CI_CAL_TYPE / CI_SEQUENCE_NUMBER — identify the calendar type and sequence to which the Pell range set applies, allowing different award charts for different aid years or academic calendars.
• COA_START / COA_END — the lower and upper bounds of the cost-of-attendance band for a given row.
• EFC_START / EFC_END — the lower and upper bounds of the expected family contribution band.
• ENROLLMENT_STAT — the enrollment status (e.g., full-time, three-quarter, half-time, less than half-time) that qualifies the row; Pell amounts are scaled by enrollment intensity.
• AMOUNT — the Pell award amount payable when a student's COA, EFC, and enrollment status fall within the row's defined ranges.
• ORG_ID — the operating unit context, supporting multi-org deployments.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns capturing who inserted or last modified the row and when.

The primary key, IGF_GR_PELL_RNG_AMT_ALL_PK, is a composite business key composed of CI_CAL_TYPE, CI_SEQUENCE_NUMBER, COA_START, COA_END, EFC_START, EFC_END, and ENROLLMENT_STAT. The unique index IGF_GR_PELL_RNG_AMT_ALL_U1 mirrors that same column set, confirming the natural key that guarantees no two overlapping range definitions exist for the same calendar, COA band, EFC band, and enrollment status.

Common Use Cases and Queries

The primary operational use is Pell award lookup during financial aid packaging. Given a student's computed COA, EFC, enrollment status, and aid-year calendar, an award lookup returns the applicable AMOUNT. A representative query pattern follows:

• SELECT amount FROM igf.igf_gr_pell_rng_amt_all WHERE ci_cal_type = :cal AND ci_sequence_number = :seq AND enrollment_stat = :stat AND :coa BETWEEN coa_start AND coa_end AND :efc BETWEEN efc_start AND efc_end AND org_id = :org;
• Range integrity reporting: verifying that no gaps or overlaps exist across the COA and EFC bands for a given calendar and enrollment status combination.
• Year-over-year comparison: extracting AMOUNT grids per CI_CAL_TYPE / CI_SEQUENCE_NUMBER to detect federally mandated Pell chart changes.
• Award disbursement projections: joining to student COA and EFC data to estimate aggregate Pell liability per aid year.

Related Objects

The documented foreign key relationship ties this table to its parent reference table:

• IGF_GR_PELL_COA_RNG_ALL — joined on CI_CAL_TYPE, CI_SEQUENCE_NUMBER, COA_START, COA_END, and ENROLLMENT_STAT; this parent table defines the valid COA range bands, and IGF_GR_PELL_RNG_AMT_ALL attaches EFC bands and award amounts to those bands.

Related objects commonly referenced in this functional area include the ISI/IGF student award and disbursement tables, the aid-year calendar definitions used by CI_CAL_TYPE / CI_SEQUENCE_NUMBER, and the operating unit setup underlying ORG_ID. Because the amount grid is consumed during award calculation, financial aid packaging processes and Pell award views in the IGF module depend indirectly on this table. Because the range grid must contain no overlapping bands per calendar and enrollment status, the primary key and unique index IGF_GR_PELL_RNG_AMT_ALL_U1 are the principal integrity safeguards referenced during configuration and maintenance.