Results for “term_amt”
7 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.
- COAINT_ID — surrogate primary key, enforced by the unique index IGF_AW_LI_COA_INTS_PK; no documented business unique key exists beyond this.
- BATCH_NUM — foreign key to IGF_AP_LI_BAT_INTS, grouping interface rows into a load batch.
- PERSON_NUMBER — the student or applicant identifier associated with the COA record.
- ITEM_CODE and CI_ALTERNATE_CODE — the cost-of-attendance item and its alternate classification code.
- PELL_COA_AMT and ALT_PELL_EXPENSE_AMT — Pell-eligible and alternate expense monetary amounts.
- TERM_AMT — the amount attributed to a specific term.
- FIXED_COST_FLAG — indicates whether the item is treated as a fixed (static) cost.
- LD_ALTERNATE_CODE — alternate lookup/detail code for the line.
- IMPORT_STATUS_TYPE and IMPORT_RECORD_TYPE — control the interface processing state and record classification.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE provide standard EBS concurrency and audit tracking.
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.
-
Interface table for Cost of Attendance Items
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program