This fact captures the Person daily event information
Module: Global Human Resources
PERSON_ID, EVENT_DATE, LEGISLATION_CODE
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 |