DW_PERSON_NAME_D

This dimension captures the Global Person Name Information

Details

Module: Global Human Resources

Key Columns

PERSON_NAME_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

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.    

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