Search Results end_penalty_dt_alias

Overview

The IGS_PR_S_CRV_PRG_CON table is a core configuration table within the Oracle E-Business Suite (EBS) Student System, specifically for the Progression module. Its primary role is to store program-version-specific parameters that govern the automatic application of academic progression rules. When a record exists for a specific program and version, it overrides any system-wide defaults or organizational unit-level values, enabling precise control over progression processing timelines for different academic offerings. This table is critical for defining the progression calendar's key dates via date aliases, which are symbolic names mapped to specific calendar dates.

Key Information Stored

The table's structure centers on a unique program version identifier and a series of date alias parameters. The composite primary key consists of COURSE_CD (the program code) and VERSION_NUMBER. The most significant columns are the date alias fields, which define the progression processing windows. As referenced in the user's search for "apply_end_dt_alias", the APPLY_END_DT_ALIAS column specifies the last date a student's program attempt can be automatically checked for the first time within a progression period. Other critical alias columns include APPLY_START_DT_ALIAS, END_BENEFIT_DT_ALIAS, END_PENALTY_DT_ALIAS, APPEAL_CUTOFF_DT_ALIAS, and SHOW_CAUSE_CUTOFF_DT_ALIAS. These aliases link to a progression calendar to determine the actual dates for starting checks, finalizing penalties or benefits, and submitting appeals.

Common Use Cases and Queries

A primary use case is retrieving the complete set of progression rules for a specific program to configure or validate the progression calendar in the application. Administrators often query this table to audit which programs have custom progression rules defined versus those relying on system defaults. The non-unique indexes, such as IGS_PR_S_CRV_PRG_CON_N4 on APPLY_END_DT_ALIAS, are optimized for queries filtering by these parameters. A typical reporting query would join this table with the date alias and calendar tables to resolve the alias names into concrete dates for a given progression period.

SELECT course_cd,
       version_number,
       apply_start_dt_alias,
       apply_end_dt_alias,
       end_benefit_dt_alias
  FROM igs.igs_pr_s_crv_prg_con
 WHERE course_cd = 'BSC_COMP'
   AND version_number = 2022;

Another common operational query involves identifying all program versions that use a particular date alias, which is useful when a calendar date alias needs to be updated globally.

Related Objects

This configuration table is intrinsically linked to several other EBS objects. It is directly referenced by the progression engine logic, likely within packages that apply rules automatically. The date alias columns (APPLY_END_DT_ALIAS, etc.) functionally depend on the institution's date alias setup, typically stored in tables like IGS_CA_DA_INST. The table's unique index (U1) enforces the one-to-one relationship between a configuration record and a program version, which would be defined in core program tables such as IGS_PS_VER. The progression rules and outcomes for individual students, stored in tables like IGS_PR_STU_CUR_PRG, are processed according to the timelines defined in IGS_PR_S_CRV_PRG_CON.