Search Results igf_aw_fund_incl_all_pk

Overview

The table IGF_AW_FUND_INCL_ALL is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its primary function is to manage contingent fund relationships, storing the association between a primary financial aid fund and other funds that are prerequisites or contingencies for its disbursement. This table is essential for enforcing complex financial aid packaging rules, ensuring that awards from one fund are only granted if specific conditions related to other funds are met. As a multi-organization-enabled table, indicated by the "_ALL" suffix and the presence of the ORG_ID column, it stores data partitioned by operating unit, supporting a multi-org deployment architecture in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its primary and foreign key columns, which establish the contingent relationships. The primary key is a composite of FUND_ID and FUND_CODE, ensuring a unique link between a specific fund and its contingent fund category. The FUND_ID column references a specific fund master record in IGF_AW_FUND_MAST_ALL, identifying the primary fund in question. The FUND_CODE column references a fund category in IGF_AW_FUND_CAT_ALL, identifying the category of funds that act as a contingency. The ORG_ID column is critical for data isolation, tying each record to a specific operating unit within the EBS instance.

Common Use Cases and Queries

A primary use case is during the automated packaging process, where the system must verify if a student has met all contingent fund requirements before awarding a particular fund. For reporting and administrative review, queries against this table help financial aid officers understand the dependency rules configured in the system. A typical analytical query might join to the fund master and category tables to list all contingencies:

• SELECT m.fund_code AS primary_fund, c.fund_code AS required_fund_category FROM igf_aw_fund_incl_all i, igf_aw_fund_mast_all m, igf_aw_fund_cat_all c WHERE i.fund_id = m.fund_id AND i.fund_code = c.fund_code AND m.org_id = :p_org_id;

Data maintenance involves inserting or deleting records to define or remove contingent relationships between a fund ID and a fund category code, always within the context of a specific ORG_ID.

Related Objects

IGF_AW_FUND_INCL_ALL sits at the intersection of two fundamental Financial Aid tables, as documented by its foreign key relationships:

• IGF_AW_FUND_MAST_ALL: This is the master table for all financial aid funds. The relationship is defined by IGF_AW_FUND_INCL_ALL.FUND_ID referencing IGF_AW_FUND_MAST_ALL. This links a contingent rule to a specific, primary fund.
• IGF_AW_FUND_CAT_ALL: This table stores fund categories. The relationship is defined by IGF_AW_FUND_INCL_ALL.FUND_CODE (and ORG_ID) referencing IGF_AW_FUND_CAT_ALL. This specifies the category of funds that must be awarded as a contingency for the primary fund.

These relationships are enforced by the primary key constraint IGF_AW_FUND_INCL_ALL_PK and the corresponding foreign key constraints, ensuring referential integrity for all contingent fund definitions.