Search Results tdirr_req_reason_code

Overview

The table IGF_AP_TD_INST_REQRS_ALL is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It functions as a detailed audit and tracking table for student to-do items. Specifically, it stores the reasons why a student's assigned to-do item, or task, is marked as incomplete. This table provides the granular data necessary for financial aid administrators to understand the specific requirements a student has not yet fulfilled, enabling targeted follow-up and ensuring compliance with aid disbursement rules. Its role is integral to the workflow management of financial aid packaging and verification processes in both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is a composite of four columns, reflecting the precise nature of the data it holds. The key columns are BASE_ID, which links to the student's base financial aid record; ITEM_SEQUENCE_NUMBER, identifying the specific to-do item instance; TDIRR_REQ_REASON_FLAG, which likely indicates the type or category of the reason; and TDIRR_REQ_REASON_CODE, which stores the specific reason code for the incomplete status. Together, these fields create a unique record for each reason associated with an incomplete task. The table does not store the to-do item description itself but rather the justification for its incomplete state, linking back to the master task definition via the foreign key relationship.

Common Use Cases and Queries

A primary use case is generating reports for financial aid counselors listing all students with pending items and the specific reasons for the hold. This drives proactive student communication. Another critical use is during the batch packaging process, where the system may check this table to determine if a student is eligible to proceed to the next aid award step. A common analytical query would join this table to the student and item master tables to summarize incomplete reasons by type or student demographic.

Sample Query Pattern:
SELECT s.student_name, ti.item_description, ir.tdirr_req_reason_code
FROM igf_ap_td_inst_reqrs_all ir,
     igf_ap_td_item_inst_all ii,
     igf_ap_td_item_vl ti,
     igf_ap_fa_base_rec_all b
WHERE ir.base_id = ii.base_id
  AND ir.item_sequence_number = ii.item_sequence_number
  AND ii.item_id = ti.item_id
  AND ii.base_id = b.base_id
  AND b.person_id = :student_id;

Related Objects

The table maintains a direct foreign key relationship with the to-do item instance table, IGF_AP_TD_ITEM_INST_ALL. This relationship is defined on two key columns: BASE_ID and ITEM_SEQUENCE_NUMBER. This means every reason record in IGF_AP_TD_INST_REQRS_ALL must correspond to a valid, existing instance record in IGF_AP_TD_ITEM_INST_ALL. The parent table, IGF_AP_TD_ITEM_INST_ALL, stores the core details of the to-do item assigned to the student (e.g., assigned date, status, due date), while IGF_AP_TD_INST_REQRS_ALL provides the supporting detail for incomplete statuses. This table is also indirectly related to the master item definition table (IGF_AP_TD_ITEM_VL) and the student's base financial aid record (IGF_AP_FA_BASE_REC_ALL) through its parent table.