This dimension captures the Person history information
Module: Global Human Resources
PERSON_ID, LEGISLATION_CODE, DATE_FROM
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
PERSON_ID | NUMBER | 38 | 0 | True | Person Identifier | ||
LEGISLATION_CODE | VARCHAR2 | 32 | True | Legislation code derived from Legal Entity. | DW_LEGISLATION_D_TL | LEGISLATION_CODE | |
DATE_FROM | DATE | True | Date at the beginning of the date range within which the row is effective. | ||||
SOURCE_RECORD_ID | VARCHAR2 | 256 | Source Record Identifier Uniquely identifies the Person and uses as the primary key | ||||
DATE_TO | DATE | Date at the end of the date range within which the row is effective. | |||||
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 | ||||
SEX | VARCHAR2 | 32 | Sex and valid for the legislation code | DW_SEX_D_TL | SEX | ||
MARITAL_STATUS | VARCHAR2 | 32 | Marital Status and valid for the legislation code | DW_MARITAL_STATUS_D_TL | MARITAL_STATUS | ||
MARITAL_STATUS_DATE | DATE | Date the Marital Status came into effect | |||||
HIGHEST_EDUCATION_LEVEL | VARCHAR2 | 32 | Legislation-specific value that indicates the highest level of education of the person | DW_HIGHEST_EDUCATION_LEVEL_D_TL | HIGHEST_EDUCATION_LEVEL | ||
DISABILITY_FLAG | VARCHAR2 | 16 | Flag to indicate if the person is disabled or not | ||||
ETHNICITY | VARCHAR2 | 32 | Ethnicity.Valid for the legislation code | DW_ETHNICITY_D_TL | ETHNICITY | ||
RELIGION | VARCHAR2 | 32 | Religion.Valid for the legislation code | DW_RELIGION_D_TL | RELIGION |
Copyright © 2019, 2022, Oracle and/or its affiliates.