Search Results igf_ap_inst_ver_item




Overview
Explore in AI Chat

Overview

IGF_AP_INST_VER_ITEM is a security-enabled (Multi-Org) view owned by the APPS schema within the IGF — Financial Aid product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The view presents institution-level verification item configuration data used by the Financial Aid processing engine. Specifically, it exposes the columns that define how individual verification items are configured, evaluated, and mapped during the verification of student ISIR (Institutional Student Information Record) data.

The object is classified as a VIEW rather than a table, and its status is VALID across both 12.1.1 and 12.2.2 releases. Because it is defined over a single underlying base table, it functions primarily as a filtered, alias-consistent presentation layer rather than as a join or aggregation construct. The principal value of the view lies in its embedded organization-level (ORG_ID) filtering predicate, which restricts result sets to the current operating unit or organization context derived from USERENV('CLIENT_INFO'). This makes the view suitable for reporting and integration use where Multi-Org security must be enforced without exposing the full unfiltered table.

As with other IGF Financial Aid views, IGF_AP_INST_VER_ITEM does not appear as a documented referenced base object in the ETRM 12.2.2 metadata, but the view text explicitly identifies its source. The objects here are configured at the institution level and drive how verification tolerances and ISIR mapping are applied.

Underlying Base Objects

The view is defined exclusively over a single base table:

  • IGF_AP_INST_VER_ITEM_ALL — the underlying "_ALL" table storing verification item definitions across all organizations.

The view text selects from IGF_AP_INST_VER_ITEM_ALL IVI and applies a WHERE clause that enforces organization-level security. The predicate compares the row's ORG_ID against a value extracted from the client information environment variable, using a DECODE/SUBSTRB pattern that yields NULL for whitespace-led contexts and defaults to -99 when no organization is determinable. This is the standard Oracle Multi-Org view pattern (similar to _ALL/_V conventions) used throughout EBS to present organization-filtered data. Because the view is built on a single _ALL table, there are no joins, and no additional base objects are documented in the ETRM metadata.

Key Columns

  • ROW_ID — the ROWID of the underlying base row, providing a unique physical row identifier.
  • BASE_ID — the base identifier linking the verification item to its parent definition.
  • UDF_VERN_ITEM_SEQ_NUM — sequence number for the verification item, used to order items within a verification group.
  • ITEM_VALUE — the configured value for the verification item; this is the column referenced by users searching for "item_value."
  • WAIVE_FLAG — indicates whether the verification item may be waived.
  • USE_BLANK_FLAG — controls whether a blank value is permitted for the item.
  • LEGACY_RECORD_FLAG — flags records migrated from legacy systems.
  • INCL_IN_TOLERANCE — indicates whether the item participates in tolerance calculations.
  • ISIR_MAP_COL — identifies the ISIR field to which the item maps.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
  • ORG_ID — the organization/operating unit that owns the row; the view's security predicate is built on this column.

Common Use Cases and Queries

The view is most commonly queried to inspect how verification items are configured for the active organization, and to retrieve the ITEM_VALUE associated with a given base or sequence number.

To list all verification items for the current organization:

  • SELECT BASE_ID, UDF_VERN_ITEM_SEQ_NUM, ITEM_VALUE, WAIVE_FLAG, INCL_IN_TOLERANCE FROM IGF_AP_INST_VER_ITEM ORDER BY UDF_VERN_ITEM_SEQ_NUM;

To locate a specific item's configured value:

  • SELECT ITEM_VALUE FROM IGF_AP_INST_VER_ITEM WHERE BASE_ID = :base_id AND UDF_VERN_ITEM_SEQ_NUM = :seq_num;

To identify items mapped to ISIR columns and subject to tolerance checking:

  • SELECT BASE_ID, ITEM_VALUE, ISIR_MAP_COL FROM IGF_AP_INST_VER_ITEM WHERE INCL_IN_TOLERANCE = 'Y' AND ISIR_MAP_COL IS NOT NULL;

Because the view enforces Multi-Org security, results are automatically scoped to the organization in the session context; users requiring cross-organization extracts must query IGF_AP_INST_VER_ITEM_ALL directly with appropriate privileges. The view is read-only with respect to DML on item configuration; inserts and updates should target the base table.