Timesheets
This table contains a list of file objects.
Table Specific Information
Select
Query the Timesheets table. The connector will use the TSheets API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id, UserId, JobcodeId, PayrollIds, GroupIds fields support the '=' and IN operators.
- OnTheClock and JobCodeType fields support the '=' operator.
- LastModified and Date fields support the <=,<=,<,>=,>,= operators.
For example, the following queries are processed server side:
SELECT * FROM Timesheets WHERE OnTheClock = false SELECT * FROM Timesheets WHERE LastModified > '2019-01-01 18:30' AND GroupIds IN (1,2,3) SELECT * FROM Timesheets WHERE JobcodeId IN (1,2,3)
Columns
| Name | Type | Description |
| Id [KEY] | String | Id of the timesheet. |
| UserId | String | User id for the user that this timesheet belongs to. |
| JobcodeId | Int | Jobcode id for the jobcode that this timesheet is recorded against. |
| Locked | Boolean | If greater than 0, the timesheet is locked for editing. A timesheet could be locked for various reasons. |
| Notes | String | Notes associated with this timesheet. |
| LastModified | Datetime | Date/time when this timesheet was last modified. |
| Type | String | Either 'regular' or 'manual'. |
| OnTheClock | Boolean | If true, the user is currently on the clock . If false the user is not currently working on this timesheet. Manual timesheets will always have this property set as false. |
| CreatedByUserId | String | User id for the user that initially created this timesheet. |
| StartTime | Datetime | Date/time that represents the start time of this timesheet. Will always be an empty string for manual timesheets. |
| EndTime | Datetime | Date/time that represents the end time of this timesheet. Will always be an empty string for manual timesheets. |
| Date | Date | The timesheet's date |
| Duration | Int | The total number of seconds recorded for this timesheet. |
| OriginHint | String | A string that will be logged as part of the timesheet history when someone is clocked in, clocked out, or a timesheet is created (with both in/out). Will always be an empty string for manual timesheets. |
| JobCodeType | String | The type of the jobcode linked with this timesheet. Any of the 'regular', 'pto', 'paid_break', 'unpaid_break' |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| PayrollIds | Int | A comma-separated string of payroll ids. Only time recorded against users with these payroll ids will be returned. |
| GroupIds | Int | A comma-separated list of group ids. Only timesheets linked to users from these groups will be returned. |