Search Results igs_ad_offresp_int




Overview
Explore in AI Chat

Overview

IGS_AD_OFFRESP_INT is an interface table in the IGS (Student System) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. Its documented description states that it "holds offer response interface details." In practice, this table serves as the staging and working area through which admission offer responses — acceptances, declines, and conditional acceptances received from applicants or external systems — are loaded, validated, and subsequently processed into the operational student-system tables. Because it is an interface object, its rows typically carry a batch identifier and a processing status, allowing concurrent loads to be grouped, monitored, and reprocessed without disturbing already-validated data.

Primary key IGS_AD_OFFRESP_INT_PK is defined on OFFRESP_INT_ID, the surrogate identifier for each interface row. The documented foreign key from BATCH_ID to IGS_AD_OFFRESP_BATCH confirms the batch-oriented design of the load process. Under the heuristic Data Vault classification mined from the foreign-key structure, this table is characterized as satellite-leaning: it records descriptive attributes describing a single business event (an offer response) and is keyed by its own surrogate identifier, with the batch acting as a parent grouping rather than a true hub relationship.

Key Information Stored

The table comprises 26 documented columns. The most significant are:

Only OFFRESP_INT_ID is documented as a unique index (IGS_AD_OFFRESP_INT_PK); no separate business-key unique index is reported, so admission application number combined with course and sequence is best treated as a logical, non-enforced key.

Common Use Cases and Queries

Typical usage centers on monitoring pending interface rows and reconciling loaded offer responses against applications. A common pattern selects unprocessed rows for a given batch:

  • SELECT OFFRESP_INT_ID, PERSON_ID, ADMISSION_APPL_NUMBER, ADM_OFFER_RESP_STATUS, STATUS FROM IGS_AD_OFFRESP_INT WHERE BATCH_ID = :batch AND STATUS = 'PENDING';
  • Joining to IGS_AD_OFFRESP_BATCH to report throughput per load run.
  • Joining to IGS_AD_OFFRESP_ERR on OFFRESP_INT_ID to isolate rows that failed validation for correction and resubmission.
  • Reporting acceptance/decline volumes by course and calendar using NOMINATED_COURSE_CD and the default calendar columns.

Related Objects

  • IGS_AD_OFFRESP_BATCH — parent batch table; join on IGS_AD_OFFRESP_INT.BATCH_ID = IGS_AD_OFFRESP_BATCH.BATCH_ID.
  • IGS_AD_OFFRESP_ERR — error table holding validation failures; join on IGS_AD_OFFRESP_ERR.OFFRESP_INT_ID = IGS_AD_OFFRESP_INT.OFFRESP_INT_ID.
  • IGS_AD_OFFRESP_INT_PK — the primary key constraint/index on OFFRESP_INT_ID.
  • Associated admission, application, and person entities (referenced by PERSON_ID, ADMISSION_APPL_NUMBER, PROGRAM_APPLICATION_ID) supply the validation context used by the offer-response import process, though they are not documented here as enforced foreign keys.