JDBC Driver for TSheets

Build 20.0.7654


This table contains a list of file objects.

Table Specific Information


Query the Timesheets table. The driver 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 driver.

  • 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)


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 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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654