Results for “igs_ad_inq_prunt_int”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS.IGS_AD_INQ_PRUNT_INT table is an interface (staging) table within the IGS – Student System product family of Oracle E-Business Suite (validated across 12.1.1 and 12.2.2). It holds admission inquiry combined program and unit set information interface records, serving as the inbound landing area for data that pairs a prospective applicant's program-of-interest with the unit set (subject/unit grouping) selections attached to that program. Per the ETRM documentation, the object carries a status of VALID but is explicitly marked Obsolete, meaning it is retained in the schema for backward compatibility and historical reference rather than active functional use. Newer implementations should not rely on it for fresh integration design.

From a Data Vault modeling perspective, the mined FK structure classifies this table heuristically as a standalone object. Because it is a staging/interface surface keyed on an interface surrogate identifier and carrying an internal foreign key to a parent interface table, it is best treated as a link-style interface record — a transient association between an admission inquiry program and its unit set preference — rather than a durable hub or satellite.

Key Information Stored

The table is documented with 17 columns in the 12.1.1 physical schema. The most operationally significant are:

• INTERFACE_INQ_PRGUNT_ID — Surrogate primary key of the interface row, backed by unique index IGS_AD_INQ_PRUNT_INT_U1 and constraint IGS_AD_INQ_PRUNT_INT_PK. This is the documented business-key candidate and the join driver for all downstream processing.
• INTERFACE_INQ_PRG_ID — Foreign key to IGS_AD_INQ_PRG_INT, tying each unit set record to its parent admission inquiry program interface row.
• UNIT_SET_CODE_ID — Identifier of the unit set (subject grouping) associated with the program preference.
• UNIT_SET_PREFERENCE — The applicant's ranking or preference order for the unit set.
• DUP_INQ_PRG_PREF_USET_ID — Reference used to detect or tag duplicate program/unit-set preferences.
• STATUS, MATCH_IND, ERROR_CODE — Interface processing state, match flag against existing records, and error diagnostic code.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent request and program tracking for the batch that loaded the row.

Common Use Cases and Queries

Because the object is obsolete, use cases center on auditing historical loads and reconciling residual interface data. Typical patterns include defect investigation, migration cleanup, and reporting on purge candidates.

SELECT t.interface_inq_prgunt_id,
       t.interface_inq_prg_id,
       t.unit_set_code_id,
       t.unit_set_preference,
       t.status,
       t.error_code
FROM   igs.igs_ad_inq_prunt_int t
WHERE  t.status = 'ERROR'
ORDER BY t.creation_date DESC;

Joining to the parent interface table identifies incomplete program/unit-set combinations awaiting resolution:

SELECT p.interface_inq_prg_id,
       u.unit_set_code_id,
       u.unit_set_preference
FROM   igs.igs_ad_inq_prg_int p,
       igs.igs_ad_inq_prunt_int u
WHERE  p.interface_inq_prg_id = u.interface_inq_prg_id
AND    u.match_ind IS NULL;

Related Objects

• IGS_AD_INQ_PRG_INT — Parent interface table referenced through INTERFACE_INQ_PRG_ID; the primary join partner for program-level inquiry data.
• IGS_AD_INQ_PRUNT_INT_PK / IGS_AD_INQ_PRUNT_INT_U1 — Primary key constraint and unique index on INTERFACE_INQ_PRGUNT_ID.
• Downstream admission inquiry base tables in the IGS schema that consume validated interface rows once staging completes.
• Concurrent program and request metadata referenced via PROGRAM_ID, REQUEST_ID, and PROGRAM_APPLICATION_ID.
• Unit set definition tables supplying UNIT_SET_CODE_ID values.