Search Results tdint_id

Overview

The IGF_AP_LI_TODO_INTS table is a core interface table within the Oracle E-Business Suite's Institutional Grants and Financial Aid (IGF) product, specifically for versions 12.1.1 and 12.2.2. It serves as the staging area for the "Legacy - To Do Item Import Process," facilitating the bulk import of student to-do items from external legacy systems into the EBS production tables. As an interface table, its primary role is to hold data temporarily for validation and processing by a concurrent program before the data is transferred to the application's base tables, ensuring data integrity and system performance during high-volume data migrations or integrations.

Key Information Stored

The table stores transactional data related to student application requirements. The TDINT_ID column is the mandatory primary key, uniquely identifying each interface record. Key functional columns include PERSON_NUMBER (student identifier), ITEM_CODE (the specific to-do item), and ITEM_STATUS_CODE (e.g., requested, received). The BATCH_NUM column groups records for processing and links to the batch control table. Critical control columns are IMPORT_STATUS_TYPE, which tracks the success or failure of the import attempt, and IMPORT_RECORD_TYPE, which determines if the record should update an existing system record (value 'U').

Common Use Cases and Queries

The primary use case is the execution of the To Do Item Import concurrent program, which validates and processes records from this interface. Common operational queries involve monitoring batch status and troubleshooting failed imports. For example, to check all pending records for a specific batch: SELECT tdint_id, person_number, item_code, import_status_type FROM igf.igf_ap_li_todo_ints WHERE batch_num = &batch_id AND import_status_type IS NULL;. For reporting on import errors: SELECT tdint_id, person_number, item_code FROM igf.igf_ap_li_todo_ints WHERE import_status_type = 'ERROR';. Analysts may also query to analyze to-do item frequency or status distribution within a batch before final submission.

Related Objects

This table has a direct, documented foreign key relationship to the batch control interface table. The relationship is defined as:

• TABLE: IGF.IGF_AP_LI_BAT_INTS - The BATCH_NUM column in IGF_AP_LI_TODO_INTS references this table, linking all to-do item interface records to their parent import batch for controlled processing.

The table's primary key, IGF_AP_LI_TODO_INTS_PK on the TDINT_ID column, ensures uniqueness. Downstream, after successful import processing, the data is typically moved to base application tables within the IGF schema (e.g., IGF_AP_TD_ITEM_DTLS), though these specific base table dependencies are not detailed in the provided metadata.