subscribed_users_with_role
Identifies subscribed users and their roles to support access and licensing analysis.
Columns
| Name | Type | References | Description |
| userrolect_sys_id | String | Provides the system identifier (sys_id) for the user role record associated with the subscription. | |
| userrolect_role_name | String | Specifies the name of the role assigned to the subscribed user. | |
| userrolect_role_ref | String | References the role record defining the permissions granted to the user. | |
| userrolect_role_ref_link | String | Provides a link to the detailed role record associated with the user. | |
| userrolect_sys_created_by | String | Identifies the user who created the user role record. | |
| userrolect_sys_created_on | Datetime | Records the date and time when the user role record was created. | |
| userrolect_sys_mod_count | Int | Tracks how many times the user role record has been modified. | |
| userrolect_sys_tags | String | Stores tags used to organize or categorize the user role record. | |
| userrolect_sys_updated_by | String | Indicates the user who last updated the user role record. | |
| userrolect_sys_updated_on | Datetime | Records the date and time of the most recent update to the user role record. | |
| userrolect_table_name | String | Specifies the name of the table where the user role information is stored. | |
| userrolect_table_ref | String | References the specific table record linked to the user's role assignment. | |
| userrolect_table_ref_link | String | Provides a link to the table record associated with the user's role assignment. | |
| userrolect_user | String | References the user assigned to the role within the subscription. | |
| userrolect_user_link | String | Provides a link to the user record associated with the role assignment. | |
| userct_sys_id | String | Provides the sys_id for the user subscription count record tracking role usage. | |
| userct_count | Int | Indicates the total number of users assigned to a given role during the reporting period. | |
| userct_end_month | String | Specifies the end month of the reporting or tracking period. | |
| userct_roles | String | Lists the roles included in the user's active subscription during the reporting period. | |
| userct_start_month | String | Specifies the start month of the reporting or tracking period. | |
| userct_sys_created_by | String | Identifies the user who created the subscription count record. | |
| userct_sys_created_on | Datetime | Records when the subscription count record was created. | |
| userct_sys_mod_count | Int | Tracks how many times the subscription count record has been updated. | |
| userct_sys_tags | String | Stores metadata or tags applied to the subscription count record for classification. | |
| userct_sys_updated_by | String | Identifies the user who last modified the subscription count record. | |
| userct_sys_updated_on | Datetime | Records when the subscription count record was last updated. | |
| userct_user | String | References the user associated with the subscription usage and role count. | |
| userct_user_link | String | Provides a link to the user record related to the subscription count entry. |