Search Results pell_coa_amt

Overview

The IGF_AW_LI_COA_INTS table is a critical interface table within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its designated role is to serve as the staging area for importing Cost of Attendance (COA) item details from external legacy systems into the core EBS tables. As indicated by its display name, "Legacy - Cost of Attendance Item Import Process," it facilitates data migration and integration. The table's lifecycle status is active, and it is stored in the APPS_TS_INTERFACE tablespace, which is standard for transient data used in import processes. Its primary function is to hold raw import data, which is subsequently validated and processed by a dedicated concurrent program before being transferred to the permanent application tables.

Key Information Stored

The table's structure is designed to capture all necessary data for a student's COA items. The COAINT_ID column is the mandatory primary key, uniquely identifying each interface record. Key transactional columns include BATCH_NUM for grouping records, PERSON_NUMBER for student identification, and ITEM_CODE for the specific COA component. Financial amounts are stored in PELL_COA_AMT and ALT_PELL_EXPENSE_AMT. The table also holds control flags critical for processing: IMPORT_STATUS_TYPE tracks the success or failure of the import, and IMPORT_RECORD_TYPE determines if an existing system record should be updated ('U') or not. The table includes standard EBS "Who" columns (CREATED_BY, CREATION_DATE, etc.) for auditing and the REQUEST_ID group for concurrent program tracking.

Common Use Cases and Queries

The primary use case is the execution of the "Legacy - Cost of Attendance Item Import Process" concurrent program. This program selects records from this interface table, validates them against application rules, and posts valid data to the target tables. Common operational queries involve monitoring the import status and troubleshooting failures. For example, to identify records from a specific batch that failed to import, one might use:

• SELECT coaint_id, person_number, item_code, import_status_type FROM igf.igf_aw_li_coa_ints WHERE batch_num = &batch_id AND import_status_type != 'SUCCESS';

Another typical query is to examine all pending records for a student before initiating the import process:

• SELECT * FROM igf.igf_aw_li_coa_ints WHERE person_number = 'STUDENT_123' AND import_status_type IS NULL ORDER BY item_code;

Administrators often query the table to purge successfully processed records to manage tablespace usage, typically retaining records based on CREATION_DATE.

Related Objects

The IGF_AW_LI_COA_INTS table is central to a specific data flow. It is directly referenced by the IGF_AW_LI_COA_INTS_PK index on the COAINT_ID column, which enforces uniqueness. Its data is processed by and feeds into the core Cost of Attendance business entities within the IGF module, as indicated by its category, BUSINESS_ENTITY IGF_COA. While the exact target table is not specified in the provided metadata, this interface table logically relates to permanent tables storing validated COA item details, likely with names such as IGF_AW_COA_ITEMS or similar. The import process that consumes this table's data is the key dependent program, and its operation is tracked via the REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID columns.