Search Results igs_ad_cal_conf_n4

Overview

The IGS_AD_CAL_CONF table is a critical configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Admissions (IGS) module. It functions as a central repository for date aliases that control the timing of key admissions processes. Date aliases are symbolic names that map to specific calendar dates within the system's academic calendar structure, allowing for flexible and configurable scheduling. The table's role is to define the precise calendar events that trigger automated workflows, such as application deadline enforcement, offer response periods, and eligibility checks, thereby governing the entire admissions lifecycle. By design, it contains only a single configuration row, as indicated by the S_CONTROL_NUM column, making it a singleton table for global admissions calendar settings.

Key Information Stored

The table's columns are predominantly VARCHAR2 fields that store the date alias codes. The primary and mandatory column is S_CONTROL_NUM, which is a NUMBER always set to 1, enforcing the single-row constraint. The other columns are the configuration parameters themselves. Based on the provided metadata, key columns include ADM_APPL_CHNG_OF_PREF_DT_ALIAS (the date alias for when applicants may change course preferences), ADM_APPL_DUE_DT_ALIAS (application due date), and ADM_APPL_OFFER_RESP_DT_ALIAS (deadline for responding to offers). Other significant columns are ADM_APPL_ENCMB_CHK_DT_ALIAS for encumbrance checks, INITIALISE_ADM_PERD_DT_ALIAS for initializing new admission periods, and INQ_CAL_TYPE which defines the calendar type for inquiries.

Common Use Cases and Queries

The primary use case is the runtime resolution of these date aliases to actual calendar dates to validate applicant actions and trigger batch processes. For instance, when a user attempts to change a course preference, the system will query this table to get the alias, resolve it against the academic calendar, and compare it to the current date to permit or deny the action. A system administrator or developer might query this configuration to verify or report on settings. The non-unique indexes on each major date alias column, such as IGS_AD_CAL_CONF_N4 on ADM_APPL_CHNG_OF_PREF_DT_ALIAS, are optimized for these lookups.

Sample Query:
SELECT adm_appl_chng_of_pref_dt_alias,
adm_appl_due_dt_alias,
adm_appl_offer_resp_dt_alias
FROM igs.igs_ad_cal_conf
WHERE s_control_num = 1;

This configuration is fundamental for generating admissions timelines and deadline reports for administrative staff and applicants.

Related Objects

The IGS_AD_CAL_CONF table is integral to the Admissions module's data model. Its date alias values are resolved against academic calendar tables (likely such as IGS_CA_INST or related structures) to derive actual dates. The numerous non-unique indexes (N1 through N12) indicate heavy referencing by other application logic, likely within PL/SQL packages and forms that implement admissions workflows. While specific dependent objects are not listed in the metadata, it is a foundational table. Any program logic that checks if an application action is permissible based on a deadline will ultimately reference the aliases stored in this single configuration row. The table itself resides in the APPS_TS_TX_DATA tablespace with its indexes in APPS_TS_TX_IDX, aligning with standard EBS transactional table design.