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     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    

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