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