Search Results emp_cat_desc




Overview
Explore in AI Chat

Overview

APPS.IGS_PS_EMP_CATS_WL_HR_V is a supplementary view in the Oracle E-Business Suite (12.1.1 / 12.2.2) owned by the APPS schema and registered under the FND Design Data reference IGS.IGS_PS_EMP_CATS_WL_HR_V. Its status is VALID. As documented in the ETRM metadata, this is a "supplementary view used to simplify forms coding," with the explicit Oracle warning that querying or altering data through this view is not recommended because the definition "may change dramatically in subsequent minor or major releases."

The view presents expected workload information for student/employee categories within academic calendar categories, joining the institution-level workload storage table (IGS_PS_EMP_CATS_WL) with Human Resources lookups (HR_LOOKUPS) to retrieve descriptive values. It serves primarily as a forms-support layer rather than a public reporting interface, allowing the student systems forms to display workload numbers alongside meaningful category descriptions without embedding complex join logic directly in the form. The object is not referenced by any other database object, confirming its role as a terminal, read-oriented construct.

Underlying Base Objects

The ETRM metadata documents that IGS_PS_EMP_CATS_WL_HR_V references the following database objects:

  • APPS.IGS_PS_EMP_CATS_WL — the base table holding expected workload per calendar category and employment category.
  • HR_LOOKUPS — the HR lookup table supplying the description of the employment category.
  • FND_GLOBAL — the standard concurrent/forms context package (for session context such as user and login).
  • HR_API — the HR application programming interface package, referenced within dependent code.

Functionally, the view joins employment category and calendar category records stored in IGS_PS_EMP_CATS_WL to HR lookup descriptions to produce a user-readable projection. The dependency listing confirms the view acts as a convenience wrapper over these base objects, and no documented base objects conflict with the metadata. Because the view is not referenced by any object, it is typically consumed only by the associated Oracle Forms modules.

Key Columns

The view exposes the following columns, as documented in the source definition:

  • ROW_ID (ROWID) — the row identifier of the underlying base row; not a meaningful business key.
  • CAL_CAT_CODE (VARCHAR2 30) — the calendar category at which expected workload is stored at institutional level; permitted values include Terms (Load) and Academic calendar categories.
  • EMP_CAT_CODE (VARCHAR2 30) — the employment category for a calendar category, populated from HR lookups where HR is installed.
  • EMP_CAT_DESC (VARCHAR2 80) — the description of the calendar/employment category, sourced from HR_LOOKUPS.
  • EXPECTED_WL_NUM (NUMBER) — the expected workload value in the given calendar category; this is the primary business measure and the target of the search term "expected_wl_num."
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

The view is most commonly used to retrieve the expected workload associated with a given employment category and calendar category combination, particularly when validating or displaying workload figures on student/HR-integrated forms. A representative query follows:

  • SELECT CAL_CAT_CODE, EMP_CAT_CODE, EMP_CAT_DESC, EXPECTED_WL_NUM FROM APPS.IGS_PS_EMP_CATS_WL_HR_V WHERE CAL_CAT_CODE = :p_cal_cat;
  • SELECT EMP_CAT_CODE, EMP_CAT_DESC, EXPECTED_WL_NUM FROM APPS.IGS_PS_EMP_CATS_WL_HR_V WHERE EMP_CAT_CODE = :p_emp_cat AND EXPECTED_WL_NUM IS NOT NULL;
  • SELECT CAL_CAT_CODE, SUM(EXPECTED_WL_NUM) FROM APPS.IGS_PS_EMP_CATS_WL_HR_V GROUP BY CAL_CAT_CODE;

Because this is a supplementary view, Oracle does not recommend direct querying for reporting or data alteration. Production integrations should query the base table IGS_PS_EMP_CATS_WL directly or through supported APIs, treating IGS_PS_EMP_CATS_WL_HR_V as an internal forms-coding artifact subject to change across releases.