Tenant Deduction Response Pending Reminder
Tenant Deduction Response Pending Reminder
Overview
The Tenant Deduction Response Pending Reminder is a scheduled workflow that automatically sends a follow-up email to tenants who have received a deduction notification but have not yet opened or responded to it. It runs daily and targets only notifications where the tenant's response link is still valid.
This reduces deposit release delays caused by tenants missing or overlooking their original notification.
How It Works
1. Daily Sweep
Each day at 10:00 UTC, the workflow queries the tenant_deduction_notifications table for records that meet all of the following criteria:
| Condition | Value |
|---|---|
status | pending (notification sent but never opened) |
sentAt | More than 3 days ago |
tokenExpiresAt | Greater than today (link is still active) |
2. Reminder Email
For each matching notification, a reminder email is dispatched to the tenant's sentToEmail address. The email includes:
- A summary of the pending deduction notification
- A direct link to the tenant's response portal
- A clear call-to-action to review and respond
3. No Action on Expired Links
If a tenant's tokenExpiresAt has already passed, no reminder is sent — the workflow will not email a tenant with a link they can no longer use.
Trigger
Scheduled Cron: 0 10 * * *
Runs once per day at 10:00 AM UTC, every day.
Entities
The workflow reads from and acts on the following entities:
tenantDeductionNotifications— the primary sweep target; filters onstatus,sentAt, andtokenExpiresAttenants— used to resolve tenant contact detailsdepositReleases— provides deposit context for the notificationproperties— provides property context included in the reminder email
Behaviour Summary
Every day at 10:00 UTC:
For each tenantDeductionNotification
WHERE status = 'pending'
AND sentAt > 3 days ago
AND tokenExpiresAt > today:
→ Send reminder email to sentToEmail
with link to response portal
Notes
- Only unopened notifications (status
pending) are targeted. If a tenant has opened the notification — even without submitting a response — they will not receive this reminder. - The workflow respects token expiry: no reminders are sent for notifications where the response link has expired.
- This workflow is non-destructive — it sends an email only; no statuses are changed as a result of the reminder itself.