Results for “igs_ad_cal_conf”

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

Overview

IGS_AD_CAL_CONF is a configuration table within the Oracle E-Business Suite IGS (Student System) product family, which is classified as obsolete in the ETRM documentation set. The table stores date aliases required for Admissions processing. In the Oracle Student System model, admissions cycles are driven by academic calendars built from calendar types and calendar date aliases rather than hard-coded dates, and IGS_AD_CAL_CONF provides the central mapping that binds a specific admissions configuration record to the aliases that represent key milestones such as application start, due date, and final decision dates. This indirection allows institutions to redefine the actual dates behind a milestone within the calendar infrastructure without changing admissions configuration logic.

The documented schema confirms an owner of IGS and twenty columns in release 12.1.1. The table is described as not implemented in the reference database, which reflects its obsolete status, but the physical metadata and foreign key structure remain documented. Heuristically, and based on the foreign key structure mined from ETRM, this object is best modeled as a link in a Data Vault sense: it is dominated by foreign key references to calendar types and calendar date aliases, with a single control number primary key acting as a surrogate, and it exists to associate those referenced entities rather than to hold descriptive transactional state.

Key Information Stored

The primary key is defined by the unique index IGS_AD_CAL_CONF_PK on the column S_CONTROL_NUM, which functions as the surrogate identifier for each configuration row. This is the only documented business-key candidate; no composite natural key is recorded in the ETRM metadata.

The most significant business columns are the date alias references, each pointing to the IGS_CA_DA calendar date alias table:

• INQ_CAL_TYPE — references IGS_CA_TYPE, tying the configuration to a calendar type used for enquiry processing.
• ADM_APPL_COURSE_STRT_DT_ALIAS and ADM_APPL_SHORT_STRT_DT_ALIAS — aliases for course and short application start dates.
• ADM_APPL_DUE_DT_ALIAS and ADM_APPL_FINAL_DT_ALIAS — submission deadline and final decision date aliases.
• ADM_APPL_ENCMB_CHK_DT_ALIAS — encumbrance check date alias.
• ADM_APPL_CHNG_OF_PREF_DT_ALIAS and ADM_APPL_OFFER_RESP_DT_ALIAS — change-of-preference and offer response date aliases.
• ADM_APPL_E_COMP_PERD_DT_ALIAS, ADM_APPL_M_COMP_PERD_DT_ALIAS, and ADM_APPL_S_COMP_PERD_DT_ALIAS — extended, main, and short competitive period date aliases.
• INITIALISE_ADM_PERD_DT_ALIAS — alias used to initialise the admissions period.
• ADM_PRC_TRK_DT_ALIAS and POST_ADM_TRK_DT_ALIAS — tracking aliases for admissions processing and post-admissions activity.

Standard WHO audit columns are present: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. All of the alias columns carry foreign keys to IGS_CA_DA, and INQ_CAL_TYPE is the sole reference to IGS_CA_TYPE.

Common Use Cases and Queries

Although the object is obsolete and not implemented in the documented database, the reporting patterns that surrounded it remain instructive for historical data extraction or migration. A typical query resolves the alias references to their underlying dates:

• Joining IGS_AD_CAL_CONF to IGS_CA_DA on each alias column to produce a human-readable admissions milestone report for a given calendar type.
• Auditing configuration completeness by checking for nulls across the alias columns for each S_CONTROL_NUM.
• Extracting control-number-level configuration into a target system during upgrade or decommissioning, preserving the calendar type context for reconciliation.

A representative join pattern is:

• SELECT c.S_CONTROL_NUM, d1.ALIAS_NAME, d1.START_DATE FROM IGS_AD_CAL_CONF c, IGS_CA_DA d1 WHERE c.ADM_APPL_DUE_DT_ALIAS = d1.ALIAS_NAME;
• SELECT c.S_CONTROL_NUM, t.CAL_TYPE FROM IGS_AD_CAL_CONF c, IGS_CA_TYPE t WHERE c.INQ_CAL_TYPE = t.CAL_TYPE;

Related Objects

The most significant related objects are the referenced calendar tables and the dependent admissions configuration consumers:

• IGS_CA_TYPE — joined via IGS_AD_CAL_CONF.INQ_CAL_TYPE; defines the calendar type context for the configuration.
• IGS_CA_DA — referenced by eleven alias columns, including ADM_APPL_DUE_DT_ALIAS, ADM_APPL_FINAL_DT_ALIAS, and INITIALISE_ADM_PERD_DT_ALIAS; supplies the actual date and alias definitions.
• IGS_AD_CAL_CONF_PK — the unique index enforcing the S_CONTROL_NUM surrogate key and supporting lookups by control number.
• Admissions configuration and processing objects — IGS admissions setups that read these aliases to drive application windows, offer response tracking, and period initialisation, and which are expected to join on the alias columns rather than on S_CONTROL_NUM directly.