DW_PERSON_LEGISLATION_DAILY_EVENT_F

This fact captures the Person daily event information

Details

Module: Global Human Resources

Key Columns

PERSON_ID, LEGISLATION_CODE, EVENT_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PERSON_ID NUMBER 38 0 True Person Identifier DW_PERSON_D PERSON_ID
LEGISLATION_CODE VARCHAR2 16   True Legislation code derived from Legal Entity.    
EVENT_DATE 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    
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
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
DATE_OF_BIRTH DATE       Date of birth of the person    
AGE_IN_YEARS NUMBER 38 0   Person Age as of Event Date    
SEX_CHANGE_IND NUMBER 38 0   Change Indicator for sex    
MARITAL_STATUS_CHANGE_IND NUMBER 38 0   Change Indicator for marital status    
HIGHEST_EDUCATION_CHANGE_IND NUMBER 38 0   Change Indicator for Highest education    
DISABILITY_FLAG_CHANGE_IND NUMBER 38 0   Change Indicator for Disability flag    

Copyright © 2019, 2023, Oracle and/or its affiliates.