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 This column is for Oracle Internal use only. Source Record Identifier Uniquely identifies the person and used as the primary key
PERSON_ID_CHAR VARCHAR2 512 Person Identifier
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