Your guesses sound correct and for export purposes there's a "group by" option that allows you to export subtotals and data for a group of records as a single row of exported data.
If that wasn't the "nudge" that you needed: What does one record in TC Data record? What does one record in TimeCard Record?
I figured you'd be the man with the plan. When an employee clocks in using IPad layout, a script determines if a new Pay Cycle record & Time Card record need to be created. The created TC Data record records In / Out time, whether the staff member ended a shift or took a break and calculates pay for the shift and whether the staff member entered OT during that shift.
Originally, Time Cards tracked when the week begins/ends, Hrs Worked in Week, Reg Time, OT, calculated pay, but much of that was moved to TC Data to deal with the multiple departments/rates issue and to facilitate running a report based on the TC Data. Now I just need to figure out how to apply the correct sort/filters to the report.
I think your ' ..."group by" option that allows you to export subtotals and data for a group of records as a single row of exported data... ' was the clue that I was missing to complete the necessary report. That's what I was drawing a blank on when it came to generating the export from the report.