Search Results igf_aw_fund_type_all




Overview
Explore in AI Chat

Overview

The IGF_AW_FUND_TYPE_ALL table is a core master data table within the Oracle E-Business Suite's Financial Aid module (IGF). It serves as the system of record for defining and storing all fund types used in the financial aid awarding process. A fund type represents a high-level classification for financial aid funds, such as Grant, Loan, Scholarship, or Work-Study. As a seed data table, its structure is predefined by Oracle, and its initial data set is delivered with the application, though institutions can typically extend it with their own custom values. The table supports multi-organization architecture through the ORG_ID column, allowing a single installation to manage fund types across multiple operating units.

Key Information Stored

The table's primary purpose is to maintain a unique, validated list of fund type codes and their associated descriptions. The key columns include FT_ID, a unique system-generated identifier serving as the primary key. The FUND_TYPE column is a user-defined code (e.g., 'GRANT', 'LOAN') and, combined with ORG_ID, forms a unique constraint (IGF_AW_FUND_TYPE_ALL_UK). This ensures fund type codes are not duplicated within an operating unit. Other typical columns, inferred from standard EBS design, would include ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE for controlling valid values, and standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing. The description of the fund type is stored in a corresponding column, often named DESCRIPTION.

Common Use Cases and Queries

This table is primarily referenced for validation, reporting, and as a source for list of values (LOV) in application forms. Common operational scenarios include validating entries during the setup of fund categories (IGF_AW_FUND_CAT_ALL) and generating reports that categorize awards by fund type. A fundamental query retrieves all active fund types for a specific operating unit:

  • SELECT fund_type, description FROM igf_aw_fund_type_all WHERE org_id = :p_org_id AND enabled_flag = 'Y' AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE) ORDER BY fund_type;

Another critical use case is joining to related transactional data via the fund category table to analyze award distributions: SELECT cat.fund_code, type.description, SUM(a.offered_amt) FROM igf_aw_award_all a, igf_aw_fund_cat_all cat, igf_aw_fund_type_all type WHERE a.fund_id = cat.fund_id AND cat.fund_type = type.fund_type AND cat.org_id = type.org_id GROUP BY cat.fund_code, type.description;

Related Objects

The IGF_AW_FUND_TYPE_ALL table has a direct and essential relationship with the fund category definition table. As documented in the provided metadata:

  • IGF_AW_FUND_CAT_ALL: This table references IGF_AW_FUND_TYPE_ALL via a foreign key constraint. The columns IGF_AW_FUND_CAT_ALL.FUND_TYPE and IGF_AW_FUND_CAT_ALL.ORG_ID reference the FUND_TYPE and ORG_ID columns in IGF_AW_FUND_TYPE_ALL. This enforces that every fund category must be associated with a valid, pre-defined fund type within the same operating unit.

Given its role as seed data, it is also commonly referenced by various Financial Aid forms, concurrent programs, and APIs responsible for managing the fund setup and awarding lifecycle.