Search Results igf_gr_attend_pell_pk

Overview

IGF.IGF_GR_ATTEND_PELL is a Financial Aid module table within Oracle E-Business Suite (12.1.1 and 12.2.2) that stores the Attending Pell Identifiers associated with a reporting organization. In the context of Pell Grant processing, the table captures which campus (award campus or reporting campus) is responsible for reporting a student's Pell attendance data. It serves as a bridge between the reported Pell records and the campus-level configuration used during disbursement and reporting cycles.

From a data modeling perspective, the metadata classifies this object heuristically as standalone. No parent or child link table relationships are documented beyond a single internal foreign key. Under a Data Vault style interpretation, this would best be modeled as a link entity, since it associates two campus identifiers—ACAMPUS_ID and RCAMPUS_ID—with temporal and descriptive attributes. The classification is a modeling suggestion only; the physical schema reflects a conventional normalized EBS table.

Key Information Stored

The primary key is defined by the unique index IGF_GR_ATTEND_PELL_PK, whose column is ACAMPUS_ID. This functions as the surrogate identifier for each attending-Pell record. The table contains 12 documented columns, of which the most significant are:

• ACAMPUS_ID — the sole primary key column, identifying the attending campus record.
• RCAMPUS_ID — the reporting campus identifier; it is the foreign key referencing IGF_GR_REPORT_PELL.
• CI_CAL_TYPE — the calendar type associated with the reporting or attendance cycle.
• CI_SEQUENCE_NUMBER — the sequence within that calendar type, jointly qualifying the academic period.
• ATTENDING_PELL_CD — the code denoting the attending Pell classification used in reporting.
• OPE_CD — the Office of Postsecondary Education (OPE) identifier for the institution.
• ATD_ENTITY_ID_TXT — the textual attending entity identifier, typically the campus or entity key supplied to federal reporting.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — the standard EBS who-columns for row-level traceability.

Only ACAMPUS_ID is documented as a unique-index business-key candidate; the remaining columns are descriptive or referential.

Common Use Cases and Queries

Reporting and reconciliation are the principal uses. Financial Aid administrators query this table to verify which attending Pell identifier is tied to a given reporting campus before transmitting data to the Department of Education. A typical retrieval joins the reporting campus to its parent table:

• Listing attending Pell identifiers for a reporting campus: SELECT a.ACAMPUS_ID, a.ATTENDING_PELL_CD, a.OPE_CD, a.ATD_ENTITY_ID_TXT FROM IGF.IGF_GR_ATTEND_PELL a WHERE a.RCAMPUS_ID = :rcampus_id;
• Period-scoped reporting by calendar: filter on CI_CAL_TYPE and CI_SEQUENCE_NUMBER to isolate a specific award year or term.
• OPE code validation: grouping records by OPE_CD to confirm that each reporting campus carries the correct federal institution code.
• Audit and change tracking: querying the who-columns to determine when an attending Pell mapping was created or last modified.

Because the table is standalone, no cascading joins or child dependencies constrain these queries, which simplifies ad-hoc extraction and ETL loading into a data warehouse.

Related Objects

The documented foreign key relationship ties this table to the reporting Pell configuration. The significant related objects include:

• IGF_GR_REPORT_PELL — referenced through IGF_GR_ATTEND_PELL.RCAMPUS_ID; the parent defining reporting campus Pell data.
• IGF_GR_ATTEND_PELL_PK — the unique index enforcing identity on ACAMPUS_ID.
• Standard EBS audit and lookup infrastructure (FND user and calendar tables) consulted indirectly through the who-columns and CI_CAL_TYPE.
• Financial Aid reporting interfaces and concurrent programs that consume attending Pell identifiers during federal output generation.

These objects collectively support the campus-level Pell configuration that underpins Financial Aid reporting in Oracle EBS.