Search Results igf_aw_year_grp_v

Overview

The IGF_AW_YEAR_GRP_V view resides in the APPS schema under the IGF (Financial Aid) product family and is classified as a VALID database view in Oracle E-Business Suite 12.1.1 and 12.2.2. It is an aggregation view that consolidates award amounts extended to a student, grouped by base identifier and fund category. Specifically, it stores the total Offered Amount, Accepted Amount, and Paid Amount for a student and for a fund, providing a summary-level projection of financial aid disbursement activity.

In the context of ETRM reporting and integration, this view serves as a denormalized reporting surface. Rather than requiring downstream consumers to join award, fund master, and fund category tables and perform their own aggregation, this view performs the summation on behalf of the caller. This makes it well suited to Financial Aid dashboards, student award summaries, and external integration extracts where fund-level totals by student are required. Users searching for the term "fund_desc" will typically arrive at this view because FUND_DESC is one of its five exposed columns and is the primary descriptive attribute used to label aggregated fund amounts.

Underlying Base Objects

Although the documented metadata lists no referenced base objects, the view text embedded in the ETRM record defines its definition over three base tables in the APPS schema:

• IGF_AW_AWARD_ALL — aliased as AWD; the driving table supplying BASE_ID, FUND_ID, AWARD_STATUS, OFFERED_AMT, ACCEPTED_AMT, and PAID_AMT.
• IGF_AW_FUND_MAST_ALL — aliased as FMAST; joined to the award on FUND_ID to resolve the fund code.
• IGF_AW_FUND_CAT_ALL — aliased as FCAT; joined to the fund master on FUND_CODE to supply the fund description exposed as FUND_DESC.

The three tables are joined in a chain: awards link to the fund master by FUND_ID, and the fund master links to the fund category by FUND_CODE. The view then restricts rows to awards whose AWARD_STATUS is either 'OFFERED' or 'ACCEPTED', and groups the results by BASE_ID and the fund category description.

Key Columns

The view exposes five columns. Note the deliberate column alias FUND_DESC, which is the term matched by the user's search:

• BASE_ID — the grouping key identifying the student or base person record for whom the award amounts are aggregated.
• FUND_DESC — the fund category description derived from FCAT.DESCRIPTION; the human-readable label for the fund.
• OFFRD_AMT — SUM(NVL(AWD.OFFERED_AMT,0)), the total amount offered across qualifying awards.
• ACCPT_AMT — SUM(NVL(AWD.ACCEPTED_AMT,0)), the total amount accepted by the student.
• PAID_AMT — SUM(NVL(AWD.PAID_AMT,0)), the total amount actually paid or disbursed.

All three monetary columns are wrapped in NVL to substitute zero for nulls before summation, ensuring that aggregate results are not skewed or nulled by missing amount values on individual award rows.

Common Use Cases and Queries

Typical usage involves producing a per-student, per-fund financial position. A straightforward selection for a specific student is:

• SELECT base_id, fund_desc, ofrd_amt, accpt_amt, paid_amt FROM igf_aw_year_grp_v WHERE base_id = :p_base_id;
• Reporting where accepted versus paid amounts diverge, to flag outstanding disbursements still owing to the student.
• Feeding external systems with fund-level totals keyed by student base identifier and fund description.

Because the view already filters to OFFERED and ACCEPTED statuses, callers do not need to reapply that predicate. When joining to student or person tables, the BASE_ID column is the recommended join key, and FUND_DESC provides the descriptive label preferred by report authors and users who search on "fund_desc."