ClickTime Tables
The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.
ClickTime Tables
| Name | Description |
| Allocations | Get allocations. |
| Clients | Get clients. |
| Company | Get your company. |
| CurrentUser | Get the current user. |
| CustomMessages | Get custom messages. |
| Divisions | Get divisions. |
| EmploymentTypes | Get Employment Types. |
| HolidayEntries | Get holiday entries. |
| Jobs | Get jobs. |
| ManagedDivisions | Get managed divisions. |
| ManagedTimesheetActions | Get available actions for a managed timesheet. |
| ManagedTimesheetHistory | Get a managed timesheet's status history. |
| ManagedTimesheetHolidayEntries | Get holiday entries for a timesheet for which you are the approver. |
| ManagedTimesheets | Get managed timesheets. |
| ManagedTimesheetsByDate | Get a user's timesheet by date. If the timesheet does not exist it will be created. |
| ManagedTimesheetsHolidayEntries | Get holiday entries for users whose timesheets you approve. |
| ManagedTimesheetsTimeEntries | Get managed time entries. |
| ManagedTimesheetsTimeOff | Get time off entries for managed timesheets. |
| ManagedTimesheetTimeOff | Get time off entries for a managed timesheet. |
| ManagedUsers | Get the users managed by current user. |
| MyClients | Get my clients. |
| MyExpenseItems | Get my expense items. |
| MyExpenseSheetActions | Get my expense sheet actions. |
| MyExpenseSheets | Get my expense sheets. |
| MyHolidayEntries | Get my holiday entries. |
| MyJobs | Get my jobs. |
| MyJobsTasks | Get a list of jobs and available tasks I have access to. |
| MyTasks | Get my tasks. |
| MyTimeEntries | Get my time entries. |
| MyTimeOff | Get my time off entries. |
| MyTimeOffTypes | Get my time off types. |
| MyTimesheetActions | Get available Actions for my Timesheet by ID |
| MyTimesheetHistory | Get my Timesheet's status history. |
| MyTimesheets | Get my timesheets. |
| MyTimesheetsActions | Get available Actions for my Timesheet by date |
| MyTimesheetsByDate | Get my timesheets by date. |
| Reports | Get time entry reporting. |
| Tasks | Get tasks. |
| TimeEntries | Get time entries. This table is intended for smaller data set, for example when you're retrieving time entries for a single timesheet period. For larger datasets please use Reports table. |
| TimeOff | Get time off entries. |
| TimeOffTypes | Get time off types. |
| TimesheetActions | Get available actions for a timesheet. |
| TimesheetHistory | Get a timesheet's status history. |
| TimesheetHolidayEntries | Get holiday entries for a timesheet. |
| Timesheets | Get timesheets. |
| TimesheetTimeEntries | Get a Timesheet's Time Entries. |
| TimesheetTimeOff | Get a Timesheet's Time Off entries. |
| Users | Get users. |
| UserTimesheetsByDate | Get a User's Timesheet by date. If the timesheet does not exist it will be created. |