This article provides all the Fields available for each View currently available under the Leave Time History Data Source in Upland Analytics.
The following Views are available when Leave Time History Data Source is selected upon creating a report. Click on any of them to view the available Fields.
Version Note: The Leave Time History Data Source, Views and Fields are available as of Tenrox 2019 R1 SP2.
Note: This page is being updated as new information becomes available.
Leave Time History
| Field Name | Description | Type |
| Leave Time Change Source | This field will display the source of the change. Should be similar to what is displayed from the Change History page |
|
| Leave Time Change Type | This field will display the type of the change. Possible values are Accrual, Reset, Manual and Time Entry |
|
| Leave Time Change Value | This field will display the value by which the bank was updated |
|
| Leave Time Current Value | This field will display the current leave time bank value. |
|
| Leave Time Date Modified | This field will display the date on which the leave time bank value was modified |
|
| Leave Time Effective Date | This field will display the date from which the change value is valid |
|
| Leave Time Effective Date Month | This field will display the month date from which the change value is valid |
|
| Leave Time Effective Date Month Year | This field will display the month year date from which the change value is valid |
|
| Leave Time Effective Date Quarter | This field will display the quarter date from which the change value is valid |
|
| Leave Time Effective Date Quarter Year | This field will display the quarter year date from which the change value is valid |
|
| Leave Time Effective Date Year | This field will display the year date from which the change value is valid |
|
| Leave Time Entry Date | This field will display the date of the time entry |
|
| Leave Time Entry Date Month | This field will display the month date of the time entry |
|
| Leave Time Entry Date Month Year | This field will display the month year date of the time entry |
|
| Leave Time Entry Date Quarter | This field will display the quarter date of the time entry |
|
| Leave Time Entry Date Quarter Year | This field will display the quarter year date of the time entry |
|
| Leave Time Entry Date Year | This field will display the year date of the time entry |
|
| Leave Time Entry Hours | This field will display the number of hours entered |
|
| Leave Time Entry Is Approved | This field specifies whether the entry is approved |
|
| Leave Time Entry Is Completed | This field specifies whether the entry is completed |
|
| Leave Time Entry Notes | This field will display the entry notes. If multiple notes, then will be separated by |-| (pipe, dash, pipe) |
|
| Leave Time Value On Date Modified | This field will display the value of the bank on the date modified |
|
Scope - My Approval Groups
| Field Name | Description | Type |
| Login Name | This is the name of the logged in user. |
Scope - My Functional Group
| Field Name | Description | Type |
| Login Name | This is the name of the logged in user. |
Scope - My Resource Group
| Field Name | Description | Type |
| Login Name | This is the name of the logged in user. |
User
| Field Name | Description | Type |
| User Address | This is the address of the user. |
|
| User Alternate Phone | This is the alternate phone number of the user. |
|
| User Business Phone | This is the business phone number of the user. |
|
| User Can Report On Any Client | This defines whether the user can report on any client (Yes/No). |
|
| User Can Report On Any Group | This defines whether the user can report on any group (Yes/No). |
|
| User Can Report On Any Project | This defines whether the user can report on any project(Yes/No). |
|
| User Can Report On Any User | This defines whether the user can report on any user (Yes/No). |
|
| User Description | This is the description of the user. |
|
| User Email | This is the email address of the user. |
|
| User Fax | This is the fax number of the user. |
|
| User First Name | This is the first name of the user. |
|
| User Gender | This is the user gender. |
|
| User Hire Date | This is the hire date of the user. |
|
| User Holiday Set | This is the holiday set of the user. |
|
| User ID | This is the Id of the user. |
|
| User Is Active | This defines whether the user is active (Yes/No). |
|
| User Is Decommissioned | This defines whether the user is decommissioned. This will show 0 (for not decommissioned) or 1 (for decommissioned). |
|
| User Is Suspended | This defines whether the user is Suspended. This will show 0 (for not suspended) or 1 (for suspended). |
|
| User Language | This is the language of the user. |
|
| User Last Evaluation Date | This is the last evaluation date date of the user. |
|
| User Last Name | This is the last name of the user. |
|
| User Logon Name | This is the logon name of the user |
|
| User Mobile | This is the mobile phone number of the user. |
|
| User Name | This is the user name (Last Name, First Name). |
|
| User Next Evaluation Date | This is the next evaluation date of the user. |
|
| User Pager | This is the pager number of the user. |
|
| User Primary Role | This is the primary role of the user. |
|
| User Resource Type | This is the name of the (current) resource type. |
|
| User Resource Type ID | This is the Id of the (current) resource type. |
|
| User Security Role | This is the security role of the user. |
|
| User Service Date | This is the service date of the user. |
|
| User Termination Date | This is the termination date of the user. |
|
| User Title | This is the title of the user. |
|
| User Type | This is the user type of the user. |
|
Version note: Available as of Tenrox 2019 R1 SP4: User Name (Last Name, First Name), Suspended, Decommissioned, Gender, Can report on any client, Can report on any group, Can report on any project and Can report on any user.
User Approval Group
| Field Name | Description | Type |
| Approval Group Default Task | This is the default task of the approval group. |
|
| Approval Group Description | This is the description of the approval group. |
|
| Approval Group ID | This is the unique ID of the approval group. |
|
| Approval Group Name | This is the name of the approval group. |
|
User Functional Group
| Field Name | Description | Type |
| Functional Group Default Task | This is the default task of the functional group. |
|
| Functional Group Description | This is the description of the functional group. |
|
| Functional Group ID | This is the unique ID of the functional group. |
|
| Functional Group Name | This is the name of the functional group. |
|
User Resource Group
| Field Name | Description | Type |
| Resource Group Default Task | This is the default task of the resource group. |
|
| Resource Group Description | This is the description of the resource group. |
|
| Resource Group ID | This is the unique ID of the resource group. |
|
| Resource Group Name | This is the name of the resource group. |
|
Work Type
| Field Name | Description | Type |
| Work Type | This is the name of the work type. |
|
| Work Type Description | This is the description of the work type. |
|
| Work Type ETC Enabled | This defines whether ETC is enabled on the task. This will show 1 if ETC is enabled, 0 otherwise. |
|
| Work Type ID | This is the ID of the work type. |
|
| Work Type Is Billable | This defines whether the task is billable. This will show 0 (for non-billable) or 1 (for billable). |
|
| Work Type Is Capitalized | This defines whether the task is capitalized This will show 0 (for not capitalized) or 1 (for capitalized) |
|
| Work Type Is Funded | This defines whether the task is payable This will show 0 (for not funded) or 1 (for funded) |
|
| Work Type Is Leave Time | This defines whether the work type is a leave time work type. This will show 1 if it is a leave time work type, 0 otherwise. |
|
| Work Type Is Payable | This defines whether the task is payable This will show 0 (for not payable) or 1 (for payable). |
|
| Work Type Is R&D | This defines whether the task is R&D This will show 0 (for not R&D) or 1 (for R&D) |
|
| Work Type Parent | This is the parent of the work type. |
|
| Work Type Used by Expense | This defines whether the task can be used by Expenses. |
|
| Work Type Used by Money Charge | This defines whether the task can be used by Money Charges. |
|
| Work Type Used by Product | This defines whether the task can be used by Products. |
|
| Work Type Used by Purchase | This defines whether the task can be used by Purchases. |
|
| Work Type Used by Resource Planning | This defines whether the task can be used by Resource Planning. |
|
| Work Type Used by Time | This defines whether the task can be used by Time. |
|
| Work Type Used by Work Process | This defines whether the task can be used by Work Processes. |
|
Menu