Hours logged · filtered window
0hrs
$0.00
—
Daily punch register —
Pay-run close · Fri 17:00
Awaiting approval 0 entries ·
Next deposit date
bound parameters
—
—
QUERY CONSOLE
Analytics & aggregation
Four aggregate queries executed against the in-memory relational store. Filters are pushed into each statement as bound parameters.
—
WORKBENCH
Punch in & approve
Entry writes an INSERT; manager sign-off flips ts.approved, which immediately feeds the budget and department queries.
Timesheet entryINSERT
Employee time card — no. 0000
Hourly rate$0.00
Straight time$0.00
Entry cost$0.00
Approval queueUPDATE timesheets SET approved
Audit trail
PAYROLL
Pay register
Weekly overtime premium (hours beyond 40 at 1.5×) plus employer burden of 7.65% FICA and 12.40% benefits reserve.
SCHEMA