Search Results igf_aw_fund_cat




Overview
Explore in AI Chat

Overview

The IGF_AW_FUND_CAT view is a reporting and integration object within the Oracle E-Business Suite Financial Aid (IGF) module, owned by the APPS schema. It presents fund category (fund catalog) information used by the institution's financial aid processing to identify and classify the various funds available for awarding. The name itself reflects its purpose: IGF (Financial Aid), AW (Awards), and FUND_CAT (Fund Category). This view addresses the operational need to resolve fund records by the organization (ORG_ID) of the user accessing them, in compliance with Oracle's Multi-Org Access Control (MOAC) model.

Practically, the view exposes the fund master record—including its institutional fund code, the federal fund code (FED_FUND_CODE), and the associated fund type and source—in a manner filtered by the operating unit currently in session. This makes it the natural access point for reports, concurrent programs, forms-based LOVs, and external integrations that need to reference financial aid funds at the correct organization level.

Underlying Base Objects

The view is defined over a single base table:

  • IGF_AW_FUND_CAT_ALL — the "_ALL" table containing fund category records across all organizations. The view selects directly from this table and aliases the base columns (for example, FCAT.FUND_CODE, FCAT.FED_FUND_CODE, and FCAT.FCAT_ID) into the view's exposed column names.

The critical logic is the WHERE clause, which enforces the operating unit context. It compares the base row's ORG_ID to a value derived from USERENV('CLIENT_INFO')—specifically the first ten characters of the client information string, converted to a number and defaulted to -99 when not set. Rows whose ORG_ID matches the session's operating unit (or where both sides resolve to -99) are returned. No other base objects are documented for this view.

Key Columns

  • ROW_ID — the base row's ROWID, used for identifying the physical row.
  • FCAT_ID — the primary key of the fund category record; the safest unique identifier for joins and API calls.
  • FUND_CODE — the institution's internal code identifying the fund.
  • FED_FUND_CODE — the federal fund code associated with the fund; this is the column users search for when reconciling institutional funds to federal program reporting. It links financial aid awards to federal aid programs such as Pell, SEOG, or Direct Loans.
  • DESCRIPTION — a human-readable description of the fund.
  • FUND_TYPE and SYS_FUND_TYPE — the fund's classification, both user-defined and system-defined.
  • FUND_SOURCE — indicates the source of the fund (for example, federal, state, institutional).
  • ALT_LOAN_CODE and ALT_REL_CODE — alternate loan and release codes used for federal loan processing and reconciliation.
  • ACTIVE — flag indicating whether the fund is currently active for awarding.
  • ORG_ID — the operating unit to which the fund belongs.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

This view is typically used to populate fund lists in awards processing, to validate fund codes entered during disbursement, and to drive federal reporting extracts. A frequent requirement is locating all funds sharing a given federal fund code, as shown below:

SELECT fund_code, description, fed_fund_code, fund_type, fund_source, active
FROM   igf_aw_fund_cat
WHERE  fed_fund_code = :p_fed_fund_code
AND    active = 'Y';

To retrieve the full catalog visible to the current operating unit:

SELECT fcat_id, fund_code, description, fund_source, org_id
FROM   igf_aw_fund_cat
ORDER  BY fund_code;

Because the view already applies MOAC filtering from USERENV('CLIENT_INFO'), queries executed under a properly initialized session automatically return only the funds belonging to the user's operating unit. Developers integrating externally must therefore ensure the client information string is set correctly; otherwise the effective ORG_ID resolves to -99. For cross-organization reconciliation, query IGF_AW_FUND_CAT_ALL directly rather than this view.