Search Results igs_pr_s_prg_cal




Overview
Explore in AI Chat

Overview

The IGS_PR_S_PRG_CAL table is a core configuration table within the Oracle E-Business Suite Student System (IGS) module. It serves as the master repository for defining standard progression calendar configurations. A progression calendar is a critical framework that governs the timing and rules for evaluating student academic performance, such as probation or disqualification reviews. The table's primary role is to establish these calendar definitions at a system-wide level, which can then be inherited or overridden at more granular organizational units or specific course versions. As per the official documentation, all progression calendars must be established in this table (or its related organizational or course-level overrides) for the rules defined within those calendars to be considered and executed by the system.

Key Information Stored

The table stores the foundational attributes that define a progression calendar's structure and applicability. While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its essential structure. The primary key is a composite of S_CONTROL_NUM and PRG_CAL_TYPE. The S_CONTROL_NUM acts as a foreign key linking to the IGS_PR_S_PRG_CONF table, which holds the broader progression configuration setup. The PRG_CAL_TYPE is a foreign key referencing the IGS_CA_TYPE table, defining the type of calendar (e.g., semester, trimester, quarter) used for the progression cycle. Other typical columns in such a table would include data to control the calendar's active status, effective dates, description, and parameters defining the assessment periods within the academic cycle.

Common Use Cases and Queries

This table is primarily accessed for setup, maintenance, and reporting of the progression engine's scheduling component. Common functional use cases include creating a new progression calendar for a new academic program, modifying assessment periods for an existing calendar, or inactivating a calendar that is no longer in use. From a reporting and query perspective, administrators often need to list all configured calendars or diagnose why progression rules are not firing for a specific student cohort. A typical SQL query would join this table to its related configuration and type tables to present a comprehensive view.

SELECT pc.s_control_num,
       pc.prg_cal_type,
       ct.s_cal_type,
       pc.description
FROM igs.igs_pr_s_prg_cal pc,
     igs.igs_ca_type ct
WHERE pc.prg_cal_type = ct.cal_type
  AND pc.cal_status = 'ACTIVE';

Related Objects

The IGS_PR_S_PRG_CAL table is central to a network of objects within the Student System's progression subsystem. Its key relationships, as documented, are:

  • IGS_PR_S_PRG_CONF: This is the parent configuration table. The S_CONTROL_NUM foreign key establishes that a progression calendar is a component of a larger progression configuration setup.
  • IGS_CA_TYPE: This table provides the valid list of calendar types (e.g., 'SEMESTER', 'QUARTER') via the PRG_CAL_TYPE foreign key, ensuring data integrity for the calendar's temporal structure.

Additionally, this table is logically a parent to objects that define specific rules (like probation thresholds) assigned to a calendar and to operational tables that track student-specific progression outcomes against these defined calendars.