Workflow · Appointment created - denorm
W1 Appointment created - denorm
When a visit is booked, copies the clinic, provider and end time from the chosen slot onto the appointment so schedules and reminders read cleanly without extra lookups.
Steps
- Set Clinic, End and Provider from the booked Slot
Workflow · Intake Form created - denorm
W2 Intake Form created - denorm
Stamps each new intake form with the patient's clinic and assigned provider so the front-desk queue and the provider's day filter correctly from the start.
Steps
- Set Clinic and Assigned Provider from the Patient
Workflow · W2b Provider reassignment resync
W2b Provider reassignment resync
When a patient is reassigned to a different provider, updates their intake forms to match so nothing lands in the wrong provider's queue.
Steps
- Re-sync Assigned Provider onto this patient's intake forms
Workflow · Insurance created - denorm
W3 Insurance created - denorm
Tags each new insurance record with the patient's clinic so front-desk staff only see coverage for their own site when verifying before a visit.
Steps
- Set Clinic from the Patient
Workflow · Consent created - denorm
W4 Consent created - denorm
Tags each newly signed consent with the patient's clinic so compliance checks and SMS gating stay scoped to the right site.
Steps
- Set Clinic from the Patient
Workflow · Reminder created - denorm
W5 Reminder created - denorm
Links each new reminder directly to its patient and clinic so the TCPA consent check at send time is a single lookup rather than a chain.
Steps
- Set Clinic and Patient from the Appointment so the TCPA gate is 1 hop
Workflow · Waitlist entry created - denorm
W6 Waitlist entry created - denorm
Tags each new waitlist entry with the patient's clinic so waitlist matching only offers slots at the site the patient actually attends.
Steps
- Set Clinic from the Patient
Workflow · Public intake started
W7 Public intake started
Turns a new patient into a ready-to-go intake: drafts their form, creates their portal login and logs the record the moment they sign up.
Steps
- Mark the patient as new
- Create the draft intake form
- Create the portal login when an email was supplied
- Link the portal user back onto the patient
- Record the new patient in the audit log
Workflow · Intake submitted
W8 Intake submitted
When a patient submits their forms, marks intake complete and routes the form to the clinic's front desk for verification.
Steps
- Record when the form was submitted
- Mark the patient's intake complete
- Find the front-desk staff who verify intake at this clinic
- Record the submission in the audit log
Workflow · Appointment booked
W9 Appointment booked
Books the visit end to end: reserves the slot, queues the 48-hour, 24-hour and 2-hour reminders and emails the patient a confirmation.
Steps
- Mark the slot as booked
- Queue the 48h reminder
- Queue the 24h reminder
- Queue the 2h reminder
- Email the patient their booking confirmation
Workflow · Booking request approved
W10 Booking request approved
Lets the patient know the moment the front desk approves an appointment request.
Steps
- Email the patient that their request was approved
Workflow · Reminder dispatch (TCPA-gated)
W11 Reminder dispatch (TCPA-gated)
Sends due reminders every hour by email and SMS, and only texts patients who have consented and not opted out — so reminders cut no-shows without a compliance risk.
Steps
- Find email reminders that are due
- Send them and mark as sent
- Find due SMS reminders where the patient has consented
- Send those and mark as sent
- Find SMS reminders with no consent on file
- Cancel them without sending
- Find SMS reminders for patients who opted out
- Cancel those without sending
Workflow · Patient confirms
W12 Patient confirms
When a patient confirms, moves the visit to Confirmed and stops any further reminders for it.
Steps
- Move a confirmed booking to Confirmed
- Mark this appointment's reminders Confirmed
Workflow · Outstanding-intake nudge
W13 Outstanding-intake nudge
Each day, finds tomorrow's patients who still have not finished their forms so they can be nudged before they arrive.
Steps
- Find visits in the next 24 hours with intake still incomplete
Workflow · No-show sweep
W14 No-show sweep
Every hour, flags past appointments where the patient never checked in as no-shows so nothing lingers on the schedule.
Steps
- Find past appointments where the patient never checked in
- Flag them as No-show
Workflow · Cancellation / reschedule
W15 Cancellation / reschedule
On a cancellation or reschedule, reopens the slot, cancels the pending reminders and logs the change.
Steps
- Reopen the slot for booking
- Cancel this appointment's pending reminders
- Record the cancellation in the audit log
Workflow · Waitlist match
W16 Waitlist match
When a slot frees up, finds waitlisted patients at that clinic who could take it and flags them as notified.
- 2 steps
- on Appointment Slots
Steps
- Find waitlisted patients who could take the freed slot
- Mark them as notified
Workflow · SMS opt-out
W17 SMS opt-out
Honors an SMS opt-out immediately: stamps the date, cancels the patient's pending reminders and records it for compliance.
Steps
- Record when the patient opted out
- Cancel this patient's pending reminders immediately
- Record the opt-out in the audit log
Workflow · Check-in
W18 Check-in
Records the arrival time when the front desk checks a patient in so providers see who is waiting.
Steps
- Record the patient's arrival time
Workflow · Visit complete - consent check
W19 Visit complete - consent check
When a visit is completed, checks that signed HIPAA and treatment consents are on file and logs the completion.
Steps
- Look up this patient's signed HIPAA and Treatment consents
- Record the completed visit in the audit log
Workflow · Audit logging (Patients)
W20 Audit logging (Patients)
Whenever a patient record is created or changed, appends an audit entry naming who changed which fields and when, without ever storing patient health data in the log.
Steps
- Append an audit row - field names only, never PHI values