Search Results igf_aw_repkg_prty_v




Overview
Explore in AI Chat

Overview

IGF_AW_REPKG_PRTY_V is a reporting and inquiry view in the Oracle E-Business Suite Financial Aid (IGF) module, owned by the APPS schema. Its documented role is to present the setup of re-package priority of funds at the System Fund level — that is, the ordering in which system-level funds are considered during an award repackaging cycle. In the Financial Aid funds-management flow, "repackaging" refers to the reallocation of awarded aid when a student's eligibility or available resources change; the priority ordering determines which funds are adjusted first. The view exposes the stored priority rows together with decoded (meaning) values for each lookup-driven attribute, so that report writers, form developers, and integration consumers do not have to join the IGF lookup infrastructure themselves. Because the view is synonymous with a decoded, business-friendly projection of the underlying priority setup, it is typically referenced in inquiry pages, configuration reports, and data extracts rather than used as a transactional interface.

Underlying Base Objects

The view is defined over four objects: the base table IGF_AW_REPKG_PRTY (aliased RPP) and three instances of IGF_LOOKUPS_VIEW (aliased FNDS1, FNDS2, and FNDS3). No other base objects are documented in the ETRM metadata. The joins are implemented as lookup decodes restricted by lookup type:

IGF_LOOKUPS_VIEW is the standard Financial Aid lookup view, itself generally built over the FND lookup tables (FND_LOOKUP_TYPES / FND_LOOKUP_VALUES). Because the joins are expressed as inner joins, a priority row is returned only when all three lookup codes resolve; a missing or end-dated lookup value suppresses the row from the result set. All primary attributes, including the ROWID of the base table row, originate from IGF_AW_REPKG_PRTY.

Key Columns

  • ROW_ID — the ROWID of the underlying IGF_AW_REPKG_PRTY row, useful for direct row identification and updates.
  • FUND_ORDER_NUM — the numeric priority sequence that establishes the order in which funds are repackaged; the primary sorting key for consumers of this view.
  • SYS_FUND_TYPE_CODE / SYS_FUND_TYPE_DESC — the system fund type code and its decoded meaning from lookup type IGF_AW_SYS_FUND_TYPE.
  • FUND_SOURCE_CODE / FUND_SOURCE_DESC — the fund source code and its decoded meaning from lookup type IGF_AW_FUND_SOURCE; this is the column most frequently targeted by the search term "fund_source_code."
  • SYS_FUND_CODE / SYS_FUND_CODE_DESC — the system fund code and its decoded meaning, resolved through lookup type IGF_AW_FED_FUND.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns recording the creating and last-updating user, timestamp, and login session.

Common Use Cases and Queries

Typical usage includes validating repackaging configuration, producing setup documentation for fund priority, and driving award repackaging logic that must respect fund ordering. A representative query lists repackaging priority in processing order:

  • SELECT fund_order_num, sys_fund_type_desc, fund_source_code, fund_source_desc, sys_fund_code, sys_fund_code_desc FROM igf_aw_repkg_prty_v ORDER BY fund_order_num;
  • SELECT fund_order_num, sys_fund_code FROM igf_aw_repkg_prty_v WHERE fund_source_code = :p_fund_source ORDER BY fund_order_num;
  • SELECT f.fund_source_desc, COUNT(*) FROM igf_aw_repkg_prty_v f GROUP BY f.fund_source_desc;

Consumers should note that rows with unresolved lookup values will not appear, and that the view is read-only; maintenance of priority rows is performed against IGF_AW_REPKG_PRTY through the corresponding Financial Aid setup forms or concurrent processes.