The In/Out Timesheet Data Source provides comprehensive reporting capabilities on In/Out Timesheet entries and summaries. Using the available Views, you can build reports to track timesheet details by Project, Task, User, and Approval Groups, with flexible Scope options across Groups, Projects, and functional areas. Ideal for monitoring timesheet submissions, approvals, and attendance-related data within your organization.
This article lists all the Fields available for each View currently supported under the In/Out Timesheet Data Source in Upland Analytics.
When creating a report, select this data source to access the Views described below. Click any View name to see its available Fields and descriptions.
- Approval Alternate Group Manager
- Approval Group Manager
- Project
- Project Manager
- Scope - All Groups
- Scope - All Projects
- Scope - Available Projects
- Scope - Client Contacts
- Scope - My Approval Groups
- Scope - My Entries
- Scope - My Functional Group
- Scope - My Projects
- Task
- Timesheet In/Out
- Timesheet Summary
- User
- User Approval Group
Note: This page is being updated as new information becomes available.
Approval Alternate Group Manager
Approval Alternate Group Manager
| Field Name | Description | Type |
|---|---|---|
| Approval Alternate Group Manager First Name | This is the alternate Approval Group Manager First name. |
|
| Approval Alternate Group Manager Id | This is the alternate Approval Group Manager Id. |
|
| Approval Alternate Group Manager Last Name | This is the alternate Approval Group Manager Last name. |
|
Approval Group Manager
Approval Group Manager
| Field Name | Description | Type |
|---|---|---|
| Approval Group Manager First Name | This is the Approval Group Manager First name. |
|
| Approval Group Manager Id | This is the Approval Group Manager Id. |
|
| Approval Group Manager Last Name | This is the Approval Group Manager Last name. |
|
Project
Project
| Field Name | Description | Type |
|---|---|---|
| Project | This is the Name of the Project. |
|
| Project Actual End | This is the Actual End date of the Project; latest Time Entry date. |
|
| Project Actual End Month | This is the Actual End date of the Project; latest Time Entry date (Aggregate Date - Month). |
|
| Project Actual End Month Year | This is the Actual End date of the Project; latest Time Entry date (Aggregate Date - Month Year). |
|
| Project Actual End Quarter | This is the Actual End date of the Project; latest Time Entry date (Aggregate Date - Quarter). |
|
| Project Actual End Quarter Year | This is the Actual End date of the Project; latest Time Entry date (Aggregate Date - Quarter Year). |
|
| Project Actual End Week | This is the Actual End date of the project; latest Time Entry date (Aggregate Date - Week). |
|
| Project Actual End Year | This is the Actual End date of the Project; latest Time Entry date (Aggregate Date - Year). |
|
| Project Actual Start | This is the Actual Start date of the Project; earliest Time Entry date. |
|
| Project Actual Start Month | This is the Actual Start date of the Project; earliest Time Entry date (Aggregate Date - Month). |
|
| Project Actual Start Month Year | This is the Actual Start date of the Project; earliest Time Entry date (Aggregate Date - Month Year). |
|
| Project Actual Start Quarter | This is the Actual Start date of the Project; earliest Time Entry date (Aggregate Date - Quarter). |
|
| Project Actual Start Quarter Year | This is the Actual Start date of the Project; earliest Time Entry date (Aggregate Date - Quarter Year). |
|
| Project Actual Start Week | This is the Actual Start date of the Project; earliest Time Entry date (Aggregate Date - Week). |
|
| Project Actual Start Year | This is the Actual Start date of the Project; earliest Time Entry date (Aggregate Date - Year). |
|
| Project Code | This is the Project Code. |
|
| Project Company | This is the accounting Company associated to the Project. |
|
| Project Contact | This will display the Project Contact Name (Last Name, First Name). If multiple Contacts exist, they will be separated by a --. |
|
| Project Date Created | 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 Health of the Project. |
|
| 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 Link | This is the Name of the Project with a link to the corresponding Project Edit page. |
|
| Project Parent | This is the Parent Project Name of the 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 Hours of a Project (in hours). |
|
| Project Sum of Planned Hours | This is the sum of Planned work Hours of a Project (in hours). |
|
| Project Tracking No | This is the Tracking # of the Project. |
|
| Project Workflow | This is the Workflow associated to the Project. |
|
Project Manager
Project Manager
| Field Name | Description | Type |
|---|---|---|
| Project Manager First Name | This is the First name of the Project Manager. |
|
| Project Manager Id | This is the Id of the Project Manager. |
|
| Project Manager Last Name | This is the Last name of the Project Manager. |
|
Scope - All Groups
Scope - All Groups
| Field Name | Description | Type |
|---|---|---|
| Login Name | This is the Logon name of the logged in User. |
Scope - All Projects
Scope - All Projects
| Field Name | Description | Type |
|---|---|---|
| Login Name | This is the Logon name of the logged in User. |
Scope - Available Projects
Scope - Available Projects
| Field Name | Description | Type |
|---|---|---|
| Login Name | This is the Logon name of the logged in User. |
Scope - Client Contacts
Scope - Client Contacts
| Field Name | Description | Type |
|---|---|---|
| Login Name | This is the Logon name of the logged in User. |
Scope - My Approval Groups
Scope - My Approval Groups
| Field Name | Description | Type |
|---|---|---|
| Login Name | This is the Logon name of the logged in User. |
Scope - My Entries
Scope - My Entries
| Field Name | Description | Type |
|---|---|---|
| Login Name | This is the Logon name of the logged in User. |
Scope - My Functional Group
Scope - My Functional Group
| Field Name | Description | Type |
|---|---|---|
| Login Name | This is the Logon name of the logged in User. |
Scope - My Projects
Scope - My Projects
| Field Name | Description | Type |
|---|---|---|
| Login Name | This is the Logon name of the logged in User. |
Task
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 No (for suspended/decommissioned) or Yes (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 Decommissioned | This defines whether the Task is Decommissioned (yes/No). |
|
| Task Is Funded | This defines whether the Task is Funded. 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 Is Suspended | This defines whether the Task is Suspended (yes/No). |
|
| Task Link | This is the Name of the Task with a link to the corresponding Task Edit page. |
|
| 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. |
|
Timesheet In/Out
Timesheet In/Out
| Field Name | Description | Type |
|---|---|---|
| In Out Timesheet Duration | This is the duration of the In/Out Entry in hours. |
|
| In Out Timesheet Entry Date | This is the Entry Date of the In/Out Entry. |
|
| In Out Timesheet Entry Date Month | This is the Entry Date of the In/Out Entry (Aggregate Date - Month). |
|
| In Out Timesheet Entry Date Month Year | This is the Entry Date of the In/Out Entry (Aggregate Date - Month Year). |
|
| In Out Timesheet Entry Date Quarter | This is the Entry Date of the In/Out Entry (Aggregate Date - Quarter). |
|
| In Out Timesheet Entry Date Quarter Year | This is the Entry Date of the In/Out Entry (Aggregate Date - Quarter Year). |
|
| In Out Timesheet Entry Date Week | This is the Entry Date of the In/Out Entry (Aggregate Date - Week). |
|
| In Out Timesheet Entry Date Year | This is the Entry Date of the In/Out Entry (Aggregate Date - Year). |
|
| In Out Timesheet Entry Note | This is the Note of the In/Out Entry. |
|
| In Out Timesheet In Time | This is the In time of the In/Out Entry. |
|
| In Out Timesheet Out Time | This is the Out time of the In/Out Entry. |
|
Timesheet Summary
Timesheet Summary
| Field Name | Description | Type |
|---|---|---|
| Timesheet Assigned To | This is the name of the User(s) assigned to the current State of the Timesheet. If more than 1 User is assigned, they will be separated by a --. |
|
| Timesheet Document Count | This is the number of documents attached to the Timesheet. |
|
| Timesheet Is Approved | This defines whether the Timesheet is approved. This will show 0 (for not approved) or 1 (for approved). |
|
| Timesheet Is Completed | This defines whether the Timesheet is completed. This will show 0 (for not completed) or 1 (for completed). |
|
| Timesheet is Final | Displays Yes/No to indicate if Timesheet Is Final or not. |
|
| Timesheet is Read Only | Displays Yes/No to indicate if Timesheet Is Read-only or not. |
|
| Timesheet is Rejected | This defines whether the Timesheet is rejected. This will show 0 (for not rejected) or 1 (for rejected). |
|
| Timesheet Link | This is the Timesheet Period with a link to the corresponding Timesheet edit page. |
|
| Timesheet Note | This is the Timesheet Notes. If multiple Notes exist, they will be separated by a ---. |
|
| Timesheet Period End | This is the End date of the Timesheet Period. |
|
| Timesheet Period Start | This is the Start date of the Timesheet Period. |
|
| Timesheet State | This is the current State of the Timesheet. |
|
| Timesheet Template | This is the Name of the Timesheet Template. |
|
| Timesheet Workflow | This is the Name of the Workflow associated to the Timesheet. |
|
| Timesheet Workflow Version | Displays a number indicating the version of the workflow. |
|
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 Alternate Role | This is the Alternate Role of the User. When user has multiple roles, they are displayed as concatenated with -- |
|
| 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 Date Created | This is the date and time when the User account was created. |
|
| User Date Modified* | This is the date and time when the User account was last modified. |
|
| 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 of the User. |
|
| User Last Login Date | This is the date and time when the User last logged into the system. |
|
| 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 Payment Method | This is the Default Payment Method 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 Type of the User. |
|
Note: User Date Modified refers to the date when any changes are made to the User properties found in the Details tab, including its General, Personal, and Security sub-tabs. Modifications can include entering or selecting a new value for a field, updating, or deleting an existing value. This also covers changes made to associated User Defined Fields within the Details tab and its sub-tabs. It is noteworthy to mention that the User Date Modified fields are also triggered when a User Profile is saved without any modifications.
User Approval Group
User Approval Group
| Field Name | Description | Type |
|---|---|---|
| Approval Group Default Task | This is the Approval Group Default Task of the User. |
|
| Approval Group Description | This is the Approval Group Description of the User. |
|
| Approval Group Id | This is the Approval Group Id of the User. |
|
| Approval Group Is Active | This defines whether the Approval Group is Active (Yes/No) |
|
| Approval Group Name | This is the Approval Group Name of the User. |
|