ODBC Driver for SAP Fieldglass

Build 24.0.9062

TITOTimeSheets

Retrieve worker time in/time out (TITO) details based off a parameter entered during run time using the TITO Time Sheet Status Parameter Download connector.

View Specific Information

The 本製品 will use the SAP Fieldglass API to process WHERE clause conditions built with the following columns and operators. The remaining filter criteria is executed client-side within the 本製品.

  • Time Sheet Status supports the '=' operator. This parameter specifies the status of the TITO time sheets. Available values are: Draft, Pending Validation, and Pending Supplier Review. By default, draft time sheets are retrieved.

For example, the following queries are processed server-side:

SELECT * FROM TITOTimeSheets WHERE Status = 'Pending Validation'
SELECT * FROM TITOTimeSheets WHERE Status = 'Pending Supplier Review'

Columns

Name Type Description
Worker_Id String Valid Worker ID
Last Name String Worker's Last Name
First Name String Worker's First Name
Time_Sheet_Id String Valid SAP Fieldglass Timesheet ID
Date Date Date of the Timesheet Day for which TITO Details are being added.
Time In String Worker Time In at the beginning of the work day.
Meal Break 1 Out String Meal Break 1 Out Time
Meal Break 1 In String Meal Break 1 In Time
Meal Break 2 Out String Meal Break 2 Out Time
Meal Break 2 In String Meal Break 2 In Time
Meal Break 3 Out String Meal Break 3 Out Time
Meal Break 3 In String Meal Break 3 In Time
Time Out String Worker Time Out at the conclusion of the work day.

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
Status String This parameter specifies the status of the TITO time sheets. Available values are Draft, Pending Validation, and Pending Supplier Review. Defaults to Draft.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062