Search Results igf_gr_pell_setup_all




Overview
Explore in AI Chat

Overview

IGF_GR_PELL_SETUP_ALL is a configuration table in the Oracle E-Business Suite product family IGF — Financial Aid, which is documented as obsolete in the Oracle EBS 12.1.1 / 12.2.2 reference set. The entity stores the Federal Pell grant setup details that drive institutional-level Pell processing rules — including payment methodology, enrollment date selection, course-load determination, and expected family contribution (EFC) ceilings. In the documented 12.1.1 schema, the table is owned by IGF and contains 35 columns.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is link. This is consistent with a configuration record that associates multiple reference entities: a program version (IGS_PS_VER_ALL), a calendar instance (IGS_CA_INST_ALL), an operating unit (ORG_ID), and a Pell profile. Practically, the table behaves as a setup/satellite-style master record in the operational model, but the FK topology suggests it is best represented as a link joining those referenced hubs.

Key Information Stored

The surrogate primary key is IGF_GR_PELL_SETUP_ALL_PK, defined on PELL_SEQ_ID. Two business-key candidates are documented through unique indexes: IGF_GR_PELL_SETUP_ALL_U1 on PELL_SEQ_ID, and IGF_GR_PELL_SETUP_ALL_U2 on the composite of CI_CAL_TYPE, CI_SEQUENCE_NUMBER, REP_PELL_ID, COURSE_CD, VERSION_NUMBER, and REP_ENTITY_ID_TXT. The ETRM excerpt additionally lists IGF_GR_PELL_SETUP_ALL_UK1 (CI_CAL_TYPE, CI_SEQUENCE_NUMBER, REP_PELL_ID) and IGF_GR_PELL_SETUP_ALL_UK2 (CI_CAL_TYPE, CI_SEQUENCE_NUMBER).

The most significant columns include:

Common Use Cases and Queries

Typical uses include auditing Pell setup per award year, validating that each Pell profile has a single active configuration per calendar instance, and extracting parameters used in disbursement calculations. A representative query joining to the calendar instance is:

  • SELECT p.PELL_SEQ_ID, p.CI_CAL_TYPE, p.CI_SEQUENCE_NUMBER, p.REP_PELL_ID, p.PELL_PROFILE, p.ORG_ID FROM IGF_GR_PELL_SETUP_ALL p WHERE p.CI_CAL_TYPE = :cal_type AND p.CI_SEQUENCE_NUMBER = :seq;
  • Program-version lookup: join COURSE_CD and VERSION_NUMBER to IGS_PS_VER_ALL to resolve the program title attached to a Pell setup.
  • Duplicate detection against unique index U2 to identify conflicting setup rows for the same calendar, Pell ID, program, and entity.
  • Extract payment and funding rules (FUNDING_METHOD, PAYMENT_METHOD, PAYMENT_PERIODS_NUM) for reconciliation and reporting.

Related Objects

The table participates in documented foreign-key relationships with the following objects:

  • IGS_PS_VER_ALL — via COURSE_CD and VERSION_NUMBER; provides the program version referenced by the Pell setup.
  • IGS_CA_INST_ALL — via CI_CAL_TYPE and CI_SEQUENCE_NUMBER; supplies the calendar instance (term) context.
  • IGF_GR_PELL_SETUP_ALL — the PELL_PROFILE column references a Pell profile object (relationship documented as self-referencing in the metadata excerpt).
  • Operating unit / organization entities referenced through ORG_ID for multi-org security.

Because the product is marked obsolete and the object is not implemented in the reference database, integration is effectively read-only for historical reporting; no public PL/SQL API is documented in the ETRM metadata for this table.