TITO Details for Rate Schedule Time Sheet Upload
This integration uploads Time In/Time Out (TITO) details for worker time sheets. This upload also eliminates the need to use the Time Sheet Upload to enter and allocate the hours worked, as rate rules will determine hours.
File Formatting
Assumptions/Tips
-
Only one cost center/task code combination per date is supported by this connector. If multiple cost centers/task codes per date are required, the CATS TITO Rate Schedule Time Sheet Upload may be used.
-
Only one shift code per date is supported by this connector.
-
Only shift codes associated with the work order are supported.
-
This upload is Time In Time Out. The system will also calculate the hours of the time sheet and the timesheet ID (if not entered).
-
TITO entries can be uploaded only for time sheets which are in Draft or Rejected status.
-
No custom fields will be supported in this upload, even if there are mandatory custom fields defined in the application.
-
Upload will accept the time in 24-Hour Clock format (hh:mm).
-
Columns First Name and Last Name will not get uploaded. (These columns are included to make upload file format similar to the Standard TITO Download).
-
Upload will insert new TITO entries for the time sheet deleting all existing TITO entries of the time sheet.
-
If the time entry is entered without the colon (“:” [such as “Time In” as 30]), it will be treated as 00:30.
-
Creation of Ad Hoc time sheets are not supported by this connector.
-
If Rate Schedule does not support Time Worked, uploads will disregard entries in any Cost Center, Task Code, and General Ledger Account (GLA) columns and will allocate cost using Work Order Cost Center %s and Task Codes that are associated for the Cost Center on worker’s record.
-
If Auto Invoice is enabled and if the new Job Posting Template/SOW Template flag Allow Additional Invoice Adjustment Currency is enabled, the system will look back to the latest confirmed Work Order/Work Order Revision/SOW/SOW Revision for the additional adjustments.
-
When a Rate Schedule Time Sheet is submitted for approval and a Time Sheet Allotment has enabled No Time Sheet Entry and Time Sheet Allotment is valid for at least one date on the time sheet, the system will apply that Time Sheet Allotment once to the time sheet.
-
When a Time Sheet is submitted successfully via this upload, the system will update tenure information.
-
For those that need to have 0:00 time captured, please contact the SAP Fieldglass help desk.
-
For a TITO Rate Schedule Time Sheet, Allow Time in Hundredths of Hours on Time Sheet is always = Yes.
-
With 8 day time sheets, for a day that spans across two time sheets, the details entered on the most recent time sheet will not override the time entered on the previous time sheet.
-
The headers Approval Required, Messaging Required, and Supplier Review do not appear in this file. By default, these headers are considered as 'False' for this upload. If a client wants to set any of these values to 'True', then the header must be manually added to the file.
-
When the approval enforcement setting is enabled, time sheets uploaded through this connector must be approved before they can proceed and will not bypass the approval workflow.
Configuration Considerations
|
# |
Item |
Notes |
|---|---|---|
|
1 |
Associate Unassigned Cost Centers to Workers or Associate Unassigned Cost Centres to Workers |
Prior to adding this header, company configuration ‘Allow worker access to all Cost Centers and Task Codes, and submit Time Sheets through the UI (can be updated on Worker only)’ must be enabled. The first item is for upload users with language preference of English (United States). The second item is for those with preference of English (United Kingdom). For Contingent Workers, the entered cost centers will be associated to the worker. For SOW Workers, we will validate if the underlying SOW has the new SOW rule Give Workers Access to all Cost Centers belonging to the Legal Entity of the SOW enabled. If enabled, the entered Cost Centers will be associated to the SOW Worker, else the upload will fail for that worker. |

