user_has_license_role
Displays user-license role mappings to verify license allocation and compliance.
Columns
| Name | Type | References | Description |
| u_sys_id | String | Provides the system identifier (sys_id) for the licensed user record. | |
| u_accumulated_roles | String | Lists all roles assigned to the user, including inherited and directly granted ones. | |
| u_active | Bool | Indicates whether the user account is currently active and able to access the system. | |
| u_avatar | String | Stores the file path or reference to the user's avatar image. | |
| u_building | String | References the building where the user is located or primarily works. | |
| u_building_link | String | Provides a link to the detailed building record associated with the user. | |
| u_calendar_integration | Int | Defines the user's calendar integration setting, such as synchronization status or mode. | |
| u_city | String | Specifies the city where the user resides or works. | |
| u_company | String | References the company associated with the user's profile. | |
| u_company_link | String | Provides a link to the company record related to the user. | |
| u_cost_center | String | Specifies the cost center responsible for the user's department or expenses. | |
| u_cost_center_link | String | Provides a link to the cost center record associated with the user. | |
| u_country | String | Specifies the user's country of residence or employment. | |
| u_date_format | String | Defines the preferred date display format for the user. | |
| u_default_perspective | String | Indicates the default dashboard or perspective assigned to the user in the system. | |
| u_default_perspective_link | String | Provides a link to the default perspective record for the user. | |
| u_department | String | References the department where the user works. | |
| u_department_link | String | Provides a link to the department record associated with the user. | |
| u_edu_status | String | Indicates the educational or training status of the user, if applicable. | |
| u_email | String | Stores the user's primary email address used for communication and authentication. | |
| u_employee_number | String | Specifies the employee number assigned to the user within the organization. | |
| u_enable_multifactor_authn | Bool | Indicates whether multifactor authentication (MFA) is enabled for the user. | |
| u_failed_attempts | Int | Tracks the number of failed login attempts for the user account. | |
| u_first_name | String | Stores the user's given name. | |
| u_gender | String | Specifies the user's gender, if recorded. | |
| u_home_phone | String | Stores the user's home phone number. | |
| u_internal_integration_user | Bool | Indicates whether the user account is used for internal system integrations. | |
| u_introduction | String | Contains a short introduction or bio provided by the user. | |
| u_last_login | Date | Records the date when the user last logged in. | |
| u_last_login_device | String | Identifies the device used for the user's most recent login. | |
| u_last_login_time | Datetime | Specifies the exact time when the user last accessed the system. | |
| u_last_name | String | Stores the user's family or last name. | |
| u_last_password | String | Stores metadata about the user's last password change for security auditing. | |
| u_ldap_server | String | References the Lightweight Directory Access Protocol (LDAP) server associated with the user. | |
| u_ldap_server_link | String | Provides a link to the LDAP server record. | |
| u_location | String | References the location assigned to the user, such as an office or region. | |
| u_location_link | String | Provides a link to the related location record. | |
| u_locked_out | Bool | Indicates whether the user account is locked due to repeated failed login attempts. | |
| u_manager | String | References the user's direct manager. | |
| u_manager_link | String | Provides a link to the manager's user record. | |
| u_middle_name | String | Stores the user's middle name, if available. | |
| u_mobile_phone | String | Contains the user's mobile phone number. | |
| u_name | String | Displays the user's full name as it appears in the system. | |
| u_notification | Int | Defines the notification preference or mode for the user, such as email or in-app. | |
| u_password_needs_reset | Bool | Indicates whether the user must reset their password at next login. | |
| u_phone | String | Stores the user's primary business phone number. | |
| u_photo | String | References the photo associated with the user's profile. | |
| u_preferred_language | String | Specifies the user's preferred display language in the interface. | |
| u_roles | String | Lists the roles assigned to the user for system access control. | |
| u_schedule | String | References the user's assigned work schedule or shift pattern. | |
| u_schedule_link | String | Provides a link to the related schedule record. | |
| u_source | String | Indicates the source system from which the user record originated. | |
| u_sso_source | String | Specifies the single sign-on (SSO) provider or source used for authentication. | |
| u_state | String | Indicates the state or province where the user is located. | |
| u_street | String | Stores the street address associated with the user's location. | |
| u_sys_class_name | String | Defines the system class of the user record, determining its structure and behavior. | |
| u_sys_created_by | String | Identifies the user who originally created this record. | |
| u_sys_created_on | Datetime | Records the date and time when this user record was created. | |
| u_sys_domain | String | Specifies the domain to which this user record belongs in multi-domain environments. | |
| u_sys_domain_path | String | Displays the hierarchical path representing the user's domain. | |
| u_sys_mod_count | Int | Tracks how many times the user record has been modified. | |
| u_sys_tags | String | Lists tags applied to the user record for categorization or filtering. | |
| u_sys_updated_by | String | Identifies the user who most recently updated this record. | |
| u_sys_updated_on | Datetime | Specifies the date and time when this record was last updated. | |
| u_time_format | String | Defines the preferred time display format for the user. | |
| u_time_zone | String | Specifies the user's time zone for scheduling and display purposes. | |
| u_title | String | Stores the user's job title or role within the organization. | |
| u_u_user_name | String | Contains a custom user name field used for specialized configurations or legacy mappings. | |
| u_user_name | String | Specifies the user's login name used for authentication. | |
| u_user_password | String | Stores the user's encrypted password value. | |
| u_vip | Bool | Indicates whether the user is designated as a VIP, often given higher service priority. | |
| u_web_service_access_only | Bool | Specifies whether the user account is restricted to web service access only. | |
| u_zip | String | Stores the postal or ZIP code for the user's address. | |
| ur_sys_id | String | Provides the sys_id for the role record associated with the user license. | |
| ur_assignable_by | String | References the user or role authorized to assign this role to others. | |
| ur_assignable_by_link | String | Provides a link to the record of the assigner or assigning role. | |
| ur_can_delegate | Bool | Indicates whether the role can be delegated to other users. | |
| ur_description | String | Describes the purpose or permissions granted by the role. | |
| ur_elevated_privilege | Bool | Specifies whether the role grants elevated or administrative privileges. | |
| ur_grantable | Bool | Indicates whether this role can be granted manually to other users. | |
| ur_includes_roles | String | Lists additional roles automatically included with this one. | |
| ur_name | String | Displays the name of the role associated with the license. | |
| ur_requires_subscription | String | Specifies whether this role requires an active subscription to use. | |
| ur_scoped_admin | Bool | Indicates whether the role has administrative rights limited to a specific application scope. | |
| ur_suffix | String | Stores a suffix used for identifying role variations or extended definitions. | |
| ur_sys_class_name | String | Defines the system class of the role record. | |
| ur_sys_created_by | String | Identifies the user who created the role record. | |
| ur_sys_created_on | Datetime | Records the date and time when the role record was created. | |
| ur_sys_mod_count | Int | Tracks how many times the role record has been modified. | |
| ur_sys_name | String | Specifies the internal system name of the role record. | |
| ur_sys_package | String | References the package that contains this role definition. | |
| ur_sys_package_link | String | Provides a link to the related package record. | |
| ur_sys_policy | String | Specifies the policy governing this role's behavior or lifecycle. | |
| ur_sys_scope | String | Indicates the application scope to which this role belongs. | |
| ur_sys_scope_link | String | Provides a link to the application scope record. | |
| ur_sys_tags | String | Lists tags applied to the role record for classification or filtering. | |
| ur_sys_update_name | String | Displays the internal update name of the role record. | |
| ur_sys_updated_by | String | Identifies the user who last updated the role record. | |
| ur_sys_updated_on | Datetime | Records the date and time when the role record was last updated. | |
| lr_application | String | References the application associated with the license role mapping. | |
| lr_application_link | String | Provides a link to the related application record. | |
| lr_sys_user_role | String | References the system user role linked to the license assignment. | |
| lr_sys_user_role_link | String | Provides a link to the related user role record. | |
| uhr_role | String | References the specific role assigned to the licensed user. | |
| uhr_role_link | String | Provides a link to the role record associated with the license. | |
| uhr_user | String | References the user who holds the licensed role. | |
| uhr_user_link | String | Provides a link to the licensed user's record. |