# DW_SERVICE_PERIOD_D

This table stores the work relation ship details between person and their legal employer for the period of service

## Details

Module: Global Human Resources

## Key Columns

PERIOD_OF_SERVICE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PERIOD_OF_SERVICE_ID | NUMBER | 38 | 0 | True | Perod of Service identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 32 |  |  | This column is for Oracle Internal use only. Source Record Identifier Consists of Period of Service Identifier |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier |  |
LEGISLATION_CODE | VARCHAR2 | 256 |  |  | Legislation Code |  |
DATE_START | DATE |  |  |  | Start date of the period of employment |  |
ACTUAL_TERMINATION_DATE | DATE |  |  |  | Actual date of termination of employment. |  |
NOTIFIED_TERMINATION_DATE | DATE |  |  |  | Date when the termination of employment was noted. |  |
PROJECTED_TERMINATION_DATE | DATE |  |  |  | Projected employment termination date. |  |
LAST_WORKING_DATE | DATE |  |  |  | Last Date Worked (for terminated workers). |  |
PRIMARY_FLAG | VARCHAR2 | 32 |  |  | If Yes, this employment period is considered the primary for the Legal Entity. |  |
ORIGINAL_DATE_OF_HIRE | DATE |  |  |  | Original date of hire. |  |
ADJUSTED_SERVICE_DATE | DATE |  |  |  | Adjusted Service Date |  |
WORKER_NUMBER | VARCHAR2 | 32 |  |  | WORKER_NUMBER |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.