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 This column is for Oracle Internal use only. 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