Search Results effective_end_dt_alias

Overview

The IGS_RE_S_RES_CAL_CON table is a core configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Global Systems (IGS) module. It stores system-level configuration for research calendar calculations. Its primary role is to define the date aliases used to determine the duration of a research teaching period. By storing aliases for effective start and end dates, this table enables the system to dynamically calculate equivalent full-time days for research activities based on the actual calendar dates referenced by those aliases, providing flexibility in managing diverse academic calendars.

Key Information Stored

The table is structurally simple but critical for date-driven research calculations. The key columns are:

• S_CONTROL_NUM (NUMBER): A mandatory, unique identifier for each research calendar configuration record. It is the primary key, enforced by the unique index IGS_RE_S_RES_CAL_CON_U1.
• EFFECTIVE_STRT_DT_ALIAS (VARCHAR2(10)): Stores the alias (a short code) pointing to the effective start date of a research teaching calendar. This column is indexed (IGS_RE_S_RES_CAL_CON_N1) for performance.
• EFFECTIVE_END_DT_ALIAS (VARCHAR2(10)): Stores the alias for the corresponding effective end date. As noted in the user's search context, this column is central to calculating the period's length and is also indexed (IGS_RE_S_RES_CAL_CON_N2). The number of equivalent full-time days is derived from the days between the dates these two aliases represent.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Track the audit trail for record creation and modification.

Common Use Cases and Queries

This table is primarily used in backend processes for configuring and interpreting research calendar periods. A common use case is during the setup of a research program or when generating reports on research load, where the system must resolve the date aliases to actual calendar dates to compute durations. Administrators may query this table to audit or verify the current calendar configuration. The fundamental query, as provided in the ETRM, is:

SELECT S_CONTROL_NUM,
       EFFECTIVE_STRT_DT_ALIAS,
       EFFECTIVE_END_DT_ALIAS,
       CREATION_DATE
FROM IGS.IGS_RE_S_RES_CAL_CON;

A more advanced reporting query might join this table to a date alias master table (not specified in the provided metadata) to resolve the aliases into actual dates for display or calculation purposes. Troubleshooting often involves verifying the values in the EFFECTIVE_END_DT_ALIAS column if research period calculations are incorrect.

Related Objects

Based on the provided dependency information, the IGS_RE_S_RES_CAL_CON table is a referenced object. It is listed as being referenced by the APPS schema synonym named IGS_RE_S_RES_CAL_CON. This indicates that application code within the EBS suite accesses this table via the public synonym. The metadata states the table does not itself reference other objects, confirming it is a standalone configuration point. The unique index on S_CONTROL_NUM (IGS_RE_S_RES_CAL_CON_U1) suggests this column is likely referenced by foreign keys in other, dependent research tables (though not explicitly listed in the excerpt), which would store specific calendar instances linked to this configuration.