Tables
The driver models the data in TSheets into a list of tables that can be queried using standard SQL statements.
Generally, querying TSheets tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData ODBC Driver for TSheets Tables
Name | Description |
GeoLocations | Retrieves a list of all geofence configs. |
Groups | This table contains a list of all groups associated with your company. |
JobcodeAssignments | Returns a list of all jobcode assignments associated with users. |
JobCodes | This table contains a list of jobcodes associated with your company |
Locations | Retrieves a list of all locations associated with your company. |
Notifications | Retrieves a list of notifications associated with your company. |
Reminders | Retrieves a list of reminders associated with your employees or company. |
ScheduleEvents | Retrieves a list of schedule events associated with your employees or company. |
Timesheets | This table contains a list of file objects. |
Users | Retrieves a list of all users associated with your company. |