This article provides all the Fields available for each View currently available under the Role Scheduling Data Source in Upland Analytics.
The following Views are available when Role Scheduling Data Source is selected upon creating a report. Click on any of them to view the available Fields.
Version Note: Available as of Tenrox 2018 R1 SP6.
Note: This page is being updated as new information becomes available.
Role
| Field Name | Description | Type |
| Role | This is the name of the role. |
|
| Role Calendar | This is the role calendar. |
|
| Role Description | This is the description of the . |
|
| Role Hourly Billing Rate | This is the hourly billing rate used for forecasting. |
|
| Role Hourly Cost Rate | This is the hourly cost rate used for forecasting. |
|
| Role ID | This is the id of the role. |
|
| Role Is Active | This defines whether the role is active. This will show 0 (for suspended) or 1 (for active). |
|
| Role Type | This is the role type. |
|
Role Availability
| Field Name | Description | Type |
| Availability Available Hours as Alternate | This is the number of available hours for users with this role as an alternate role e.g. calculate Max(Total working hours as alternate - Hard booking hours for users that have this alternate, 0). All user bookings are considered even if the user is booked on a different role. |
|
| Availability Available Hours as Primary | This is the number of available hours for users with this role as their primary role e.g. calculate Max(Total working hours as primary - Hard booking hours for users that have this primary role, 0). All user bookings are considered even if the user is booked on their alternate role. |
|
| Availability Date | This is the availability date. |
|
| Availability Date Day of Week | This is the availability date (Aggregate Day of Week). |
|
| Availability Date Month | This is the availability date (Aggregate Date - Month). |
|
| Availability Date Month Year | This is the availability date (Aggregate Date - Month Year). |
|
| Availability Date Quarter | This is the availability date (Aggregate Date - Quarter). |
|
| Availability Date Quarter Year | This is the availability date (Aggregate Date - Quarter Year). |
|
| Availability Date Week | This is the availability date (Aggregate Date - Week). |
|
| Availability Date Year | This is the availability date (Aggregate Date - Year). |
|
| Availability Hard Booked Hours as Alternate | This is the total number of user hard bookings for users that have this role as their alternate role. This only includes all hard bookings on this role. |
|
| Availability Hard Booked Hours as Primary | This is the total number of user hard bookings for users that have this role as their primary role. This only includes hard bookings on this role. |
|
| Availability Has Overallocated Users | This indicates if there are any users with this role as their primary role that are overallocated on this date. |
|
| Availability Role Hard Booked Hours | This is the total number of hard booked hours for this role whether or not the booking is on a user or not. |
|
| Availability Role Soft Booked Hours | This is the total number of soft booked hours for this role whether or not the booking is on a user or not |
|
| Availability Soft Booked Hours as Alternate | This is the total number of user soft bookings for users that have this role as their alternate role. This only includes soft bookings on this role. |
|
| Availability Soft Booked Hours as Primary | This is the total number of user soft bookings for users that have this role as their primary role. This only includes soft bookings on this role. |
|
| Availability Total Working Hours as Alternate | This is the total working hours for each user based on their own calendar (Total Working Hours = Working Hours - Overhead + Overload), summed over all users with this role as their alternate role. |
|
| Availability Total Working Hours as Primary | This is the total working hours for each user based on their own calendar (Total Working Hours = Working Hours - Overhead + Overload), summed over all users with this role as their primary role. |
|
| Availability Unstaffed Hard Booked Hours | This is the number of hard booked hours for this role that have not been allocated to any users (i.e. unfilled demand). |
|
| Availability Unstaffed Soft Booked Hours | This is the number of soft booked hours for this role that have not been allocated to any users (i.e. unfilled demand). |
|
Role Resource Group
| Field Name | Description | Type |
| Role Resource Group Default Task | This is the default task of the resource group of the role. |
|
| Role Resource Group Description | This is the description of the resource group of the role. |
|
| Role Resource Group ID | This is the ID of the resource group of the role. |
|
| Role Resource Group Name | This is the name of the resource group of the role. |
|
Menu