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 add-in 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 add-in.
- 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. |