Search Results igf_aw_li_awd_ints_n1

Overview

The IGF.IGF_AW_LI_AWD_INTS table is a critical interface table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Grants and Financial Aid (IGF) module. Its primary role is to serve as the staging area for the "Legacy - Award and Disbursement Data Import Process." This process facilitates the bulk import of complete financial aid award records, including associated disbursement details, from legacy or external systems into the core Oracle Student Financial Planning tables. The table is designed for batch operations, as indicated by the BATCH_NUM column, allowing administrators to group and manage large data migrations efficiently. Its storage in the APPS_TS_INTERFACE tablespace further underscores its transient, interface-specific purpose.

Key Information Stored

The table stores a comprehensive set of attributes necessary to define a financial aid award for import. Key columns include the composite primary key (CI_ALTERNATE_CODE, PERSON_NUMBER, AWARD_NUMBER_TXT), which uniquely identifies an award for a student within an award year. The FUND_CODE specifies the financial aid fund, while OFFERED_AMT and ACCEPTED_AMT hold monetary values. Crucially, the AWARD_STATUS_CODE column, as referenced in the user's search, stores the current status code of the award being imported. The IMPORT_STATUS_TYPE tracks the success or failure of the record's processing, and IMPORT_RECORD_TYPE dictates whether the operation is an Insert or Update. Other notable columns manage batch identification (BATCH_NUM), Pell schedule types (ALT_PELL_SCHEDULE_TYPE), and standard EBS "Who" audit columns.

Common Use Cases and Queries

The primary use case is executing and monitoring the legacy data import process. Administrators populate this table via custom scripts or data loaders, then execute a concurrent program to validate and transfer records into the production award tables. Common SQL queries focus on monitoring batch status and troubleshooting failed records. For example, to check the import status of records for a specific batch and award status, one might use:

• SELECT PERSON_NUMBER, AWARD_NUMBER_TXT, AWARD_STATUS_CODE, IMPORT_STATUS_TYPE FROM IGF.IGF_AW_LI_AWD_INTS WHERE BATCH_NUM = 1001 AND IMPORT_STATUS_TYPE = 'ERROR';
• SELECT COUNT(*), AWARD_STATUS_CODE FROM IGF.IGF_AW_LI_AWD_INTS WHERE BATCH_NUM = 1001 GROUP BY AWARD_STATUS_CODE;

Reporting often involves joining this interface table with the core IGF award tables post-import to verify data integrity and completeness of the migration.

Related Objects

As an interface table, IGF_AW_LI_AWD_INTS is a source for data loaded into core IGF transactional tables, though the provided metadata does not list explicit foreign keys. Its primary key structure suggests a logical relationship with core award master tables on the combination of award year, person identifier, and award number. The table is indexed for performance on its primary key (IGF_AW_LI_AWD_INTS_PK), import status (IGF_AW_LI_AWD_INTS_N1), and batch number (IGF_AW_LI_AWD_INTS_N2). It is directly referenced by the concurrent program that executes the "Legacy - Award and Disbursement Data Import Process," which reads, validates, and transforms records from this staging table into the permanent EBS award structures.