Contains information on NetClient users that we mirror in ACS. |
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. |