Automated Escalations & Compliance SLA Alerts

Multi-tier escalation workflows, background cron execution, email templates, and automated non-compliance notifications.

SmartERP 19 eliminates manual timesheet chasing through an automated, tiered notification and escalation engine.

Timesheet Overview & Notification Tracking

Escalation Tier Architecture#

Escalation lines (smart.timesheet.escalation.line) are linked directly to compliance rules:

+--------------------------------------------------------------------------+
|                       ESCALATION TIMELINE LADDER                         |
+--------------------------------------------------------------------------+
| Day 0 (Period End)    | Week ends Sunday 23:59                           |
| Day 2 (Deadline)      | Standard submission deadline (Tuesday 10:00 AM)  |
| Day 3 (Grace Period)  | Grace period expires; Reminder #1 sent           |
| Day 6 (Reminder #2)   | Second reminder sent to employee                 |
| Day 9 (Reminder #3)   | Final warning sent to employee                   |
| Day 10 (Tier 1 Escal) | Escalation Line 1: Alert sent to Project Manager |
| Day 12 (Tier 2 Escal) | Escalation Line 2: Alert sent to Department Head |
| Day 14 (Tier 3 Escal) | Escalation Line 3: Alert sent to HR Director     |
+--------------------------------------------------------------------------+

Escalation Level Parameters#

Level	Target Recipient	Template Code	Action Triggered
Tier 1	Direct Manager / Team Lead	`mail_template_timesheet_escalation_l1`	Flags employee in supervisor weekly compliance dashboard.
Tier 2	Department Head & PMO	`mail_template_timesheet_escalation_l2`	Issues non-compliance notice; pauses overtime approval.
Tier 3	HR Director & CFO	`mail_template_timesheet_escalation_l3`	Places monthly payroll payout on hold pending submission.

Background Cron Engine (`ir.cron`)#

The automated background job ir_cron_smart_timesheet_compliance_check executes every 24 hours:

Batch Safety: Processes employees in bounded chunks of 200 records (BATCH_SIZE = 200) to guarantee high-performance execution on large databases.
Holiday Awareness: Inspects smart.et.calendar to ensure public holidays do not count against employee grace period deadlines.
Notification History: Logs every dispatched message in smart.timesheet.notification.history, preventing duplicate reminders.

መጨረሻ የተሻሻለው: 2026-10-16