Table: dbo.Ems_User
Contains information on NetClient users that we mirror in ACS.
Columns
Name | Type | Constraints | Description
ems_user_id | int (4) | NOT NULL | Determined by web services, the primary key.
login_id | nvarchar (300) | NOT NULL | The ID used for logging in to a NetClient or NetFirm environment. Could be an email address, so it needs to be long.
first_name | nvarchar (300) | NOT NULL | User first name.
last_name | nvarchar (300) | NOT NULL | User last name.
registration_sent_date | nvarchar (46) | NOT NULL | The last time Web Services sent the registration email. The format is exactly as sent to ensure we maintain accuracy.
registration_date | nvarchar (46) | NOT NULL | The registration confirmation date. The format is exactly as sent to ensure we maintain accuracy.
last_modification_date | nvarchar (46) | NOT NULL | The last time Web Services changed this user. The format is exactly as sent to ensure we maintain accuracy.
enable_office | bit (1) | NOT NULL | True if user is enabled to use MS Office.
enable_file_cabinet | bit (1) | NOT NULL | True if user is enabled to use File Cabinet.
displayed_profile_message | bit (1) | NOT NULL | True 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_KEY | int (4) |  | Indicates which profile is used when the staff is running Client Access.
is_net_staff | bit (1) | NOT NULL | Determines if this particular record represents a NetStaff (true) or NetClient (false) user.

Primary key
Name | Columns | Description
PK_Ems_User$ems_user_id | ems_user_id |

Foreign keys
Name | Columns | Referenced table | Description
FK_Ems_User__Data_Location_Profile__client_access__data_location_profile_KEY | client_access__data_location_profile_KEY | Data_Location_Profile (data_location_profile_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client_File_Exchange_Portal_Ems_User__Ems_User__ems_user_id | ems_user_id | Client_File_Exchange_Portal_Ems_User |
FK_Staff_Ems_User_Id__Ems_User__ems_user_id | ems_user_id | Staff_Ems_User_Id |