Search Results igf_sp_fund_mast_v




Overview
Explore in AI Chat

Overview

IGF_SP_FUND_MAST_V is a reporting and integration view within the Oracle EBS Financial Aid (IGF) module, which is documented in ETRM as obsolete. Its stated purpose is to store the details and properties of all funds managed by the Financial Aid application. In practice, the view consolidates attribute data from a fund master record together with related fund category, calendar instance, and award lookup information so that callers receive a single denormalized result set describing each fund.

The view has no documented implementation in the reference database ("Not implemented in this database"), and no owner or referenced base objects are recorded in the 12.2.2 metadata. It should therefore be treated as a legacy or dormant object rather than an active data source. Its relevance to the search term "allow_man_pkg" lies in the column ALLOW_MAN_PKG, which it exposes from the fund master. That column indicates whether manual packaging of the fund is permitted, a control that governs whether staff may hand-assign awards to the fund rather than relying on automated packaging logic.

Underlying Base Objects

ETRM documents no base objects for this view, but the embedded view text identifies the sources through its column qualifiers. The primary source is FMAST, the fund master table, which supplies the core fund attributes. A second source, aliased FCAT, supplies fund classification attributes such as FUND_TYPE, FUND_SOURCE, FED_FUND_CODE, and SYS_FUND_TYPE. A calendar instance source, aliased CI and joined through FMAST.CI_CAL_TYPE and FMAST.CI_SEQUENCE_NUMBER, contributes ALTERNATE_CODE, START_DT, and END_DT. An alias ATT provides DESCRIPTION, and CR supplies CREDIT_TYPE_NAME through CREDIT_TYPE_ID. Several columns are derived at runtime through the IGF_AW_GEN.LOOKUP_DESC function rather than being stored values.

Key Columns

Common Use Cases and Queries

A typical use is fund eligibility reporting, listing funds enabling manual packaging alongside their award limits and calendar windows.

SELECT FUND_CODE, DESCRIPTION, ALLOW_MAN_PKG, AUTO_PKG,
       MIN_AWARD_AMT, MAX_AWARD_AMT
FROM   IGF_SP_FUND_MAST_V
WHERE  ALLOW_MAN_PKG = 'Y';

A second scenario reconciles fund classification with calendar validity for a term. Because the object is obsolete, confirm its existence with ALL_VIEWS and validate against the current fund master before relying on results in 12.1.1 or 12.2.2.