This dimension captures the Person Information
Module: Global Human Resources
PERSON_ID
| 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, 2024, Oracle and/or its affiliates.