# DW_NS_USER_D

This table contains the employees who act as users and log in into the NetSuite source system.

## Details

Module:

## Key Columns

id

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
id | NUMBER | 38 | 0 | True | Id |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. This is source record id column. |  |
username | VARCHAR2 | 512 |  |  |  |  |
first_name | VARCHAR2 | 64 |  |  | First Name |  |
last_name | VARCHAR2 | 64 |  |  | Last Name |  |
middle_name | VARCHAR2 | 64 |  |  | Middle Name |  |
active_flag | VARCHAR2 | 16 |  |  | Inactive |  |
user_formed_date | TIMESTAMP |  |  |  | Date Created |  |
department | NUMBER | 38 | 0 |  | Department | DW_NS_department_D | id
supervisor | NUMBER | 38 | 0 |  | Supervisor | DW_NS_employee_D | id
mobile_phone_number | VARCHAR2 | 128 |  |  | Mobile Phone |  |
work_phone_number | VARCHAR2 | 128 |  |  | Office Phone |  |
name_prefix | VARCHAR2 | 32 |  |  | Mr./Ms... |  |
entity_id | NUMBER | 38 | 0 |  |  | DW_NS_employee_D | id
email | VARCHAR2 | 512 |  |  | Email |  |
login_id | VARCHAR2 | 512 |  |  |  |  |
fax_number | VARCHAR2 | 128 |  |  | Fax |  |
full_name | VARCHAR2 | 256 |  |  | Full Name |  |

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