Search Results projected_termination_date




Overview
Explore in AI Chat

Overview

APPS.PER_PERIODS_OF_WORK_V is a reporting and integration view in the Oracle E-Business Suite Human Resources (PER) module. It provides a consolidated, presentation-ready representation of an enterprise's periods of work by combining two distinct transactional entities: periods of service (permanent or long-term employment) and periods of placement (contingent, temporary, or agency placements). Rather than requiring consumers to query PER_PERIODS_OF_SERVICE and PER_PERIODS_OF_PLACEMENT separately and reconcile their differing column semantics, the view exposes a single uniform structure. Its status is VALID in the APPS schema, and it is available in both EBS 12.1.1 and 12.2.2. For the search term projected_termination_date, this view is directly relevant: both branches of the underlying UNION ALL select the PROJECTED_TERMINATION_DATE column, making the view a practical source for identifying employees or contingent workers with an anticipated end-of-work date that has not yet been finalized.

Underlying Base Objects

The view is defined as a UNION ALL over two source objects, with a package supplying derived values:

  • PER_PERIODS_OF_SERVICE (referenced via synonym) — the first branch, keyed by PERIOD_OF_SERVICE_ID and tagged with the literal 'PPS'.
  • PER_PERIODS_OF_PLACEMENT (referenced via synonym) — the second branch, keyed by PERIOD_OF_PLACEMENT_ID and tagged with the literal 'PPP'.
  • HR_GENERAL (package) — invoked for DECODE_LOOKUP (translation of leaving/termination reasons) and DECODE_ORGANIZATION (business group name resolution).

Because the source objects are synonyms, the view references the underlying HR base tables owned by the PER product. Attribute columns (ATTRIBUTE1–ATTRIBUTE20) are carried through from both branches, while the descriptive-flexfield PDS_INFORMATION1–PDS_INFORMATION30 columns are populated from the service branch and left NULL for the placement branch.

Key Columns

Common Use Cases and Queries

Typical scenarios include workforce forecasting, exit/attrition pipelines, integration feeds to downstream systems, and reconciliation between employee and contingent-worker populations. A representative query to surface projected leavers is:

SELECT person_id, business_group_id, period_type, date_start, projected_termination_date
FROM apps.per_periods_of_work_v
WHERE projected_termination_date IS NOT NULL
AND projected_termination_date >= SYSDATE
ORDER BY projected_termination_date;

Filtering by period_type isolates employees ('PPS') from placements ('PPP'), while joining to PER_ALL_PEOPLE_F on person_id enriches results with names and assignment detail.