Results for “igf_gr_rfms_enrol_stat”

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

Overview

IGF_GR_PELL_COA_RNG_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, part of the Financial Aid module delivered under the Oracle Student System / Student Financial Aid (IGF) product family. It presents the records held in the Pell Grant Cost of Attendance (COA) range table alongside descriptive attributes sourced from the calendar instance table, so that enrollment-status values are returned in human-readable form rather than as raw lookup codes. The "GR" prefix refers to Grant processing and "PELL" identifies the Title IV Pell Grant program, while "COA_RNG" denotes the cost-of-attendance range configuration maintained per enrollment status and per academic period.

Because Pell award amounts are driven by the relationship between the institutional cost of attendance and the enrollment category of the student, this view serves as a reference-independent extract of those ranges. It is typically consumed by concurrent programs, reports, and interfaces that must validate or display the COA bands applicable to a Pell-eligible student. Notably, the user search term igf_gr_rfms_enrol_stat corresponds to the lookup type passed to IGF_AW_GEN.LOOKUP_DESC within the view text, confirming that the enrollment-status is decoded against the IGF_GR_RFMS_ENROL_STAT lookup before exposure.

Underlying Base Objects

The ETRM metadata records no formally documented base objects for this view; however, the view definition itself unambiguously identifies its two source objects, joined in the FROM clause:

• IGF_GR_PELL_COA_RNG CRNG — the driving table, holding the configured Pell cost-of-attendance ranges, including the enrollment status, calendar type and sequence reference, and the COA start and end amount boundaries.
• IGS_CA_INST CI — the calendar instance table, providing the alternate code, start date, and end date for the academic period against which each range is defined.

The two objects are equated on CRNG.CI_CAL_TYPE = CI.CAL_TYPE and CRNG.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER, so the view performs a straightforward inner join keyed on the academic calendar instance. All other columns are projected directly from CRNG, with the single derived column ENRL_STAT_DESC resolved through the seeded function IGF_AW_GEN.LOOKUP_DESC using the lookup type IGF_GR_RFMS_ENROL_STAT.

Key Columns

• ROW_ID — unique identifier of the underlying COA range row.
• CI_ALTERNATE_CODE — alternate (user-facing) code of the calendar instance, e.g. the academic period label.
• ENROLLMENT_STAT — the coded enrollment-status value from the IGF_GR_RFMS_ENROL_STAT lookup.
• ENRL_STAT_DESC — the decoded, descriptive text of the enrollment status.
• CI_CAL_TYPE / CI_SEQUENCE_NUMBER — the calendar type and sequence identifying the academic period.
• CI_START_DT / CI_END_DT — the effective start and end dates of that period.
• COA_START / COA_END — the cost-of-attendance range boundaries (lower and upper thresholds) for the band.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical usage is to retrieve the active COA bands per enrollment status for a given academic period, or to join these ranges into Pell award calculations that determine the applicable award tier for a student. A representative query follows:

SELECT enrollment_stat,
       enrl_stat_desc,
       ci_alternate_code,
       coa_start,
       coa_end
  FROM apps.igf_gr_pell_coa_rng_v
 WHERE ci_cal_type = :p_cal_type
   AND ci_sequence_number = :p_seq
 ORDER BY enrollment_stat, coa_start;

The view may also be joined to student enrollment records via the calendar type and sequence, filtering on enrl_stat_desc to produce readable report output. Because it already decodes the enrollment status, it is preferable to querying IGF_GR_PELL_COA_RNG directly, which would require the caller to resolve IGF_GR_RFMS_ENROL_STAT independently.

The view definition and metadata are Oracle Proprietary and Confidential Information.