Search Results disburse_batch_ack_date




Overview
Explore in AI Chat

Overview

The table IGF.IGF_AW_LI_PDB_INTS is the Pell Disbursement Interface Table for Legacy Data Import within the Oracle E-Business Suite Financial Aid module (IGF). It resides in the IGF schema and is classified in the metadata with a status of VALID and a lifecycle of active. Its functional scope is tagged as public, and it belongs to the BUSINESS_ENTITY IGF_PELL, supporting the display name "Legacy - Pell Origination and Disbursement Data Import Process." The table serves as a staging and interface object that ingests legacy Pell origination and disbursement records from external or prior systems, allowing them to be validated, edited, and ultimately promoted into the live Pell processing tables used by the institution.

The documented physical schema places the object in the APPS_TS_INTERFACE tablespace with a PCT Free of 10, consistent with its role as an interface rather than a transactional master. From a Data Vault modeling perspective, the metadata heuristic classifies this object as a standalone entity, described as a modeling suggestion rather than a strict architectural mandate. Because its business key is composed of award-level attributes and it carries descriptive disbursement attributes (dates, amounts, flags, error codes), it behaves closest to a satellite-style record keyed by the composite primary key, with no documented foreign key dependencies to hub or link tables in the provided relationship data.

The table is available in both Oracle EBS 12.1.1 and 12.2.2, and its 23 documented columns are oriented toward import, acknowledgement, and reconciliation of disbursement activity.

Key Information Stored

The primary key, implemented as the unique index IGF_AW_LI_PDB_INTS_PK, is the composite business key of CI_ALTERNATE_CODE, PERSON_NUMBER, AWARD_NUMBER_TXT, ORIGINATION_ID_TXT, and DISBURSEMENT_NUM. These five columns together uniquely identify a legacy disbursement record and act as the unique-index business-key candidates. The most significant columns include:

  • CI_ALTERNATE_CODE — Calendar Instance Alternate Code (Award Year) of the Financial Aid Award, part of the primary key.
  • PERSON_NUMBER — Person number of the financial aid award recipient.
  • AWARD_NUMBER_TXT — Unique award number for the student in context.
  • ORIGINATION_ID_TXT — Unique number used to identify the origination.
  • DISBURSEMENT_NUM — Number of the disbursement.
  • DISB_ACK_ACT_FLAG — Code indicating the processing status of the disbursement.
  • DISB_STATUS_DATE — Date on which the disbursement status changed.
  • DISB_ACCPT_AMT and DISBURSEMENT_SIGN_FLAG — Accepted disbursement amount and its positive or negative sign.
  • DISBURSE_BATCH_ID_TXT, DISBURSE_BATCH_PROCESS_DATE, and DISBURSE_BATCH_ACK_DATE — Batch identifier sent to COD, its process date, and its acknowledgement date. DISBURSE_BATCH_ACK_DATE is the field most directly associated with the user's search and records when COD acknowledged the disbursement batch.
  • EDIT_CODES_TXT — Error codes returned from the COD government system.
  • ED_USE_FLAGS — Usage flags supporting the interface process.

Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) complete the 23-column structure.

Common Use Cases and Queries

Typical use cases center on loading legacy Pell disbursement data, reconciling COD batch acknowledgement, and auditing rejected records via edit codes. A representative query identifies disbursements acknowledged by COD within a date range:

  • SELECT person_number, award_number_txt, disbursement_num, disburse_batch_id_txt, disburse_batch_ack_date FROM igf.igf_aw_li_pdb_ints WHERE disburse_batch_ack_date BETWEEN :from_date AND :to_date;
  • A rejection report selects rows carrying edit codes: SELECT * FROM igf.igf_aw_li_pdb_ints WHERE edit_codes_txt IS NOT NULL ORDER BY disb_status_date DESC;
  • Batch reconciliation joins the batch identifier and acknowledgement date to confirm which batches have and have not been acknowledged: WHERE disburse_batch_ack_date IS NULL AND disburse_batch_process_date IS NOT NULL;
  • Amount validation compares DISB_ACCPT_AMT against DISB_YTD_AMT to verify year-to-date disbursement totals.

Related Objects

Because the metadata classifies this table as standalone with no documented foreign keys, relationships are primarily functional rather than enforced by physical constraints. The following objects are the most significant consumers or counterparts of this interface data:

  • IGF_AW_LI_PDB_INTS_PK — the unique index that enforces the composite business key.
  • The legacy import concurrent program "Legacy - Pell Origination and Disbursement Data Import Process," which reads these rows to populate live Pell disbursement records.
  • Live Pell disbursement and origination tables in the IGF schema, joined on PERSON_NUMBER, AWARD_NUMBER_TXT, ORIGINATION_ID_TXT, and DISBURSEMENT_NUM.
  • COD batch reconciliation interfaces, joined via DISBURSE_BATCH_ID_TXT for processing and acknowledgement date comparison.
  • Error-handling and edit-code reporting views, which surface EDIT_CODES_TXT to users for correction.