Table:
Users
Stores user credentials for accessing the system and used for assigning roles.
| Name | Type | Description | Remarks |
|---|---|---|---|
| FailedPasswordAttemptLockout |
| Name | Type | Description | Remarks |
|---|---|---|---|
| Comments |
varchar(3000) |
Text comments about the user account. |
|
|
CompanyID |
varchar(20) |
CompanyID is a nullable foreign key to the CompanyInfo table. |
|
| CreationDate |
datetime |
The datetime the user account was created. |
|
|
varchar(128) |
|||
| EmergencyAccess |
bit |
Indicates if this user is allowed to have Emergency Access to offices when logging in. |
|
| EncompassUserUid |
varchar(36) |
Encompass User Uid |
|
|
FailedPwdAnsAttemptCnt |
int |
Indicates the number of failed attempts to answer a password question. |
|
|
FailedPwdAnsAttemptWndStart |
datetime |
DateTime of first failed attempt to answer the security question. |
|
| FailedPasswordAttemptCount |
FailedPwdAttemptCnt |
Indicates the number of failed attempts to log in. |
|
|
FailedPwdAttemptWinStart |
datetime |
DateTime of first failed attempt to enter the password. |
|
| IsApproved |
bit |
Indicates if the user has received approval to access the system. |
|
| IsLockedOut |
bit |
Indicates if the user account is locked out. |
|
| IsUserMigratedToUnifiedLogin |
bit |
Indicates if the user is migrated to Encompass ID. |
|
| LastActivityDate |
datetime |
Datetime of the last usage of the account. |
|
| LastLockedOutDate |
datetime |
||
| LastLoginDate |
datetime |
||
| LastPasswordChangeDate |
datetime |
||
| MultipleOfficeAccess |
bit |
Indicates if this user is allowed to log in to more than one office. |
|
| MustChangePassword |
bit |
Indicates if the user must change their password. |
|
| Name |
varchar(255) |
User account name - This field contains the user account name and the format is username_pm_companyid_pm. Eg. jsmith_pm_AL999_pm - where AL999 is the companyid. |
|
| Password |
varchar(128) |
||
| PasswordAnswer |
varchar(255) |
Answer to the question provided in PasswordQuestion. |
|
| PasswordFormat | Obsolete |
||
| PasswordQuestion |
varchar(255) |
A question to ask the user when they have forgotten their password. This helps to authenticate the user. |
|
| PasswordSalt |
varchar(128) |
Salt value provided to protect against brute force cracking of encryption algorithm. |