Search Results igf_gr_pell_setup_all_pk

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:

• PELL_SEQ_ID — surrogate primary key identifying the setup record.
• CI_CAL_TYPE and CI_SEQUENCE_NUMBER — the calendar instance (term/award year) to which the setup applies; FK to IGS_CA_INST_ALL.
• REP_PELL_ID — the Pell reporting identifier used in business-key unique constraints.
• PELL_PROFILE — the Pell profile definition referenced by the setup.
• COURSE_CD and VERSION_NUMBER — the program version; FK to IGS_PS_VER_ALL.
• ORG_ID — the operating unit that owns the configuration.
• FUNDING_METHOD and PAYMENT_METHOD — controls for how Pell funds are calculated and disbursed.
• USE_CENSUS_DTS — flag governing whether census dates drive enrollment measurement.
• ACADEMIC_CAL and WK_INST_TIME_CALC_PYMT — academic calendar and weekly instructional-time calculation used in payment.
• CR_CLK_HRS_PRDS_SCH_YR and CR_CLK_HRS_ACAD_YR — credit/clock-hour thresholds per scheduled and academic year.
• EFC_MAX and PELL_ALT_EXP_MAX — EFC and alternate-expectation ceilings.
• ENR_BEFORE_TS_CODE, ENR_IN_MT_CODE, ENR_AFTER_TC_CODE — enrollment status codes before, during, and after the term.
• TERM_START_OFFSET_NUM — offset used to derive the effective term start.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

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.