Search Results igs_pr_s_crv_prg_con

Overview

The IGS_PR_S_CRV_PRG_CON table is a configuration entity within the Oracle E-Business Suite Student System (IGS), specifically for releases 12.1.1 and 12.2.2. It is designated as obsolete, indicating its functionality may be deprecated or replaced in later versions. The table's primary role is to store system configuration parameters for a specific course version. Its critical function is to provide a granular level of configuration override; when a record exists for a given course version, it supersedes the default system-wide or broader organizational unit-level configuration values that would otherwise apply. This allows for tailored administrative rules and date-driven processes at the individual course level.

Key Information Stored

The table's structure is centered on identifying a course version and its associated override parameters. The primary key is a composite of COURSE_CD and VERSION_NUMBER, which uniquely identifies the course version being configured. The core data consists of several date alias columns that link to the IGS_CA_DA (Calendar Date Alias) table. These aliases define key milestone dates for the course's progression rules. Based on the foreign key relationships, the significant columns include APPEAL_CUTOFF_DT_ALIAS, END_BENEFIT_DT_ALIAS, SHOW_CAUSE_CUTOFF_DT_ALIAS, APPLY_END_DT_ALIAS, END_PENALTY_DT_ALIAS, and APPLY_START_DT_ALIAS. Each stores a reference to a calendar date alias, effectively allowing the institution to control critical deadlines for appeals, benefits, show-cause submissions, and application windows on a per-course basis.

Common Use Cases and Queries

The primary use case is querying the active configuration for a specific course version to determine which rules and dates govern student progression, appeals, and enrollment. A typical query would join this table with the course version (IGS_PS_VER_ALL) and date alias (IGS_CA_DA) tables to translate the stored aliases into actual dates for a given calendar. For reporting, it is used to audit which course versions have custom configurations versus those inheriting defaults. A sample SQL pattern to retrieve all configuration overrides for a course would be:

• SELECT crv_conf.*, da.MEANING FROM IGS_PR_S_CRV_PRG_CON crv_conf JOIN IGS_CA_DA da ON crv_conf.APPEAL_CUTOFF_DT_ALIAS = da.DT_ALIAS WHERE crv_conf.COURSE_CD = '&course_code';

Administrative processes for student progression, academic standing, and penalty application would reference this table to fetch the applicable rules for a student's enrolled course version.

Related Objects

This table is integral to a small network of objects within the Student System. Its existence is fundamentally tied to a valid course version, enforced by a foreign key to IGS_PS_VER_ALL. All date-related configuration points are references to the IGS_CA_DA table. Furthermore, the table has a direct child relationship with IGS_PR_S_CRV_PRG_CAL, which likely stores calendar-specific progression details that further depend on this parent configuration record. The metadata explicitly states the table was "Not implemented in this database," which may refer to a specific reference instance, but its defined relationships clarify its intended position in the data model for implementations where it is active.