Search Results igf_gr_pell_setup_all_u1




Overview
Explore in AI Chat

Overview

The IGF.IGF_GR_PELL_SETUP_ALL table stores the Federal Pell grant setup details used by Oracle E-Business Suite's Student Financial Aid module. It is owned by the IGF schema and is registered under FND Design Data as IGF.IGF_GR_PELL_SETUP_ALL with a status of VALID in both EBS 12.1.1 and 12.2.2. The entity captures the institution-level configuration that governs how Pell grant awards are calculated, funded, and reported to the federal government, including award-year calendar context, funding method, and payment formula assignments.

The table is stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. The physical schema documented for release 12.1.1 comprises 35 columns. Heuristic Data Vault classification mined from the foreign key structure suggests this object models as a link, bridging the Pell setup record to academic calendar instances and course version definitions. Its primary key is defined by constraint IGF_GR_PELL_SETUP_ALL_PK on PELL_SEQ_ID.

Key Information Stored

The surrogate primary key is PELL_SEQ_ID (NUMBER(15)), a system-generated identifier for each Pell grant setup record. Two unique indexes supply business-key candidates. IGF_GR_PELL_SETUP_ALL_U1 enforces uniqueness on PELL_SEQ_ID alone, mirroring the primary key. IGF_GR_PELL_SETUP_ALL_U2 — the index the user searched for — is the substantive composite business key, spanning CI_CAL_TYPE, CI_SEQUENCE_NUMBER, REP_PELL_ID, COURSE_CD, VERSION_NUMBER, and REP_ENTITY_ID_TXT.

The most operationally significant columns include:

  • CI_CAL_TYPE — code for the award-year calendar type, scoped within the operating unit.
  • CI_SEQUENCE_NUMBER — unique identifier for the award-year calendar instance.
  • REP_PELL_ID — reporting Pell identifier, parent to a record in the reporting Pell setup entity.
  • COURSE_CD and VERSION_NUMBER — reference the program version definition to which the setup applies.
  • REP_ENTITY_ID_TXT — external entity identifier used in federal reporting.
  • FUNDING_METHOD — designates advance or just-in-time funding; advance permits reporting disbursements up to 30 days before payment, just-in-time up to 5 days before.
  • PAYMENT_METHOD — the formula code used to compute a student's Pell award.
  • ACADEMIC_CAL — the calendar code applying to the student's educational program.
  • ORG_ID — the operating unit that owns the setup record.
  • EFC_MAX and PELL_ALT_EXP_MAX — threshold values governing award eligibility.
  • PAYMENT_PERIODS_NUM, ENR_BEFORE_TS_CODE, ENR_IN_MT_CODE, ENR_AFTER_TC_CODE — enrollment and payment-period parameters.
  • Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Several columns are documented as obsolete, including PELL_PROFILE, BRANCH_CAMPUS, ATTEND_CAMPUS_ID, USE_CENSUS_DTS, and LOW_TUTION_FEE. These should not be used in new development or reporting.

Common Use Cases and Queries

Typical usage covers award calculation configuration, federal reporting extracts, and multi-operating-unit setup validation. A common retrieval pattern selects setup rows for a specific award year and course version:

  • Querying setup by business key: SELECT * FROM IGF.IGF_GR_PELL_SETUP_ALL WHERE CI_CAL_TYPE = :cal_type AND CI_SEQUENCE_NUMBER = :seq AND ORG_ID = :org_id;
  • Joining to academic calendar instances through the documented foreign key CI_CAL_TYPE → IGS_CA_INST_ALL to validate the award-year instance.
  • Joining COURSE_CD to IGS_PS_VER_ALL to resolve program version descriptions for reporting.
  • Reporting on funding and payment method distributions by operating unit using FUNDING_METHOD and PAYMENT_METHOD.

Because the composite unique index IGF_GR_PELL_SETUP_ALL_U2 spans calendar type, calendar sequence, reporting Pell identifier, course, version, and reporting entity, it is the recommended predicate set for efficient single-row lookups and for detecting duplicate or conflicting setup definitions during data conversion.

Related Objects

  • IGS_CA_INST_ALL — referenced from IGF_GR_PELL_SETUP_ALL.CI_CAL_TYPE; supplies academic calendar instance data.
  • IGS_PS_VER_ALL — referenced from COURSE_CD; provides program version definitions.
  • The reporting Pell setup entity referenced by REP_PELL_ID; acts as the parent of the reporting Pell identifier.
  • The profile entity referenced through PELL_PROFILE; documented as obsolete in current releases.
  • IGF_GR_PELL_SETUP_ALL itself, with child/audit relationships implied by the PELL_SEQ_ID primary key.

Writers should note that the COURSE_CD and CI_CAL_TYPE foreign keys are the strongest structural anchors, reinforcing the link classification suggested by the Data Vault heuristic.