Search Results agrint_id

Overview

The IGF_AW_LI_AGR_INTS table is a core interface table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Grants and Funds (IGF) module. Its designated role is to serve as the staging area for the "Legacy - Aggregate Award Data Import Process." This process facilitates the bulk upload of historical or external student aggregate award data into the EBS system. The table acts as a temporary holding area where data is loaded, validated, and then processed by a concurrent program to populate the permanent transactional tables. Its storage in the APPS_TS_INTERFACE tablespace and its "Interface table" classification confirm its transient, data-loading purpose within the application architecture.

Key Information Stored

The table stores a record for each student award transaction to be imported. Key transactional columns include PERSON_NUMBER for student identification, CI_ALTERNATE_CODE for the award year, and FUND_CODE for the financial aid fund. The monetary amounts—OFFERED_AMT, ACCEPTED_AMT, and PAID_AMT—form the core financial data. Critical to the import process control are BATCH_NUM, which groups records for a single run, and AGRINT_ID, the primary key that uniquely identifies each interface row. The IMPORT_STATUS_TYPE and IMPORT_RECORD_TYPE columns manage the processing lifecycle, indicating the record's validation status and whether it should update an existing system record (value 'U') or create a new one.

Common Use Cases and Queries

The primary use case is the execution of the legacy data import concurrent program. Administrators load CSV or spreadsheet data into this table, often via custom SQL*Loader scripts or database links, and then run the associated process. Common queries involve monitoring batch status and troubleshooting failed records. A fundamental query to review a specific batch is:

• SELECT person_number, fund_code, offered_amt, import_status_type FROM igf.igf_aw_li_agr_ints WHERE batch_num = &batch_number ORDER BY agrint_id;

To identify records that failed validation for correction and re-submission:

• SELECT * FROM igf.igf_aw_li_agr_ints WHERE import_status_type != 'SUCCESS' AND batch_num = &batch_number;

Reporting use cases typically involve analyzing the staged data before final import or auditing historical loads by joining on the standard WHO columns like CREATED_BY and CREATION_DATE.

Related Objects

The most direct related object is the IGF_AW_LI_AGR_INTS_PK index, which enforces uniqueness on the AGRINT_ID column. This table is the source for the "Legacy - Aggregate Award Data Import Process" concurrent program, which likely references or updates permanent IGF award tables (e.g., IGF_AW_AWARD). While not explicitly listed in the provided metadata, it is architecturally dependent on the FND_CONCURRENT_REQUESTS table (via REQUEST_ID) for concurrent program execution tracking. The PERSON_NUMBER column would typically relate to student identifiers in the PER_ALL_PEOPLE_F table, and FUND_CODE would map to the IGF_AW_FUND_MST table, though these validations occur during the import process itself.