BizTalk Adapter for TSheets

Build 20.0.7654

JobCodes

This table contains a list of jobcodes associated with your company

Table Specific Information

Select

Query the Jobcodes table. The adapter 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 adapter.

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

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