Business problem
Teams use different shift codes, and leave requests can span weekends, holidays and half days. HR needs one consistent view before reconciling monthly attendance.
How it works
One workflow reads roster headers, normalizes shift codes and reorganizes entries by employee and date. The other filters leave by approval status, splits it using the company calendar and standardizes leave types and partial days. Exceptions are flagged for review.
What it delivers
The outputs are an import-ready roster, daily leave records and an exception list. HR can review them before import and trace discrepancies back to the source forms.
Workflow at a glance
- Source files
- Rules and mapping
- Review and export
Related reading



