Search Results igs_ge_s_gen_cal_con




Overview
Explore in AI Chat

Overview

The table IGS_GE_S_GEN_CAL_CON is a Student System (IGS) object in Oracle E-Business Suite 12.1.1 and 12.2.2. It is documented as obsolete within the ETRM reference set and is recorded as not implemented in this database. Its purpose, as described by the metadata, is to describe the date alias representing the cutoff date and the teaching period census for an academic period. In other words, the table acts as a control or configuration record that ties a given academic calendar entry to the date aliases that govern census processing and course completion cutoff logic.

From a data-modeling perspective, the mined heuristic classification for this object is a link. This is a suggestion rather than a fixed fact: the table contains no descriptive measure columns beyond audit fields, and it holds foreign-key references to other calendar-related structures. Such a shape is consistent with a join or association table that resolves relationships between academic periods, date aliases, and their control numbers.

Key Information Stored

The documented physical schema for 12.1.1 lists eight columns. The most functionally significant are described below:

Notably, the table contains no explicit academic-period key column in the documented column list; the association to a period is implied by the control number and by the relationship to the calendar and date-alias structures.

Common Use Cases and Queries

Because the object is obsolete and not implemented, production queries against it are unlikely. However, when working with legacy or migrated IGS data, the following patterns are representative.

  • Resolving the census date alias for a control record:

    SELECT gcc.S_CONTROL_NUM, da.DATE_ALIAS, da.START_DATE, da.END_DATE
    FROM IGS_GE_S_GEN_CAL_CON gcc, IGS_CA_DA da
    WHERE gcc.CENSUS_DT_ALIAS = da.DATE_ALIAS;

  • Retrieving both the census and course completion cutoff aliases in a single pass:

    SELECT gcc.S_CONTROL_NUM,
    c.DATE_ALIAS AS CENSUS_ALIAS, k.DATE_ALIAS AS CUTOFF_ALIAS
    FROM IGS_GE_S_GEN_CAL_CON gcc, IGS_CA_DA c, IGS_CA_DA k
    WHERE gcc.CENSUS_DT_ALIAS = c.DATE_ALIAS
    AND gcc.CRS_COMPLETION_CUTOFF_DT_ALIAS = k.DATE_ALIAS;

  • Auditing changes to control records using the audit columns (LAST_UPDATED_BY, LAST_UPDATE_DATE).

Reporting use cases center on verifying that the census and cutoff aliases resolve to valid, non-conflicting dates before an academic period is activated — a validation step historically performed during calendar setup.

Related Objects

The ETRM relationship data identifies two foreign keys, both resolving to the date alias table. The most significant related objects are:

  • IGS_CA_DA — the date alias table referenced twice: once via IGS_GE_S_GEN_CAL_CON.CENSUS_DT_ALIAS and once via IGS_GE_S_GEN_CAL_CON.CRS_COMPLETION_CUTOFF_DT_ALIAS. This is the dominant dependency.
  • IGS_GE_S_GEN_CAL_CON_PK — the primary key unique index on S_CONTROL_NUM.
  • IGS_GE_S_GEN_CAL_CON_U1 — the unique index providing the business-key candidate on S_CONTROL_NUM.

No additional downstream referencing tables, views, or APIs are documented in the supplied metadata. Because the object is flagged obsolete, its dependent structures are likely also retired or replaced by newer academic calendar configuration entities within the IGS module.