RPT-18 Attendance & Leave
Daily attendance, shift and leave-balance report for HR & Managers with explicit policy and effective-date context. Definition owner: Huda Al Ameri (HR Manager).
RPT-18
HR-03
HR-04
§9.2
Report certification & ownershipOperational
- Report owner
- Huda Al Ameri — HR Manager (metric owner of record)
- Prepared by
- Attendance import service (idempotent) · corrections by managers with HR approval
- Authoritative dataset
hr.attendance_events+hr.shift_roster+hr.leave_balances· semantic modelhr_time_v4- Refresh cadence
- Daily 06:00 GST + device sync every 15 min · last refresh 17 Jul 2026 14:00
- Certification state
- Operational — payroll-feeding view; certified only at payrun cut-off (RPT-19)
- Definition version
RPT-18 v4.0· approved 30 Apr 2026 by Huda Al Ameri- Governing policy versions
- Attendance policy
WP-ATT-2026.2(effective 01 May 2026, grace 10 min) · Leave policyWP-LVE-2026.1(effective 01 Jan 2026, accrual 2.5 d/mo) · Export policyEXP-HR-01 - Currency / time zone
- Asia/Dubai (GST) · business calendar UAE-2026 (Sun–Thu; site roster Sat–Thu)
§9.2 Report definition of done8 / 8 met
| Criterion | Evidence | State |
|---|---|---|
| Named owner & business definition | Huda Al Ameri · definition RPT-18 v4.0 | Met |
| Authoritative dataset & lineage | Events + roster + balances · lineage below | Met |
| Filters, dimensions, currency/TZ | Branch, shift, status, leave type · GST calendar | Met |
| Refresh & certification state | Daily + 15-min sync · Operational | Met |
| Permission-aware drill-down | Managers limited to own team; HR sees all | Met |
| Controlled export + watermark | Export (audited) · watermark "INTERNAL — RPT-18" | Met |
| Reconciliation totals & tolerances | tfoot device-event tie-out, 0 duplicates | Met |
| Accessible chart/table alternative | Bars + data table · EN/AR labels approved | Met |
On shift today
46 / 52
5 on leave · 1 absent unexplained
Late arrivals
4
Grace 10 min per WP-ATT-2026.2
Missing punches
3
▼ 2 corrections pending HR approval
On leave today
5
4 annual · 1 sick (certificate on file)
Avg annual-leave balance
14.2 d
Liability AED 412,600.00 · policy WP-LVE-2026.1
Attendance status by day — week 13–17 Jul 2026Headcount present + on-time %
| Day | Present | Late | On leave | Missing punch | Absent |
|---|---|---|---|---|---|
| Sun 13 Jul | 47 | 3 | 4 | 1 | 0 |
| Mon 14 Jul | 48 | 2 | 3 | 1 | 0 |
| Tue 15 Jul | 45 | 4 | 5 | 2 | 0 |
| Wed 16 Jul | 47 | 3 | 4 | 1 | 0 |
| Thu 17 Jul | 46 | 4 | 5 | 3 | 1 |
| Week totals | 233 | 16 | 21 | 8 | 1 |
Leave balances by type — companyRequests
| Leave type | Entitled YTD (d) | Taken (d) | Balance (d) | Pending requests |
|---|---|---|---|---|
| Annual (accrual 2.5 d/mo) | 910.0 | 171.5 | 738.5 | 6 |
| Sick (certified) | 780.0 | 42.0 | 738.0 | 1 |
| Parental | 55.0 | 10.0 | 45.0 | 1 |
| Unpaid (approved) | — | 36.0 | — | 0 |
| Hajj (once per service) | 30.0 | 0.0 | 30.0 | 1 |
| Total — policy WP-LVE-2026.1 | 1,775.0 | 259.5 | 1,551.5 | 9 |
Attendance register — today 17 Jul 2026, shift view
Device sync 14:00 · policy WP-ATT-2026.2
| Employee | Branch / shift | In | Out | Worked (h) | Status | Exception / correction | Annual balance (d) |
|---|---|---|---|---|---|---|---|
OHOmar Haddad |
Dubai HQ Office 09:00–18:00 |
08:52 | — | 5.1 | Present | Field visit 16:30 viewing PR-A-1103 (geo-punch planned) | 12.5 |
LHLayla Hassan |
Dubai HQ Office 09:00–18:00 |
09:14 | — | 4.8 | Late 14 min | Beyond 10-min grace (WP-ATT-2026.2) · manager note added | 9.0 |
RFRashid Al Farsi |
Dubai HQ Office 09:00–18:00 |
08:45 | — | 5.3 | Present | — | 18.0 |
DCDaniel Chen |
Dubai HQ Office 08:30–17:30 |
08:28 | — | 5.5 | Present | — | 15.5 |
FRFatima Rashid |
Dubai HQ Office 08:30–17:30 |
— | — | 0.0 | On leave — annual | LV-2026-0412 approved 30 Jun · 14–21 Jul · payroll notified (HR-04) | 6.0 |
EPElena Petrova |
Prototype Residences Site 08:00–17:00 (Sat–Thu roster) |
07:58 | — | 6.0 | Present — field | Mobile geo-punch, Building B gatehouse | 11.0 |
YKYusuf Karim |
Abu Dhabi Branch Office 09:00–18:00 |
09:03 | — | 4.9 | Present | Within 10-min grace | 16.5 |
NSNoura Saeed |
Dubai HQ Office 09:00–18:00 |
08:57 | 12:40 | 3.7 | Missing punch — return | Correction CR-0871 pending: "device offline at lobby B" · original event retained · approver Huda Al Ameri | 13.0 |
TNTomasz Nowak |
Prototype Residences Site 08:00–17:00 |
— | — | 0.0 | Absent — unexplained | No punch by 10:00 · manager notified 10:05 · escalates to HR 18:00 | 7.5 |
GOGrace Okafor |
Dubai HQ Office 09:00–18:00 |
08:49 | — | 5.2 | Present | — | 20.0 |
| Device import reconciliation — 17 Jul 06:00 run | 1,248 events received · 1,245 imported · 3 resent duplicates recognised, 0 duplicate records created (HR-03 idempotent import) | Tie-out OK | 2 corrections pending approval · originals retained | 738.5 total | |||
Rows 1–10 of 52 employees · manager scope applies; corrections require reason + HR approval and retain device evidence (HR-03)
Lineage — source to report (§9.2)Lineage snapshot 17 Jul 2026 14:00
Attendance devices + mobile geo-punch→
Idempotent import (dedupe by device event id)→
hr.attendance_events + hr.shift_roster→
Correction approval (reason + approver, HR-03)→
Leave engine — versioned rules WP-LVE-2026.1 (HR-04)→
RPT-18 semantic view hr_time_v4 → payroll (RPT-19)
| Source object | Transformation | Refresh | Reconciliation evidence |
|---|---|---|---|
hr.attendance_events | Device/mobile events deduplicated by (device, event id); status vs shift + policy grace | 15-min sync | Import tie-out in tfoot · device logs via device connectors |
hr.shift_roster | Effective-dated shifts, breaks and site calendars | On roster publish | Roster approvals · Attendance & Shifts |
hr.leave_balances | Accrual + entitlement from versioned policy, effective dates (HR-04) | Nightly 05:30 | Balance recalc log · feeds RPT-19 payroll · WF-07 |
Static render mockup — no live data. Source: ERP Modern Development Specification v2.0 · Covers: RPT-18 (Table 15), HR-03, HR-04, §9.2 report definition of done.