Search Results igs_ad_interface_v

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

• INTERFACE_ID / INTERFACE_RUN_ID / BATCH_ID — Identifiers for the individual interface record, the run that processed it, and the batch to which it belongs.
• PERSON_NUMBER / PERSON_ID — Applicant identifiers; may be null prior to matching or creation.
• SURNAME / GIVEN_NAMES / PREFERRED_GIVEN_NAME / TITLE / SUFFIX — Name attributes of the prospective applicant.
• SEX — Stored code value; SEX_MEANING — decoded meaning from HZ_GENDER.
• BIRTH_DT — Date of birth.
• LEVEL_OF_QUAL — Level-of-qualification code carried on the interface row; the column referenced by the user’s search.
• PROOF_OF_INSURANCE / PROOF_OF_IMMUN / MILITARY_SERVICE_REG / VETERAN — Compliance and status flags.
• MATCH_IND / PERSON_MATCH_IND — Indicators describing how the record matched to an existing person.
• STATUS / RECORD_STATUS / ERROR_CODE — Processing state and failure diagnostics.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE22 — Descriptive flexfield (DFF) columns available for client-specific data.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / REQUEST_ID / PROGRAM_ID — Standard WHO and concurrent program audit 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.