DW_PERSON_NAME_CURRENT_D

This dimension captures the Person latest names

Details

Module: Global Human Resources

Key Columns

PERSON_NAME_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PERSON_NAME_ID NUMBER 38 0 True Person Name Identifier
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source Record Identifier Uniquely identifies the person Name and used as the primary key
PERSON_ID NUMBER 38 0 Identifier of the Person to whom this name belongs DW_PERSON_D PERSON_ID
PERSON_ID_CHAR VARCHAR2 512 Person Identifier
LEGISLATION_CODE VARCHAR2 16 Country context for the Name data DW_LEGISLATION_D_TL LEGISLATION_CODE
NAME_TYPE VARCHAR2 32 This column tells us whether the name is Global or Local.
DISPLAY_NAME VARCHAR2 256 Derived denormalized name formatted for on-screen display.Formatting depends on the Legislation Code
FIRST_NAME VARCHAR2 256 Person's First name
LAST_NAME VARCHAR2 256 Person's Last Name
MIDDLE_NAMES VARCHAR2 128 Person's middle name
TITLE VARCHAR2 32 Person's title, means of addressing person.
PRE_NAME_ADJUNCT VARCHAR2 256 Prefix to a person's last name
SUFFIX VARCHAR2 128 Part of name appended to the last name
KNOWN_AS VARCHAR2 128 Preferred first name for the user.
PREVIOUS_LAST_NAME VARCHAR2 256 Previous Last Name of the person if any
FULL_NAME VARCHAR2 999 System constructed version of name, used in more formal display purposes
LIST_NAME VARCHAR2 256 Constructed version of a person's name, intended for use in an alphabetically-ordered list. The value may naturally differ depending on the Legislation Code.Expect the Last Name as the first component in this format in most cases.
ORDER_NAME VARCHAR2 256 System-constructed version of name used for sorting