Search Results control_num

Overview

The IGS_PS_EXP_WL table is a configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Student Management (i.e., Campus Solutions) module. Owned by the IGS schema, its primary role is to store institutional-level setup data for defining the expected student workload within specific academic calendar categories. This table historically supported functionality for workload planning and reporting at a term or academic period level. However, based on the provided metadata, key functional columns within this table are now documented as obsolete or no longer used, indicating its active operational role in current implementations may be limited or reserved for historical reference.

Key Information Stored

The table's structure is relatively simple, consisting of configuration and standard audit columns. The core functional columns are:

• CALENDAR_CAT (VARCHAR2): A mandatory field specifying the calendar category for which the expected workload is defined. Permissible values are constrained to 'Term' (or 'Load') and 'Academic' calendar categories, as per the application's validation.
• EXPECTED_WL (NUMBER): This column was designed to hold the numerical value of the expected workload for the associated calendar category. The metadata explicitly marks this column as "Obsolete."
• CONTROL_NUM (NUMBER): This column is documented as "No longer used," suggesting it was once a sequence or identifier that has been deprecated.
• Standard WHO Columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. These columns track the creation and modification history of each record.

The table is indexed uniquely on the CALENDAR_CAT column via the IGS_PS_EXP_WL_PK primary key, enforcing that only one expected workload record can exist per calendar category.

Common Use Cases and Queries

Given the obsolete status of its main data columns, direct operational use of this table in contemporary processes is unlikely. Its primary use cases now involve reference, data auditing, or supporting legacy data extracts. A user searching for "control_num" would find it in the structure but should note its deprecated status. The standard query for examining all records, as provided by the ETRM, is: SELECT CONTROL_NUM, CALENDAR_CAT, EXPECTED_WL, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM IGS.IGS_PS_EXP_WL; A more practical query might focus on the still-relevant configuration data, such as retrieving the defined calendar categories: SELECT CALENDAR_CAT, CREATION_DATE, LAST_UPDATED_BY FROM IGS_PS_EXP_WL; This can be useful for validating setup or understanding historical configuration, even if the EXPECTED_WL values are not actively maintained by the application.

Related Objects

The dependency information indicates that the IGS_PS_EXP_WL table does not reference any other database objects. However, it is referenced by an object within the APPS schema, listed as "IGS_PS_EXP_WL." This is most likely a public synonym (APPS.IGS_PS_EXP_WL) that points to the underlying IGS.IGS_PS_EXP_WL table, which is a standard EBS architecture pattern to provide a single point of access for application code. The absence of foreign key relationships or numerous dependencies further supports the conclusion that this table's functional integration within the live system is minimal in current versions.