Search Results igs_pr_s_prg_conf




Overview
Explore in AI Chat

Overview

The IGS_PR_S_PRG_CONF table is a core configuration entity within the Oracle E-Business Suite Student System (IGS), specifically designed for managing student academic progression. Its primary role is to define the system-wide default rules and parameters governing progression processes. These defaults establish a baseline configuration that can be overridden at more granular levels, such as for specific organizational units or course versions, thereby enabling a flexible, hierarchical configuration model. As indicated by its "Obsolete" status in the provided ETRM metadata, this table and its associated functionality are part of a legacy student system module that is no longer under active development in the standard Oracle EBS roadmap for versions 12.1.1 and 12.2.2. Its presence in a database indicates a historical implementation of the IGS product.

Key Information Stored

The table's central function is to store alias references to key academic calendar dates that control the progression lifecycle. This is achieved through a series of date alias columns, each linked to the IGS_CA_DA (Calendar Date Alias) table via foreign keys. The primary key is a single column, S_CONTROL_NUM. The critical configuration data includes date aliases for: the APPEAL_CUTOFF_DT, SHOW_CAUSE_CUTOFF_DT, and various milestone dates such as APPLY_START_DT, APPLY_END_DT, EFFECTIVE_END_DT, END_BENEFIT_DT, and END_PENALTY_DT. By storing calendar aliases instead of fixed dates, the system ensures that progression rules automatically align with the active academic calendar, providing annual consistency without manual reconfiguration.

Common Use Cases and Queries

The primary use case is the centralized retrieval of default progression calendar settings for runtime processing and administrative reporting. A typical query would join IGS_PR_S_PRG_CONF with IGS_CA_DA to resolve date aliases into actual calendar dates for the current cycle. For example, to determine the current appeal deadline, a query would select the actual date value corresponding to the APPEAL_CUTOFF_DT_ALIAS. This configuration is essential for batch processes that evaluate student standing, generate progression letters, or enforce deadlines for applications and appeals. Reporting use cases include auditing the system's default configuration and comparing it against organizational unit-level overrides to ensure policy compliance.

Related Objects

This table sits at the center of a small configuration hierarchy. Its main relationships are defined by foreign key constraints. It is heavily dependent on the IGS_CA_DA table to resolve all its date alias columns into concrete dates. In turn, IGS_PR_S_PRG_CONF is a parent table to IGS_PR_S_PRG_CAL (Progression Calendar), linked via the S_CONTROL_NUM primary key. This relationship suggests that the system-wide configuration in IGS_PR_S_PRG_CONF can spawn or be associated with specific procedural calendars. Given its configuration nature, it is likely referenced by various progression engine packages and possibly by views that present a consolidated set of progression rules for end-users.