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