Search Results exp_range_start

Overview

IGF.IGF_GR_ALT_AMTS is a standalone configuration and reference table within the Oracle E-Business Suite Financial Aid module (IGF schema), used to store Alternate Pell Grant Amounts keyed against defined ranges of Cost of Attendance (COA), Expected Family Contribution (EFC), and alternate expenses. It supports the needs-analysis and packaging logic that determines a student's Pell award when the standard Pell payment schedule must be overridden or supplemented by institutional alternate amount rules for a given system award year and enrollment status.

The table is deployed in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, and its indexes reside in APPS_TS_TX_IDX, consistent with standard transaction-data placement convention in EBS 12.1.1 and 12.2.2. The object is registered under FND Design Data as IGF.IGF_GR_ALT_AMTS and is reported as VALID.

From a Data Vault modeling perspective, the metadata classifies this object as standalone, meaning it has no foreign-key relationships to other tables and no dependent child tables. In Data Vault terms this suggests a hub-like or reference/satellite pattern where the business key is fully contained within the row and no upstream link structure is required.

Key Information Stored

The table contains 15 documented columns. The most operationally significant are the range-boundary and award columns described below.

• SEQUENCE_TXT (VARCHAR2(15), mandatory) — the surrogate primary key defined by IGF_GR_ALT_AMTS_PK and enforced uniquely by index IGF_GR_ALT_AMTS_U1. It provides a unique sequence identifier for each alternate amount rule row.
• SYS_AWD_YR (VARCHAR2(30)) — the System Award Year to which the alternate amount applies, the primary temporal discriminator for the rule set.
• ENROLLMENT_STAT_CODE (VARCHAR2(30)) — the student's enrollment status code, scoping the award to a specific enrollment intensity (e.g., full-time, half-time).
• COA_RANGE_START / COA_RANGE_END (NUMBER(15)) — the lower and upper bounds of the Cost of Attendance band.
• EFC_RANGE_START / EFC_RANGE_END (NUMBER(15)) — the lower and upper bounds of the Expected Family Contribution band.
• EXP_RANGE_START / EXP_RANGE_END (NUMBER(15)) — the lower and upper bounds of the alternate expense band. The user's search term, exp_range_start, maps directly to this column, which anchors the expense side of the rule.
• PELL_AMOUNT (NUMBER(15)) — the resulting Pell grant amount to be applied when a student's COA, EFC, and alternate expense values fall within the configured ranges.
• Standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide the standard EBS audit trail.

The business key candidate documented in unique index IGF_GR_ALT_AMTS_U2 is the composite of SYS_AWD_YR, ENROLLMENT_STAT_CODE, COA_RANGE_START, COA_RANGE_END, EFC_RANGE_START, EFC_RANGE_END, EXP_RANGE_START, and EXP_RANGE_END. This composite uniqueness prevents overlapping rule definitions for the same award year and enrollment status, which is essential to deterministic award calculation.

Common Use Cases and Queries

Typical uses include verifying rule coverage, reproducing an award calculation, and auditing overlaps or gaps in configured ranges.

• Retrieve all alternate Pell rules for an award year and enrollment status:
  SELECT sequence_txt, coa_range_start, coa_range_end, efc_range_start, efc_range_end, exp_range_start, exp_range_end, pell_amount FROM igf.igf_gr_alt_amts WHERE sys_awd_yr = :p_award_yr AND enrollment_stat_code = :p_enr_stat ORDER BY coa_range_start, efc_range_start, exp_range_start;
• Point-lookup of the applicable amount for a student's specific COA, EFC, and expense values, driven by the EXP_RANGE_START column: WHERE :p_coa BETWEEN coa_range_start AND coa_range_end AND :p_efc BETWEEN efc_range_start AND efc_range_end AND :p_exp BETWEEN exp_range_start AND exp_range_end;
• Validate that composite business keys are unique across the rule set by grouping on the eight U2 columns and filtering HAVING COUNT(*) > 1.
• Detect range gaps by comparing each EXP_RANGE_END to the next EXP_RANGE_START within a partition of award year and enrollment status.
• Reporting extracts that join the stored PELL_AMOUNT against packaged student awards for reconciliation.

Related Objects

IGF.IGF_GR_ALT_AMTS does not reference any database object by foreign key, and it is referenced by the AP module rather than by other IGF tables. Consequently, joins are driven by matching business-key values — SYS_AWD_YR, ENROLLMENT_STAT_CODE, and the COA/EFC/EXP range columns — rather than by enforced referential constraints. The most significant related objects are:

• AP (Accounts Payable module dependency noted in the metadata) — the documented referencing object.
• IGF award and disbursement tables — joined on SYS_AWD_YR and ENROLLMENT_STAT_CODE to compare the configured PELL_AMOUNT against awarded values.
• Student enrollment and needs-analysis tables — supply the COA, EFC, and alternate expense values matched against the range columns.
• IGF_GR_ALT_AMTS_PK and unique indexes IGF_GR_ALT_AMTS_U1 and IGF_GR_ALT_AMTS_U2 — the integrity objects that enforce surrogate and composite uniqueness.