Search Results igf_aw_li_pell_ints

Overview

IGF_AW_LI_PELL_INTS is a Financial Aid (IGF) interface table in Oracle E-Business Suite Release 12.1.1 and 12.2.2, owned by the IGF schema. Its documented purpose is to hold Pell Origination interface records staged for legacy data import into the EBS Financial Aid module. The table functions as a landing zone for Pell Grant origination data extracted from a prior or external system, prior to validation, mapping, and posting into the native Financial Aid Pell processing tables.

The documented physical schema in ETRM 12.1.1 defines 52 columns and a single primary key constraint, IGF_AW_LI_PELL_INTS_PK, over the composite of CI_ALTERNATE_CODE, PERSON_NUMBER, AWARD_NUMBER_TXT, and ORIGINATION_ID_TXT. The relationship metadata classifies this object as standalone, with no documented foreign key dependencies. Under a heuristic Data Vault classification, this object is best modeled as a satellite candidate: it carries descriptive, import-status, and Pell award attributes keyed by a composite business key rather than representing an independent hub or an associative link between two hubs. Because the object is standalone, no parent hub resolution is documented in the repository, so the classification remains a modeling suggestion rather than a declarative fact.

Key Information Stored

The primary key IGF_AW_LI_PELL_INTS_PK is a composite natural business key rather than a generated surrogate: CI_ALTERNATE_CODE, PERSON_NUMBER, AWARD_NUMBER_TXT, and ORIGINATION_ID_TXT uniquely identify each staged Pell origination record. PERSON_NUMBER is the common integration key to the EBS person model; CI_ALTERNATE_CODE and the two _TXT identifiers link the staged row to the institution's award and origination references.

The most operationally significant columns include:

• BATCH_NUM — groups records into a single legacy import run.
• IMPORT_STATUS_TYPE and IMPORT_RECORD_TYPE — control the import lifecycle state and record category.
• EFC_AMT and SECONDARY_EFC_AMT — the primary and secondary Expected Family Contribution amounts used in Pell award calculation.
• PELL_AWARD_AMT and PELL_COA_AMT — the Pell award and Cost of Attendance amounts attested for the origination.
• ENROLLMENT_STATUS_FLAG and ENROLLMENT_DATE — enrollment data affecting award level.
• ORIGINATION_ID_TXT, ORIG_SEND_BATCH_ID_TXT, TRANSACTION_NUM_TXT — the federal origination identifiers and transaction references.
• ORIG_STATUS_CODE and ORIG_STATUS_DATE — the current origination status and its effective date.
• OPE_CD — the Office of Postsecondary Education institution identifier.
• ORIG_REJECT_CODES_TXT — reject reasons returned for the staged origination.
• PROGRAM_APPLICATION_ID, PROGRAM_ID, REQUEST_ID, and the WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) — standard concurrent program and audit context.

Common Use Cases and Queries

The primary use case is pre-import reconciliation: verifying that count and dollar totals in the legacy extract agree with the staged rows before conversion runs.

• Batch completeness and status reporting: SELECT BATCH_NUM, IMPORT_STATUS_TYPE, COUNT(*) FROM IGF.IGF_AW_LI_PELL_INTS GROUP BY BATCH_NUM, IMPORT_STATUS_TYPE;
• Award level profiling by person: filter on PERSON_NUMBER to trace a single student's staged Pell origination rows and their PELL_AWARD_AMT values.
• Reject analysis: rows where ORIG_REJECT_CODES_TXT is populated indicate origination failures requiring correction before posting.
• Duplicate detection: since the business key is composite, count rows per CI_ALTERNATE_CODE/PERSON_NUMBER/AWARD_NUMBER_TXT/ORIGINATION_ID_TXT combination to identify collisions in the legacy extract.
• Audit and lineage: use REQUEST_ID and PROGRAM_APPLICATION_ID to correlate staged records with the concurrent request that loaded them.

Related Objects

The ETRM metadata classifies IGF_AW_LI_PELL_INTS as standalone, so no foreign key relationships are documented. The following associations are inferred from the business key columns and common Financial Aid integration patterns:

• Pell origination and disbursement tables in the IGF/FA schemas — the ultimate target of the import, joined via the origination and award identifiers.
• Person/student records — joined on PERSON_NUMBER to resolve the student for whom the origination is staged.
• Institution and OPE configuration — matched on OPE_CD to validate the reporting institution.
• Concurrent program request tables — joined on REQUEST_ID and PROGRAM_APPLICATION_ID for load lineage.

Because no explicit foreign keys are declared, developers should validate joins against the target IGF tables in their specific release rather than assuming enforced referential integrity.