Search Results igf_gr_report_pell_v

Overview

IGF_GR_REPORT_PELL_V is a reporting view owned by the APPS schema within the IGF (Financial Aid) product module of Oracle E-Business Suite. The view is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 and is described in the ETRM metadata as holding reporting Pell identifiers for an award year. Its purpose is to present a denormalized, query-ready projection of Pell Grant reporting attributes tied to a specific academic calendar instance, allowing downstream reporting, integration, and extract processes to resolve reporting Pell codes and Originating Provider of Education (OPE) identifiers without joining multiple tables manually.

The view does not store data itself; it is a read-only construct whose rows are derived at runtime from its base objects. As a result, any insert or update must target the underlying base table, not the view. Because the view is owned by APPS and marked VALID, it is generally consumed by concurrent programs, Oracle Reports, BI Publisher data templates, and custom PL/SQL that perform regulatory or institutional financial aid reporting.

Underlying Base Objects

The documented view definition references two source objects:

• IGF_GR_REPORT_PELL RP — the primary base table storing the reporting Pell identifiers and related attributes for an award year.
• IGS_CA_INST CI — the academic calendar instance table, joined to supply calendar instance context such as alternate code and start/end dates.

The join condition links the two objects on RP.CI_CAL_TYPE = CI.CAL_TYPE and RP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER, effectively associating each reporting Pell record with a specific calendar instance. The view also exposes RP.ROWID as ROW_ID, preserving a stable identifier back to the base table row. The ETRM view metadata lists no documented referenced base objects under the 12.2.2 entry, but the embedded view text and column list confirm the two-table join above.

Key Columns

• ROW_ID — the ROWID of the IGF_GR_REPORT_PELL base row, useful for identifying or updating the underlying record.
• RCAMPUS_ID — reporting campus identifier associated with the Pell reporting setup.
• ALTERNATE_CODE, START_DT, END_DT — sourced from IGS_CA_INST, providing the calendar instance alternate code and its validity dates.
• CI_CAL_TYPE, CI_SEQUENCE_NUMBER — the calendar type and sequence number identifying the calendar instance.
• REPORTING_PELL_CD — the reporting Pell code for the award year, the central attribute described in the object description.
• OPE_CD — the Originating Provider of Education code required for federal Pell reporting.
• REP_ENTITY_ID_TXT — reporting entity identifier stored as text.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns tracking row creation and modification.

Common Use Cases and Queries

Typical uses include validating that reporting Pell codes and OPE codes are correctly set up for a given award year, generating federal Pell reporting extracts, and auditing which calendar instances carry active reporting identifiers. A representative query follows:

• SELECT reporting_pell_cd, ope_cd, alternate_code, start_dt, end_dt FROM igf_gr_report_pell_v WHERE alternate_code = :calendar_instance ORDER BY start_dt;
• SELECT rep_entity_id_txt, ope_cd FROM igf_gr_report_pell_v WHERE ci_cal_type = :cal_type AND ci_sequence_number = :seq;
• SELECT COUNT(*) FROM igf_gr_report_pell_v WHERE ope_cd IS NULL; — to detect incomplete setup.

Because the view spans calendar instance data and Pell reporting attributes, it is well suited to reporting extracts that require both the academic timeframe and the associated federal reporting identifiers in a single result set.