Search Results person_match_ind




Overview
Explore in AI Chat

Overview

IGS_AD_INTERFACE_V is a VALID view owned by the APPS schema within the IGS (Student System) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is documented as being created using a join condition between IGS_AD_INTERFACE and IGS_LOOKUPS_VIEW, giving it a dual purpose: exposing the staging rows of the admissions interface alongside decoded lookup values for selected attributes. Because admissions data frequently originates in external systems (web forms, third-party CRMs, or legacy student systems), this view acts as a reporting and diagnostic layer over the interface staging table before records are validated and promoted into the core person and admissions tables.

The view is a critical artifact for users investigating interface load status, batch errors, and demographic codes. The search term “level_of_qual” maps directly to the LEVEL_OF_QUAL column exposed by the view, which carries a level-of-qualification code for an applicant record.

Underlying Base Objects

The ETRM metadata documents the view as a join between IGS_AD_INTERFACE (the admissions interface staging table) and IGS_LOOKUPS_VIEW (a lookups wrapper). The view text, however, shows the actual lookup decoding is performed inline against FND_LOOKUP_VALUES using a scalar subquery, which retrieves the meaning for SEX from lookup type HZ_GENDER scoped to VIEW_APPLICATION_ID = 222, SECURITY_GROUP_ID = 0, and the user’s session language. No additional documented base objects are listed beyond these. In practice the view remains tightly coupled to IGS_AD_INTERFACE, with I.ROWID preserved as ROW_ID to support row-level identification of the source interface record.

Key Columns

Common Use Cases and Queries

Typical uses include auditing stalled or errored admissions interface rows, verifying qualification codes, and confirming demographic decoding ahead of person creation.

  • List applicants by qualification level: 
    SELECT interface_id, person_number, surname, given_names, level_of_qual, status
FROM   apps.igs_ad_interface_v
WHERE  level_of_qual IS NOT NULL;
  • Identify errored interface rows: 
    SELECT interface_id, batch_id, person_number, error_code, record_status
FROM   apps.igs_ad_interface_v
WHERE  error_code IS NOT NULL;
  • Review gender decoding and audit trail: 
    SELECT interface_id, surname, sex, sex_meaning, creation_date, created_by
FROM   apps.igs_ad_interface_v;

Because the view exposes a ROW_ID derived from the underlying table ROWID, it can also be used in controlled update or diagnostic scripts, though direct DML against the interface should be performed only under Oracle’s documented interface procedures.