Results for “pell_coa_amt”

9 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGF_AW_LI_COA_INTS table is an interface (staging) table used by the Oracle Financial Aid module (IGF) within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to hold Cost of Attendance (COA) items as they are loaded from external sources before validation and transfer into the core financial aid award and need-analysis structures. In the ETRM 12.1.1 documentation this table is explicitly flagged as obsolete and is reported as "Not implemented in this database," meaning it exists primarily as a legacy artifact for historical financial aid processing rather than as an actively maintained object in current EBS installations.

From a modeling perspective, the mined FK structure classifies this object as satellite-leaning. Its primary key (COAINT_ID) is a surrogate identifier, and the grain is one row per interface line item rather than a true association between two business entities. This classification is a heuristic suggestion derived from the foreign-key topology, not a formal Data Vault designation declared by Oracle.

Key Information Stored

The documented schema contains 21 columns. The most significant are summarized below.

Common Use Cases and Queries

Because the table is obsolete, typical usage is diagnostic or archival: verifying whether stale COA interface rows remain in a legacy instance, reconciling batch loads, and reconstructing financial aid need analysis for audit purposes. A representative query groups interface rows by batch and status:

  • SELECT batch_num, import_status_type, COUNT(*) FROM igf_aw_li_coa_ints GROUP BY batch_num, import_status_type; — summarizes load volumes and processing states per batch.
  • SELECT person_number, item_code, pell_coa_amt, term_amt FROM igf_aw_li_coa_ints WHERE batch_num = :p_batch; — extracts cost items for a specific batch.
  • SELECT i.* FROM igf_aw_li_coa_ints i, igf_ap_li_bat_ints b WHERE i.batch_num = b.batch_num; — joins interface lines to their parent batch headers for reconciliation.

Reporting generally targets validation of imported amounts against expected COA totals and confirmation that all lines reached a terminal import status.

Related Objects

The dominant relationship is the foreign key from IGF_AW_LI_COA_INTS.BATCH_NUM to IGF_AP_LI_BAT_INTS. This parent batch table governs the loading of interface lines and is the primary join partner for any reconciliation query. The table's primary key (COAINT_ID) is referenced by the IGF_AW_LI_COA_INTS_PK unique index, which guarantees surrogate uniqueness. Downstream consumers within the Financial Aid module — such as need-analysis and award-processing logic — traditionally consume these staged COA rows after import, though the object's obsolete status means such dependencies are confined largely to historical environments.