Workflow · Client onboarding and denorm
W1 Client onboarding and denorm
Runs the moment a client is added: assigns a dietitian, creates their portal login and sends the welcome email.
Steps
- Attach the new client to your organization
- No dietitian was chosen?
- Has an email but no portal login yet?
- Log the new client in the audit trail
Workflow · Meal Plan denorm
W2 Meal Plan denorm
Runs when a meal plan is created: copies the client's access keys onto the plan so the right dietitian and client can see it, and logs the event in the audit trail.
Steps
- Copy the RLS keys from the client
- Append the audit row
Workflow · W2b Note denorm
W2b Note denorm
Runs when a consult note or adherence check-in is saved: stamps the author and the client's access keys so it stays visible only to the right people, and logs it in the audit trail.
- 2 steps
- on Notes / Adherence
Steps
- Copy the RLS keys and stamp the author
- Append the audit row
Workflow · W2c Referral and authorization denorm
W2c Referral and authorization denorm
Runs when a referral or authorization is added: links it to the client, works out the authorized units and remaining balance, and records the event in the audit trail.
- 4 steps
- on Referrals & Authorizations
Steps
- Copy the RLS keys from the client
- Derive authorized units and the remaining balance
- Write the unit ledger
- Append the audit row
Workflow · Order denorm
W3 Order denorm
Runs when an order is created: pulls in the client's diet code and active authorization, then builds the packing-label and production fields the kitchen board relies on.
Steps
- Copy the tenant, portal user and diet code
- Find the client's active authorization
- Link the authorization if one is active
- Compose the label fields and totals
- Write the packing-label and production fields
Workflow · Delivery denorm
W4 Delivery denorm
Runs when a delivery is created: copies the client, address and handling details from the order and defaults the route to the client's zone so drivers see a complete stop.
Steps
- Copy the tenant, portal user, client and authorization from the order
- Denormalize the driver-facing client details
- Default the route to the client's zone
Workflow · Allergy guard - Meal Plans
W5 Allergy guard - Meal Plans
Checks every dish on a meal plan against the client's allergies and diet codes as the dietitian saves it, and flags unsafe combinations before they reach the kitchen.
Steps
- Check every selected dish against the client's allergies and diet codes
- Mark the plan as safe or flagged
- Did someone override a non-severe conflict?
Workflow · Allergy guard - Orders
W6 Allergy guard - Orders
Re-runs the allergy and diet-code safety check on every order, so a last-minute substitution can never slip an unsafe dish into the bag.
Steps
- Check every ordered dish against the client's allergies and diet codes
- Mark the order as safe or flagged and update the totals
- Did someone override a non-severe conflict?
Workflow · W1b Client allergy and dietitian denorm
W1b Client allergy and dietitian denorm
Keeps each client's allergy profile and dietitian contact flattened onto the client record whenever it changes, so the allergy guard and notifications always use the latest data.
Steps
- Flatten the client's allergy profile
- Write the guard keys and the dietitian address
Workflow · Recurring order generation
W7 Recurring order generation
Creates the next round of orders for every active client on your organization's generation day, so nobody has to key in weekly orders by hand.
Steps
- Check whether today is this organization's order day
- Is this an active client on order day?
Workflow · Selection cutoff auto-fill
W8 Selection cutoff auto-fill
When a client has not chosen their meals by the cutoff, fills the order from their meal plan so the kitchen never waits on a missing selection.
Steps
- Check whether the selection cutoff has passed
- Still pending and past the cutoff?
Workflow · Kitchen routing
W9 Kitchen routing
The moment an order is confirmed, sends it to the kitchen board and creates its delivery, so nothing is re-keyed between plan, kitchen and driver.
Steps
- Has the order just been confirmed?
Workflow · Delivery dispatch
W10 Delivery dispatch
Each morning, moves today's deliveries onto the drivers' stop lists so every driver starts the day with a ready route.
Steps
- Check whether this delivery goes out today
- Scheduled for today?
Workflow · Delivered and authorization decrement
W11 Delivered and authorization decrement
When a driver marks a delivery complete, closes the order and deducts the delivered units from the client's authorization automatically.
Steps
- Has this delivery just been completed?
Workflow · Failed delivery recovery
W12 Failed delivery recovery
When a delivery fails, flags it for ops and queues a redelivery attempt so a missed client is never forgotten.
Workflow · Authorization expiry ladder
W13 Authorization expiry ladder
Watches every authorization daily and warns your team as it nears its end date or unit ceiling, then marks it expired once it lapses.
- 3 steps
- on Referrals & Authorizations
Steps
- Check whether this authorization is near its end date or unit ceiling
- Active, not yet alerted, and inside the warning window?
- Has the authorization passed its end date?
Workflow · Client paused or cancelled
W14 Client paused or cancelled
When a client pauses or cancels service, cancels their pending orders and records the change so no meals go out to someone who has stopped.
Steps
- Has the client stopped service?
Workflow · Inquiry received
W15 Inquiry received
Turns every public inquiry into an intake-queue item and notifies your administrator and ops team right away.
Steps
- Add the inquiry to the intake queue
- Email the administrator about the new inquiry
- Email the ops team about the new inquiry
Workflow · W16a PHI audit - Clients edited
W16a PHI audit - Clients edited
Writes an audit entry every time a client record is edited, so every change to protected health information is traceable for compliance review.
Workflow · W16b PHI audit - Meal Plans edited
W16b PHI audit - Meal Plans edited
Writes an audit entry every time a meal plan is edited, keeping a compliance trail of who changed a client's clinical plan and when.
Workflow · W16c PHI audit - Notes edited
W16c PHI audit - Notes edited
Writes an audit entry every time a consult note or adherence check-in is edited, so clinical notes carry a full change history.
- 1 step
- on Notes / Adherence
Workflow · W16d PHI audit - Authorizations edited
W16d PHI audit - Authorizations edited
Writes an audit entry every time a referral or authorization is edited, so changes to coverage and covered units are always accountable.
- 1 step
- on Referrals & Authorizations
Workflow · W17a Config denorm - Staff
W17a Config denorm - Staff
Tags each new staff member with the organization of whoever created them, so staff records land in the right program without a manual step.
Steps
- Stamp the tenant from the creator
Workflow · W17b Config denorm - Diet Codes
W17b Config denorm - Diet Codes
Tags each new diet code with the organization of whoever created it, so lookup lists stay scoped to your own program.
Steps
- Stamp the tenant from the creator
Workflow · W17c Config denorm - Allergies
W17c Config denorm - Allergies
Tags each new allergy or restriction with the organization of whoever created it, keeping every program's safety list separate.
- 1 step
- on Allergies / Restrictions
Steps
- Stamp the tenant from the creator
Workflow · W17d Config denorm - Menu Items
W17d Config denorm - Menu Items
Tags each new menu item with the organization of whoever created it, so your menu catalog is only ever visible to your own kitchen and dietitians.
Steps
- Stamp the tenant from the creator