JobCodes
This table contains a list of jobcodes associated with your company
Table Specific Information
Select
Query the Jobcodes 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 and Name fields support the '=' and IN operators.
- Type and Active fields support the '=' operator.
- LastModified field supports the <=,<,>=,>,= operators.
For example, the following queries are processed server side:
SELECT * FROM Jobcodes WHERE Id IN (1242515, 1242515) SELECT * FROM Jobcodes WHERE Type = 'unpaid_break'
Columns
| Name | Type | Description |
| Id [KEY] | Int | Id of jobcode. |
| ParentId | Int | Id of this jobcode's parent. 0 if it's top-level. |
| Name | String | Id of this jobcode's parent. 0 if it's top-level. |
| ShortCode | Int | This is a shortened code or alias that is associated with the jobcode. It may only consist of letters and numbers. Must be unique for all jobcodes that share the same parent id. |
| Type | String | Indicates jobcode type. One of 'regular', 'pto', 'paid_break', or 'unpaid_break' |
| Billable | Boolean | Indicates whether this jobcode is billable or not. |
| BillableRate | Double | Dollar amount associated with this jobcode for billing purposes. Only effective if billable is true. |
| HasChildren | Boolean | If true, there are jobcodes that exist underneath this one, so this jobcode should be treated as a container or folder with children jobcodes underneath it. |
| AssignedToAll | Boolean | Indicates whether this jobcode is assigned to all employees or not. |
| RequiredCustomFields | Boolean | Ids of customfields that should be displayed when this jobcode is selected on a timecard. |
| Active | Boolean | If true, this jobcode is active. If false, this jobcode is archived. To archive a jobcode, set this field to false. When a jobcode is archived, any children underneath the jobcode are archived as well. Note that when you archive a jobcode, any jobcode assignments or customfield dependencies are removed. To restore a jobcode, set this field to true. When a jobcode is restored, any parents of that jobcode are also restored. |
| LastModified | Datetime | Date/time when this jobcode was last modified. |
| Created | Datetime | Date/time when this jobcode was created |
| FilteredCustomFiledsItems | String | Displays which customfielditems should be displayed when this jobcode is chosen for a timesheet. Each property of the object is a customfield id with its value being an array of customfielditem id. If none, an empty string is returned. |