All Docs
FeaturesDepositClearUpdated March 12, 2026

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:

ConditionValue
statuspending (notification sent but never opened)
sentAtMore than 3 days ago
tokenExpiresAtGreater 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 on status, sentAt, and tokenExpiresAt
  • tenants — used to resolve tenant contact details
  • depositReleases — provides deposit context for the notification
  • properties — 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.

Related