Search Results per_previous_job_usages




Overview
Explore in AI Chat

Overview

The HR.PER_PREVIOUS_JOB_USAGES table is a Human Resources (PER) module object that stores the usage records associated with a candidate or employee's previous job history. Where PER_PREVIOUS_JOBS captures the definition of a prior position, PER_PREVIOUS_JOB_USAGES records how that job entry is actually used — for example, the assignment of the previous job to a specific person, along with the tenure period over which it was held. In Oracle EBS 12.1.1 and 12.2.2, this table underpins the "Previous Employment" and "Previous Job" information blocks used during recruitment, onboarding, and applicant tracking.

From a Data Vault modeling perspective, the relationships mined from the foreign-key structure suggest this object behaves as a satellite-leaning entity. It carries descriptive attributes (period durations, dates, and descriptive flexfield content) that hang off the parent PREVIOUS_JOBS entity rather than acting as an independent hub or link. Treating it as a satellite of the previous-job hub is a reasonable heuristic when mapping to a Data Vault or dimensional warehouse, though the direct foreign key to PER_PREVIOUS_EMPLOYERS also implies a light link role.

Key Information Stored

The table holds 57 documented columns in the HR schema. The most significant for functional and reporting purposes are:

Common Use Cases and Queries

Typical scenarios include verifying prior-service credit, computing total years of relevant experience during recruitment, and auditing applicant-provided employment history. Analysts frequently join this table to the parent job and employer tables, and filter on the tenure period columns.

SELECT pju.previous_job_usage_id,
       pju.assignment_id,
       pju.start_date,
       pju.end_date,
       pju.period_years,
       pju.period_months,
       pju.period_days
FROM   hr.per_previous_job_usages pju
WHERE  pju.previous_job_id = :previous_job_id
ORDER  BY pju.start_date DESC;

A common employer-oriented query joins to PER_PREVIOUS_EMPLOYERS to summarize prior employers per person, while a tenure rollup aggregates PERIOD_YEARS across a person's usage records to derive total prior experience. Reporting extracts should honor DFF context by filtering on PJU_ATTRIBUTE_CATEGORY to isolate customer-defined segments.

Related Objects

  • PER_PREVIOUS_JOBS — parent entity referenced via PREVIOUS_JOB_ID; holds the prior position definition.
  • PER_PREVIOUS_EMPLOYERS — referenced via PREVIOUS_EMPLOYER_ID; supplies the employer details.
  • PER_ASSIGNMENTS_F / PER_ASSIGNMENTS — accessed via ASSIGNMENT_ID to relate prior experience to the current assignment.
  • PER_PREVIOUS_JOBS_USAGES_PK — the primary-key index enforcing uniqueness on PREVIOUS_JOB_USAGE_ID.
  • PER_ALL_PEOPLE_F — commonly joined through the assignment or job chain to attribute prior-job usage to a person.
  • PER_JOBS / PER_POSITIONS — reference master data useful for classifying the nature of prior positions during reporting.