Search Results igf_ap_sar_field_map

Overview

IGF_AP_INS_VERN_ITEM_V is an Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 view owned by the APPS schema and defined in the Financial Aid / Institutional Grants (IGF) module of Oracle Student Financials. The view exposes installment verification line items in a denormalized, reporting-friendly form. It joins institutional award values stored in IGF_AP_INST_VER_ITEM to the base financial aid record, the batch award map, the SAR (Student Aid Report) code master, and the standard Oracle lookups repository. Its central purpose is to translate internally-coded SAR field mappings into human-readable lookup meanings, so that verification items can be reported, audited, or exported without additional application logic.

The name references the lookup type IGF_AP_SAR_FIELD_MAP — consistent with the user's search term "igf_ap_sar_field_map" — which is the seed lookup set used by the view to resolve SAR field descriptions. The view therefore acts as a semantic bridge between the raw ISIR/SAR mapping columns stored in the base tables and the friendly labels defined in the lookups view.

Underlying Base Objects

The view is defined over five objects. Although ETRM metadata shows no explicit base-object list, the view SQL documents them clearly:

• IGF_AP_INST_VER_ITEM (IVI) — the primary source of installment verification item rows, supplying row_id, base_id, ISIR_MAP_COL, ITEM_VALUE, WAIVE_FLAG, LEGACY_RECORD_FLAG, INCL_IN_TOLERANCE, and standard WHO audit columns.
• IGF_AP_FA_BASE_REC_ALL (FABASE) — the financial aid base record, joined on BASE_ID and used to retrieve the CI_CAL_TYPE and CI_SEQUENCE_NUMBER context.
• IGF_AP_BATCH_AW_MAP (MAP) — the batch award map, joined on CI_CAL_TYPE and CI_SEQUENCE_NUMBER, and providing SYS_AWARD_YEAR.
• IGF_FC_SAR_CD_MST (SAR) — the SAR code master, joined on SYS_AWARD_YEAR and matched to IVI.ISIR_MAP_COL via SAR_FIELD_NUMBER.
• IGF_LOOKUPS_VIEW (LKUP) — the standard lookups view, filtered to LOOKUP_TYPE = 'IGF_AP_SAR_FIELD_MAP' and matched on LOOKUP_CODE = SAR.SAR_FIELD_NAME, returning MEANING.

Key Columns

• ROW_ID, BASE_ID — primary identifiers for the installment verification item and its parent base record.
• MEANING — the human-readable SAR field description from IGF_LOOKUPS_VIEW; this is the primary value-add of the view.
• ISIR_MAP_COL — the raw ISIR/SAR mapping column identifier on the item.
• ITEM_VALUE — the reported value for the verification item.
• WAIVE_FLAG — indicates whether the item has been waived during verification.
• LEGACY_RECORD_FLAG — flags rows migrated from legacy systems.
• INCL_IN_TOLERANCE — determines whether the item participates in tolerance calculations.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Several positional NULLs appear in the SELECT list (columns 3 through 8), indicating placeholders retained for interface compatibility.

Common Use Cases and Queries

Typical uses include verification tracking reports, ISIR/SAR reconciliation, waiver audits, and extracts feeding downstream financial aid systems. A representative query lists all verification items for a given base record with their resolved SAR meanings:

• SELECT row_id, base_id, isir_map_col, meaning, item_value, waive_flag FROM apps.igf_ap_ins_vern_item_v WHERE base_id = :p_base_id;
• SELECT meaning, item_value FROM apps.igf_ap_ins_vern_item_v WHERE waive_flag = 'Y' ORDER BY meaning;
• SELECT base_id, meaning, item_value FROM apps.igf_ap_ins_vern_item_v WHERE incl_in_tolerance = 'Y';

Because the view resolves SAR field names through IGF_AP_SAR_FIELD_MAP, it is the preferred source whenever reporting requires labeled SAR data rather than raw codes.