# DW_PERSON_LEGISLATION_DAILY_EVENT_F

This fact captures the Person daily event information

## Details

Module: Global Human Resources

## Key Columns

EVENT_DATE, PERSON_ID, LEGISLATION_CODE

## 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 |  |
CAL_MONTH_ID | NUMBER | 38 | 0 |  | Month identifier in YYYYQMM format. For example, 1979412. |  |
CAL_QUARTER_ID | NUMBER | 38 | 0 |  | Quarter identifier in YYYYQ format. For example, 19794. |  |
CAL_YEAR_ID | NUMBER | 38 | 0 |  | Year identifier in YYYY format. For example, 1979. |  |

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