This article provides all the Fields available for each View currently available under the Leave Request Data Source in Upland Analytics.
The following Views are available when Leave Request Data Source is selected upon creating a report. Click on any of them to view the available Fields.
- Active Site
- Approval Alternate Group Manager
- Approval Group Manager
- Creator
- Functional Alternate Group Manager
- Functional Group Manager
- Leave Request
- Master Site
- Originator
- Originator Approval Group
- Originator Functional Group
- Originator Resource Group
- Resource Alternate Group Manager
- Resource Group Manager
- Scope - All Groups
- Scope - My Approval Groups
- Scope - My Entries
- Scope - My Functional Group
- Scope - My Resource Groups
Version Note: The Leave Request Data Source, Views and Fields are available as of Tenrox 2019 R1.
Note: This page is being updated as new information becomes available.
Active Site
| Field Name | Description | Type |
| Active Site | This is the name of the user's active site. |
|
| Active Site ID | This is the ID of the user's active site. |
|
Approval Alternate Group Manager
| Field Name | Description | Type |
| Approval Alternate Group Manager First Name | This is the first name of the approval alternate group manager. |
|
| Approval Alternate Group Manager ID | This is the ID of the approval alternate group manager. |
|
| Approval Alternate Group Manager Last Name | This is the last name of the approval alternate group manager. |
|
Approval Group Manager
| Field Name | Description | Type |
| Approval Group Manager First Name | This is the first name of the approval group manager. |
|
| Approval Group Manager ID | This is the ID of the approval group manager. |
|
| Approval Group Manager Last Name | This is the last name of the approval group manager. |
|
Functional Alternate Group Manager
| Field Name | Description | Type |
| Functional Alternate Group Manager First Name | This is the first name of the functional alternate group manager. |
|
| Functional Alternate Group Manager ID | This is the ID of the functional alternate group manager. |
|
| Functional Alternate Group Manager Last Name | This is the last name of the functional alternate group manager. |
|
Functional Group Manager
| Field Name | Description | Type |
| Functional Group Manager First Name | This is the first name of the functional group manager. |
|
| Functional Group Manager ID | This is the ID of the functional group manager. |
|
| Functional Group Manager Last Name | This is the last name of the functional group manager. |
|
Leave Request
| Field Name | Description | Type |
| Leave Request Assigned Users | This is the user assigned to the leave request. This is in the format Last Name, First Name. |
|
| Leave Request Created On | This is the creation date of the leave request |
|
| Leave Request Created On Month | This is the creation date of the leave request (Aggregate Date - Month). |
|
| Leave Request Created On Month Year | This is the creation date of the leave request (Aggregate Date - Month Year). |
|
| Leave Request Created On Quarter | This is the creation date of the leave request (Aggregate Date - Quarter). |
|
| Leave Request Created On Quarter Year | This is the creation date of the leave request (Aggregate Date - Quarter Year). |
|
| Leave Request Created On Week | This is the creation date of the leave request (Aggregate Date - Week). |
|
| Leave Request Created On Year | This is the creation date of the leave request (Aggregate Date - Year). |
|
| Leave Request Date Modified On | This is the date on which the leave request was modified |
|
| Leave Request Date Modified On Month | This is the date on which the leave request was modified (Aggregate Date - Month). |
|
| Leave Request Date Modified On Month Year | This is the date on which the leave request was modified (Aggregate Date - Month Year). |
|
| Leave Request Date Modified On Quarter | This is the date on which the leave request was modified (Aggregate Date - Quarter). |
|
| Leave Request Date Modified On Quarter Year | This is the date on which the leave request was modified (Aggregate Date - Quarter Year). |
|
| Leave Request Date Modified On Week | This is the date on which the leave request was modified (Aggregate Date - Week). |
|
| Leave Request Date Modified On Year | This is the date on which the leave request was modified (Aggregate Date - Year). |
|
| Leave Request Description | This is the description of the leave request |
|
| Leave Request End | This is the end date of the leave request |
|
| Leave Request End Month | This is the end date of the leave request (Aggregate Date - Month). |
|
| Leave Request End Month Year | This is the end date of the leave request (Aggregate Date - Month Year). |
|
| Leave Request End Quarter | This is the end date of the leave request (Aggregate Date - Quarter). |
|
| Leave Request End Quarter Year | This is the end date of the leave request (Aggregate Date - Quarter Year). |
|
| Leave Request End Week | This is the end date of the leave request (Aggregate Date - Week). |
|
| Leave Request End Year | This is the end date of the leave request (Aggregate Date - Year). |
|
| Leave Request Hours Per Day | This is the hours per day entered for the leave request |
|
| Leave Request Reason | This is the reason of the leave request |
|
| Leave Request Start | This is the start date of the leave request |
|
| Leave Request Start Month | This is the start date of the leave request (Aggregate Date - Month). |
|
| Leave Request Start Month Year | This is the start date of the leave request (Aggregate Date - Month Year). |
|
| Leave Request Start Quarter | This is the start date of the leave request (Aggregate Date - Quarter). |
|
| Leave Request Start Quarter Year | This is the start date of the leave request (Aggregate Date - Quarter Year). |
|
| Leave Request Start Week | This is the start date of the leave request (Aggregate Date - Week). |
|
| Leave Request Start Year | This is the start date of the leave request (Aggregate Date - Year). |
|
| Leave Request State | This is the state of the leave request |
|
| Leave Request Summary | This is the summary of the leave request |
|
| Leave Request Total Hours | This is the total hours requested. This is calculated as the number of hours per day multiplied by the number of weekdays within the start and end date of the request |
|
| Leave Request Tracking No | This is the tracking number of the leave request |
|
| Leave Request Workflow | This is the name of the leave request workflow |
|
Master Site
| Field Name | Description | Type |
| Master Site | This is the name of the user's master site |
|
| Master Site ID | This is the unique ID of the user's master site |
|
Originator
| Field Name | Description | Type |
| Originator Address | This is the address of the originator. |
|
| Originator Business Phone | This is the business phone number of the originator. |
|
| Originator Description | This is the description of the originator. |
|
| Originator Email | This is the email address of the originator. |
|
| Originator Fax | This is the fax number of the originator. |
|
| Originator First Name | This is the first name of the originator. |
|
| Originator Hire Date | This is the hire date of the originator. |
|
| Originator Holiday Set | This is the holiday set of the originator. |
|
| Originator Id | This is the Id of the originator. |
|
| Originator Is Active | This defines whether the originator is active. This will show 0 (for suspended or decommissioned) or 1 (for active). |
|
| Originator Language | This is the language of the originator. |
|
| Originator Last Evaluation Date | This is the last evaluation date of the originator. |
|
| Originator Last Name | This is the last name of the originator. |
|
| Originator Logon Name | This is the logon name of the originator |
|
| Originator Mobile | This is the mobile phone number of the originator. |
|
| Originator Next Evaluation Date | This is the next evaluation date of the originator. |
|
| Originator Pager | This is the pager number of the originator. |
|
| Originator Phone | This is the phone number of the originator. |
|
| Originator Primary Role | This is the primary role of the originator. |
|
| Originator Resource Type | This is the name of the (current) resource type of the originator. |
|
| Originator Resource Type Id | This is the Id of the (current) resource type of the originator. |
|
| Originator Security Role | This is the security role of the originator. |
|
| Originator Service Date | This is the service date of the originator. |
|
| Originator Termination Date | This is the termination date of the originator. |
|
| Originator Title | This is the title of the originator. |
|
| Originator Type | This is the user type of the originator. |
|
Originator Approval Group
| Field Name | Description | Type |
| Default Task | This is the default task of the approval group. |
|
| Group Description | This is the description of the approval group. |
|
| Group Id | This is the unique ID of the approval group. |
|
| Group Name | This is the name of the approval group. |
|
Originator Functional Group
| Field Name | Description | Type |
| Default Task | This is the default task of the functional group. |
|
| Group Description | This is the description of the functional group. |
|
| Group Id | This is the unique ID of the functional group. |
|
| Group Name | This is the name of the functional group. |
|
Originator Resource Group
| Field Name | Description | Type |
| Default Task | This is the default task of the resource group. |
|
| Group Description | This is the description of the resource group. |
|
| Group Id | This is the unique ID of the resource group. |
|
| Group Name | This is the name of the resource group. |
|
Resource Alternate Group Manager
| Field Name | Description | Type |
| Resource Alternate Group Manager First Name | This is the first name of the alternate group manager of the resource group. |
|
| Resource Alternate Group Manager ID | This is the ID of the alternate group manager of the resource group. |
|
| Resource Alternate Group Manager Last Name | This is the last name of the alternate group manager of the resource group. |
|
Resource Group Manager
| Field Name | Description | Type |
| Resource Group Manager First Name | This is the first name of the group manager of the resource group. |
|
| Resource Group Manager ID | This is the ID of the group manager of the resource group. |
|
| Resource Group Manager Last Name | This is the last name of the group manager of the resource group. |
|
Scope - My Approval Groups
| Field Name | Description | Type |
| Login Name | This is the name of the logged in user. |