Report for {{ $forDate->isoFormat('dddd, D MMMM YYYY') }}

@if(!empty($filtersLine))

Filters: {{ $filtersLine }}

@endif

Attached is an Excel workbook containing all consultations performed today by each nurse. It helps clinical leads and HR review activity and quickly surface trends (sick leave, referrals, IODs) at the end of each day.

What’s inside the workbook

One sheet per nurse listing all consultations performed on the report date.
Patient details: First, Middle, Surname, Gender, Phone, Employee Number, Company, Dependent flag; if dependent: Account Holder full name and employee number.
Consultation details: Clinic, Diagnosis, Sick Leave (✓) with days & reasons, IOD flag, Referral flags (Radiology, Lab, Specialist, Casualty, Out-Patient), Specialist name, Referral notes.
Per-sheet summary at the bottom: Total consultations, Sick-leave count & total days, IOD count, and counts for each referral type.

Data window: All consultations recorded on {{ $forDate->isoFormat('dddd, D MMMM YYYY') }}.

How sheets are organized

Each worksheet is titled with the nurse’s name. Use Excel’s sheet tabs or press Ctrl+PgDn/PgUp to switch between nurses.

Trouble opening the attachment or need a different format? Reply to this email and the IT team will assist.

Regards,
{{ config('app.name') }}

This is an automated daily report sent at 17:30 (Africa/Harare).