DW_PERSON_SERVICE_PERIOD_TYPE_D

This table stores the enterprise hire date per person and period type for period of service

Details

Module: Global Human Resources

Key Columns

PERIOD_TYPE, PERSON_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PERSON_ID NUMBER 38 0 True Person Identifier
PERIOD_TYPE VARCHAR2 32 True Determines whether it is a period of service for an Employee, or Contingent worker: E, C, or N: non-worker.
SOURCE_RECORD_ID VARCHAR2 32 This column is for Oracle Internal use only. Source Record Identifier Consists of Period of Service Identifier
ENTERPRISE_HIRE_DATE DATE Minimum start date of the period of employment