Search Results finst_id

Overview

The table IGF_AW_TP_INSTMT_ALL is a core data object within the Oracle E-Business Suite's Financial Aid module (IGF). It serves as a transactional table that stores detailed information linking financial aid fund disbursement terms to specific calendar dates. Its primary role is to manage the temporal scheduling of award disbursements, a critical function for ensuring funds are released to students according to defined academic calendars and term-based plans. The table's design, incorporating foreign keys to calendar and fund term tables, establishes it as a central junction for enforcing business rules related to the timing of financial aid distribution in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its primary and unique keys, which highlight the critical data elements. The surrogate primary key is the column FINST_ID. The business logic, however, is enforced through a unique key constraint that combines several foreign key columns: FUND_ID (identifying the specific financial aid fund), LD_CAL_TYPE and LD_SEQUENCE_NUMBER (defining the load or disbursement calendar term), and TP_CAL_TYPE and TP_SEQUENCE_NUMBER (defining the associated teaching period or academic term). A pivotal column is TP_OFFSET_DA, which stores a date offset or a specific calendar date used to calculate the exact disbursement date within the defined terms, creating the link between fund terms and the institutional calendar.

Common Use Cases and Queries

This table is essential for processes that generate disbursement schedules and validate award timing. Common operational use cases include the batch process that creates anticipated disbursement transactions for a student's award package and the validation of fund availability against an academic calendar. A typical reporting query might join this table to fund and calendar tables to list all scheduled disbursement dates for a specific fund. For example:

• Identifying the disbursement calendar for a fund: SELECT tp_inst.fund_id, tp_inst.tp_offset_da FROM igf_aw_tp_instmt_all tp_inst WHERE tp_inst.fund_id = :p_fund_id;
• Validating term alignment for an award: Queries often join IGF_AW_T_P_INSTMT_ALL to IGS_CA_DA (for dates) and IGF_AW_FUND_TP_ALL to ensure a student's enrollment term matches the fund's disbursement terms.

Related Objects

The table maintains defined relational integrity with other key Financial Aid and Foundation calendar tables, as documented in the provided metadata. The primary relationships are:

• IGF_AW_FUND_TP_ALL: This is a fundamental parent table. The columns FUND_ID, LD_CAL_TYPE, and LD_SEQUENCE_NUMBER in IGF_AW_TP_INSTMT_ALL reference this table, linking each disbursement schedule entry to a specific fund term definition.
• IGS_CA_DA: The column TP_OFFSET_DA is a foreign key to this calendar date table. This relationship anchors the disbursement timing to the institution's official calendar, allowing for precise date calculations and validations.

These relationships position IGF_AW_TP_INSTMT_ALL as a crucial connector between fund definitions (IGF_AW_FUND_TP_ALL) and the institutional calendar (IGS_CA_DA), enabling the automated and rule-based scheduling of financial aid disbursements.