Search Results min_award_amt




Overview
Explore in AI Chat

Overview

IGF_AW_FSEOG_MATCH_V is a reporting view in the Oracle E-Business Suite Financial Aid (IGF) module, historically used in releases spanning 12.1.1 and 12.2.2. It exposes the relationship between matching funds and their associated match order for specific award years, drawing on records from the Federal Supplemental Educational Opportunity Grant (FSEOG) matching process. The view surfaces the fund identifier, fund code, description, and a numeric match order, along with calendar type and sequence information that tie the match to a specific award year cycle.

In the context of a search for match_order, this view is the primary retrieval point for the sequence in which matching funds are applied or prioritized. The documentation notes that the entity is "used to retrieve the Matching Fund and its Match Order for the specific Award Years." Notably, the ETRM metadata records the underlying product as IGF - Financial Aid (Obsolete), and states "Not implemented in this database," indicating the view may not exist in every environment and is retained largely for legacy reference. Its role is confined to read-only reporting rather than transactional processing.

Underlying Base Objects

The view is defined over three base tables, joined as follows:

  • IGF_AW_FUND_MAST (FMAST) — the fund master, supplying fund code, description, and minimum/maximum award amounts.
  • IGF_AW_FSEOG_MATCH (FMAT) — the FSEOG match table, supplying match order and calendar type/sequence.
  • IGF_AW_FUND_CAT (FCAT) — the fund category table, used to filter out sponsored funds.

The join predicate links FMAST.FUND_ID to FMAT.FUND_ID and FMAST.FUND_CODE to FCAT.FUND_CODE, with the filter FCAT.SYS_FUND_TYPE <> 'SPONSOR' restricting the result set to non-sponsored funds. The result set is ordered by FUND_ID. Because the view is documented as obsolete and not implemented, base object definitions may be absent in modernized or fresh installations.

Key Columns

Common Use Cases and Queries

Typical use cases include reporting on the matching fund order for a given award year and auditing award amount thresholds. A representative query follows:

  • SELECT FUND_ID, FUND_CODE, FUND_DESC, MATCH_ORDER, CI_CAL_TYPE, CI_SEQUENCE_NUMBER FROM IGF_AW_FSEOG_MATCH_V WHERE CI_CAL_TYPE = :calendar_type ORDER BY MATCH_ORDER;
  • SELECT FUND_CODE, MATCH_ORDER, MIN_AWARD_AMT, MAX_AWARD_AMT FROM IGF_AW_FSEOG_MATCH_V ORDER BY FUND_ID;

Where the view is unavailable due to its obsolete status, equivalent data can be reconstructed by joining IGF_AW_FUND_MAST, IGF_AW_FSEOG_MATCH, and IGF_AW_FUND_CAT directly, applying the same filter and ordering logic documented in the view text.