This dimension captures the Person Information
Module: Global Human Resources
PERSON_ID
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 |