Search Results hz_work_class




Overview
Explore in AI Chat

Overview

HZ_WORK_CLASS is a Receivables (AR) module table in the Oracle E-Business Suite that stores classifications or groupings of work activities within the Trading Community Architecture (TCA) model. It is used to categorize the nature of work performed in the context of a party's employment or professional history, allowing organizations to record standardized work classifications such as job categories, occupational groupings, or activity types for individuals and organizations tracked in the TCA registry.

Its role in Oracle EBS is largely supporting and reference-oriented: it extends the employment history record with structured classification attributes rather than acting as a standalone transactional entity. Based on the foreign key relationship documented in the metadata, and the heuristic Data Vault classification provided, this table is best modeled as satellite-leaning. It carries descriptive classification attributes tied to a parent employment history record, functioning as a dependent satellite of HZ_EMPLOYMENT_HISTORY rather than an independent hub or a many-to-many link table.

Key Information Stored

The column set comprises eighteen documented columns. The most significant are summarized below:

  • WORK_CLASS_ID — The surrogate primary key of the table, enforced through the HZ_WORK_CLASS_PK constraint. It also appears as the sole documented unique index (HZ_WORK_CLASS_U1), making it the principal business-key candidate as recorded in the ETRM metadata.
  • EMPLOYMENT_HISTORY_ID — Foreign key to HZ_EMPLOYMENT_HISTORY. This column anchors the work class record to its parent employment history entry and defines the table's satellite relationship.
  • WORK_CLASS_NAME — The descriptive name of the work classification or grouping.
  • LEVEL_OF_EXPERIENCE — Stores the experience level associated with the work class, supporting qualification or seniority-based categorization.
  • STATUS — Indicates the record's active/inactive state, typically used for soft-retirement of obsolete classifications.
  • APPLICATION_ID — Owning application identifier within the multi-application TCA/AR context.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the concurrent OLTP framework to prevent update conflicts.
  • Standard WHO/audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — capture creation and modification lineage.
  • Concurrent program columns: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — capture the concurrent program execution context for batch-loaded rows.
  • CREATED_BY_MODULE — Identifies the module or interface that created the row.
  • WH_UPDATE_DATE — Warehouse update date, used to support incremental data extraction into reporting or data-warehouse layers.

Common Use Cases and Queries

Typical use cases revolve around TCA party reporting: enumerating work classifications for an individual, producing employment history registries, and filtering classifications by status or experience level. A pattern to retrieve active work classes for a given employment history record is:

  • SELECT wc.WORK_CLASS_ID, wc.WORK_CLASS_NAME, wc.LEVEL_OF_EXPERIENCE FROM HZ_WORK_CLASS wc WHERE wc.EMPLOYMENT_HISTORY_ID = :p_history_id AND wc.STATUS = 'A';
  • SELECT wc.WORK_CLASS_NAME, COUNT(*) FROM HZ_WORK_CLASS wc GROUP BY wc.WORK_CLASS_NAME HAVING COUNT(*) > 1; to detect duplicated naming within classification sets.
  • A join to the parent employment history is common: SELECT eh.*, wc.* FROM HZ_EMPLOYMENT_HISTORY eh, HZ_WORK_CLASS wc WHERE eh.EMPLOYMENT_HISTORY_ID = wc.EMPLOYMENT_HISTORY_ID;

Because of the WH_UPDATE_DATE and OBJECT_VERSION_NUMBER columns, the table is also a candidate source for incremental ETL extracts into a reporting warehouse.

Related Objects

The documented FK structure identifies the principal related object; surrounding TCA employment and party tables complete the picture:

  • HZ_EMPLOYMENT_HISTORY — Parent table, joined via HZ_WORK_CLASS.EMPLOYMENT_HISTORY_ID = HZ_EMPLOYMENT_HISTORY.EMPLOYMENT_HISTORY_ID. This is the only FK relationship documented in the ETRM metadata.
  • HZ_PARTIES / HZ_PARTY_SITES — Party master records that indirectly reference employment history and therefore the work classifications.
  • HZ_PERSON_PROFILES — Person-level profile data that commonly aggregates employment history and its work classes.
  • HZ_WORK_CLASS_PK / HZ_WORK_CLASS_U1 — Primary key and unique index constraints enforcing identity on WORK_CLASS_ID.
  • AR Receivables and TCA-related concurrent programs and interfaces that load work classification data using the REQUEST_ID, PROGRAM_ID, and CREATED_BY_MODULE columns.

The table is referenced by standard TCA APIs and party data management processes whenever employment history records are created or queried.