Search Results end_benefit_dt_alias

Overview

The IGS_PR_S_PRG_CONF table is a core configuration table within the Oracle E-Business Suite (EBS) Student Administration (SA) module, specifically for the Progression functionality. It stores the system-wide default settings for academic progression rule processing. These defaults govern the timing and parameters for the automated evaluation of student progression status against defined academic rules. The configuration acts as a master template, which can be overridden at more granular levels, such as for specific organizational units or program versions, ensuring flexibility while maintaining a centralized control point.

Key Information Stored

The table is structured around a single control record and a series of date alias parameters that link progression logic to the academic calendar. The primary columns are:

• S_CONTROL_NUM (NUMBER): A unique identifier for the configuration record. As per the documentation, this value is always 1, indicating a singleton table meant to hold a single row of system configuration.
• APPEAL_CUTOFF_DT_ALIAS (VARCHAR2(10)): A critical column, as indicated by the user's search and its dedicated non-unique index (IGS_PR_S_PRG_CONF_N1). This stores a date alias that defines the final date by which a student can submit an appeal against a progression outcome within a given progression period.
• Other key date alias columns include APPLY_START_DT_ALIAS and APPLY_END_DT_ALIAS, which define the window for automatic rule application; EFFECTIVE_END_DT_ALIAS, which sets a cutoff for including academic results in a period; and aliases for show-cause, penalty, and benefit dates. Each of these has a corresponding non-unique index to support efficient querying.

Common Use Cases and Queries

The primary use case is to retrieve the system defaults for progression processing, often to apply them or compare them against organizational unit-specific overrides. A common query would fetch the single configuration row to obtain the date aliases used in runtime progression engine calculations. For example, to find the appeal cutoff date alias for reporting or integration purposes:

• SELECT appeal_cutoff_dt_alias, apply_start_dt_alias, apply_end_dt_alias FROM igs.igs_pr_s_prg_conf WHERE s_control_num = 1;

In practice, these date aliases are resolved against a progression calendar to determine actual dates. The table is also central during the setup and maintenance of progression rules, where administrators reference these aliases to understand the default timeline. Reporting on progression configuration across the institution would typically join this table with any overriding configuration tables at the program or unit level.

Related Objects

As a configuration table, IGS_PR_S_PRG_CONF is referenced by the progression processing engine and likely by various forms and APIs within the Progression subsystem. The presence of multiple indexes on date alias columns (e.g., IGS_PR_S_PRG_CONF_N1 on APPEAL_CUTOFF_DT_ALIAS) suggests these fields are frequently used in WHERE clauses, possibly in joins with calendar or student attempt tables. While the provided metadata does not list explicit foreign keys or dependencies, this table is foundational. Related objects would include tables storing organizational unit-specific progression configuration (which likely have a foreign key to S_CONTROL_NUM or similar design), progression calendar tables that store the actual dates for the aliases, and the core tables for progression rules and student progression outcomes.