Search Results igf_aw_fund_tp_all

Overview

The table IGF_AW_FUND_TP_ALL is a core data object within the Oracle E-Business Suite Financial Aid module (IGF). Its primary function is to define the temporal eligibility of financial aid funds by establishing a link between a fund master record and the academic calendar teaching periods during which that fund can be disbursed and utilized. This table acts as a critical junction, enforcing business rules that restrict fund availability to specific terms within an institution's academic calendar, thereby ensuring accurate award packaging and compliance.

Key Information Stored

The table stores a unique combination of identifiers that define a fund's valid teaching period. Its structure is defined by a composite primary key. The key columns are FUND_ID, which links to the master fund definition in IGF_AW_FUND_MAST_ALL; TP_CAL_TYPE, which specifies the calendar type (e.g., 'TERM', 'SEMESTER'); and TP_SEQUENCE_NUMBER, which identifies the specific instance or sequence of that calendar type. Together, these columns create a record that authorizes a specific fund for use in a specific academic period. The table's design implies a one-to-many relationship, where a single fund master can be associated with multiple valid teaching periods.

Common Use Cases and Queries

This table is central to processes that validate fund availability during award packaging and disbursement. A common operational query involves retrieving all valid teaching periods for a given fund to populate eligibility lists in the user interface. For reporting and audit purposes, administrators often run queries to list funds with their authorized periods or to identify funds that lack any defined teaching period, which may indicate a configuration gap. A typical SQL pattern joins this table to the fund master and calendar tables for a comprehensive view.

• Sample Query: SELECT fund.fund_code, inst.cal_type, inst.sequence_number FROM igf_aw_fund_tp_all tp JOIN igf_aw_fund_mast_all fund ON tp.fund_id = fund.fund_id JOIN igs_ca_inst_all inst ON tp.tp_cal_type = inst.cal_type AND tp.tp_sequence_number = inst.sequence_number WHERE fund.fund_code = '&FUND_CODE';

Related Objects

IGF_AW_FUND_TP_ALL maintains defined foreign key relationships with several key tables in the Financial Aid and Student Systems architecture, as documented in the ETRM metadata.

• Referenced Tables (Outgoing Foreign Keys):
  • IGF_AW_FUND_MAST_ALL: via FUND_ID. This is the master definition table for all financial aid funds.
  • IGS_CA_INST_ALL: via TP_CAL_TYPE and TP_SEQUENCE_NUMBER. This table stores instances of academic calendar types, defining the actual teaching periods.
• Referencing Tables (Incoming Foreign Key):
  • IGF_AW_TP_INSTMT_ALL: via FUND_ID, LD_CAL_TYPE, and LD_SEQUENCE_NUMBER. This table, which stores installment details for teaching periods, references IGF_AW_FUND_TP_ALL to validate that the fund is authorized for the period in question.