Search Results igf_aw_fund_mast_all_uk

Overview

The IGF_AW_FUND_MAST_ALL table is a core master data table within the Oracle E-Business Suite's Financial Aid module (IGF). It serves as the central repository for defining and storing the properties and details of every financial aid fund available to an institution. A fund represents a distinct source of money, such as a federal loan, an institutional scholarship, or a private grant, each governed by specific eligibility rules, award amounts, and disbursement parameters. This table's role is critical as it establishes the foundational definitions upon which all award packaging, disbursement, and fund management processes are built. Its multi-org structure, indicated by the "_ALL" suffix and the ORG_ID column, supports implementations across multiple business units.

Key Information Stored

While the provided metadata does not list specific columns beyond key fields, the table's primary and foreign key structure reveals its core data relationships. The unique identifier for each fund record is the FUND_ID (Primary Key). The table enforces a unique constraint (IGF_AW_FUND_MAST_ALL_UK) on the combination of CI_CAL_TYPE (Calendar Type), CI_SEQUENCE_NUMBER (Calendar Sequence), ORG_ID (Operating Unit), and FUND_CODE, ensuring fund definitions are unique within a given academic calendar and organization. Key foreign key columns link this master data to other critical setup entities: FUND_CODE references the fund category (IGF_AW_FUND_CAT_ALL), CI_CAL_TYPE/CI_SEQUENCE_NUMBER tie the fund to an academic calendar instance (IGS_CA_INST_ALL), PARTY_ID can link to a donor or source (HZ_PARTIES), and columns like FM_FC_METHD and SAP_TYPE reference methodology and SAP (Satisfactory Academic Progress) type lookups.

Common Use Cases and Queries

This table is central to numerous financial aid operations. Common use cases include the setup and maintenance of new aid funds, the generation of fund availability reports for administrators, and serving as the source for fund lists during the award packaging process. For reporting and data extraction, typical SQL patterns involve joining to its related setup tables. A fundamental query to list all active funds for a specific academic period and operating unit would be:

SELECT fm.fund_code, fc.description, fm.ci_cal_type, fm.ci_sequence_number
FROM igf_aw_fund_mast_all fm,
igf_aw_fund_cat_all fc
WHERE fm.fund_code = fc.fund_code
AND fm.org_id = fc.org_id
AND fm.ci_cal_type = :p_cal_type
AND fm.ci_sequence_number = :p_sequence_num
AND fm.org_id = :p_org_id
ORDER BY fm.fund_code;

Another critical use case is analyzing fund utilization by joining to the award table (IGF_AW_AWARD_ALL) to compare awarded amounts against fund ceilings or limits defined in the master record.

Related Objects

The IGF_AW_FUND_MAST_ALL table maintains extensive relationships, acting as a hub for financial aid data. It references several setup tables and is referenced by numerous transactional and configuration tables. Key documented relationships include:

• Referenced By (Parent): IGS_CA_INST_ALL (via CI_CAL_TYPE, CI_SEQUENCE_NUMBER), IGF_AW_FUND_CAT_ALL (via FUND_CODE, ORG_ID), HZ_PARTIES (via PARTY_ID), IGF_AP_NEED_MTH_TYP (via FM_FC_METHD), IGF_AP_SAP_TYPES (via SAP_TYPE).
• Referenced In (Child):
  • Core Awards: IGF_AW_AWARD_ALL (FUND_ID) – The primary transactional link to student awards.
  • Fund Configuration: IGF_AW_FUND_EXCL_ALL, IGF_AW_FUND_INCL_ALL, IGF_AW_FUND_TP_ALL, IGF_AW_FUND_PRG_ALL, IGF_AW_FUND_UNIT_ALL, IGF_AW_FUND_TD_MAP_ALL, IGF_AW_FUND_FEECLAS_ALL (all via FUND_ID) – Tables that define fund-specific rules for exclusions, inclusions, types, programs, units, term details, and fee classifications.
  • Packaging & Disbursement: IGF_AW_AWD_FRML_DET_ALL (FUND_ID), IGF_SP_FC_ALL (FUND_ID), IGF_SE_PAYMENT (FUND_ID), IGS_FI_BILL_PLN_CRD (FUND_ID) – Links to packaging formulas, student financial profiles, payments, and billing.
  • Logging & Relationships: IGF_AW_FRLOG_ALL (FUND_ID), IGF_SP_STDNT_REL_ALL (FUND_ID) – Tracks fund-related changes and student relationships.