Search Results incl_in_tolerance




Overview
Explore in AI Chat

Overview

IGF_AP_INS_VERN_ITEM_V is a reporting view within the Oracle E-Business Suite IGF (Financial Aid) module, which is classified as obsolete in Release 12.1.1 and 12.2.2. The view assembles institutional verification item data drawn from the Institution Verification Item table (IGF_AP_INST_VER_ITEM) and enriches it with lookup meanings resolved through the SAR field mapping configuration used by the financial aid institutional application process. Its principal role is to present each verification item alongside a human-readable field label, the associated ISIR mapping column, and processing flags such as WAIVE_FLAG.

Because the IGF product line is obsolete, this view is documented in ETRM metadata but is not implemented in the target database. Any reference to it in a 12.1.1 or 12.2.2 environment is therefore informational only; it does not resolve to a deployed database object unless a legacy custom implementation exists. Organizations that previously used IGF should treat this view as a historical artifact rather than a supported integration point.

Underlying Base Objects

The view definition joins four distinct sources. The primary driving table is IGF_AP_INST_VER_ITEM, aliased IVI, which supplies the verification item rows and the WAIVE_FLAG column. IGF_AP_FA_BASE_REC_ALL, aliased FABASE, supplies the base record and calendar context, joined on BASE_ID. IGF_AP_BATCH_AW_MAP, aliased MAP, links the base record to a system award year through CI_CAL_TYPE and CI_SEQUENCE_NUMBER. IGF_FC_SAR_CD_MST, aliased SAR, resolves the SAR field number against that award year. IGF_LOOKUPS_VIEW, aliased LKUP, provides the decoded meaning by matching LOOKUP_TYPE = 'IGF_AP_SAR_FIELD_MAP' and LOOKUP_CODE = SAR.SAR_FIELD_NAME.

The metadata records no documented referenced base objects for the 12.2.2 repository entry, reflecting its unimplemented status. The join chain, however, clearly defines the dependency graph described above.

Key Columns

  • ROW_ID — Unique row identifier from IGF_AP_INST_VER_ITEM.
  • BASE_ID — Foreign key linking the verification item to the financial aid base record.
  • FIELD_LABEL — Decoded lookup meaning for the SAR field, presented as the display label.
  • ISIR_MAP_COL — The ISIR (Institutional Student Information Record) mapping column for the item.
  • ITEM_VALUE — The value captured for the verification item.
  • WAIVE_FLAG — Indicates whether the verification requirement has been waived; the column most frequently searched by users.
  • LEGACY_RECORD_FLAG — Marks records migrated from a legacy system.
  • INCL_IN_TOLERANCE — Determines whether the item participates in tolerance calculations.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Several columns defined in the view structure (UDF_VERN_ITEM_SEQ_NUM, PROFILE_MAP_COL, FIELD_TYPE, REQ_BY_FLAG) are projected as NULL in the view text, indicating they are reserved or populated elsewhere.

Common Use Cases and Queries

The most common reporting scenario is identifying waived verification items for a given base record. A representative query is:

SELECT BASE_ID, FIELD_LABEL, ISIR_MAP_COL, ITEM_VALUE, WAIVE_FLAG
FROM IGF_AP_INS_VERN_ITEM_V
WHERE WAIVE_FLAG = 'Y'
ORDER BY BASE_ID;

Because the object is unimplemented in 12.1.1 and 12.2.2, such queries will fail unless the view was manually created. Analysts should instead consult the base table IGF_AP_INST_VER_ITEM and join it to IGF_AP_BATCH_AW_MAP and IGF_FC_SAR_CD_MST to reproduce the view's logic. This approach preserves the same WAIVE_FLAG filtering semantics while remaining valid in a supported schema.