Search Results igs_en_cal_conf

Overview

The IGS_EN_CAL_CONF table is a core configuration entity within the Oracle E-Business Suite Student System (IGS). It functions as a central repository for institution-defined date aliases, which are symbolic references to specific calendar dates. These aliases are not dates themselves but are pointers to actual dates stored in the IGS_CA_DA (Date Alias) table. The primary role of this table is to provide default date values for various enrollment and academic records and to control the execution logic of critical student system processes. By externalizing these date references into a configuration table, the system allows for institutional flexibility and centralized management of key academic calendar milestones across modules in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by a single primary key, S_CONTROL_NUM, which typically acts as a unique identifier or control number for the configuration record. The majority of its columns are foreign key references to the IGS_CA_DA table, each representing a specific date alias used for a distinct business purpose. Key date alias columns include COMMENCEMENT_DT_ALIAS for the program start date, ENROLLED_RULE_CUTOFF_DT_ALIAS for deadlines in enrollment rule processing, RECORD_OPEN_DT_ALIAS and RECORD_CUTOFF_DT_ALIAS for controlling the open and close periods for recording enrollments, and LAPSE_DT_ALIAS for managing application or offer expiration. Each of these columns stores a code that corresponds to a defined date alias, decoupling the configuration from absolute calendar dates.

Common Use Cases and Queries

This table is essential for process automation and validation. A common use case is determining if the current date falls within an enrollment period by comparing the system date to the actual dates referenced by RECORD_OPEN_DT_ALIAS and RECORD_CUTOFF_DT_ALIAS. System batch processes, such as enrollment cleanup or fee assessment, will query the relevant date alias (e.g., ENR_CLEANUP_DT_ALIAS) to determine their effective run date. A typical reporting query involves joining IGS_EN_CAL_CONF to IGS_CA_DA to translate aliases into readable dates for administrative dashboards. For example:

• SELECT da.alias, da.description, da.cal_date FROM igs_en_cal_conf conf, igs_ca_da da WHERE conf.commencement_dt_alias = da.alias;

Administrators use this configuration to adjust academic timelines without modifying application code, ensuring processes like unit submission (SUB_UNIT_DT_ALIAS) or enrollment package production (ENR_PCKG_PROD_DT_ALIAS) trigger correctly.

Related Objects

The IGS_EN_CAL_CONF table has a fundamental dependency on the IGS_CA_DA (Date Alias) table, as documented by its extensive foreign key relationships. Every date alias column in IGS_EN_CAL_CONF references the IGS_CA_DA table. The documented foreign key relationships, with their corresponding join columns, are as follows:

• PLANNING_OPEN_DT_ALIAS → IGS_CA_DA
• SCHEDULE_OPEN_DT_ALIAS → IGS_CA_DA
• AUDIT_STATUS_DT_ALIAS → IGS_CA_DA
• ENR_CLEANUP_DT_ALIAS → IGS_CA_DA
• COMMENCEMENT_DT_ALIAS → IGS_CA_DA
• COMMENCE_CUTOFF_DT_ALIAS → IGS_CA_DA
• ENR_FORM_DUE_DT_ALIAS → IGS_CA_DA
• EFFECT_ENR_STRT_DT_ALIAS → IGS_CA_DA
• ENROLLED_RULE_CUTOFF_DT_ALIAS → IGS_CA_DA
• INVALID_RULE_CUTOFF_DT_ALIAS → IGS_CA_DA
• LAPSE_DT_ALIAS → IGS_CA_DA
• LOAD_EFFECT_DT_ALIAS → IGS_CA_DA
• ENR_PCKG_PROD_DT_ALIAS → IGS_CA_DA
• RECORD_CUTOFF_DT_ALIAS → IGS_CA_DA
• RECORD_OPEN_DT_ALIAS → IGS_CA_DA
• SUB_UNIT_DT_ALIAS → IGS_CA_DA
• VARIATION_CUTOFF_DT_ALIAS → IGS_CA_DA

This table is centrally referenced by numerous enrollment and academic administration processes and forms within the Student System, making it a critical configuration point.