Three ways to capture time, one record
Attendance capture is an input problem, and different teams need different answers, so AWRA offers three methods that all write to a single attendance record per employee per day. The manual daily register lets a supervisor pick a day and mark everyone — "mark all present", or set each person's status and clock times — which suits supervised sites. Self-service clock-in/out lets employees record their own time. CSV/biometric import ingests an export from a physical device. Because they share one record keyed by employee and date, the register, dashboards, timesheets, and payroll all read the same truth regardless of how a day was captured.
That shared record has a source marker (manual, clock-in, import, or system) so you can always tell how a day was captured, and a unique key on organisation, employee, and date so a day cannot be recorded twice. Import leans on that: it de-duplicates on employee and date, updating rather than duplicating, and a real clock-in always wins over a system-suggested value. This is what lets you mix methods safely — a mostly self-service team with a few days imported from a device will not produce conflicting rows.
The design lesson is to pick the capture method per team, not per company, and trust the single record to reconcile them. A head office might run self-service clock-in, a warehouse might import from a biometric reader, and a remote site might use the manual register — and all of it rolls up into the same timesheets. Decide capture first, because everything after this lesson assumes clean daily records exist.
Key takeaways
- Three capture methods — manual register, self-service clock-in/out, CSV/biometric import — write to one record per employee per day.
- A source marker records how each day was captured; a unique (org, employee, date) key prevents duplicates.
- Import de-duplicates on employee+date and updates rather than duplicating; a real clock-in wins over a suggested value.
- Choose the capture method per team; all methods roll up into the same timesheets.