# DW_PERSON_D

This dimension captures the Person Information

## Details

Module: Global Human Resources

## Key Columns

PERSON_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PERSON_ID | NUMBER | 38 | 0 | True | Person Identifier |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. Source Record Identifier Uniquely identifies the person and used as the primary key |  |
PERSON_ID_CHAR | VARCHAR2 | 512 |  |  | Person Identifier |  |
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 |  |

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