Search Results fund_desc




Overview
Explore in AI Chat

Overview

APPS.IGF_AW_YEAR_GRP_V is a reporting view in the Oracle E-Business Suite Financial Aid module (IGF), part of the Student Systems product family. It is registered as a multi-org view, meaning that queries against it automatically restrict returned rows to the operating unit that is currently set in the user's session. The view presents aggregated award amounts at the student and fund level, summarizing the total offered amount, the total accepted amount, and the total paid amount. Because it carries the multi-org designation, data belonging to other operating units is silently excluded from the result set unless the session context is changed.

The view is a read-only reporting construct rather than a transaction base object. It consolidates information that would otherwise require joins across the award, fund master, and fund category tables, and it exposes this consolidated picture through a small, stable column list. This makes it suitable for use in Oracle Reports, BI Publisher data templates, Discoverer workbooks, and custom concurrent programs. The presence of the FUND_DESC column, which corresponds to the search term that surfaced this object, provides a human-readable fund label that avoids the need for the consumer to resolve a fund identifier.

Underlying Base Objects

The ETRM metadata documents that IGF_AW_YEAR_GRP_V references three APPS tables: IGF_AW_AWARD_ALL, IGF_AW_FUND_MAST_ALL, and IGF_AW_FUND_CAT_ALL. The view draws its numeric measures from the award table, which holds the individual award records including offered, accepted, and disbursed or paid amounts. The fund master table supplies the fund definition and its descriptive text, which the view surfaces as FUND_DESC. The fund category table provides the categorization layer that links funds into broader groupings, which is consistent with the "year group" semantics implied by the view name.

Each of the three referenced tables is an _ALL table, which is the standard EBS convention indicating that the table is partitioned by operating unit and that a corresponding multi-org secured view filters rows based on the current organization. IGF_AW_YEAR_GRP_V inherits and enforces this behavior, so the aggregation it performs is scoped to the active operating unit. The metadata notes that IGF_AW_YEAR_GRP_V is not referenced by any other database object, confirming that it is a terminal reporting view rather than a building block for further views.

Key Columns

  • BASE_ID (NUMBER, length 10) — The identifier that anchors the grouping, typically the award or fund basis identifier used to consolidate the associated award lines.
  • FUND_DESC (VARCHAR2, length 80) — The descriptive name of the fund. This is the column most commonly used for display, grouping, and filtering in reports, and it is the target of the "fund_desc" lookup.
  • OFFRD_AMT (NUMBER) — The total amount offered to the student for the fund.
  • ACCPT_AMT (NUMBER) — The total amount the student has accepted for the fund.
  • PAID_AMT (NUMBER) — The total amount actually paid or disbursed for the fund.

Common Use Cases and Queries

Typical uses include fund-level award summaries for financial aid offices, reconciliation of offered versus accepted versus paid amounts, and feeds into downstream reporting or integration extracts. A baseline query selects all columns for the current operating unit:

  • SELECT BASE_ID, FUND_DESC, OFFRD_AMT, ACCPT_AMT, PAID_AMT FROM APPS.IGF_AW_YEAR_GRP_V;
  • To isolate a specific fund by description: SELECT BASE_ID, FUND_DESC, OFFRD_AMT, ACCPT_AMT, PAID_AMT FROM APPS.IGF_AW_YEAR_GRP_V WHERE FUND_DESC = :p_fund_desc;
  • To surface funds where acceptance lags offers: SELECT FUND_DESC, OFFRD_AMT, ACCPT_AMT FROM APPS.IGF_AW_YEAR_GRP_V WHERE ACCPT_AMT < OFFRD_AMT ORDER BY FUND_DESC;

Because the view enforces operating unit security, report developers should ensure the correct organization context is initialized (for example, via FND_GLOBAL or the standard multi-org initialization in the concurrent program) before the query executes, so that the intended operating unit's awards are returned.