Search Results igs_ad_admde_int_all_u1

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

Overview

IGS.IGS_AD_ADMDE_INT_ALL is a public, active interface table within the Oracle E-Business Suite (EBS) IGS (Student Systems / Advanced Placement) product schema. Its display name, "Import Admission Decision," accurately describes its function: it is the staging area for admission decision records that the Automatic Batch Admission Decisions Import process subsequently moves into the permanent application-instance table, IGS_AD_PS_APPL_INST_ALL. The table is classified under the business entity IGS_ADM_APPLICATION and resides in the APPS_TS_INTERFACE tablespace, which is the conventional location for EBS interface/staging objects.

From a data-modeling perspective, the metadata tags this object as standalone based on its foreign-key structure, with no documented parent-child relationships to other tables. In Data Vault terms, this renders it effectively a standalone hub-like or staging structure rather than a true link. Each row represents one admission-decision detail for a single application instance, keyed uniquely by INTERFACE_MKDES_ID. Because it is an interface table, records are transient by nature: they are populated by an external or batch source, validated and processed by the import concurrent program, and then either migrated into the production application tables or flagged with an error for correction and reprocessing.

Key Information Stored

The table comprises 29 documented columns. The most operationally significant are:

• INTERFACE_MKDES_ID — the surrogate unique identifier and leading column of the primary key (IGS_AD_ADMDE_INT_PK) and of the unique index IGS_AD_ADMDE_INT_ALL_U1. This is the definitive per-row business-key candidate for uniquely identifying a staging record.
• INTERFACE_RUN_ID — identifies the batch process run that generated the automatic decision-making records.
• BATCH_ID — the batch process identifier; indexed non-uniquely by IGS_AD_ADMDE_INT_ALL_N1 for batch-scoped retrieval.
• PERSON_ID — the person (applicant) identifier, part of the composite non-unique index IGS_AD_ADMDE_INT_ALL_N2.
• ADMISSION_APPL_NUMBER and SEQUENCE_NUMBER — the admission application number and the application-instance sequence, which together identify the target application row; both participate in index N2.
• NOMINATED_COURSE_CD — the program code applied for, also in index N2.
• ADM_OUTCOME_STATUS — the outcome status of the admission application.
• DECISION_MAKE_ID, DECISION_DATE, and DECISION_REASON_ID — the decisioning authority, decision timestamp, and decision rationale.
• PENDING_REASON_ID — reason an application remains pending.
• OFFER_DT and OFFER_RESPONSE_DT — offer issue date and the applicant's response deadline.
• ERROR_CODE and ERROR_TEXT — validation failures captured for rejected interface rows.
• Standard EBS who-columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, ORG_ID, and RECONSIDER_FLAG.

Common Use Cases and Queries

Typical usage centers on staging validation, batch monitoring, and reconciliation prior to import. Common patterns include:

• Listing failed rows for a given batch for correction: SELECT INTERFACE_MKDES_ID, PERSON_ID, ADMISSION_APPL_NUMBER, ERROR_CODE, ERROR_TEXT FROM IGS.IGS_AD_ADMDE_INT_ALL WHERE ERROR_CODE IS NOT NULL AND BATCH_ID = :batch;
• Counting staged decisions per run: SELECT INTERFACE_RUN_ID, COUNT(*) FROM IGS.IGS_AD_ADMDE_INT_ALL GROUP BY INTERFACE_RUN_ID;
• Joining to IGS_AD_PS_APPL_INST_ALL on PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, and SEQUENCE_NUMBER to reconcile staged versus posted decisions.
• Reporting pending versus offered applications using PENDING_REASON_ID, OFFER_DT, and OFFER_RESPONSE_DT.

Related Objects

• IGS_AD_PS_APPL_INST_ALL — the target table into which validated rows are imported, matched on application instance identity columns.
• IGS_AD_ADMDE_INT_PK — the primary-key constraint on INTERFACE_MKDES_ID.
• IGS_AD_ADMDE_INT_ALL_U1 — the unique constraint/index enforcing uniqueness on INTERFACE_MKDES_ID (the object referenced in the user's search).
• IGS_AD_ADMDE_INT_ALL_N1 / _N2 — non-unique indexes supporting batch and applicant lookups.
• Reference lookups for decision reasons (DECISION_REASON_ID) and pending reasons (PENDING_REASON_ID), and person records keyed by PERSON_ID.

Although no enforced foreign keys are documented, the table is logically bound to the application, person, and program entities it stages data for.