Results for “igf_gr_pell_rng_amt”

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

Overview

IGF_GR_PELL_RNG_AMT is a reporting view within the Oracle E-Business Suite Financial Aid module (IGF), historically associated with the administration of Federal Pell Grant award ranges. The object is classified under the IGF product family, which carries an Obsolete designation in Oracle's Electronic Technical Reference Manual (ETRM). This classification signals that the object is no longer actively supported or installed in current EBS implementations, and the ETRM metadata explicitly records its implementation status as "Not implemented in this database."

The view is designed to present Pell Grant range-amount configuration data — the calculated award amounts corresponding to defined Cost of Attendance (COA) and Expected Family Contribution (EFC) ranges, qualified by enrollment status and academic calendar context. In the context of Oracle EBS 12.1.1 and 12.2.2, such a view served as a reporting and integration layer over the underlying range-all table, enabling external reads of award-matrix data without direct access to the base table. As an obsolete object, it is documented for reference and migration analysis rather than for active development.

Underlying Base Objects

The view is defined over a single base object, IGF_GR_PELL_RNG_AMT_ALL, aliased as CRNGD in the view text. The _ALL suffix identifies the base table as a multi-organization (multi-org) object, meaning it stores rows partitioned by ORG_ID to support operating-unit-level data segregation. No other base objects are documented; the ETRM "Referenced base objects" field records none, and the view text confirms a single-table SELECT with no joins.

The relationship between view and table is therefore one-to-one in terms of columns: every column exposed by the view is sourced directly from IGF_GR_PELL_RNG_AMT_ALL, with only the ORG_ID-based filter applied. This design pattern is the standard multi-org secured view idiom in EBS, where a view named without the _ALL suffix presents only the rows visible to the current operating unit.

Key Columns

• ROW_ID — Derived from the base table's ROWID; a unique physical row identifier useful for direct row addressing.
• ENROLLMENT_STAT — Enrollment status qualifier (e.g., full-time, part-time) to which the range-amount record applies.
• CI_CAL_TYPE / CI_SEQUENCE_NUMBER — The academic calendar type and sequence number defining the period of applicability.
• COA_START / COA_END — Lower and upper bounds of the Cost of Attendance range that the record governs.
• EFC_START / EFC_END — Lower and upper bounds of the Expected Family Contribution range.
• AMOUNT — The Pell Grant award amount assigned to the COA/EFC range intersection.
• ORG_ID — Operating unit identifier supporting multi-org data segregation.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and the analogous WHO columns on the base table.

Common Use Cases and Queries

Typical uses included extract-and-report functions for financial aid offices — reconciling configured award matrices against disbursed Pell amounts — and integration feeds passing range data to downstream award-calculation or reporting systems. Because the object is obsolete, reproduction in a current environment is unlikely to succeed; the following construct reflects the documented behavior.

SELECT enrollment_stat,
       coa_start, coa_end,
       efc_start, efc_end,
       amount
  FROM igf_gr_pell_rng_amt
 WHERE ci_cal_type = :p_cal_type
   AND ci_sequence_number = :p_seq
 ORDER BY enrollment_stat, coa_start, efc_start;

Analysts migrating off IGF should treat this view as legacy reference material, confirming against ETRM that it is not implemented before including it in any active data model.