system_user
Stores user account details, including credentials, roles, and contact information.
Columns
| Name | Type | ReadOnly | References | Description |
| SysId [KEY] | String | False |
Provides the system identifier (sys_id) for the user record. | |
| AccumulatedRoles | String | False |
Lists all roles assigned to the user, including inherited or implied roles. | |
| Active | Bool | False |
Indicates whether the user account is currently active and allowed to access the system. | |
| AgentStatus | String | False |
Shows the current agent availability status, typically used for service desk or support users. | |
| Avatar | String | False |
Stores the image or avatar associated with the user's profile. | |
| Building | String | False |
References the building where the user is located or assigned to work. | |
| BuildingLink | String | False |
Provides a link to the record of the building associated with the user. | |
| BusinessCriticality | Int | False |
Represents the importance level of the user's role or function to business operations. | |
| CalendarIntegration | Int | False |
Specifies whether the user's calendar is integrated with external calendar systems. | |
| City | String | False |
Indicates the city associated with the user's work location or address. | |
| Company | String | False |
References the company the user is employed by or associated with. | |
| CompanyLink | String | False |
Provides a link to the company record related to the user. | |
| CostCenter | String | False |
Specifies the cost center responsible for the user's expenses or department budget. | |
| CostCenterLink | String | False |
Provides a link to the cost center record associated with the user. | |
| Country | String | False |
Indicates the country where the user is based or employed. | |
| DateFormat | String | False |
Defines the preferred date display format for the user's interface. | |
| DefaultPerspective | String | False |
Specifies the default perspective or dashboard the user sees upon logging in. | |
| DefaultPerspectiveLink | String | False |
Provides a link to the record defining the user's default perspective. | |
| Department | String | False |
References the department the user belongs to within the organization. | |
| DepartmentLink | String | False |
Provides a link to the department record related to the user. | |
| EduStatus | String | False |
Specifies the user's education or training status when relevant to internal learning modules. | |
| String | False |
Stores the user's primary email address used for notifications and communication. | ||
| EmployeeNumber | String | False |
Contains the employee number assigned to the user within the organization. | |
| EnableMultifactorAuthn | Bool | False |
Indicates whether multifactor authentication (MFA) is enabled for the user account. | |
| FailedAttempts | Int | False |
Tracks the number of consecutive failed login attempts by the user. | |
| FederatedId | String | False |
Stores the federated identity used for single sign-on (SSO) authentication. | |
| FirstName | String | False |
Contains the user's first name as displayed in the system. | |
| Gender | String | False |
Specifies the user's gender for profile or reporting purposes. | |
| GeolocationTracked | Bool | False |
Indicates whether the user's geographical location is being tracked for operational purposes. | |
| HashedUserId | String | False |
Stores a hashed version of the user identifier used for secure integrations. | |
| HomePhone | String | False |
Stores the user's home phone number for contact purposes. | |
| InternalIntegrationUser | Bool | False |
Indicates whether the user account is used for internal system or integration processes. | |
| Introduction | String | False |
Contains a brief introduction or biography for the user's profile. | |
| LastLogin | Date | False |
Records the date when the user last logged in to the system. | |
| LastLoginDevice | String | False |
Identifies the device used during the user's most recent login session. | |
| LastLoginTime | Datetime | False |
Records the exact date and time of the user's last successful login. | |
| LastName | String | False |
Contains the user's last name as stored in the system. | |
| LastPassword | String | False |
Stores the hash of the user's previous password for security tracking. | |
| LastPositionUpdate | Datetime | False |
Records when the user's position or role was last updated in the system. | |
| Latitude | Float | False |
Represents the latitude coordinate of the user's registered location. | |
| LdapServer | String | False |
References the Lightweight Directory Access Protocol (LDAP) server used for user authentication. | |
| LdapServerLink | String | False |
Provides a link to the LDAP server record associated with the user. | |
| Location | String | False |
Specifies the user's physical or work location within the organization. | |
| LocationLink | String | False |
Provides a link to the location record related to the user. | |
| LockedOut | Bool | False |
Indicates whether the user account is locked due to failed login attempts or administrative action. | |
| Longitude | Float | False |
Represents the longitude coordinate of the user's registered location. | |
| Manager | String | False |
References the manager or supervisor responsible for this user. | |
| ManagerLink | String | False |
Provides a link to the record of the manager associated with the user. | |
| MiddleName | String | False |
Contains the user's middle name, if available. | |
| MobilePhone | String | False |
Stores the user's mobile phone number for contact or notification purposes. | |
| Name | String | False |
Displays the user's full name as it appears throughout the system. | |
| Notification | Int | False |
Defines the user's notification preference settings, such as email or mobile alerts. | |
| OnSchedule | String | False |
References the on-call or work schedule assigned to the user. | |
| PasswordNeedsReset | Bool | False |
Indicates whether the user must reset their password at the next login. | |
| Phone | String | False |
Stores the user's primary work phone number. | |
| Photo | String | False |
References the user's profile photo stored in the system. | |
| PreferredLanguage | String | False |
Defines the user's preferred display language for the interface. | |
| Roles | String | False |
Lists the roles explicitly assigned to the user for access control and permissions. | |
| Schedule | String | False |
References the user's assigned work or shift schedule. | |
| ScheduleLink | String | False |
Provides a link to the schedule record related to the user. | |
| Source | String | False |
Indicates the source system or method through which the user record was created. | |
| State | String | False |
Specifies the administrative state or region where the user is located. | |
| Street | String | False |
Contains the user's street address. | |
| SysClassName | String | False |
Defines the system class for this user record, identifying its structure and behavior. | |
| SysCreatedBy | String | False |
Identifies the user who originally created this record. | |
| SysCreatedOn | Datetime | False |
Records the date and time when this user record was created. | |
| SysDomain | String | False |
Indicates the domain to which this user belongs in multi-domain environments. | |
| SysDomainPath | String | False |
Specifies the hierarchical domain path for the user in multi-domain setups. | |
| SysModCount | Int | False |
Tracks the total number of updates made to this user record. | |
| SysTags | String | False |
Lists tags associated with the user for categorization or quick filtering. | |
| SysUpdatedBy | String | False |
Identifies the user who last modified this user record. | |
| SysUpdatedOn | Datetime | False |
Records the date and time when the user record was last updated. | |
| TimeFormat | String | False |
Defines the preferred time display format for the user interface. | |
| TimeZone | String | False |
Specifies the time zone that determines how date and time values are displayed for the user. | |
| Title | String | False |
Indicates the user's job title or position within the organization. | |
| UserName | String | False |
Stores the unique username used by the user to log in to the system. | |
| UserPassword | String | False |
Contains the user's password in encrypted or hashed form for authentication purposes. | |
| Vip | Bool | False |
Indicates whether the user is marked as a VIP (very important person) for prioritized handling. | |
| WebServiceAccessOnly | Bool | False |
Specifies whether the user account is restricted to web service access only. | |
| Zip | String | False |
Stores the postal or ZIP code associated with the user's address. |