Search Results ope_cd




Overview
Explore in AI Chat

Overview

APPS.IGF_GR_REPORT_PELL_V is a supplementary database view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as IGF.IGF_GR_REPORT_PELL_V. It is classified as a supplementary view whose stated purpose is to simplify forms coding. The view exposes reporting-related Pell grant identifier data drawn from the IGF Grantor reporting subsystem and joins it to award calendar instance information. Because it is documented as a view rather than a base table, Oracle explicitly warns against querying or altering data through it directly, noting that its definition may change dramatically in subsequent minor or major releases.

The name reflects its function: it reports on Pell code mappings (IGF_GR_REPORT_PELL) as they relate to award year calendar instances. The view is central to the mapping between a Reporting Pell identifier and the OPE ID (Office of Postsecondary Education identification) associated with it, making it the reference object users reach for when searching on "ope_cd" within ETRM and related reporting contexts.

Underlying Base Objects

The documented dependency list identifies the base objects underlying this view as:

The join between these two objects allows Pell reporting identifiers to be presented in the context of their effective award year. The ETRM 12.2.2 dependency metadata records no downstream objects referencing this view; it is a terminal, read-only convenience object in the dependency chain. The ROW_ID column, sourced as ROWID, provides a unique row identifier but is not a persistent key stored in any base table.

Key Columns

  • ROW_ID (ROWID) — row identifier.
  • RCAMPUS_ID (NUMBER) — unique identifier for the record.
  • ALTERNATE_CODE (VARCHAR2 10) — code value for the Award Calendar.
  • START_DT / END_DT (DATE) — effective start and end dates of the award year.
  • CI_CAL_TYPE (VARCHAR2 10) — calendar type of the award calendar instance.
  • CI_SEQUENCE_NUMBER (NUMBER) — unique identifier for the award calendar instance.
  • REPORTING_PELL_CD (VARCHAR2 30) — the Reporting Pell identifier.
  • OPE_CD (VARCHAR2 20) — the OPE ID associated with the Reporting Pell entry; this is the column most frequently targeted by user searches.
  • REP_ENTITY_ID_TXT (VARCHAR2) — indicates the Reporting Entity ID.
  • WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN, provided as standard audit columns.

Common Use Cases and Queries

Typical usage centers on validating or displaying the OPE ID mapping for a Reporting Pell code within a given award year, and on supporting forms that present Pell reporting setup. A basic lookup by OPE code:

SELECT reporting_pell_cd, ope_cd, start_dt, end_dt,
       ci_cal_type, ci_sequence_number
  FROM apps.igf_gr_report_pell_v
 WHERE ope_cd = :p_ope_cd;

Retrieving all Reporting Pell codes effective for the current date:

SELECT reporting_pell_cd, ope_cd, rep_entity_id_txt
  FROM apps.igf_gr_report_pell_v
 WHERE SYSDATE BETWEEN start_dt AND end_dt;

Joining to an award calendar to reconcile Pell mappings by academic year:

SELECT v.reporting_pell_cd, v.ope_cd, v.alternate_code
  FROM apps.igf_gr_report_pell_v v
 WHERE v.ci_cal_type = :cal_type
   AND v.ci_sequence_number = :seq_num;

Because no database object references this view, it serves purely as a read-only reporting surface. Extension or integration work should target the base tables IGF_GR_REPORT_PELL and IGS_CA_INST rather than the view itself, consistent with Oracle's guidance on supplementary view stability.