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

PERSON_ID, PERIOD_TYPE

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     Source Record Identifier Consists of Period of Service Identifier    
ENTERPRISE_HIRE_DATE DATE       Minimum start date of the period of employment    

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