Results for “igf_aw_fund_type”

27 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGF_AW_FUND_TYPE is a secured (organization-striped) view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGF — Financial Aid product family. The object has a documented status of VALID and is classified in the ETRM as a VIEW. Its purpose is to expose fund type definition records — the lookup-style reference data that classifies the sources of financial aid funds administered through the Financial Aid module (for example, grant, loan, scholarship, or work-study categories) — while enforcing Oracle's standard multi-organization security model at query time.

Rather than presenting the full underlying table to every caller, the view filters rows according to the organization context carried in the session. Reporting tools, concurrent programs, forms, and integration layers query the view instead of the base table so that a user or process only sees fund types belonging to the organization currently set in the session. Because the row identifier and audit columns are exposed intact, the view remains fully usable as a data source for BI Publisher reports, OAF pages, and interface extracts.

Underlying Base Objects

The documented ETRM metadata for IGF_AW_FUND_TYPE lists no referenced base objects. The view text contained in the documentation, however, defines the view explicitly over a single table:

  • IGF_AW_FUND_TYPE_ALL — the "_ALL" table that stores every fund type record across all organizations, including the ORG_ID discriminator. It is the only base object referenced by the view definition.

The relationship between the two objects is a one-to-one row projection with a WHERE clause predicate. The SELECT list aliases every column of IGF_AW_FUND_TYPE_ALL, and the filter restricts the result set to rows whose ORG_ID matches the organization derived from the session. In the absence of a usable client information value, the predicate resolves to a sentinel of -99, which typically returns no rows — a deliberate safeguard against exposing cross-organization data.

Key Columns

  • ROW_ID — the ROWID of the underlying base table row; used for direct row addressing and by some Oracle Forms and OAF constructs.
  • FT_ID — the surrogate primary key of the fund type definition; the join key to other Financial Aid tables that reference a fund type.
  • FUND_TYPE — the coded value or short name identifying the fund type.
  • DESCRIPTION — the descriptive text presented to users in lists of values and reports.
  • ACTIVE — the enabled/disabled flag; inactive fund types are generally suppressed in transactional entry but retained for historical reporting.
  • ORG_ID — the operating unit / organization identifier that drives the view's security predicate.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle audit columns, carried through unchanged from the base table.

Common Use Cases and Queries

The view is typically consumed in three ways: as the value set source behind a fund type list of values on Financial Aid forms and OAF pages; as the lookup source for concurrent programs that validate or translate fund type codes; and as a reporting dimension for BI Publisher or Discoverer reports that summarize awards and disbursements by fund type. Because the view is organization-secured, callers must initialize the client information (or run under a responsibility with an assigned organization) before querying it.

A straightforward listing of active fund types:

  • SELECT ft_id, fund_type, description, org_id FROM apps.igf_aw_fund_type WHERE active = 'Y' ORDER BY fund_type;

Resolving a fund type code to its identifier for use in an interface or join:

  • SELECT ft_id, description FROM apps.igf_aw_fund_type WHERE fund_type = :p_fund_type;

Auditing recently maintained definitions within the current organization context:

  • SELECT fund_type, active, last_updated_by, last_update_date FROM apps.igf_aw_fund_type WHERE last_update_date >= SYSDATE - 30 ORDER BY last_update_date DESC;