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