We’re a month past go-live and integrated with Workforce Go! for payroll. We sync time activity data to them and they do hours calcs from the raw data.
If there is any overlapping time in a timecard (actually in time activities), the sync will fail until it's corrected. Employees enter time via mobile app time punches or manually entering time in timecards.
We’ve customized the employee’s timecard view with a calculated End Time field so they can clearly see their next Start Time doesn’t overlap and their Approvers are also supposed to be checking this.
However, as with all human-driven processes, overlaps are still getting through. The problem is the entire sync will fail on a single overlap, so it’s a constantly iterative process to fix and resync, fix and resync until they’re all found and fixed.
Our WFG integration specialist has said other customers have asked their partners to develop a GI that shows and/or flags time overlaps in time activities for any given pay period or pay week to fix them in bulk BEFORE doing the sync.
I’ve gotten pretty good at GIs but for the life of me, I cannot get any of the tables involved to show the actual start time. I don’t feel too bad because our partner hasn’t had much success in this either.
I’ve Ctl-Alt’ed the Time field in EPTimeCardDetail and it shows Date_Time (which actually isn’t a field in the DAC), and none of the other, related DACs have it either (PMTimeActivities, EPActivityApprove, EPTimeCard, or EP.TimeCardMaint+EPTimecardDetail). Closest is Date but when used only shows a Date, not a time.
So I’m reaching out to the community in hopes someone’s faced this before and can help. TIA!