This article provides all the Fields available for each View currently available under the Work Process Entry Data Source in Upland Analytics.
The following Views are available when Work Process Entry 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.
Client
| Field Name | Description | Type |
| Client | This is the name of the client. |
|
| Client Account Executive First Name | This is the last name of the client's account executive. |
|
| Client Account Executive Last Name | This is the last name of the client's account executive. |
|
| Client Address Line 1 | This is the first line of the client's address. |
|
| Client Address Line 2 | This is the second line of the client's address. |
|
| Client Annual Revenue | This is the annual revenue of the client (as defined on the CRM tab of Client Edit). |
|
| Client City | This is the client's city. |
|
| Client Company | This is the company of the client. |
|
| Client Company Type | This is the company type of the client (as defined on the CRM tab of Client Edit). |
|
| Client Country | This is the country of the client. |
|
| Client Country Code | This is the country code of the client. |
|
| Client Department | This is the department of the client. |
|
| Client Description | This is the description of the client. |
|
| Client Division | This is the division of the client. |
|
| Client Email | This is the email address of the client. |
|
| Client Employees | This is the number of employees of the client (as defined on the CRM tab of Client Edit). |
|
| Client Exchange Rate | This identifies which exchange change should be used for invoicing (e.g. entry date, invoice start date, invoice end date). |
|
| Client Fax | This is the fax number of the client. |
|
| Client Fiscal End Date | This is the fiscal end date of the client (as defined on the CRM tab of Client Edit). |
|
| Client Id | This is the Id of the client. |
|
| Client Industry | This is the industry of the client (as defined on the CRM tab of Client Edit). |
|
| Client Invoice Issuer Contact First Name | This is the first name of the invoice issuer contact of the client. |
|
| Client Invoice Issuer Contact Last Name | This is the last name of the invoice issuer contact of the client. |
|
| Client Invoice To The Attn Of First Name | This is the first name of the client contact in the To the Attention of field. |
|
| Client Invoice To The Attn Of Last Name | This is the last name of the client contact in the To the Attention of field. |
|
| Client Ownership | This is the ownership of the client (as defined on the CRM tab of Client Edit). |
|
| Client Payment Term | This is the payment term for the client. |
|
| Client Phone | This is the phone number of the client. |
|
| Client Purchase | This is the purchase status of the client (as defined on the CRM tab of Client Edit). |
|
| Client Rating | This is the rating of the client (as defined on the CRM tab of Client Edit). |
|
| Client Reference Customer | This is the reference customer of the client (as defined on the CRM tab of Client Edit). |
|
| Client Referred By | This is the user who referred the client (as defined on the CRM tab of Client Edit). |
|
| Client Sic Code | This is the SIC code of the client (as defined on the CRM tab of Client Edit). |
|
| Client State Province | This is the state or province of the client. |
|
| Client State Province Code | This is the state or province code of the client |
|
| Client Status | This is the status of the client (as defined on the CRM tab of Client Edit). |
|
| Client Status Comment | This is the status comment of the client (as defined on the CRM tab of Client Edit). |
|
| Client Tax Group | This is the tax group of the client. |
|
| Client Ticker Symbol | This is the ticker symbol of the client (as defined on the CRM tab of Client Edit). |
|
| Client Type | This is the type of the client. |
|
| Client Web Site | This is the web site of the client (as defined on the CRM tab of Client Edit). |
|
| Client Zip Postal Code | This is the zip or postal code of the client. |
|
Project
| Field Name | Description | Type |
| Project | This is the name of the project. |
|
| Project Code | This is the project code. |
|
| Project Company | This is the accounting company associated to the project. |
|
| Project Created On | This is the Date and Time the Project was created on. |
|
| Project Description | This is the description of the project. |
|
| Project End | This is the end date of the project. |
|
| Project Health | This is the project health. |
|
| Project Id | This is the Id of the project. |
|
| Project Is Active | This defines whether the project is active. This will show 0 (for suspended) or 1 (for active). |
|
| Project Parent | This is the parent project. |
|
| Project Priority | This is the priority of the project. |
|
| Project Start | This is the start date of the project. |
|
| Project State | This is the state of the project. |
|
| Project Sum of Allocated Hours | This is the sum of allocated time of a project (in hours). |
|
| Project Sum of Planned Hours | This is the sum of planned work of a project (in hours). |
|
| Project Tracking No | This is the project tracking number. |
|
| Project Workflow | This is the project workflow. |
|
Scope - Available Projects
| Field Name | Description | Type |
| Login Name | This is the name of the logged in user. |
Task
| Field Name | Description | Type |
| Task | This is the name of the task. |
|
| Task Description | This is the description of the task. |
|
| Task End | This is the end date of the task. |
|
| Task ETC Enabled | This defines whether ETC is enabled on the task. This will show 1 if ETC is enabled, 0 otherwise. |
|
| Task ID | This is the ID of the task. |
|
| Task Is Active | This defines whether the task is active. This will show 0 (for suspended/decommissioned) or 1 (for active). |
|
| Task Is Billable | This defines whether the task is billable. This will show 0 (for non-billable) or 1 (for billable). |
|
| Task Is Capitalized | This defines whether the task is capitalized This will show 0 (for not capitalized) or 1 (for capitalized). |
|
| Task Is Funded | This defines whether the task is payable This will show 0 (for not payable) or 1 (for payable). |
|
| Task Is Payable | This defines whether the task is payable This will show 0 (for not payable) or 1 (for payable). |
|
| Task Is Project Overhead | This indicates if the task is considered a cost / overhead to the company (1) or not (0). |
|
| Task Is RandD | This defines whether the task is R&D This will show 0 (for not R&D) or 1 (for R&D). |
|
| Task Milestone | This is the milestone that is associated to the task. |
|
| Task Priority | This is the priority of the task. |
|
| Task Start | This is the start date of the task. |
|
| Task State | This is the state of the task. |
|
| Task Used by Expense | This defines whether the task can be used by Expense. |
|
| Task Used by Money Charge | This defines whether the task can be used by Money Charges. |
|
| Task Used by Product | This defines whether the task can be used by Products. |
|
| Task Used by Purchase | This defines whether the task can be used by Purchases. |
|
| Task Used by Resource Planning | This defines whether the task can be used by Resource Planning. |
|
| Task Used by Time | This defines whether the task can be used by Time. |
|
| Task Used by Work Process | This defines whether the task can be used by Work Processes. |
|
Work Process Entry
| Field Name | Description | Type |
| Creator Full Name | This field will display the Creator's Full Name |
|
| Originator Full Name | This field will display the Originator's Full Name |
|
| Work Process Entry Additional Info | This field will display the additional info of the work process entry |
|
| Work Process Entry Assigned To | This field will display the assignment rule name of the current work process entry state. For example, an assignment to User with title Administrator will be displayed as “Title: Administrator” The functionality is similar to what is done for the Expense views |
|
| Work Process Entry Component | This field will display the component of the work process entry |
|
| Work Process Entry Created On | This field will display the creation date of the work process entry |
|
| Work Process Entry Created On Month | This field will display the creation month date of the work process entry |
|
| Work Process Entry Created On Month Year | This field will display the creation month year date of the work process entry |
|
| Work Process Entry Created On Quarter | This field will display the creation quarter date of the work process entry |
|
| Work Process Entry Created On Quarter Year | This field will display the creation quarter year date of the work process entry |
|
| Work Process Entry Created On Year | This field will display the creation year date of the work process entry |
|
| Work Process Entry Days Open | This field will display the number of days the work process entry has been open |
|
| Work Process Entry Deadline |
|
|
| Work Process Entry Description | "This field will display the description of the work process entry. Should be in the same format as in the work process entry description field (order as well). " |
|
| Work Process Entry Is Approved | This flag defines if the entry is in an approved state |
|
| Work Process Entry Is Final | This flag defines if the entry is in a final state |
|
| Work Process Entry Is Open | This flag defines if the entry is in an open state |
|
| Work Process Entry Is Rejected | This flag defines if the entry is in a rejected state |
|
| Work Process Entry Modified On | This field will display the modification date of the work process entry |
|
| Work Process Entry Modified On Month | This field will display the modification month date of the work process entry |
|
| Work Process Entry Modified On Month Year | This field will display the modification month year date of the work process entry |
|
| Work Process Entry Modified On Quarter | This field will display the modification quarter date of the work process entry |
|
| Work Process Entry Modified On Quarter Year | This field will display the modification quarter year date of the work process entry |
|
| Work Process Entry Modified On Year | This field will display the modification year date of the work process entry |
|
| Work Process Entry Note | "This field will display the notes associated to the work process entry If there are multiple notes, they will be separated by 3 dashes (- - -)" |
|
| Work Process Entry Priority | This field will display the priority (name) of the work process entry |
|
| Work Process Entry State | This field will display the current state of the work process entry |
|
| Work Process Entry Summary | This field will display the summary of the work process entry |
|
| Work Process Entry Tracking Number | This field will display the tracking # of the work process entry |
|
| Work Process Entry Way To Reproduce | This field will display the way to reproduce of the work process entry |
|
| Work Process Entry Work Around | This field will display the workaround of the work process entry |
|
| Work Process Workflow Alias | This field will display the work process workflow alias |
|
| Work Process Workflow Name | This field will display the work process workflow name |
|
Menu