Search Results igf_aw_fund_mast




Overview
Explore in AI Chat

Overview

IGF_AW_FUND_MAST is a view owned by the APPS schema within the Financial Aid (IGF) product family of Oracle E-Business Suite, validated in both Release 12.1.1 and 12.2.2. It presents master-level attribute and aggregation data for financial aid funds, exposing the configuration, processing controls, monetary thresholds, and cumulative award totals that define how each fund behaves throughout the award lifecycle. Functionally, the view serves as a reporting and integration surface over the award fund master entity, allowing external reports, concurrent programs, and custom extensions to read fund definitions and balance figures without directly querying the underlying base table.

The view surfaces a wide column set spanning fund identity (FUND_ID, FUND_CODE, DESCRIPTION), calendar context (CI_CAL_TYPE, CI_SEQUENCE_NUMBER), packaging and disbursement controls, need-analysis method fields, and totals such as total offered, accepted, declined, revoked, cancelled, disbursed, and committed amounts. Because the definition includes the ROWID pseudo-column and the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) plus the PROGRAM_* columns, it is usable in both read-only reporting and row-identification contexts.

Underlying Base Objects

The documented ETRM metadata for this view lists no referenced base objects, so the definitive dependency list is not recorded in the supplied excerpt. The view text, however, selects all columns from an aliased source "FMAST." The naming convention and column set — including award-lifecycle totals (TOTAL_OFFERED, TOTAL_ACCEPTED, TOTAL_DISBURSED, COMMITTED_AMT) and configuration flags — indicate the view projects, with no joins or filters, from the award fund master base table (the table conventionally named IGF_AW_FUND_MAST, or its all-table counterpart), exposing essentially a one-to-one column mapping. Two positions in the select list are literal NULLs and thus expose no underlying column. Because it is a simple projection view, all DML against the view inherits the constraints of the base table, and column-level attributes such as datatype and optionality mirror the base object.

Key Columns

Common Use Cases and Queries

Typical uses include validating fund configuration before packaging, reconciling committed versus disbursed balances, and extracting fund master data for downstream reporting or interfaces. A basic lookup of active funds for a given year:

SELECT fund_code, description, available_amt, remaining_amt
FROM apps.igf_aw_fund_mast
WHERE discontinued_fund = 'N'
ORDER BY fund_code;

Aggregate reconciliation of aid totals by fund:

SELECT fund_code, total_offered, total_accepted, total_disbursed, committed_amt
FROM apps.igf_aw_fund_mast
WHERE ci_cal_type = :p_cal_type
AND ci_sequence_number = :p_seq;

Identifying funds with packaging limits:

SELECT fund_code, min_award_amt, max_award_amt, max_yearly_amt, max_life_amt, max_life_term
FROM apps.igf_aw_fund_mast
WHERE min_award_amt IS NOT NULL
OR max_award_amt IS NOT NULL;

Because the view is a thin projection, queries should apply the standard APPS schema qualifier, observe fund expiration logic where relevant, and treat the literal NULL columns as non-reportable placeholders.