Search Results unit_discont_dt_alias

Overview

The table IGS_PS_UNIT_DISC_CRT is a core entity within the Oracle E-Business Suite Student System (IGS), specifically in releases 12.1.1 and 12.2.2. It is designed to manage the criteria governing when a student can formally discontinue from a unit of study within a defined teaching period calendar instance. This table plays a critical administrative role in enforcing academic policy by linking the permissible unit discontinuation action to specific calendar dates and student statuses. It serves as a configuration and control point, ensuring that discontinuations are processed according to institutional rules tied to the academic calendar.

Key Information Stored

The table's primary function is to define the relationship between a calendar alias for a discontinuation date and the associated administrative status. The primary key is the UNIT_DISCONT_DT_ALIAS column, which stores a unique identifier referencing a specific date alias within the academic calendar (IGS_CA_DA). A second critical column is ADMINISTRATIVE_UNIT_STATUS, which holds a code linking to a valid administrative unit status (IGS_AD_ADM_UNIT_STAT_ALL). This structure essentially creates a rule: for a given discontinuation date alias, what is the resulting administrative status for the student's unit attempt. Other supporting columns, while not detailed in the provided metadata, would typically include creation and last update dates, and potentially sequence or versioning information.

Common Use Cases and Queries

This table is central to processes that validate or apply a unit discontinuation. A common use case is when a student requests to drop a unit; the system will query this table to determine if the current date falls within the valid discontinuation period for the teaching period and, if so, what final administrative status (e.g., "Discontinued - Penalty", "Discontinued - No Penalty") should be applied. A typical reporting query might join this table to the calendar date alias and status tables to list all configured discontinuation rules for an academic period.

SELECT udc.unit_discont_dt_alias,
       da.description AS date_alias_desc,
       udc.administrative_unit_status,
       aus.meaning AS status_meaning
FROM igs.igs_ps_unit_disc_crt udc,
     igs.igs_ca_da da,
     igs.igs_ad_adm_unit_stat_all aus
WHERE udc.unit_discont_dt_alias = da.dt_alias
AND udc.administrative_unit_status = aus.administrative_unit_status;

Related Objects

The table maintains defined foreign key relationships with two other key entities in the Student System, ensuring referential integrity and enabling critical joins.

• IGS_CA_DA (Date Alias): The primary key and a foreign key, UNIT_DISCONT_DT_ALIAS, references this table. This join retrieves the actual calendar date(s) associated with the discontinuation rule.
• IGS_AD_ADM_UNIT_STAT_ALL (Administrative Unit Status): The foreign key column ADMINISTRATIVE_UNIT_STATUS references this table. This join provides the descriptive meaning and validity of the status code to be applied upon discontinuation.

These relationships position IGS_PS_UNIT_DISC_CRT as a pivotal link between the academic calendar (IGS_CA_DA) and student enrollment statuses (IGS_AD_ADM_UNIT_STAT_ALL).