Users
- DarkLight
Users
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Source Table | Column Name | Display Name | Data Type | Description | Platform |
|---|---|---|---|---|---|
OBD_Users | UID | UID | int (not null) | This is the auto-generated unique identifier for the user. | All |
OBD_Users | USERID | USERID | nvarchar (100) (null) | This the login user ID. | All |
OBD_Users | NAME | NAME | nvarchar (100) (null) | The name of the user. | All |
OBD_Users | PASSWORD | PASSWORD | nvarchar (1024) (null) | The password for the user to log in to the application. | All |
OBD_Users | ADDRESS1 | ADDRESS1 | nvarchar (32) (null) | The first line of the postal address of the user. | All |
OBD_Users | ADDRESS2 | ADDRESS2 | nvarchar (32) (null) | The second line, if available, of the postal address of the user. | All |
OBD_Users | CITY | CITY | nvarchar (16) (null) | The city that the user belongs to. | All |
OBD_Users | STATE | STATE | nvarchar (16) (null) | The postal code for the above city/state/address. | All |
OBD_Users | PIN | PIN | nvarchar (8) (null) | The postal code for the above city/state/address. | All |
OBD_Users | HOME_PHONE | HOME_PHONE | nvarchar (16) (null) | The home phone number of the user. | All |
OBD_Users | MOBILE_PHONE | MOBILE_PHONE | nvarchar (16) (null) | The mobile phone number of the user. | All |
OBD_Users | EMAIL_ID | EMAIL_ID | nvarchar (64) (null) | The Email address of the user. | All |
OBD_Users | COMMENTS | COMMENTS | nvarchar (128) (null) | Any additional comments about the user that are entered. | All |
OBD_Users | CREATETIME | CREATETIME | datetime (null) | The date and time the user was created on the application. | All |
OBD_Users | CREATEUSER | CREATEUSER | nvarchar (16) (null) | The person (user) who created this user. | All |
OBD_Users | AuthenticationType | AuthenticationType | int (null) | The authentication type enabled for this user. Options are Windows authentication, Database authentication, and SSO authentication. | All |
OBD_Users | UserType | UserType | int (null) | This indicates if the user is an admin user or a role-based user with specified access. | All |
OBD_Users | IsUserMapped | IsUserMapped | bit (null) |
| All |
OBD_Users | IsSalesforce | IsSalesforce | bit (null) | If this is a Service Cloud Voice-enabled user, this value is specified as 1. Else, it is 0. | All |
OBD_Users | IsConcurrentLogin | IsConcurrentLogin | bit (null) | This indicates if the user is allowed to login concurrently from another device. Possible values – 0 if not allowed; 1 if allowed. | All |
OBD_Users | NeverExpires | NeverExpires | bit (not null) | This is the setting to ensure the password never expires. Set 1 if the password never expires; 0 if the password expires and needs to be reset. | All |
OBD_Users | NextLogonPassword | NextLogonPassword | bit (not null) | This is the setting to force the user to change the password at the next log on attempt. Set 1 to force the user to change password; 0 to allow log in with old password. | All |
OBD_Users | CreateUserInDomain | CreateUserInDomain | bit (not null) | This determines if the user is created on the domain when created here. 1 if the user is created on the domain; 0 if not created on the domain. | All |
OBD_Users | IsDeleted | IsDeleted | bit (null) | This indicates a deleted user. The value is 1 if the user is deleted; 0 if not deleted user. | All |
OBD_Users | ModifiedBy | ModifiedBy | nvarchar (10) (null) | This denotes the user information modification route – via the application or an API method. | All |
OBD_Users | TenantID | TenantID | int (null) | The Tenant ID auto-generated by the application when a new tenant is created. | All |
OBD_Users | SubTenantID | SubTenantID | int (null) | The Sub Tenant ID autogenerated by the application when a new tenant is created. | All |
Was this article helpful?