Search Results igf_aw_round_off

Overview

IGF_SP_FUND_MAST_V is a Financial Aid (IGF) reporting view shipped in the APPS schema of Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a denormalized, flattened representation of the fund master record — the definitional entity behind every student financial aid fund — enriched with descriptive values drawn from related category, calendar, and lookup reference data. Because it resolves raw code values into human-readable lookup descriptions at the database layer, the view is intended for reporting, extract, and integration consumption without requiring calling code to join lookup tables or invoke the IGF_AW_GEN lookup utility itself.

The view is particularly relevant to the keyword used to locate it, igf_aw_need_method. The column FM_FC_METHD holds the fund's need calculation method code, and the view exposes its decoded value through an inline call to IGF_AW_GEN.LOOKUP_DESC('IGF_AW_NEED_METHOD', FMAST.FM_FC_METHD). This makes the view the natural reporting entry point for any analysis involving need analysis methodology.

Underlying Base Objects

The view is defined over a multi-table join. While ETRM documentation records no referenced base objects for this view, the view text identifies the driving table as FMAST (the fund master table, alias for the IGF fund master record), joined to FCAT for fund category attributes and to CI for calendar instance attributes. Two other joined entities supply descriptive text: a table aliased ATT (likely an award-type or attribute reference) and CR, which provides CREDIT_TYPE_NAME. The lookup utility function IGF_AW_GEN.LOOKUP_DESC is invoked repeatedly to translate stored codes into display values.

Because FMAST is the driving table, the view carries one row per fund master record, with the joined tables contributing descriptive attributes rather than multiplying the result set. This one-row-per-fund grain is the key characteristic to understand when using the view in reports.

Key Columns

• FUND_ID, FUND_CODE, DESCRIPTION, ROW_ID — core identity of the fund record.
• FUND_TYPE, FUND_SOURCE, FED_FUND_CODE, SYS_FUND_TYPE — fund category classification sourced from FCAT.
• CI_CAL_TYPE, CI_SEQUENCE_NUMBER, ALTERNATE_CODE, START_DT, END_DT — calendar instance context bounding the fund's active period.
• FM_FC_METHD and its decoded form — the fund's need method code and its IGF_AW_NEED_METHOD lookup description; the primary decoding relevant to need-method reporting.
• ROUNDOFF_FACT and its decoded form — rounding behavior code and its IGF_AW_ROUND_OFF description.
• PCKG_AWD_STAT and its decoded form — packaging award status decoded via IGF_AWARD_STATUS.
• Award ceiling/threshold columns — MIN_AWARD_AMT, MAX_AWARD_AMT, MAX_YEARLY_AMT, MAX_LIFE_AMT, MAX_LIFE_TERM, OVER_AWARD_AMT, OVER_AWARD_PERCT.
• Aggregate totals — TOTAL_OFFERED, TOTAL_ACCEPTED, TOTAL_DECLINED, TOTAL_REVOKED, TOTAL_CANCELLED, TOTAL_DISBURSED, TOTAL_COMMITTED, with corresponding amount columns (AVAILABLE_AMT, OFFERED_AMT, PENDING_AMT, ACCEPTED_AMT, DECLINED_AMT, CANCELLED_AMT, REMAINING_AMT, COMMITTED_AMT, DISBURSED_AMT).
• Processing flags — ENTITLEMENT, AUTO_PKG, SELF_HELP, ALLOW_MAN_PKG, DISBURSE_FUND, DISCONTINUE_FUND, ALLOW_OVERAWARD, REPLACE_FC, ENROLLMENT_STATUS.
• Dates and disbursement controls — DISB_VERF_DA, FUND_EXP_DA, NSLDS_DISB_DA, DISB_EXP_DA, MIN_NUM_DISB, MAX_NUM_DISB.
• Descriptive text — PRN_AWARD_LETTER, AWD_NOTICE_TXT, BILL_DESC, ELIG_CRITERIA, CREDIT_TYPE_NAME.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE14 — the standard EBS DFF extension columns.

Common Use Cases and Queries

The view supports fund configuration reporting, need-method auditing, and financial aid extracts. The following query lists active funds alongside their decoded need method and award ceilings:

• SELECT fund_code, description, fund_type, fm_fc_met_hd? — Note: reference the column by its documented alias position, since LOOKUP_DESC output is unnamed in the view text.

A practical projection that avoids the unnamed decoded columns while still surfacing the need method is to select FM_FC_METHD directly and apply the lookup in the report layer, or to reference the view's columns by ordinal position. The view is equally suited to aggregation, for example summing TOTAL_OFFERED and TOTAL_DISBURSED by FUND_TYPE to reconcile fund utilization, or filtering on ENROLLMENT_STATUS and DISCONTINUE_FUND to isolate active funds. Because the view already decodes status, rounding, and need method, it eliminates repetitive lookup joins in operational reporting against IGF fund master data across both 12.1.1 and 12.2.2.