# 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 |  |

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