Search Results schedule_open_dt_alias

Overview

The IGS_EN_CAL_CONF table is a core configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Student Administration (Oracle Campus Solutions) module. Owned by the IGS schema, its primary function is to define institution-specific date aliases that serve as default values in student records and control the execution of key academic processes. The table is designed to hold a single configuration record, enforced by the S_CONTROL_NUM column, which centralizes critical calendar-driven business rules for enrollment, commencement, and record management.

Key Information Stored

The table's columns are predominantly VARCHAR2 fields that store date alias codes. These aliases reference specific dates within academic calendars (e.g., teaching periods). Key columns include S_CONTROL_NUM, which must always be 1, and numerous date alias columns such as COMMENCE_CUTOFF_DT_ALIAS, RECORD_OPEN_DT_ALIAS, and RECORD_CUTOFF_DT_ALIAS. Based on the user's search for "planning_open_dt_alias," it is noteworthy that this specific column is not listed in the provided metadata. The documented columns relevant to planning and enrollment operations include ENR_FORM_DUE_DT_ALIAS, ENR_PCKG_PROD_DT_ALIAS, and EFFECT_ENR_STRT_DT_ALIAS, which manage form due dates, package production, and effective enrollment start dates, respectively.

Common Use Cases and Queries

This table is essential for processes that require dynamic date determination. For instance, a batch job controlling when student enrollment records are opened or closed would query the RECORD_OPEN_DT_ALIAS and RECORD_CUTOFF_DT_ALIAS to resolve the actual calendar date for the current period. A common reporting use case is to join this table with calendar date tables to translate aliases into real dates for administrative dashboards. A sample query to retrieve all configured aliases would be:

• SELECT commence_cutoff_dt_alias, record_open_dt_alias, enr_form_due_dt_alias FROM igs.igs_en_cal_conf WHERE s_control_num = 1;

Technical consultants often reference this table when troubleshooting why certain enrollment or commencement processes are not activating as expected, verifying that the configured date aliases correspond to valid, active calendar dates.

Related Objects

The IGS_EN_CAL_CONF table is a referenced parent table, as indicated by its numerous non-unique indexes. While explicit foreign key relationships are not detailed in the metadata, the indexes imply that columns like SUB_UNIT_DT_ALIAS, LOAD_EFFECT_DT_ALIAS, and ENROLLED_RULE_CUTOFF_DT_ALIAS are likely foreign keys referencing a calendar date alias master table (potentially IGS_CA_DA_INST). The unique index IGS_EN_CAL_CONF_U1 on S_CONTROL_NUM enforces the singleton record. This configuration record is centrally accessed by various enrollment and calendar-related packages and forms within the IGS schema to govern process timing.