DW_PERSON_D

This dimension captures the Person Information

Details

Module: Global Human Resources

Key Columns

PERSON_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PERSON_ID NUMBER 38 0 True Person Identifier    
SOURCE_RECORD_ID NUMBER 38 0   Source Record Identifier Uniquely identifies the person and used as the primary key    
PERSON_NUMBER VARCHAR2 32     Peson Number    
START_DATE DATE       Start date of person record on system    
CORRESPONDENCE_LANGUAGE VARCHAR2 32     language to use for this communication    
DATE_OF_BIRTH DATE       Date of birth of the person    
DATE_OF_DEATH DATE       Date of death of the person    
COUNTRY_OF_BIRTH VARCHAR2 256     Identifies the country where the person was born    
REGION_OF_BIRTH VARCHAR2 256     Region of birth, within the country of birth    
TOWN_OF_BIRTH VARCHAR2 256     Town of birth, within the region of birth    
BLOOD_TYPE VARCHAR2 32     Identified the blood group of the person