Search Results igf_ap_td_item_inst_all




Overview
Explore in AI Chat

Overview

The table IGF_AP_TD_ITEM_INST_ALL is a core data repository within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It functions as the central table for storing item instance information, which represents the specific, individualized occurrences of financial aid items (such as loans, grants, or scholarships) awarded to a student. Its role is critical in the administration and tracking of a student's complete financial aid package, linking the definition of an aid item type to a specific student's record and capturing the unique details of that particular award instance. The table is designed as a multi-org structure, as indicated by the "_ALL" suffix, meaning it stores data for multiple operating units within a single installation.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships. The primary key is a composite of BASE_ID and ITEM_SEQUENCE_NUMBER. The BASE_ID column links the item instance to a specific student's base financial aid record in the IGF_AP_FA_BASE_REC_ALL table, uniquely identifying the applicant. The ITEM_SEQUENCE_NUMBER serves a dual purpose: it is part of the primary key for this table and also acts as a foreign key to both the IGF_AP_TD_ITEM_MST_ALL and IGF_AP_TD_ITEM_TYPE_ALL tables. This relationship ties the instance to the master definition and the type classification of the financial aid item. A significant foreign key is CLPRL_ID, which references the IGF_SL_CL_PREF_LENDERS table. This column is pivotal for student loan processing, as it stores the identifier for the preferred lender selected for a specific loan item instance, connecting aid packaging with the lender management system.

Common Use Cases and Queries

This table is central to numerous financial aid operations. Common use cases include generating a student's award letter by retrieving all item instances for a given BASE_ID, tracking the disbursement status of specific awards, and reporting on the distribution of different aid types (e.g., loans vs. grants) across the student population. For system integrations, such as with the U.S. Department of Education's Common Origination and Disbursement (COD) system, data from this table is often sourced to report actual awards. A typical query pattern involves joining to related tables to get a comprehensive view of a student's aid package:

  • Joining with IGF_AP_FA_BASE_REC_ALL to get student identifiers.
  • Joining with IGF_AP_TD_ITEM_TYPE_ALL to get the descriptive name and category of the aid item.
  • Joining with IGF_SL_CL_PREF_LENDERS when reporting on student loan details to include lender information.

Sample SQL to list all item instances for a student would filter on BASE_ID and join to the item type table for descriptions.

Related Objects

The table exists within a tightly integrated schema. Its documented relationships, as per the provided ETRM metadata, are as follows:

  • Primary Key Dependency: The table is uniquely identified by the IGF_AP_TD_ITEM_INST_ALL_PK constraint on (BASE_ID, ITEM_SEQUENCE_NUMBER).
  • Foreign Key References (Outgoing):
    • BASE_ID references IGF_AP_FA_BASE_REC_ALL (Links to the student's base financial aid record).
    • CLPRL_ID references IGF_SL_CL_PREF_LENDERS (Links to the preferred lender for a loan).
    • ITEM_SEQUENCE_NUMBER references IGF_AP_TD_ITEM_MST_ALL (Links to the item master).
    • ITEM_SEQUENCE_NUMBER references IGF_AP_TD_ITEM_TYPE_ALL (Links to the item type definition).
  • Foreign Key References (Incoming):
    • The table IGF_AP_TD_INST_REQRS_ALL references IGF_AP_TD_ITEM_INST_ALL via its columns (BASE_ID, ITEM_SEQUENCE_NUMBER). This table likely stores specific requirements or conditions tied to each item instance.