Search Results max_award_amt




Overview
Explore in AI Chat

Overview

APPS.IGF_AW_FSEOG_MATCH_V is a supplementary database view owned by the APPS schema in Oracle E-Business Suite, registered as a valid object under FND Design Data reference IGF.IGF_AW_FSEOG_MATCH_V. It belongs to the Financial Aid component of the Oracle iGrants / Grants Management (IGF) module, and specifically to the "Award" (IGF_AW) sub-product area that governs fund awarding and matching logic. The view concentrates on the Federal Supplemental Educational Opportunity Grant (FSEOG) matching rules, exposing the criteria by which individual funds are matched against one another and the award amount thresholds that qualify a disbursement for matching.

As documented, the view is explicitly described as a "supplementary view used to simplify forms coding." This is a Forms-driven construct rather than a fully normalized reporting interface; Oracle cautions that the view should not be queried or altered for data maintenance and that its structure "may change dramatically in subsequent minor or major releases." Consequently, in Oracle EBS 12.1.1 and 12.2.2 the view should be treated as a read-only convenience layer. It surfaces the same information that the FSEOG matching setup form displays, allowing developers and report authors to retrieve fund matching data without replicating the joins performed within the form.

The view's principal value lies in its exposure of the MIN_AWARD_AMT and MAX_AWARD_AMT columns—the lower and upper boundaries of the award amount that a student must receive in order for a given fund to participate in the FSEOG match—alongside the fund identity and matching sequence.

Underlying Base Objects

The view is defined over three APPS-layer base objects: IGF_AW_FSEOG_MATCH, IGF_AW_FUND_CAT, and IGF_AW_FUND_MAST. IGF_AW_FSEOG_MATCH supplies the core FSEOG matching configuration, including the matching order and the minimum and maximum award amount thresholds. IGF_AW_FUND_MAST provides the fund master attributes—FUND_ID, FUND_DESC, and FUND_CODE. IGF_AW_FUND_CAT contributes fund category information that supports the calendar (CI_CAL_TYPE and CI_SEQUENCE_NUMBER) context in which the matching rule applies.

The ROW_ID column is a ROWID identifying the base row that the view projects, which is useful when tracing a form record back to its underlying physical row. The view is not referenced by any other database object, confirming its role as a terminal presentation layer rather than a reusable building block for other views or packages. No materialized view or synonym dependencies are documented.

Key Columns

  • ROW_ID — ROWID of the base table row, enabling direct row identification.
  • FUND_ID — Numeric identifier of the fund participating in the FSEOG match.
  • FUND_CODE / FUND_DESC — Short code and descriptive name of the fund, joined from the fund master.
  • MATCH_ORDER — Sequence in which funds are considered for matching; lower values are typically evaluated first.
  • CI_CAL_TYPE / CI_SEQUENCE_NUMBER — Calendar type and sequence number establishing the award period context.
  • MIN_AWARD_AMT — The minimum award amount a student's disbursement must reach to be eligible for matching against this fund. This column is central to the user's search term.
  • MAX_AWARD_AMT — The maximum award amount beyond which matching is no longer applied for the fund.
  • WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard audit and concurrent-program tracking.

Common Use Cases and Queries

The primary use case is verifying that configured minimum and maximum award thresholds align with institutional FSEOG policy, and reporting which funds are active for a given award period. Analysts may also compare matching order across funds to confirm the intended priority sequence.

SELECT fund_id,
       fund_code,
       fund_desc,
       match_order,
       min_award_amt,
       max_award_amt,
       ci_cal_type,
       ci_sequence_number
FROM   apps.igf_aw_fseog_match_v
WHERE  min_award_amt IS NOT NULL
ORDER  BY match_order;

A second scenario isolates awards falling within a specific range, or identifies funds whose thresholds have been updated recently:

SELECT fund_code, min_award_amt, max_award_amt, last_update_date
FROM   apps.igf_aw_fseog_match_v
WHERE  last_update_date >= TRUNC(SYSDATE) - 30
ORDER  BY last_update_date DESC;

Because Oracle restricts modification through this view, all such queries should be read-only. Where persistent extraction is required, the underlying base tables IGF_AW_FSEOG_MATCH and IGF_AW_FUND_MAST should be used, since they are not subject to the volatility warning attached to the supplementary view.