Search Results igs_ps_unit_disc_crt_u1

Overview

The IGS_PS_UNIT_DISC_CRT table is a core configuration entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Student Management (Campus Solutions) module. It defines the business rules governing how a student's unit (course) attempt is administratively handled when it is discontinued within a specific teaching period calendar. The table maps specific discontinuation dates, represented by date aliases, to resulting administrative actions. These actions include applying a defined Administrative Unit Status (AUS) to the student's record or logically deleting the unit attempt from the system. This configuration ensures consistent and automated processing of unit discontinuations across the academic calendar.

Key Information Stored

The table stores criteria that link a discontinuation event to a system action. The primary and most critical column is UNIT_DISCONT_DT_ALIAS (VARCHAR2(10)), which holds the name of a date alias marking the threshold for applying the associated rule. The ADMINISTRATIVE_UNIT_STATUS (VARCHAR2(10)) column stores the code for the status to be applied to the unit attempt upon discontinuation on or after the specified date alias. Two key indicator columns control behavior: DELETE_IND specifies if the unit attempt should be logically deleted instead of receiving a status, and DFLT_IND designates the associated AUS as the default status for the given date, though it remains overrideable. Standard WHO columns (CREATED_BY, CREATION_DATE, etc.) track audit information.

Common Use Cases and Queries

A primary use case is configuring the academic calendar to automatically assign a status like "Withdrawn Fail" (WN) to units discontinued after the census date. Administrators query this table to review or audit the discontinuation rules for a teaching period. A common reporting need is to list all configured criteria with their corresponding statuses and default indicators. Sample SQL to retrieve this core configuration would be:

• SELECT unit_discont_dt_alias, administrative_unit_status, delete_ind, dflt_ind FROM igs.igs_ps_unit_disc_crt ORDER BY unit_discont_dt_alias;

For troubleshooting, one might join this table to the date alias (IGS_CA_DA) and AUS (IGS_AD_ADM_UNIT_STAT_ALL) tables to validate the existence of referenced values and ensure proper system behavior during batch discontinuation processes.

Related Objects

The IGS_PS_UNIT_DISC_CRT table maintains defined relationships with other key setup tables, primarily through foreign key constraints. The UNIT_DISCONT_DT_ALIAS column references the IGS_CA_DA (Date Alias) table to ensure the specified date alias is valid. The ADMINISTRATIVE_UNIT_STATUS column references the IGS_AD_ADM_UNIT_STAT_ALL table to validate the institution-defined administrative unit status code. The table's primary key is enforced by the unique index IGS_PS_UNIT_DISC_CRT_U1 on the UNIT_DISCONT_DT_ALIAS column, establishing it as the unique identifier for each discontinuation criterion record.