Every authorised hour delivered, and every shift filled
Connect your scheduling, visit and payroll data and ask in plain English: authorised against delivered hours, missed and late visits, overtime by caregiver, open shifts, census and payer mix.
For home care and home health agencies, assisted-living and senior-living operators, and healthcare staffing agencies.
Free plan. No credit card required.
Authorised against delivered hours by client last month: who is under 90%?
AI Analyst
Three clients used under 90% of their authorised hours in September. C-2187 got 49 of 68 hours, 72%, and C-1188 went over, at 104%.
90% of authorised hours
ReadauthorizationsvisitsclientsSQL
Keep itPin to dashboardEmail it weeklyAlert me
Every question, by who asks it
Taken from what teams in this industry ask Supaboard. Each one opens a free account with the question waiting.
01 · Scheduling and visits
- Authorised against delivered hours by client last month: who is under 90%?Ask this: Authorised against delivered hours by client last month: who is under 90%?
- Missed visits and visits started more than 15 minutes late, last week, by officeAsk this: Missed visits and visits started more than 15 minutes late, last week, by office
- Medicaid visits last week with an EVV exception, by reasonAsk this: Medicaid visits last week with an EVV exception, by reason
- Authorisations ending in the next 30 days with hours still unusedAsk this: Authorisations ending in the next 30 days with hours still unused
02 · Caregivers and payroll
- Caregivers who will pass 40 hours this week on what is already scheduledAsk this: Caregivers who will pass 40 hours this week on what is already scheduled
- Overtime hours and cost by office over the last 4 pay periodsAsk this: Overtime hours and cost by office over the last 4 pay periods
- Caregivers who left in the last 12 months, by months worked before leavingAsk this: Caregivers who left in the last 12 months, by months worked before leaving
03 · Staffing and communities
- Open shifts for the next 7 days, and last month's fill rate by facility clientAsk this: Open shifts for the next 7 days, and last month's fill rate by facility client
- Resident census last month across all communities: what moved it?Ask this: Resident census last month across all communities: what moved it?
- Payer mix by delivered hours last quarter: Medicaid, VA, private pay and long-term care insuranceAsk this: Payer mix by delivered hours last quarter: Medicaid, VA, private pay and long-term care insurance
Keep it running
What teams keep on a schedule once they've asked the question once.
Report · Monday 06:30
The week's hours and visits
Authorised against delivered hours, missed and late visits and open shifts for each office, in every coordinator's inbox before the week's first calls.
- Timed Start
- Query Your Data
- Summarize Insights
- Send Email
Alert · Every 5 minutes
Overtime watch
A SQL check on the scheduling database finds caregivers whose worked and scheduled hours will pass 40 this week, and emails the scheduler while the shifts can still move.
- Alerts
- Send Email
Datasite · Every morning
Each facility client's datasite
A private datasite for each facility client, with its orders, fills and open shifts, and Google or Microsoft sign-in.
The numbers it keeps watch on
Standard definitions, and where each one lives in Supaboard once you've asked for it.
| Measure | Definition | Source | In Supaboard |
|---|---|---|---|
| Authorised hours used | Delivered hours ÷ authorised hours, per client, payer and authorisation period | Your payer authorisations | Weekly report, by coordinator |
| EVV-verified visits | Visits with all six EVV items (service, client, caregiver, date, location, start and end times) ÷ Medicaid personal care and home health visits | 21st Century Cures Act, s. 12006 | Alert on new exceptions |
| Missed visit rate | Scheduled visits not delivered and not rescheduled ÷ scheduled visits | Common practice | Weekly report, by office |
| Late visits | Visits clocked in after the grace period past the scheduled start | Your service agreements | A rule, then a daily list |
| Overtime hours | Hours worked past the overtime threshold in a workweek, per caregiver | Your payroll rules | Alert before the week closes |
| Fill rate | Shifts filled ÷ shifts ordered, per facility client | Common practice | Each client's datasite |
| Caregiver turnover | Caregivers who left ÷ average caregiver headcount, over 12 months | Common practice | Monthly report |
| Occupancy | Occupied units ÷ available units, per community | Common practice | Month-end owners' pack |
Where your data lives
Or attach an export to a conversation, as CSV or Excel:
- XLSEVV, visit and payroll exportsUpload
The tables these questions read:
- Scheduled and completed visits by office, with clock-in and clock-out times
- EVV visit records and their exceptions
- Client authorisations: hours by payer, programme and period
- Caregiver timesheets, pay rates, and hire and leaving dates
- Shift orders and fills, by facility client
- Census for each community: units, residents, move-ins and move-outs
Teach it your definitions once
Rules are read with every question, so a term means the same thing in Chat, in Slack and in the Monday report.
- Rule“A missed visit is a scheduled visit with no clock-in by its end time that wasn't rescheduled.”
- Rule“A visit is late when the clock-in is more than 15 minutes after the scheduled start.”
- Rule“The workweek runs Sunday to Saturday, and overtime is any hour past 40 in it.”
Security
HIPAA BAA
Available on Enterprise. Sign it before patient data goes into Supaboard.
Read-only by construction
Database and warehouse queries are read-only. We give you the SQL for a read-only user too.
Your data region
North America, EU or Asia, chosen when the workspace is created.
Credentials stay in the workspace
Scoped to the one workspace that connected them, never logged and never sent back to a browser.
Frequently asked questions
Does it work with our scheduling and EVV system?
If its data sits in SQL Server, Postgres or MySQL that you can reach, connect it live and read-only, and the reports and alerts on this page run on it. If it only gives you exports, upload one as CSV or Excel and ask about it. To keep the exports current on a schedule, have them copied into a database you connect.
Will Supaboard sign a BAA?
Yes. A HIPAA BAA is available on Enterprise. Client records are protected health information, so sign it before they go into Supaboard.
Does it check our EVV records?
It answers questions about them: which visits carry an exception and why, by office, caregiver and payer. What your state requires, and whether it accepts a visit, is set by your state's EVV system.
Can each facility client see its own fill rate?
Yes. Publish a private datasite for each client with Google or Microsoft sign-in, or email each one its own report on its own schedule.
How does it know what counts as a late or missed visit?
Write it once as a rule, such as "a visit is late 15 minutes after the scheduled start". The agent reads its rules with every question, and you can save reviewed SQL as examples.
More in Healthcare & Life Sciences
- Revenue Cycle ManagementDenials, aging AR, days to bill and client SLAs, from claims and remittance data.
- Medical & Dental PracticesSchedule fill, no-shows, production by provider and collections, from your practice system.
- PharmaciesScripts, margin by payer, stock and refills, from your pharmacy system's data.
Ask your first question on your own data
Connect a source, ask in plain English, and keep what you find.
Start FreeBook a 30-minute demo
Free plan. No credit card required.