Working Hours MonitoringDEMO
Demo · fictional data · not connected to attendance, payroll or HR

Data Source

How attendance records would flow from the existing turnstile system into this dashboard. Nothing is connected in this prototype.

Proposed data flow

Read-only extraction — existing attendance, payroll and HR systems remain unchanged

Existing attendance system

Product/version to be confirmed — sample assumes Lenel OnGuard turnstile IN/OUT events at sample sites BL & BK

Read-only extract

Connection method: to be confirmed (file export, database view or API). Sync schedule: to be confirmed.

Working Hours Monitoring

Pairing, calculation, exceptions & reports

Example import outcomes · illustrative

Sample states to show how results would be reported. Not real imports.

SuccessfulExample

4,812 records imported

All rows matched known badge IDs and valid timestamps.

PartialExample

4,790 imported · 14 rejected

14 rows had an unknown badge ID; held for review, not counted in hours.

FailedExample

0 records imported

Export file not found at the scheduled time; previous data kept unchanged.

Import history

Simulated entries

Time (MYT)TypeReceivedProcessedReview
16/11/2026 06:00Scheduled daily batch (simulated)41401
15/11/2026 06:00Scheduled daily batch (simulated)1211174
14/11/2026 06:00Scheduled daily batch (simulated)1431394
13/11/2026 06:00Scheduled daily batch (simulated)1321284
12/11/2026 06:00Scheduled daily batch (simulated)1411374
11/11/2026 06:00Scheduled daily batch (simulated)95923

Sample raw scan preview

Format assumed for the demo — to be matched to the customer's actual attendance-system export

EmployeeIDTimestampDirectionTerminal
PG102032026-11-15 21:24:51OUTBL-Main Gate T1
PG105812026-11-15 20:17:43OUTBL-Main Gate T2
PG104412026-11-15 20:01:28OUTBL-Main Gate T2
PG103012026-11-15 19:38:41INBL-Main Gate T1
PG104412026-11-15 17:43:08INBL-Canteen T3
PG105812026-11-15 13:20:50INBL-Canteen T3
PG105812026-11-15 12:40:32OUTBL-Canteen T3
PG103082026-11-15 08:25:06OUTBL-Main Gate T1
PG103012026-11-15 08:25:06OUTBL-Main Gate T1
PG106092026-11-15 08:23:20OUTBL-Main Gate T1
PG102802026-11-15 08:21:06OUTBL-Main Gate T1
PG104692026-11-15 08:20:41OUTBL-Main Gate T1
PG104132026-11-15 08:18:25OUTBL-Main Gate T1
PG102942026-11-15 08:18:03OUTBL-Main Gate T1
PG103992026-11-15 08:15:46OUTBL-Main Gate T2
PG105602026-11-15 08:14:11OUTBK-Lobby T2
PG103922026-11-15 08:12:05OUTBL-Main Gate T2
PG102662026-11-15 08:11:10OUTBL-Main Gate T1
PG102872026-11-15 08:09:42OUTBL-Main Gate T2
PG105322026-11-15 08:08:44OUTBK-Lobby T1
PG106162026-11-15 08:07:16OUTBL-Main Gate T2
PG105392026-11-15 08:07:55OUTBK-Lobby T2
PG104202026-11-15 08:05:14OUTBL-Main Gate T1
PG104762026-11-15 08:03:47OUTBL-Main Gate T1
PG103782026-11-15 08:03:29OUTBL-Main Gate T2
PG103712026-11-15 08:03:37OUTBL-Main Gate T1
PG104062026-11-15 08:00:38OUTBL-Main Gate T1
PG102032026-11-15 07:54:32INBL-Main Gate T1
PG105812026-11-15 07:53:55INBL-Main Gate T2
PG104412026-11-15 07:36:32INBL-Main Gate T2
Automatic integration is a proposed capability, not available in this prototype. Connection method and sync schedule are to be confirmed. Actual integration feasibility depends on customer IT access and the attendance system's export/API options, to be reviewed together.