DW_PERSON_LEGISLATION_ALL_D

This dimension captures the Person history information

Details

Module: Global Human Resources

Key Columns

PERSON_ID, DATE_FROM, LEGISLATION_CODE

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     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, 2023, Oracle and/or its affiliates.