DW_PERSON_NAME_D

This dimension captures the Global Person Name Information

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, 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
EFFECTIVE_START_DATE DATE True Date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE True Date at the end 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 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
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
DW_DATE_FROM DATE Warehouse Effective From Date for the Person Name record. If Initial extract date is greater than EFFECTIVE_FROM_DATE then Initial extract date is used.
DW_DATE_TO DATE Warehouse Effective To Date for the Person Name record. This is equal to EFFECTIVE_END_DATE
DW_INITIAL_RECORD_IND NUMBER 38 0 This indicates whether the record is the first event for the assignment to be brought into the warehouse based on initial extract date set by user.