Search Results igf_gr_alt_coa_all




Overview
Explore in AI Chat

Overview

IGF_GR_ALT_COA_ALL is a setup table within the IGF (Financial Aid) product family of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the Cost of Attendance (COA) ranges that define the Alternate Pell Payment Schedule used by the Grants module. Its specific functional purpose is to determine the Pell award amount for Low Tuition Schools, where the standard Pell schedule does not apply and an institution-specific or program-specific COA banding must be evaluated instead.

From a Data Vault modeling perspective, the heuristic classification for this object is hub-leaning. The table anchors on a single surrogate identifier (ALTCOA_ID) and acts as the parent of dependent child records, with no significant descriptive payload that would suggest a pure satellite role. The classification is a modeling suggestion derived from the foreign key topology rather than an enforced property of the delivered schema.

Key Information Stored

The table is documented with twelve physical columns in the IGF schema. The most significant are:

  • ALTCOA_ID — The surrogate primary key, enforced through IGF_GR_ALT_COA_ALL_PK. It uniquely identifies each Alternate COA range and is the value propagated to dependent rows in IGF_GR_ALT_EXP_ALL.
  • ENRL_STAT — Enrollment status code, indicating the enrollment intensity (for example, full-time or part-time) to which the COA range applies.
  • CI_CAL_TYPE and CI_SEQUENCE_NUMBER — The academic calendar type and sequence number that bind the range to a specific award or academic period.
  • COA_START and COA_END — The lower and upper bounds of the Cost of Attendance band. Together they define the interval within which a student's COA falls for the associated enrollment status and calendar period.
  • ORG_ID — The operating unit or business unit discriminator, supporting multi-org partitioning of the setup data.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — Standard EBS WHO-column audit attributes that record row creation and modification.

Two unique indexes are documented. IGF_GR_ALT_COA_ALL_U1 covers ALTCOA_ID alone and reinforces the surrogate key. IGF_GR_ALT_COA_ALL_U2 is the composite business-key candidate spanning ENRL_STAT, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, COA_START, COA_END, and ORG_ID. The composite uniqueness constraint is the meaningful one: it guarantees that a given enrollment status, calendar period, and COA band combination exists only once per operating unit, preventing ambiguous or overlapping alternate schedule definitions.

Common Use Cases and Queries

The primary use case is award calculation: when the Grants process evaluates an Alternate Pell Payment Schedule for a low tuition school, it looks up the student's enrollment status and Cost of Attendance against the range defined here. Reporting and validation scenarios typically verify completeness and non-overlap of the configured bands.

A representative query retrieves all alternate COA bands for a given calendar and operating unit:

SELECT alc.altcoa_id,
       alc.enrl_stat,
       alc.coa_start,
       alc.coa_end
FROM   igf.igf_gr_alt_coa_all alc
WHERE  alc.org_id          = :p_org_id
AND    alc.ci_cal_type     = :p_cal_type
AND    alc.ci_sequence_number = :p_seq_num
ORDER BY alc.enrl_stat, alc.coa_start;

A second pattern finds the matching band for a specific student's COA:

SELECT alc.altcoa_id
FROM   igf.igf_gr_alt_coa_all alc
WHERE  alc.enrl_stat = :p_enrl_stat
AND    :p_coa BETWEEN alc.coa_start AND alc.coa_end
AND    alc.org_id    = :p_org_id;

Common reporting checks include detecting gaps or overlaps between COA_START and COA_END within the same enrollment status, and auditing setup changes by comparing LAST_UPDATE_DATE and LAST_UPDATED_BY.

Related Objects

The documented foreign key relationships define the principal dependent objects:

  • IGF_GR_ALT_EXP_ALL — The most significant child table. Its ALTCOA_ID foreign key column references IGF_GR_ALT_COA_ALL, so alternate Pell expenditure or award detail rows depend on the COA range defined here.
  • IGF_GR_ALT_COA_ALL_PK — The primary key constraint index on ALTCOA_ID.
  • IGF_GR_ALT_COA_ALL_U1 and IGF_GR_ALT_COA_ALL_U2 — Unique index constraints enforcing the surrogate and composite business keys respectively.

Additional integration is expected through the standard Grants award calculation and Pell processing logic, which consumes this setup data along with enrollment and calendar references from the shared Oracle Student System and HR organization structures, though these dependencies are not enumerated in the documented foreign key metadata.