DW_USER_D

This table contains information about users who created or modified records in the source system from which the rows have been extracted. It has the users' contact and location information.Person information such as Supervisor, Department, Name etc. are current.

Details

Module:

Key Columns

USERNAME

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
USERNAME VARCHAR2 128   True User name.    
SOURCE_RECORD_ID VARCHAR2 128     Source record identifier. Value is same as the user name.    
FIRST_NAME VARCHAR2 256     First name.    
MIDDLE_NAME VARCHAR2 256     Middle name.    
LAST_NAME VARCHAR2 256     Last name.    
FULL_NAME VARCHAR2 999     Full name.    
NAME_PREFIX VARCHAR2 256     Name prefix.    
NAME_SUFFIX VARCHAR2 128     Name suffix.    
NAME_EFFECTIVE_START_DATE TIMESTAMP       Effective start date for user name.    
WORK_PHONE_NUMBER VARCHAR2 256     Work phone.    
MOBILE_PHONE_NUMBER VARCHAR2 256     Mobile number.    
PAGER_NUMBER VARCHAR2 256     Pager number.    
FAX_NUMBER VARCHAR2 256     Fax number.    
PRIMARY_EMAIL_ADDRESS VARCHAR2 256     Primary email.    
SUPERVISOR_NAME VARCHAR2 999     Supervisor name.    
DEPARTMENT_ID NUMBER 38 0   Department.    
LOGIN_ID VARCHAR2 256     Login.    
USER_FORMED_DATE TIMESTAMP       Date of user account creation.    
ACTIVE_FLAG VARCHAR2 32     User active flag.    
PARTY_ID NUMBER 38 0   User party id    

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