DW_PERSON_LEGISLATION_ALL_D

This dimension captures the Person history information

Details

Module: Global Human Resources

Key Columns

LEGISLATION_CODE, PERSON_ID, DATE_FROM

Columns

Columns
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 This column is for Oracle Internal use only. 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