Search Results igs_pr_s_crv_prg_cal

Overview

The table IGS_PR_S_CRV_PRG_CAL is a configuration entity within the Oracle E-Business Suite's Student System (IGS), specifically for versions 12.1.1 and 12.2.2. It serves as a critical junction for defining progression calendar settings at the program version level. Its primary role is to establish which progression calendars are applicable to specific academic programs (courses) and their versions. This configuration is mandatory; any progression rules defined within a calendar are only considered for evaluation if the calendar is explicitly linked to a program version via this table. The metadata indicates this component is marked as obsolete, and it was not implemented in the referenced database instance, suggesting it may be part of a legacy or deprecated data model within the Student System.

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the core data it holds. The key columns are COURSE_CD, representing the unique code for an academic program or course; VERSION_NUMBER, indicating the specific version of that program; and PRG_CAL_TYPE, which stores the type of progression calendar being assigned. This combination ensures a unique configuration entry per program version and calendar type. The table does not store calendar instance details (like dates) but rather the high-level authorization linking a program to a specific category of progression calendar, enabling the system to know which set of progression rules to apply.

Common Use Cases and Queries

The primary use case is administrative setup and validation during student progression processing. A system administrator would use this table to configure or verify which progression calendars are active for a given program. Common queries would involve joining to the course and calendar type tables to generate configuration reports. For instance, to list all program versions configured with a specific progression calendar type, one might use a query such as: SELECT crv.course_cd, crv.version_number, ct.cal_type FROM igs_pr_s_crv_prg_cal crv JOIN igs_ca_type ct ON crv.prg_cal_type = ct.cal_type WHERE crv.prg_cal_type = '<CALENDAR_TYPE_CODE>';. Another typical query would retrieve the full configuration for a specific program: SELECT * FROM igs_pr_s_crv_prg_cal WHERE course_cd = '<COURSE_CODE>' AND version_number = <VERSION_NUM>;.

Related Objects

IGS_PR_S_CRV_PRG_CAL maintains defined foreign key relationships with two core tables in the Student System, as per the provided metadata:

• IGS_CA_TYPE: The column PRG_CAL_TYPE references IGS_CA_TYPE. This validates that the configured progression calendar type is a legitimate calendar type within the system.
• IGS_PR_S_CRV_PRG_CON: The columns COURSE_CD and VERSION_NUMBER together reference IGS_PR_S_CRV_PRG_CON. This links the calendar configuration to a specific program version record, ensuring the program exists within the progression control framework.

These relationships enforce data integrity, ensuring that calendar configurations are only created for valid program versions and calendar types.