Search Results enrl_stat_desc

Overview

IGF_GR_PELL_COA_RNG_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the IGF (Financial Aid) product family. Its documented purpose is to show Cost of Attendance (COA) ranges for Pell grant processing. The view consolidates Pell COA range definitions with their associated academic calendar instances, exposing a denormalized, query-ready result set suitable for reporting, validation, and integration use cases. The view carries a VALID status in both Oracle EBS 12.1.1 and 12.2.2 environments.

For the search term "enrl_stat_desc," this view is directly relevant: it exposes a column named ENRL_STAT_DESC, which is the descriptive translation of an enrollment status code. This is the column most likely sought by users investigating enrollment status descriptions within the Pell COA context.

Underlying Base Objects

The view is defined over two base objects in the APPS schema:

• IGF_GR_PELL_COA_RNG — the Pell Cost of Attendance range table, aliased as CRNG in the view text. It supplies the enrollment status, COA start/end amounts, calendar type and sequence, and audit columns.
• IGS_CA_INST — the academic calendar instance table, aliased as CI. It supplies the calendar instance alternate code, start date, and end date.

The join is an equijoin on CRNG.CI_CAL_TYPE = CI.CAL_TYPE and CRNG.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER, meaning each COA range row is enriched with its corresponding calendar instance attributes. No additional base objects are documented in the ETRM metadata.

Key Columns

• ROW_ID — unique row identifier from IGF_GR_PELL_COA_RNG.
• CI_ALTERNATE_CODE — alternate code of the academic calendar instance from IGS_CA_INST.
• ENROLLMENT_STAT — the enrollment status code stored on the COA range row.
• ENRL_STAT_DESC — the descriptive text for ENROLLMENT_STAT, derived via the lookup function IGF_AW_GEN.LOOKUP_DESC('IGF_GR_RFMS_ENROL_STAT', CRNG.ENROLLMENT_STAT). This resolves the enrollment status code against the IGF_GR_RFMS_ENROL_STAT lookup type, producing the human-readable description that satisfies the "enrl_stat_desc" search.
• CI_CAL_TYPE / CI_SEQUENCE_NUMBER — calendar type and sequence identifying the academic calendar instance.
• CI_START_DT / CI_END_DT — start and end dates of the calendar instance.
• COA_START / COA_END — the lower and upper bounds of the cost of attendance range for Pell.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns (note the view aliases LAST_UPDATE_DATE as LAST_UPDATED_DATE).

Common Use Cases and Queries

Typical scenarios include verifying Pell COA ranges by enrollment status, reconciling calendar instance dates against COA effective periods, and feeding downstream financial aid calculations. A representative query filtering on the enrollment description is:

SELECT row_id, ci_alternate_code, enrollment_stat, enrl_stat_desc, coa_start, coa_end
FROM apps.igf_gr_pell_coa_rng_v
WHERE enrl_stat_desc LIKE '%FULL%';

A second pattern joins the view to calendar data to validate active ranges:

SELECT ci_alternate_code, enrl_stat_desc, ci_start_dt, ci_end_dt, coa_start, coa_end
FROM apps.igf_gr_pell_coa_rng_v
WHERE SYSDATE BETWEEN ci_start_dt AND ci_end_dt
ORDER BY ci_alternate_code, enrollment_stat;

Because ENRL_STAT_DESC is computed at runtime by IGF_AW_GEN.LOOKUP_DESC, queries filtering on that column cannot leverage a base-table index and may perform a full scan; filtering instead on ENROLLMENT_STAT is recommended for performance-sensitive reports.