Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Company | varchar | 200 | √ | null |
|
|
Company name - Display name of the company or organization the user belongs to for multi-tenant identification |
|
| AgencyId | int | 4 | √ | null |
|
|
Agency identifier - Numeric ID of the agency associated with the user for organizational hierarchy |
|
| Roles | varchar | 2147483647 | √ | null |
|
|
User roles - Comma-separated list of roles assigned to the user for permission and access control |
|
| Teams | varchar | 2147483647 | √ | null |
|
|
Team assignments - List of teams the user belongs to for collaboration and workflow routing |
|
| UserId | int | 4 | √ | null |
|
|
User identifier - Unique numeric ID of the user for system references and relationships |
|
| FirstName | varchar | 200 | √ | null |
|
|
User first name - Given name of the user for personalization and display |
|
| LastName | varchar | 200 | √ | null |
|
|
User last name - Family name of the user for identification and communication |
|
| varchar | 200 | √ | null |
|
|
Email address - Primary email address for communication and authentication |
||
| UserStatus | nvarchar | 200 | √ | null |
|
|
Account status - Current status of the user account for access control |
|
| LoginCompanyID | nvarchar | 200 | √ | null |
|
|
Login company context - Company ID used during current login session for multi-tenant security |
|
| AgencyStatus | nvarchar | 20 | √ | null |
|
|
Agency relationship status - Status of user’s relationship with their assigned agency |
|
| Apps | nvarchar | 1073741823 | √ | null |
|
|
Available applications - List of applications the user has access to based on permissions and licensing |
|
| LastVisit | nvarchar | 1073741823 | √ | null |
|
|
Last activity timestamp - When the user was last active in the system for session management |
|
| SignUpCode | nvarchar | 1073741823 | √ | null |
|
|
Registration code - Code used during user registration for tracking and validation |
|
| DateEntered | datetime | 16,3 | √ | null |
|
|
Record creation timestamp - When this active user record was created for session tracking |