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