Search Results igf_gr_report_pell_pk

Overview

IGF_GR_REPORT_PELL is a Financial Aid (IGF) module table in Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the IGF schema and documented as VALID. Its stated purpose is to hold reporting Pell identifiers — the Pell Grant reporting attributes that a financial aid institution (campus) uses when transmitting Title IV disbursement and origination data for the federal Pell Grant program. In practice, the table acts as the anchor that ties a reporting campus record to an academic calendar instance, so that downstream Pell attendance and disbursement records can be grouped, validated, and reported at the correct institution/period grain.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification: the table carries descriptive, context-dependent attributes (reporting Pell code, OPE identifier, reporting entity text) attached to a key that is shared with other financial aid objects, rather than acting as a pure hub of unrelated business keys or as a many-to-many link. The primary key constraint is IGF_GR_REPORT_PELL_PK, keyed on RCAMPUS_ID, and the unique index IGF_GR_REPORT_PELL_U1 also covers RCAMPUS_ID, indicating that RCAMPUS_ID is both the surrogate-style identifier for this object and its effective business key.

Key Information Stored

The documented physical schema for the 12.1.1 baseline contains 11 columns. The most significant are summarized below; only columns present in the metadata are listed.

• RCAMPUS_ID — the primary key (IGF_GR_REPORT_PELL_PK) and the unique-index column (IGF_GR_REPORT_PELL_U1). It identifies a reporting campus row and is the join key from dependent tables.
• CI_CAL_TYPE and CI_SEQUENCE_NUMBER — the composite foreign key to IGS_CA_INST_ALL, identifying the academic calendar instance (calendar type plus sequence) to which the reporting record applies.
• REPORTING_PELL_CD — the reporting Pell code, the core Pell-program attribute held by this entity.
• OPE_CD — the Office of Postsecondary Education (OPE) identifier for the institution, used in federal reporting and reconciliation.
• REP_ENTITY_ID_TXT — free-text reporting entity identifier, providing additional institutional identifying context.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS WHO audit columns capturing row provenance and change history.

The surrogate primary key (RCAMPUS_ID) is therefore distinct from the calendar-instance foreign key: the former identifies the reporting record itself, while the latter points to the academic period it describes.

Common Use Cases and Queries

Typical usage centers on Pell reporting and reconciliation. Analysts join this table to the academic calendar instance to resolve period names, and to the dependent attendance table to aggregate Pell detail.

A representative query resolving the calendar context:

• SELECT p.RCAMPUS_ID, p.REPORTING_PELL_CD, p.OPE_CD, c.CAL_TYPE, c.SEQUENCE_NUMBER FROM IGF_GR_REPORT_PELL p, IGS_CA_INST_ALL c WHERE p.CI_CAL_TYPE = c.CAL_TYPE AND p.CI_SEQUENCE_NUMBER = c.SEQUENCE_NUMBER;

A query aggregating dependent attendance records:

• SELECT r.RCAMPUS_ID, r.OPE_CD, COUNT(a.RCAMPUS_ID) FROM IGF_GR_REPORT_PELL r, IGF_GR_ATTEND_PELL a WHERE r.RCAMPUS_ID = a.RCAMPUS_ID GROUP BY r.RCAMPUS_ID, r.OPE_CD;

Because the table is keyed on RCAMPUS_ID, it is well suited as the driving table in reporting extracts, one-row-per-campus lookups, and OPE-based institutional reconciliation reports.

Related Objects

The most significant related objects, based on documented foreign-key relationships, are:

• IGS_CA_INST_ALL — referenced by IGF_GR_REPORT_PELL via CI_CAL_TYPE and CI_SEQUENCE_NUMBER; supplies the academic calendar instance.
• IGF_GR_ATTEND_PELL — the principal dependent table, referencing this table through RCAMPUS_ID; holds Pell attendance detail for the reporting campus.

These two tables form the immediate Pell reporting neighborhood. Other IGF financial aid objects (for example, Pell disbursement and origination entities) generally reach this table indirectly through IGF_GR_ATTEND_PELL and the IGS_CA_INST_ALL calendar instance, rather than by direct foreign key.