Results for “fund_desc”
31 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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."
-
View: IGF_AW_YEAR_GRP_V 12.1.1
Stores the Total Offered Amount,Accepted Amount and Paid Amount for a Student and for a Fund
APPS.IGF_AW_YEAR_GRP_V·↳ IGF_AW_AWARD_ALL·↳ IGF_AW_FUND_CAT_ALL·↳ IGF_AW_FUND_MAST_ALL·Explore IGF module →
-
View: IGF_SP_STDNT_REL_V 12.1.1
FORM VIEW formed by joining IGF_SP_STDNT_REL MO view, IGF_AW_FUND_MAST view and IGF_AP_FA_BASE_REC. The view holds sponsor student relation details
APPS.IGF_SP_STDNT_REL_V·↳ IGF_AP_FA_BASE_REC·↳ IGF_AW_FUND_MAST·↳ IGF_SP_STDNT_REL·Explore IGF module →
-
View: IGF_AW_FUND_GRP_V 12.1.1
APPS.IGF_AW_FUND_GRP_V·↳ IGF_AP_FA_CON_V·↳ IGF_AW_AWARD_V·↳ IGF_AW_FUND_CAT_ALL·Explore IGF module →
-
View: IGF_AW_CORRESP_LD_V 12.1.1
APPS.IGF_AW_CORRESP_LD_V·↳ IGF_AW_AWARD·↳ IGF_AW_AWD_DISB_ALL·↳ IGF_AW_FUND_MAST·Explore IGF module →
-
View: IGF_SP_AWARD_V 12.1.1
FORM VIEW formed by joining IGF_AW_AWARD MO view, IGF_AW_FUND_TP MO view, IGF_AW_FUND_MAST MO View, IGF_AW_FUND_CAT MO View and IGS_CA_INST. The view holds students award details for a sponsor fund
APPS.IGF_SP_AWARD_V·↳ IGF_AW_AWARD·↳ IGF_AW_AWD_DISB·↳ IGF_AW_FUND_CAT·Explore IGF module →
-
View: IGF_AW_FSEOG_MATCH_V 12.1.1
This entity is used to retrieve the Matching Fund and its Match Order for the specific Award Years
APPS.IGF_AW_FSEOG_MATCH_V·↳ IGF_AW_FSEOG_MATCH·↳ IGF_AW_FUND_CAT·↳ IGF_AW_FUND_MAST·Explore IGF module →
-
View: IGF_AW_FN_RPKG_PRTY_V 12.1.1
Sets up the re-package priority of funds at the Fund Level
APPS.IGF_AW_FN_RPKG_PRTY_V·↳ IGF_AW_FN_RPKG_PRTY·↳ IGF_AW_FUND_MAST_V·↳ IGF_AW_GEN·Explore IGF module →
-
View: IGF_AW_FUND_TP_V 12.1.1
Lists of all the valid teaching periods during which this fund can be used
APPS.IGF_AW_FUND_TP_V·↳ IGF_AW_FUND_MAST·↳ IGF_AW_FUND_TP·↳ IGS_CA_INST·Explore IGF module →
-
VIEW: APPS.IGF_AW_YEAR_GRP_V 12.1.1
-
VIEW: APPS.IGF_AW_FUND_GRP_V 12.1.1
-
View: IGF_AW_YEAR_GRP_V 12.2.2
Stores the Total Offered Amount,Accepted Amount and Paid Amount for a Student and for a Fund
Not implemented in this database·Explore IGF module →
-
VIEW: APPS.IGF_SP_AWARD_V 12.1.1
-
View: IGF_AW_FN_RPKG_PRTY_V 12.2.2
Sets up the re-package priority of funds at the Fund Level
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_CORRESP_LD_V 12.2.2
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_FSEOG_MATCH_V 12.2.2
This entity is used to retrieve the Matching Fund and its Match Order for the specific Award Years
Not implemented in this database·Explore IGF module →
-
VIEW: APPS.IGF_AW_FUND_TP_V 12.1.1
-
View: IGF_AW_FUND_GRP_V 12.2.2
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_FUND_TP_V 12.2.2
Lists of all the valid teaching periods during which this fund can be used
Not implemented in this database·Explore IGF module →
-
View: IGF_SP_AWARD_V 12.2.2
FORM VIEW formed by joining IGF_AW_AWARD MO view, IGF_AW_FUND_TP MO view, IGF_AW_FUND_MAST MO View, IGF_AW_FUND_CAT MO View and IGS_CA_INST. The view holds students award details for a sponsor fund
Not implemented in this database·Explore IGF module →
-
View: IGF_SP_STDNT_REL_V 12.2.2
FORM VIEW formed by joining IGF_SP_STDNT_REL MO view, IGF_AW_FUND_MAST view and IGF_AP_FA_BASE_REC. The view holds sponsor student relation details
Not implemented in this database·Explore IGF module →
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program