# DW_PERSON_LEGISLATION_ALL_D

This dimension captures the Person history information

## Details

Module: Global Human Resources

## Key Columns

DATE_FROM, 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 |  |
LEGISLATION_CODE | VARCHAR2 | 32 |  | True | Legislation code derived from Legal Entity. | DW_LEGISLATION_D_TL | LEGISLATION_CODE
DATE_FROM | 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 |  |
DATE_TO | DATE |  |  |  | Date at the end of the date range within which the row is effective. |  |
PERSON_NUMBER | VARCHAR2 | 32 |  |  | Peson Number |  |
START_DATE | DATE |  |  |  | Start date of person record on system |  |
CORRESPONDENCE_LANGUAGE | VARCHAR2 | 32 |  |  | language to use for this communication |  |
DATE_OF_BIRTH | DATE |  |  |  | Date of birth of the person |  |
DATE_OF_DEATH | DATE |  |  |  | Date of death of the person |  |
COUNTRY_OF_BIRTH | VARCHAR2 | 256 |  |  | Identifies the country where the person was born |  |
REGION_OF_BIRTH | VARCHAR2 | 256 |  |  | Region of birth, within the country of birth |  |
TOWN_OF_BIRTH | VARCHAR2 | 256 |  |  | Town of birth, within the region of birth |  |
BLOOD_TYPE | VARCHAR2 | 32 |  |  | Identified the blood group of the person |  |
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
MARITAL_STATUS_DATE | DATE |  |  |  | Date the Marital Status came into effect |  |
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

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