Search Results igs_ps_emp_cats_wl_pk

Overview

The IGS_PS_EMP_CATS_WL table is a core data entity within the Oracle E-Business Suite (EBS) Student System (IGS). It serves as a master reference table that defines the standard workload associated with specific employment categories for academic personnel. Its primary role is to establish a consistent mapping between an employment classification (e.g., full-time, part-time, adjunct) and its expected workload, which is critical for workload planning, costing, and reporting within the institution's academic structure. As indicated in the ETRM, the table intelligently sources its reference data from Human Resources (HR) module lookups when HR is installed; otherwise, it defaults to lookups defined within the Student System itself, ensuring integration flexibility.

Key Information Stored

The table stores the relationship between an employment category and a calendar category, defining the associated workload. Its structure is defined by a composite primary key, ensuring a unique combination for each valid workload rule. The critical columns include:

• EMP_CAT_CODE: The code identifying the employment category (e.g., 'FULL', 'PART').
• CAL_CAT_CODE: The code for the calendar category (e.g., 'SEMESTER', 'QUARTER'), which contextualizes the workload period.
• WORKLOAD_PERCENTAGE (implied by context): While not explicitly listed in the brief metadata, a column defining the numerical workload value (often as a percentage or unit count) is typically central to this entity's purpose.

The primary key constraint IGS_PS_EMP_CATS_WL_PK is enforced on the combination of CAL_CAT_CODE and EMP_CAT_CODE.

Common Use Cases and Queries

This table is primarily used in administrative processes involving faculty and staff assignment planning. A common use case is during the course scheduling or instructor assignment process, where the system calculates an individual's load based on their employment category and the academic calendar. It is also essential for generating workload reports for departmental or institutional reviews. Sample SQL patterns often involve joining this table to personnel or assignment data.

For example, to retrieve all defined workload rules: SELECT emp_cat_code, cal_cat_code, workload_value FROM igs.igs_ps_emp_cats_wl ORDER BY 1,2;

To find the standard workload for a specific employment category within a semester calendar: SELECT workload_value FROM igs.igs_ps_emp_cats_wl WHERE emp_cat_code = 'FULL' AND cal_cat_code = 'SEM';

Related Objects

The IGS_PS_EMP_CATS_WL table has defined relationships with other key entities in the Student System, as per the provided foreign key metadata. The primary relationship is with the IGS_PS_EXP_WL (Expected Workload) table, where CAL_CAT_CODE acts as a foreign key. This indicates that IGS_PS_EMP_CATS_WL provides the foundational workload definitions that are likely referenced or utilized when calculating or storing expected workload figures for specific instances or individuals. Furthermore, it is intrinsically linked to the lookup tables (e.g., FND_LOOKUP_VALUES) for both the HR and Student System modules, from which the valid EMP_CAT_CODE and possibly CAL_CAT_CODE values are sourced.