Results for “rcampus_id”

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

Overview

IGF_GR_ATTEND_PELL_V is a reporting view within the Oracle E-Business Suite IGF (Financial Aid) product family. It exposes the set of Attending Pell identifiers associated with a reporting Pell record, joining the attendance detail table IGF_GR_ATTEND_PELL to the calendar instance table IGS_CA_INST so that each attendance row carries its valid calendar context (alternate code and start/end dates). In ETRM 12.1.1 and 12.2.2, IGF is classified as Obsolete, meaning the module is no longer implemented in the current database and the view text is documented for reference only. Despite this status, the view remains a useful reference artifact for institutions that historically extracted Pell attendance data, and it continues to illustrate the join pattern between financial aid attendance records and the institution's academic calendar instances.

Underlying Base Objects

The view text shows two referenced base objects:

• IGF_GR_ATTEND_PELL AP — the driving table holding the attending Pell detail, including campus, calendar instance, Pell code, OPE code, and audit columns.
• IGS_CA_INST CI — the calendar instance table, providing ALTERNATE_CODE, START_DT, and END_DT for the referenced calendar type and sequence number.

The join condition is AP.CI_CAL_TYPE = CI.CAL_TYPE AND AP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER, a standard calendar-instance resolution pattern used throughout Oracle Student System–based products. The documented ETRM metadata lists no additional referenced base objects; the view is a straightforward two-table equijoin with ROWID exposed as ROW_ID.

Key Columns

• ROW_ID — the ROWID of the IGF_GR_ATTEND_PELL row, useful for identifying or updating the underlying attendance record.
• ACAMPUS_ID / RCAMPUS_ID — the aid campus and reporting campus identifiers. The user's search term rcampus_id maps directly to RCAMPUS_ID, the reporting campus key used to segment Pell reporting by reporting campus.
• ALTERNATE_CODE, START_DT, END_DT — calendar instance attributes retrieved from IGS_CA_INST, identifying the term or reporting period and its validity dates.
• CI_CAL_TYPE / CI_SEQUENCE_NUMBER — the composite key linking the attendance row to its calendar instance.
• ATTENDING_PELL_CD — the attending Pell code, the core identifier this view is designed to surface.
• OPE_CD — the Office of Postsecondary Education (OPE) identification code for the institution.
• ATD_ENTITY_ID_TXT — the attendance entity identifier stored as text, typically a student or entity reference.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle audit columns.

Common Use Cases and Queries

Typical usage centers on reporting Pell attendance by reporting campus and calendar instance, or reconciling attendance identifiers against OPE codes. A representative query filtered on the user's search term would be:

• SELECT rcampus_id, alternate_code, start_dt, end_dt, attending_pell_cd, ope_cd FROM igf_gr_attend_pell_v WHERE rcampus_id = :p_rcampus_id ORDER BY start_dt;

To scope attendance to a reporting period, filter on the calendar instance columns:

• SELECT atd_entity_id_txt, attending_pell_cd, ope_cd FROM igf_gr_attend_pell_v WHERE ci_cal_type = :p_cal_type AND ci_sequence_number = :p_seq AND trunc(start_dt) >= :p_from_date;

Because IGF is documented as Obsolete and "Not implemented in this database" in the ETRM metadata, these queries should be treated as reference patterns rather than runnable assets in a current 12.1.1 or 12.2.2 instance. Where the view is absent, equivalent data must be sourced directly from IGF_GR_ATTEND_PELL joined to IGS_CA_INST using the same keys.