Search Results expected_wl_num

Overview

The view APPS.IGS_PS_EMP_CATS_WL_HR_V is a reporting and integration object within the Oracle E-Business Suite IGS – Student System product family. It describes the workload associated with employment categories, combining internal Student System workload configuration data with employment category values maintained in Oracle Human Resources. The view is defined in the APPS schema and is documented as VALID in ETRM for release 12.2.2 (and applicable to 12.1.1). Its principal role is to expose a denormalized, Human Resources–enriched representation of employment category workloads so that downstream forms, reports, concurrent programs, and integrations can consume both the coded value and its descriptive meaning without performing the join themselves.

The view’s name embeds the functional identity of the object: IGS_PS (Student System), EMP_CATS_WL (employment category workload), HR (the source of the lookup values), and _V (view). Because the employment category description is resolved from HR lookups rather than stored redundantly in the IGS table, the view guarantees that category terminology remains consistent with the HR setup at query time.

Underlying Base Objects

The view text joins two base objects: IGS_PS_EMP_CATS_WL (aliased ECW), which holds the Student System’s employment category workload records, and HR_LOOKUPS (aliased HRLKUP), the HR lookup table. The join is established on ECW.EMP_CAT_CODE = HRLKUP.LOOKUP_CODE, constrained by LOOKUP_TYPE = 'EMP_CAT'.

Two important filters govern the result set. First, HRLKUP.ENABLED_FLAG = 'Y' restricts output to currently enabled lookups. Second, the date predicate SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE) ensures only employment categories active as of the current date are returned; open-ended start or end dates default to SYSDATE, effectively treating them as unbounded. Consequently, deactivated or date-expired employment categories are excluded, and the view returns only those rows where a matching, currently valid HR employment category exists.

Key Columns

• ROW_ID – The ROWID of the underlying IGS_PS_EMP_CATS_WL record, providing direct row addressing for the base table.
• CAL_CAT_CODE – The calendar category code associated with the workload definition.
• EMP_CAT_CODE – The employment category code, sourced from the HR lookup code and used as the join key to HR_LOOKUPS.
• EMP_CAT_DESC – The HR lookup MEANING, delivering the user-facing description of the employment category.
• EXPECTED_WL_NUM – The expected workload number for the employment category; this is the column most commonly targeted when searching for expected_wl_num, representing the workload value configured for the category within the given calendar category.
• CREATED_BY, CREATION_DATE – Standard audit columns recording who created the underlying workload row and when.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard audit columns capturing the last modification details of the base record.

Common Use Cases and Queries

Typical uses include validating expected workload figures per employment category, feeding admissions or progression reporting, and reconciling IGS workload configuration against HR employment category setup. A representative query retrieving workload by category is:

SELECT emp_cat_code, emp_cat_desc, cal_cat_code, expected_wl_num FROM apps.igs_ps_emp_cats_wl_hr_v WHERE cal_cat_code = :cal_cat;

To locate a specific expected workload value, a developer may filter directly on the searched column:

SELECT cal_cat_code, emp_cat_code, emp_cat_desc, expected_wl_num FROM apps.igs_ps_emp_cats_wl_hr_v WHERE expected_wl_num IS NOT NULL;

Reports that require descriptive category labels rather than codes should select emp_cat_desc alongside expected_wl_num, relying on the view to resolve HR meanings and enforce the enabled/date-active constraints automatically.