This dimension captures the Person latest information
Module: Global Human Resources
PERSON_ID, LEGISLATION_CODE
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PERSON_ID | NUMBER | 38 | 0 | True | Person Identifier | ||
| LEGISLATION_CODE | VARCHAR2 | 16 | True | Legislation code derived from Legal Entity. | DW_LEGISLATION_D_TL | LEGISLATION_CODE | |
| 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 | ||||
| PERSON_NUMBER | VARCHAR2 | 32 | Person 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, 2024, Oracle and/or its affiliates.