Search Results period_of_work_id

Overview

APPS.PER_PERIODS_OF_WORK_V is a supplementary Oracle EBS view owned by the APPS schema and registered under FND Design Data as PER.PER_PERIODS_OF_WORK_V. It presents a consolidated, single-source projection of an employee's or contingent worker's period of work, unifying two structurally similar but logically distinct entities: periods of service and periods of placement. The view is classified as a supplementary view used to simplify Oracle Forms coding. Oracle explicitly warns that this view is not intended for direct query or data manipulation by customers, and that its definition may change substantially across minor or major releases. Developers and integrators should therefore treat it as an interface of convenience rather than a stable public API, and should prefer the underlying base entities for long-lived customizations.

Underlying Base Objects

The documented dependency set comprises HR_GENERAL (a PL/SQL package), PER_PERIODS_OF_PLACEMENT (synonym), and PER_PERIODS_OF_SERVICE (synonym). The PERIOD_OF_WORK_ID and SOURCE columns are the mechanism that fuses these two sources: SOURCE indicates whether a given row originates from a period of service or a period of placement, while PERIOD_OF_WORK_ID carries the corresponding primary key of that source record (the period of service id or the period of placement id). The HR_GENERAL package supplies business logic and utility functions referenced in the view's definition, consistent with the HRMS pattern of centralizing date and business-group handling. Because both source synonyms resolve to HRMS base tables, the view behaves as a union-style abstraction over the two period entities, flattening their common attributes into one columnar shape.

Key Columns

The view exposes a compact set of analytical and transactional columns:

• PERIOD_OF_WORK_ID — the identifying key, mapped to either the period of service id or the period of placement id depending on SOURCE.
• SOURCE — a CHAR discriminator indicating whether the record is a period of service or a period of placement.
• BUSINESS_GROUP_ID — the owning business group, essential for multi-organization security filtering.
• PERSON_ID — foreign key to PER_ALL_PEOPLE_F, linking the period to the person.
• DATE_START, ACTUAL_END_DATE, FINAL_PROCESS_DATE, LAST_STANDARD_PROCESS_DATE, PROJECTED_TERMINATION_DATE — the lifecycle dates governing the period's duration, termination processing, and payroll final processing.
• LEAVING_REASON and LEAVING_REASON_DESC — the lookup code and its description explaining why the period ended.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE16 — descriptive flexfield columns for client-specific extensions.

Common Use Cases and Queries

The view is typically used for reporting on workforce tenure, termination forecasting, and period-of-work reconciliation across employee and contingent worker populations. A common query resolves the person context and restricts to a business group:

SELECT period_of_work_id, source, person_id, date_start,
       actual_end_date, projected_termination_date, leaving_reason
  FROM apps.per_periods_of_work_v
 WHERE business_group_id = :p_bg_id
   AND person_id = :p_person_id;

Because the view is a Forms-support object and Oracle does not recommend querying it directly, production integrations should validate results against PER_PERIODS_OF_SERVICE and PER_PERIODS_OF_PLACEMENT and re-verify the definition after any patch or upgrade to 12.1.1 or 12.2.2.