DW_PERSON_LEGISLATION_DAILY_EVENT_F

This fact captures the Person daily event information

Details

Module: Global Human Resources

Key Columns

EVENT_DATE, LEGISLATION_CODE, PERSON_ID

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