Results for “igf_gr_pell_coa_rng_all”

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

Overview

IGF_GR_PELL_COA_RNG_ALL is a table within the IGF (Financial Aid) product family in Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. Its stated purpose is to store Cost of Attendance (COA) ranges used in Pell Grant processing. Cost of attendance represents the total estimated student expense budget — tuition, fees, books, supplies, room, board, and personal costs — against which a student's Expected Family Contribution is measured to determine Pell eligibility. This table captures the range boundaries that drive that determination logic.

ETRM explicitly flags this object as obsolete (Product: IGF - Financial Aid (Obsolete)) and notes "Not implemented in this database." Organizations on 12.1.1 or 12.2.2 should therefore treat it as a legacy or reference artifact rather than an active transaction table. It typically surfaces in upgrade analysis, data archival exercises, or lineage reviews where older financial aid customizations must be traced. Note also that IGF is not a standard certified EBS application module; it appears in student-system and higher-education deployments, so availability varies by installation.

From a data modeling perspective, the heuristic Data Vault classification is satellite-leaning. The table's grain is a specific COA range tied to a calendar instance and enrollment status, making it descriptive context rather than an independent business entity. A satellite modeling suggestion would place these attributes under a hub or link keyed by calendar and enrollment dimensions.

Key Information Stored

The documented physical schema lists 11 columns. The most significant are described below.

• CI_CAL_TYPE — Calendar type identifier. Part of the composite primary key and a foreign key, indicating the academic calendar under which the range applies.
• CI_SEQUENCE_NUMBER — Calendar instance sequence number. Together with CI_CAL_TYPE, it identifies the specific calendar occurrence (for example, an aid year or term).
• COA_START — Lower boundary of the cost of attendance range.
• COA_END — Upper boundary of the cost of attendance range.
• ENROLLMENT_STAT — Enrollment status (for example, full-time, part-time) associated with the range.
• ORG_ID — Operating unit / organization identifier, indicating multi-org partitioning of the rows.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording row creation and modification.

The surrogate primary key is IGF_GR_PELL_COA_RNG_ALL_PK, spanning CI_CAL_TYPE, CI_SEQUENCE_NUMBER, COA_END, COA_START, and ENROLLMENT_STAT. The unique index IGF_GR_PELL_COA_RNG_ALL_U1 covers the identical five-column set, so the documented business-key candidate and the primary key coincide — there is no separate surrogate column distinct from the business attributes. The absence of a generated numeric ID column confirms the natural composite key design characteristic of this legacy structure.

Common Use Cases and Queries

Because the table is obsolete and not implemented, practical use is limited to migration validation, historical reconciliation, and schema archaeology. A typical inspection query lists the configured ranges for a calendar instance:

SELECT ci_cal_type, ci_sequence_number, coa_start, coa_end, enrollment_stat FROM igf.igf_gr_pell_coa_rng_all WHERE ci_cal_type = :cal_type AND ci_sequence_number = :seq ORDER BY enrollment_stat, coa_start;

A range-lookup pattern binds a student's computed COA to the matching band:

SELECT * FROM igf.igf_gr_pell_coa_rng_all WHERE :student_coa BETWEEN coa_start AND coa_end AND enrollment_stat = :status;

For archival work, an existence and count check per operating unit confirms whether any rows survived:

SELECT org_id, COUNT(*) FROM igf.igf_gr_pell_coa_rng_all GROUP BY org_id;

Reporting scenarios include reconstructing historical Pell award logic, auditing COA band definitions across aid years, and validating that the companion amount table's ranges align with the bands defined here.

Related Objects

The most significant related object is IGF_GR_PELL_RNG_AMT_ALL, which stores the award or amount values keyed to these ranges. The foreign key relationship joins on five columns — CI_CAL_TYPE, CI_SEQUENCE_NUMBER, COA_END, COA_START, and ENROLLMENT_STAT — making the two tables one logical structure split by concern (range definition versus monetary amount). The join pattern is:

SELECT r.coa_start, r.coa_end, r.enrollment_stat, a.* FROM igf.igf_gr_pell_coa_rng_all r, igf.igf_gr_pell_rng_amt_all a WHERE r.ci_cal_type = a.ci_cal_type AND r.ci_sequence_number = a.ci_sequence_number AND r.coa_start = a.coa_start AND r.coa_end = a.coa_end AND r.enrollment_stat = a.enrollment_stat;

Other dependencies derive from the calendar foreign key, which resolves to calendar type and instance definitions maintained in the academic calendar framework, and from the ORG_ID partition, which associates rows with operating unit and organizational hierarchy definitions. Because both documented tables are marked obsolete, no supported API or concurrent program is expected to write to them in current releases; any integration points would exist only in legacy customizations. Reviewing these relationships is essential before dropping or archiving the tables during a 12.2 upgrade.