JobcodeAssignments
Returns a list of all jobcode assignments associated with users.
Table Specific Information
Select
Query the JobcodeAssignments 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 and UserId fields support the '=' and IN operators.
- JobcodeId, JobCodeType, JobCodeParentId fields and ActiveStatus filter all support the '=' operator.
- LastModified field supports the <=,<,>=,>,= operators.
For example, the following queries are processed server side:
SELECT * FROM JobcodeAssignments WHERE UserId IN (1242515, 1242515) SELECT * FROM JobcodeAssignments WHERE JobCodeParentId = 17285791
Insert
Insert can be executed by specifying the UserId and JobcodeId columns. The columns that are not required can be inserted optionally. Following is an example of how to insert into this table
INSERT INTO JobcodeAssignments (UserId,JobcodeId) VALUES ('1234','39')
Delete
Delete can be executed by specifying the Id in the WHERE Clause.
For example:
DELETE FROM JobcodeAssignments WHERE Id = '41321421'
DELETE FROM JobcodeAssignments WHERE Id IN ('41321421','41321435')
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | True |
Id of jobcode assignment. |
| UserId | Int | False |
Id of the user that this assignment pertains to. |
| JobcodeId | Int | False |
Id of the jobcode that this assignment pertains to. |
| Active | Boolean | True |
Whether or not this assignment is 'active'. If false, then the assignment has been deleted. true means it is in force. |
| LastModified | Datetime | True |
Date/time when this jobcode assignment was last modified. |
| Created | Datetime | True |
Date/time when this jobcode assignment was created |
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 |
| JobCodeType | String |
Refers to the jobcode type - 'regular', 'pto', 'unpaid_break', 'paid_break', or 'all'. Defaults to 'regular'. |
| JobCodeParentId | Integer |
When omitted, all jobcode assignments are returned regardless of jobcode parent. If specified, only assignments for jobcodes with the given jobcode parent_id are returned. To get a list of only top-level jobcode assignments, pass in a jobcode_parent_id of 0. |
| ActiveStatus | String |
Filter column for whether to fetch only active records, only archived records, or both. By default, only active records are fetched. Possible values are: yes, no, both |