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     This column is for Oracle Internal use only. 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, 2024, Oracle and/or its affiliates.