Search Results igf_aw_li_pdb_ints

Overview

IGF_AW_LI_PDB_INTS is a table owned by the IGF schema within the Oracle E-Business Suite Financial Aid (IGF) module. Its documented purpose is to serve as the Pell Disbursement Interface Table for Legacy Data Import. In EBS 12.1.1 and 12.2.2, this table acts as a staging and interface surface through which externally originated Pell Grant disbursement records are loaded into the financial aid processing pipeline. Because Pell disbursement data frequently arrives from Title IV systems, legacy student information systems, or batch files supplied by external processors, the table provides a normalized landing zone where incoming rows are validated, edited, and reconciled before downstream award and disbursement processing occurs.

The ETRM metadata classifies this object, heuristically mined from its foreign key structure, as standalone, meaning it participates in no documented referential integrity constraints and therefore behaves independently of the surrounding schema. From a Data Vault modeling perspective, this classification does not support treating the object as a hub, link, or satellite; instead it is best understood as an interface or staging entity whose business meaning is derived from the composite business key rather than from enforced relationships. Practitioners modeling the IGF subject area should treat it as a source-driven staging construct rather than as a conformed dimension or fact.

Key Information Stored

The table contains 23 documented columns. The following are the most significant for identification, reconciliation, and processing.

• CI_ALTERNATE_CODE — Alternate identifier, typically the student or campus identifier, forming the first component of the composite business key.
• PERSON_NUMBER — The student or person number associated with the disbursement record.
• AWARD_NUMBER_TXT — Textual award number carried from the legacy source system.
• ORIGINATION_ID_TXT — The Title IV origination identifier supplied by the originating system.
• DISBURSEMENT_NUM — Sequence number identifying the individual disbursement within the award.
• DISB_ACK_ACT_FLAG — Acknowledgement action flag indicating the state of the disbursement acknowledgement.
• DISB_STATUS_DATE and ACCPT_DISB_DATE — Status and acceptance dates for the disbursement event.
• DISB_ACCPT_AMT — Accepted disbursement amount, a primary financial measure.
• DISBURSEMENT_SIGN_FLAG — Sign indicator distinguishing positive and negative (adjustment) disbursements.
• DISB_YTD_AMT — Year-to-date disbursement amount used in cumulative reporting.
• PYMT_PRD_START_DATE and ACCPT_PYMT_PRD_START_DATE — Payment period start dates, original and accepted.
• EDIT_CODES_TXT — Edit or validation codes returned during import processing.
• DISBURSE_BATCH_ID_TXT, DISBURSE_BATCH_PROCESS_DATE, DISBURSE_BATCH_ACK_DATE — Batch identity and processing/acknowledgement timestamps linking rows to load runs.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS who-column audit attributes.

The unique index IGF_AW_LI_PDB_INTS_PK, defined over CI_ALTERNATE_CODE, PERSON_NUMBER, AWARD_NUMBER_TXT, ORIGINATION_ID_TXT, and DISBURSEMENT_NUM, is the documented business-key candidate. No separate surrogate key is documented; the composite natural key functions as the primary key.

Common Use Cases and Queries

Typical usage centers on pre-processing validation, error triage, and reconciliation reporting. A common pattern selects rows flagged with edit codes to identify rejected records before they are admitted to award processing:

• Validate inbound rows: SELECT CI_ALTERNATE_CODE, PERSON_NUMBER, AWARD_NUMBER_TXT, DISBURSEMENT_NUM, EDIT_CODES_TXT FROM IGF_AW_LI_PDB_INTS WHERE EDIT_CODES_TXT IS NOT NULL;
• Reconcile accepted amounts by batch: aggregate DISB_ACCPT_AMT grouped by DISBURSE_BATCH_ID_TXT.
• Audit acknowledgement lag: compare DISBURSE_BATCH_PROCESS_DATE against DISBURSE_BATCH_ACK_DATE.
• Year-to-date verification: compare DISB_YTD_AMT against summed DISB_ACCPT_AMT for a person and award.

These queries support financial aid reconciliation, compliance reporting, and correction of legacy import defects.

Related Objects

The metadata documents no foreign keys, and the object is classified as standalone. Consequently, joins to adjacent IGF tables are conventionally performed on shared business attributes rather than enforced constraints:

• Student and person tables joined on PERSON_NUMBER or CI_ALTERNATE_CODE.
• Award tables joined on AWARD_NUMBER_TXT.
• Disbursement tables joined on ORIGINATION_ID_TXT and DISBURSEMENT_NUM.
• ISIR and Title IV import staging tables sharing the CI_ALTERNATE_CODE identifier.
• Concurrent program and batch control tables referenced by DISBURSE_BATCH_ID_TXT.

Administrators should confirm actual join viability against the deployed 12.1.1 or 12.2.2 schema, as the absence of documented constraints permits data orphan conditions.