Search Results pell_award_amt

Overview

IGF.IGF_AW_LI_PELL_INTS is a public interface table in the Oracle E-Business Suite Financial Aid (IGF) product, owned by the IGF schema and created under the FND Design Data definition IGF.IGF_AW_LI_PELL_INTS. Its documented display name, "Legacy - Pell Origination and Disbursement Data Import Process," describes its function precisely: it is a staging table for importing Pell Grant origination and disbursement records from legacy or external systems, typically prior to transmission to the Common Origination and Disbursement (COD) system. The table resides in the APPS_TS_INTERFACE tablespace, is flagged as VALID and active, and contains 52 columns at the 12.1.1 baseline. Physically it is a flat, wide interface structure with no foreign key dependencies, and the Data Vault classification heuristic therefore suggests treating it as a standalone staging object rather than as a hub, link, or satellite in a modeled warehouse; if it were modeled, the surrogate key would most naturally resolve to a hub on person and award, with the Pell amount and EFC attributes treated as descriptive satellite content.

Key Information Stored

The uniqueness of a row is defined by the primary key index IGF_AW_LI_PELL_INTS_PK, a composite business key over CI_ALTERNATE_CODE, PERSON_NUMBER, AWARD_NUMBER_TXT, and ORIGINATION_ID_TXT. There is no system-generated surrogate column separate from this composite, so the primary key is effectively the business-key candidate as well. Supporting indexes are IGF_AW_LI_PELL_INTS_N1 on IMPORT_STATUS_TYPE and IGF_AW_LI_PELL_INTS_N2 on BATCH_NUM, both non-unique and both reflecting the dominant access paths of an interface table: selecting by processing status and selecting by batch.

The most significant columns include:

• PELL_AWARD_AMT (NUMBER, 12) — the awarded Pell Grant amount, and the column most often targeted by ad hoc queries, including searches such as "pell_award_amt" on this table.
• CI_ALTERNATE_CODE (VARCHAR2, 10) — the calendar instance alternate code, effectively the award year, and the first component of the primary key.
• PERSON_NUMBER (VARCHAR2, 30) — the person number of the financial aid award.
• AWARD_NUMBER_TXT (VARCHAR2, 15) — the unique award number for the student.
• ORIGINATION_ID_TXT (VARCHAR2, 30) — the unique origination identifier.
• BATCH_NUM (NUMBER, 15) — identifies the set of records processed as one batch.
• IMPORT_STATUS_TYPE and IMPORT_RECORD_TYPE — the record's import status and record type, used to drive and audit concurrent processing.
• EFC_AMT, SECONDARY_EFC_AMT, and SECONDARY_EFC_CODE — the Expected Family Contribution values and the code selecting which EFC value determines the award.
• PELL_COA_AMT and FT_SCH_PELL_AMT — the Pell cost of attendance and full-time scheduled Pell award amounts.
• TRANSACTION_NUM_TXT and ORIG_SEND_BATCH_ID_TXT — the SAR transaction number and the origination batch ID sent to COD.
• ORIG_STATUS_CODE, ORIG_STATUS_DATE, and ORIG_REJECT_CODES_TXT — origination status and COD rejection information returned to the institution.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, REQUEST_ID, and the PROGRAM_* columns — standard WHO and concurrent-program audit columns.

Common Use Cases and Queries

The primary use case is bulk loading Pell origination records from a legacy system, then letting the "Legacy - Pell Origination and Disbursement Data Import Process" validate and move those rows into the live IGF award tables. Typical operational queries select unprocessed rows by status or by batch:

• SELECT * FROM igf.igf_aw_li_pell_ints WHERE import_status_type = 'NEW' AND batch_num = :batch;
• SELECT person_number, award_number_txt, pell_award_amt, efc_amt FROM igf.igf_aw_li_pell_ints WHERE ci_alternate_code = :award_year ORDER BY person_number;
• SELECT batch_num, COUNT(*), SUM(pell_award_amt) FROM igf.igf_aw_li_pell_ints GROUP BY batch_num;
• Reconciliation of imported amounts against COD accepted amounts, driven by ORIG_STATUS_CODE and IMPORT_STATUS_TYPE, and exception reporting on empty PERSON_NUMBER or AWARD_NUMBER_TXT values prior to submission.

Related Objects

The documented metadata records no foreign keys, so the table is a dependency-free staging object. The relationships that matter operationally are to the standard IGF award and person entities that the import process reads from and writes to, matched on the same business identifiers held in this table:

• IGF_AW_LI_PELL and the associated Pell disbursement tables — the live award tables populated from interface rows, joined on CI_ALTERNATE_CODE, PERSON_NUMBER, and AWARD_NUMBER_TXT.
• IGF_AP_PELL_ISIR and ISIR-related tables — source of EFC and verification attributes compared during validation.
• PER_ALL_PEOPLE_F — resolved via PERSON_NUMBER to obtain the person and party identifiers required by the downstream award records.
• FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROGRAMS — joined on REQUEST_ID to identify the concurrent program run that loaded or processed a given batch.
• IGF_AW_LI_PELL_INTS paired with COD transmission staging objects, joined on ORIGINATION_ID_TXT and ORIG_SEND_BATCH_ID_TXT to trace records sent to the federal processor.