Table: dbo.Ems_User
Contains information on NetClient users that we mirror in ACS.
Columns
NameTypeConstraintsDescription
ems_user_idint (4)NOT NULLDetermined by web services, the primary key.
login_idnvarchar (300)NOT NULLThe ID used for logging in to a NetClient or NetFirm environment. Could be an email address, so it needs to be long.
first_namenvarchar (300)NOT NULLUser first name.
last_namenvarchar (300)NOT NULLUser last name.
registration_sent_datenvarchar (46)NOT NULLThe last time Web Services sent the registration email. The format is exactly as sent to ensure we maintain accuracy.
registration_datenvarchar (46)NOT NULLThe registration confirmation date. The format is exactly as sent to ensure we maintain accuracy.
last_modification_datenvarchar (46)NOT NULLThe last time Web Services changed this user. The format is exactly as sent to ensure we maintain accuracy.
enable_officebit (1)NOT NULLTrue if user is enabled to use MS Office.
enable_file_cabinetbit (1)NOT NULLTrue if user is enabled to use File Cabinet.
displayed_profile_messagebit (1)NOT NULLTrue if we've already displayed a message reminding the ACS user that adding a client user to a profile means that client user can see data saved by other client users.
client_access__data_location_profile_KEYint (4)Indicates which profile is used when the staff is running Client Access.
is_net_staffbit (1)NOT NULLDetermines if this particular record represents a NetStaff (true) or NetClient (false) user.
Primary key
NameColumnsDescription
PK_Ems_User$ems_user_idems_user_id
Foreign keys
NameColumnsReferenced tableDescription
FK_Ems_User__Data_Location_Profile__client_access__data_location_profile_KEYclient_access__data_location_profile_KEYData_Location_Profile (data_location_profile_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_File_Exchange_Portal_Ems_User__Ems_User__ems_user_idems_user_idClient_File_Exchange_Portal_Ems_User
FK_Staff_Ems_User_Id__Ems_User__ems_user_idems_user_idStaff_Ems_User_Id

Schema diagram