Search Results igs_re_s_res_cal_con

Overview

The IGS_RE_S_RES_CAL_CON table is a core configuration entity within the Oracle E-Business Suite Student System (IGS) module. It serves as the central repository for defining and managing the system-level parameters of the research calendar. This table is critical for establishing the academic and administrative timeline framework used for research-related activities, such as candidature management, milestone tracking, and thesis submission windows. Its configuration directly influences how dates are calculated, validated, and presented across the research lifecycle, making it a foundational setup object for institutions using the EBS research functionality.

Key Information Stored

The table's primary structure is controlled by a single-column primary key, S_CONTROL_NUM, which uniquely identifies each configuration record. The most significant data points stored are the date aliases that define the calendar's operational boundaries. These are held in the EFFECTIVE_STRT_DT_ALIAS and EFFECTIVE_END_DT_ALIAS columns. These columns do not store actual dates but instead contain references (aliases) to specific date entries defined in the IGS_CA_DA (Date Alias) table. This design allows for dynamic and institution-specific configuration of the research calendar's effective start and end dates, enabling flexible academic year and period setups without hard-coded values.

Common Use Cases and Queries

A primary use case is the initial implementation and annual maintenance of the research calendar system. Administrators query this table to verify or update the current configuration. Common reporting needs involve joining to the date alias table to translate the aliases into actual calendar dates for procedural logic or user interfaces. A typical SQL pattern retrieves the full effective date range for the active configuration:

• SELECT cfg.s_control_num, da_start.absolute_val AS start_date, da_end.absolute_val AS end_date FROM igs_re_s_res_cal_con cfg JOIN igs_ca_da da_start ON cfg.effective_strt_dt_alias = da_start.alias JOIN igs_ca_da da_end ON cfg.effective_end_dt_alias = da_end.alias WHERE cfg.s_control_num = [CONTROL_NUMBER];

This configuration is also fundamental for batch processes and APIs that schedule research events, validate submission deadlines, or generate reports based on the academic research period.

Related Objects

The IGS_RE_S_RES_CAL_CON table has documented dependencies on the IGS_CA_DA (Date Alias) table via two foreign key relationships. These relationships are essential for resolving the configured date aliases into concrete values.

• IGS_CA_DA (via EFFECTIVE_STRT_DT_ALIAS): This foreign key links to the date alias table to obtain the actual calendar date defined as the research calendar's effective start date.
• IGS_CA_DA (via EFFECTIVE_END_DT_ALIAS): This foreign key links to the date alias table to obtain the actual calendar date defined as the research calendar's effective end date.

As a configuration table with a system-level scope, it is typically referenced by various program units and views within the Research (RE) submodule that require knowledge of the current academic timeline, rather than having other tables foreign-key to it.