RPT-17 Employee Document Expiry

Daily employee document and expiry report for HR under highly restricted access. Definition owner: Huda Al Ameri (HR Manager) · identity numbers masked throughout.

RPT-17 HR-01 §9.2

Employee master Self-service renewals

Highly restricted HR access This report is scoped to the HR Administrator role only (Huda Al Ameri + 2 named HR officers). Managers see counts for their own team, never document numbers. Emirates ID, passport and visa numbers render masked (e.g. 784-19●●-●●●●●●●-●); full values exist only in the encrypted HR vault. Every open, drill-down and export of this report is written to the Audit Explorer. Screenshots and unaudited exports are prohibited by policy HR-PRIV-01 v2.

Report certification & ownershipOperational

Report owner: Huda Al Ameri — HR Manager (metric owner of record)
Prepared by: HR document scheduler (system) · exceptions triaged by HR officers
Authoritative dataset: hr.employee_documents (encrypted vault, field-level ACL) · semantic model hr_docs_v3
Refresh cadence: Daily 05:00 GST · last refresh 17 Jul 2026 05:04 · reminder dispatch 07:30
Certification state: Operational — governed transactional view, restricted audience
Definition version: RPT-17 v2.2 · approved 20 Apr 2026 by Huda Al Ameri
Governing policy versions: HR privacy HR-PRIV-01 v2 · Document rules HR-DOC-POL v4 (lead times 90/60/30d) · Export policy EXP-HR-01 (audited, masked only)
Currency / time zone: Asia/Dubai (GST) · scope: all branches · 52 active employees

§9.2 Report definition of done8 / 8 met

Criterion	Evidence	State
Named owner & business definition	Huda Al Ameri · definition `RPT-17 v2.2`	Met
Authoritative dataset & lineage	`hr.employee_documents` · lineage below	Met
Filters, dimensions, currency/TZ	Doc type, branch, urgency bucket · GST dates	Met
Refresh & certification state	Daily 05:00 · Operational	Met
Permission-aware drill-down	HR Admin only; managers get masked team counts	Met
Controlled export + watermark	Masked-only export · watermark "RESTRICTED — RPT-17"	Met
Reconciliation totals & tolerances	`tfoot` ties to employee-master doc count	Met
Accessible chart/table alternative	Bars + data table · EN/AR labels approved	Met

Documents tracked

486

52 employees · 7 document types

Expiring ≤ 30 days

▼ 4 within 7 days — reminders sent

Expired

2 escalated to HR Manager · 1 on leave hold

Renewals in progress

Median processing time 9 days

Compliance rate

99.4%

▲ 0.3 pt vs Jun 2026

Expiries by month — next 6 monthsDocuments due

Month	Expiring	Renewals started	Not started
Jul 2026	15	12	3
Aug 2026	18	6	12
Sep 2026	9	2	7
Oct 2026	22	0	22
Nov 2026	7	0	7
Dec 2026	11	0	11
Total H2 2026	82	20	62

Escalations — expired documents2 open

Employee	Document	Expired	Escalation
TNTomasz Nowak — Facilities coordinator	Residence visa · 201/2023/●●●●●●●	05 Jul 2026 (12d)	HR Manager + PRO engaged · fine risk
SLSara Lim — Marketing executive	Medical insurance card	10 Jul 2026 (7d)	Renewal submitted — insurer SLA 20 Jul
RPRavi Patel — Accountant (on unpaid leave)	Labour card · MB●●●●●●43	01 Jul 2026 (16d)	On-leave hold — resume on rejoining

Document expiry register — expiring ≤ 30 days + expired Generated 17 Jul 2026 05:04 · masked view

Employee	Branch / role	Document type	Document no (masked)	Issued	Expiry	Days left	Reminders	Status
OHOmar Haddad	Dubai HQ Senior Agent	RERA broker card	BRN 24●●1 · ORN 1203	02 Aug 2024	01 Aug 2026	15	90d ✓ · 60d ✓ · 30d ✓	Renewal in progress — exam booked 22 Jul
LHLayla Hassan	Dubai HQ Agent	Emirates ID	784-19●●-●●●●●●●-●	29 Jul 2021	28 Jul 2026	11	90d ✓ · 60d ✓ · 30d ✓	Renewal in progress — ICP application ICP-88291
TNTomasz Nowak	Dubai HQ Facilities coordinator	Residence visa	201/2023/●●●●●●●	06 Jul 2023	05 Jul 2026	−12	Complete (3/3)	Expired — escalated, PRO engaged
DCDaniel Chen	Dubai HQ Accountant	Passport	E5●●●●●12	15 Aug 2016	14 Aug 2026	28	90d ✓ · 60d ✓ · 30d queued 18 Jul	Renewal not started — employee notified
SLSara Lim	Dubai HQ Marketing executive	Medical insurance card	INS-2025-●●●●7	11 Jul 2025	10 Jul 2026	−7	Complete (3/3)	Expired — replacement with insurer
EPElena Petrova	Dubai HQ Property Admin	Driving licence	DL-DXB-●●●●82	21 Jul 2024	20 Jul 2026	3	30d ✓ · 7d ✓ · 1d queued 19 Jul	Renewal in progress — RTA appointment 18 Jul
YKYusuf Karim	Abu Dhabi Branch KYC Maker	Emirates ID	784-20●●-●●●●●●●-●	10 Aug 2022	09 Aug 2026	23	90d ✓ · 60d ✓ · 30d ✓	Renewal in progress — biometrics 21 Jul
RPRavi Patel	Abu Dhabi Branch Accountant · on unpaid leave	Labour card	MB●●●●●●43	02 Jul 2024	01 Jul 2026	−16	Suspended — on leave	On-leave hold — resume on rejoining (HR-04)
NSNoura Saeed	Dubai HQ KYC Checker	Passport	A9●●●●●77	03 Aug 2018	02 Aug 2026	16	90d ✓ · 60d ✓ · 30d ✓	Renewal in progress — consulate slot 25 Jul
GOGrace Okafor	Dubai HQ Auditor	Residence visa	201/2024/●●●●●●●	12 Aug 2024	11 Aug 2026	25	90d ✓ · 60d ✓ · 30d ✓	Renewal not started — PRO queue position 4
Reconciliation — register vs employee master	486 tracked documents = 486 mandatory documents for 52 active employees (Employee Master completeness check 05:04)				15 in window	10 shown	0 unmonitored	Variance 0

Lineage — source to report (§9.2)Lineage snapshot 17 Jul 2026 05:04

Document capture (onboarding / self-service upload)→ hr.employee_documents (encrypted vault)→ Expiry calculator + reminder scheduler (HR-DOC-POL v4)→ Masking + row-level ACL (HR-PRIV-01 v2)→ RPT-17 semantic view hr_docs_v3

Source object	Transformation	Refresh	Reconciliation evidence
`hr.employee_documents`	Field-level encryption; masked projection only for reporting	On upload / verification	Vault access log in Audit Explorer
`hr.employees`	Active-employee scope; mandatory-document matrix by role/branch	On HR event	Completeness check vs Employee Master
`hr.reminder_log`	Reminder dispatch state (90/60/30d) with delivery receipts	Daily 07:30	Dispatch receipts per document

Static render mockup — no live data. Source: ERP Modern Development Specification v2.0 · Covers: RPT-17 (Table 15), HR-01, §9.2 report definition of done.