DW_PERSON_INFO_D

This dimension captures the Person number information

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, PERSON_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PERSON_ID NUMBER 38 0 True Person Identifier    
EFFECTIVE_START_DATE DATE     True effective start date    
EFFECTIVE_END_DATE DATE     True effective end date    
SOURCE_RECORD_ID VARCHAR2 128     Source Record Identifier Uniquely identifies the person and used as the primary key    
PERSON_NUMBER VARCHAR2 32     Person number