Daily Time Entry Upload
This integration uploads daily time entries. It enables hours entry per day against a time sheet, with time entry date, cost center, task,code/gla and rate category combination.
File Formatting
Unique Identifier
-
Each unique combination of the following fields will require another record: Job_Seeker_ID/Work_Order_ID/ Worker_ID/ Buyer_Ref/Time Sheet ID, Time Entry Date, Cost_Center_Code, Task_Code, and Rate_Category_Code. The position of the primary key fields is important and cannot be moved.
Uniqueness Examples:
-
A worker with both Straight Time and Overtime hours will require at least two lines.
-
A worker booking time to three Cost Centers will require at least three lines.
-
A worker with two different Cost Centers and two different Task Codes will require a minimum of four lines.
-
Configuration Considerations
|
# |
Item |
Notes |
|---|---|---|
|
1 |
Custom Fields |
Prior to adding custom fields, determine if the value will be constant within a given time sheet or could have multiple values within a single time sheet. If only a single value per time sheet is required, then a time sheet custom field may be best. If it varies throughout the week, then a task code custom field is likely the best choice. |
|
2 |
Data Feed Timing |
If implementing an automated solution, it is important that the owners of both SAP Fieldglass and the time sheet system fully understand the data and processes of each system and ensure that the timing of data flowing between the two is set up to best ensure data integrity. For example, if workers are only downloaded on Sundays and the time sheets are uploaded on Fridays, it is likely there will be issues with end dates and/or start dates as the updates to worker profiles do not arrive until after the worker’s time sheet data. |
|
3 |
Associations |
Cost Centers, Task Codes, and Rate Categories can only be based on the list of those associated with the worker. If new items are required for booking of time, other than those currently associated with the worker, then those associations must be updated prior to uploading the hours. |
|
4 |
Task Code Custom Field(s) |
If a Task Code Custom Field is based on values within a pick list, then only those values will be valid in the Time Sheet Upload. If working with an external system, be sure that both application owners understand the full set of values that may be populated in this type of non-standard field. |
Assumptions/Tips
-
The time sheet must be in Draft or Rejected status.
-
If a subsequent file receives the time entry for the same day, it will remove the earlier time entry and will create a new time entry with given values.
-
This connector does not support revised time sheets.
-
This connector will support Contingent and SOW workers' time entries.