Search Results igf_gr_pell_coa_rng

Overview

The view IGF_GR_PELL_COA_RNG belongs to the IGF (Financial Aid) product family in Oracle E-Business Suite and is documented in the ETRM repository under the module designation "IGF - Financial Aid (Obsolete)." Its stated purpose is to display cost-of-attendance (COA) ranges associated with Pell grant processing. In practice, the view exposes a multi-organization filtered projection of Pell cost-of-attendance range data, allowing callers to retrieve the lower and upper boundaries of a COA band together with the enrollment status and academic calendar context in which that band applies.

The view is explicitly flagged as obsolete in the documented metadata, and it is annotated "Not implemented in this database." This means the object may not be instantiated in all environments, and where it does exist it persists primarily for backward compatibility with earlier Financial Aid releases. Its role in reporting and integration is therefore narrow: it serves as a read-only, Org-striped interface for Pell COA range lookups, typically consumed by Financial Aid batch processes, student aid eligibility logic, and ad hoc institutional reporting.

Underlying Base Objects

According to the documented metadata, the view is defined over a single object, IGF_GR_PELL_COA_RNG_ALL, with no other referenced base objects recorded. The _ALL suffix denotes a multi-organization (multi-Org) table that stores records across all operating units identified by ORG_ID. The view IGF_GR_PELL_COA_RNG functions as the Org-secured counterpart, restricting rows to the operating unit derived from the session context.

Although the ETRM metadata records no other referenced objects, the naming convention and the presence of foreign-key-style columns such as CI_CAL_TYPE and CI_SEQUENCE_NUMBER indicate a logical dependency on the institution's academic calendar definitions. The _ALL table is the sole documented source of rows, and the view adds no joins or aggregations; it simply projects columns and applies a row-level Org filter.

Key Columns

• ROW_ID — The ROWID of the underlying _ALL row, exposed for unique row identification.
• ENROLLMENT_STAT — The enrollment status code for which the COA range is defined, such as full-time, half-time, or less-than-half-time.
• CI_CAL_TYPE — The academic calendar type (for example, academic year or term-based calendar) to which the range applies.
• CI_SEQUENCE_NUMBER — The sequence number identifying the specific calendar instance within the calendar type.
• COA_START — The lower bound of the cost-of-attendance range.
• COA_END — The upper bound of the cost-of-attendance range.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each row and when.
• ORG_ID — The operating unit identifier, used by the view's Org-security predicate.

The Org filter uses USERENV('CLIENT_INFO'): it extracts the first ten characters of the client info string via SUBSTRB, decodes a leading space to NULL, converts to a number, and defaults to -99 when unavailable. Rows are returned where the row's ORG_ID matches this derived identifier. This is the classic pre-12.2 Org-security pattern later replaced by the MOAC/VPD model.

Common Use Cases and Queries

The principal use case is determining the applicable Pell COA band for a given enrollment status and calendar instance, either for eligibility determination or for reconciliation reporting. A representative query restricting by enrollment status and calendar follows:

SELECT enrollment_stat,
       ci_cal_type,
       ci_sequence_number,
       coa_start,
       coa_end
  FROM igf_gr_pell_coa_rng
 WHERE enrollment_stat = :p_enrollment_stat
   AND ci_cal_type = :p_cal_type
   AND ci_sequence_number = :p_sequence_number;

Because the view is Org-filtered automatically, no explicit ORG_ID predicate is required; the session's client information determines the operating unit. Analysts validating range setup may enumerate all defined bands for an operating unit:

SELECT org_id, enrollment_stat, coa_start, coa_end
  FROM igf_gr_pell_coa_rng
 ORDER BY enrollment_stat, coa_start;

Given the object's obsolete status, integrators should confirm its presence with ALL_VIEWS or DBA_VIEWS before relying on it, and should prefer any successor Financial Aid constructs where available. Where the view remains deployed, its stable column set makes it suitable for legacy extracts and migration baselines, but it should be treated as read-only and not used for insert, update, or delete operations.