Results for “routeb_pref”

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

Overview

The IGS_AD_APL_INT table is an interface (staging) table within the Oracle E-Business Suite Student System (IGS) product family. In Oracle EBS 12.1.1 and 12.2.2, it resides in the IGS schema and holds application details for a person pending validation, enrichment, or transfer into the core admissions tables. It functions as the landing zone for admissions application data received from external sources such as the Oracle Student System application processing engine, self-service portals, or third-party admissions systems before the data is committed to the permanent admissions model.

The physical implementation documented in ETRM for 12.1.1 comprises 33 columns, with the primary key enforced by the IGS_AD_APL_INT_PK index on INTERFACE_APPL_ID. From a Data Vault modeling perspective, the relationship metadata suggests this object is satellite-leaning. The column distribution and the presence of descriptive attributes such as application dates, fee amounts, and error tracking fields — rather than a pure set of foreign references — align with a satellite structure hanging off the interface run and interface header entities, rather than a standalone hub or link.

Key Information Stored

The table is anchored by the surrogate primary key INTERFACE_APPL_ID, which uniquely identifies each staged application record within an interface run. This is distinct from business-key candidates, as documented through the unique index IGS_AD_APL_INT_PK; the metadata identifies INTERFACE_APPL_ID as the single unique-key candidate, so no additional natural composite key is formally enforced.

The columns most significant for processing and reconciliation include:

• INTERFACE_ID — foreign key to IGS_AD_INTERFACE_ALL, grouping each application row under its parent interface run.
• INTERFACE_RUN_ID — ties the row to a specific execution of the interface process.
• PERSON_ID — links the staged application to the individual person record.
• APPL_DT — the application date captured from the source system.
• ADMISSION_APPL_NUMBER and UPDATE_ADM_APPL_NUMBER — the admissions application identifier and the flag or value used to control whether the identifier is updated on load.
• ACAD_CAL_TYPE and ACAD_CI_SEQUENCE_NUMBER — the academic calendar and calendar instance targeted by the application.
• ADM_CAL_TYPE and ADM_CI_SEQUENCE_NUMBER — the admissions calendar and instance for the application cycle.
• CHOICE_NUMBER and ROUTEB_PREF — the preference ordering of the application or program choice.
• ADMISSION_APPLICATION_TYPE and COMMON_APP — classification of the application and its source channel.
• APPL_FEE_AMT — the application fee amount staged for fee processing.
• ERROR_CODE, ERROR_TEXT, and MATCH_IND — validation outcome fields used to flag and describe rejected or matched rows.
• STATUS — the processing state of the staged record.
• Standard audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE support concurrency and concurrent-program traceability.

Common Use Cases and Queries

Typical uses center on monitoring, error resolution, and reconciliation of interface activity. A common pattern is to count staged rows per interface run and status:

SELECT INTERFACE_RUN_ID, STATUS, COUNT(*) FROM IGS.IGS_AD_APL_INT GROUP BY INTERFACE_RUN_ID, STATUS;

Error triage queries filter rows with populated ERROR_CODE or ERROR_TEXT to identify applications that failed validation before promotion. Reconciliation joins to IGS_AD_INTERFACE_ALL on INTERFACE_ID to confirm that staged applications belong to a valid, completed interface header. Reporting use cases include tracking application volumes by academic calendar and admission calendar, auditing application fee amounts, and verifying person-level application counts using PERSON_ID.

Related Objects

The table participates in a well-defined referential structure:

• IGS_AD_INTERFACE_ALL — parent interface header, joined via IGS_AD_APL_INT.INTERFACE_ID.
• IGS_AD_PS_APPL_INST_INT — references IGS_AD_APL_INT.INTERFACE_APPL_ID for application institution detail.
• IGS_AD_APPINT_INT — application program/intent detail referencing INTERFACE_APPL_ID.
• IGS_AD_APPHIST_INT — application history detail.
• IGS_AD_ACADINT_INT — academic interest detail.
• IGS_AD_FEE_INT — application fee detail linked to the staged application.
• IGS_AD_OTHINST_INT — other institution detail for transfer applications.
• IGS_AD_SPLINT_INT, IGS_AD_SPLTAL_INT, IGS_AD_PERSTMT_INT, and IGS_AD_ACADHONOR_INT_ALL — additional child interface tables, all joined on INTERFACE_APPL_ID.

These dependencies confirm that IGS_AD_APL_INT is the central application-level anchor within the admissions interface family, with downstream detail tables keyed to its primary key.