Search Results tenure_code




Overview
Explore in AI Chat

Overview

HZ_EMPLOYMENT_HISTORY is a Receivables (AR) schema table within the Oracle E-Business Suite Trading Community Architecture (TCA) model. It stores employment information for persons registered as parties in the TCA registry, capturing where a person works, in what capacity, and for what period. The table is owned by the AR schema and is documented as VALID in both EBS 12.1.1 and 12.2.2, with 36 columns in the 12.2.2 physical schema.

The object occupies the person-employment slice of the party model: a party of type PERSON may have one or more employment history records, each describing a job, an employer (itself a party), and associated attributes such as title, branch, tenure, and military rank. In Data Vault terms, this table is a satellite-leaning structure. Its grain is defined by the surrogate primary key EMPLOYMENT_HISTORY_ID, while its descriptive attributes describe the person-to-employer relationship over time. The presence of BEGIN_DATE, END_DATE, and status columns supports the temporal, type-2 style history that satellites typically carry. The EMPLOYED_BY_PARTY_ID column effectively acts as a link to the employing party, making the table a hybrid of satellite attributes and a person-to-organization association.

Key Information Stored

The table is anchored by the surrogate primary key EMPLOYMENT_HISTORY_ID, implemented through HZ_EMPLOYMENT_HISTORY_PK and reinforced by the unique index HZ_EMPLOYMENT_HISTORY_U1. This identifier is the business-key candidate referenced by dependent tables. Among the 36 documented columns, the most significant are:

Common Use Cases and Queries

The primary use case is retrieving and reporting a person's employment profile within TCA-based applications such as Receivables, iRecruitment, and HR-adjacent flows that reference party employment. A typical query joins the table to HZ_PARTIES twice — once for the person and once for the employer:

  • SELECT eh.employment_history_id, eh.employed_as_title, eh.begin_date, eh.end_date, ep.party_name employer FROM hz_employment_history eh, hz_parties ep WHERE eh.employed_by_party_id = ep.party_id AND eh.party_id = :person_party_id;
  • Reporting current employment: filter on STATUS and END_DATE IS NULL to obtain active records.
  • Cross-referencing work classification through the HZ_WORK_CLASS child table using EMPLOYMENT_HISTORY_ID.
  • Extracting the employer party for downstream deduplication or organization hierarchy analysis.

Because the table is a detail satellite on the party hub, bulk scans should always be filtered by PARTY_ID or EMPLOYED_BY_PARTY_ID to avoid full-table reads.

Related Objects

  • HZ_PARTIES — parent hub for both PARTY_ID and EMPLOYED_BY_PARTY_ID; the central join target.
  • HZ_WORK_CLASS — child table referencing HZ_EMPLOYMENT_HISTORY.EMPLOYMENT_HISTORY_ID; holds work-classification detail.
  • IGS_AD_HZ_EMP_DTL — child table referencing EMPLOYMENT_HISTORY_ID, used in the student/advanced-degree context.

These relationships confirm the table's role as a satellite feeding more specialized downstream records while depending on the party hub for identity.