Regional Healthcare Provider Modernizes Referral Operations with Quickbase, Claude, and Workato

The Client Profile

• Industry: Healthcare; Outpatient Home Care

• Headquarters: Kansas City, MO

• Organization Size: 1,200 employees

• Operational Footprint: 12 states

• States Served: Kansas, Illinois, Indiana, Michigan, Ohio, Wisconsin, North Dakota, South Dakota, Idaho, Minnesota, Missouri, and Nebraska

• Engagement Focus: Referral management, AI-powered document processing, systems integration, and workflow automation

A rapidly growing home healthcare provider headquartered in Kansas City, MO receives patient referrals from more than 100 hospital systems across a 12-state service area. With 1,200 employees supporting patients throughout the Midwest and Mountain West, the organization needed a more efficient way to coordinate referrals across its expanding network.

The Challenge

Fragmented Referral Processes Delayed Patient Admissions

Each referral required collaboration among intake coordinators, clinical reviewers, insurance specialists, schedulers, branch teams, and field clinicians. However, these teams relied heavily on spreadsheets, email, shared documents, and manual status updates to manage the referral process.

Referral packets arrived through multiple channels and often contained incomplete, inconsistent, or duplicate information. Employees had to manually review clinical documents, enter patient data, verify insurance requirements, identify missing records, and contact hospital discharge teams before a referral could move forward.

The fragmented process created several operational challenges:

• Referral information was distributed across spreadsheets, inboxes, document repositories, and the organization’s EHR.

• Employees frequently duplicated work because teams could not easily see which tasks had already been completed.

• Incomplete referral packets were not always identified immediately, creating delays later in the admission process.

• Intake teams spent significant time reading documents and manually creating referral summaries.

• Payer requirements and insurance verification activities varied across states, markets, and health plans.

• Branch managers lacked a consistent view of incoming referrals and admission readiness.

• Leadership could not easily identify bottlenecks, measure turnaround times, or compare referral performance across locations.

• Qualified patients risked being admitted later than necessary or lost to another provider because of administrative delays.

As referral volume increased, hiring additional administrative employees would not solve the underlying problem. The organization needed a centralized platform that could standardize its referral process, connect existing systems, and help employees make faster decisions without removing human oversight.

The Solution

An AI-Powered Referral Operations Platform

Quandary Consulting Group designed and implemented a centralized referral operations platform using Quickbase, Claude, and Workato. The solution connected referral intake, document review, insurance verification, clinical approval, scheduling, and admission readiness within one coordinated workflow.

Rather than replacing the organization’s EHR or Microsoft 365 environment, Quandary created an operational layer that connected these systems and provided employees with a consistent process for managing every referral.

Centralized Referral Management in Quickbase

Quickbase became the organization’s central referral operations platform. Every referral was captured in a standardized digital record containing the patient’s information, referring hospital, assigned branch, requested services, payer details, required documentation, clinical review status, and admission timeline. The platform guided each referral through clearly defined stages:

• Referral received

• Documentation review

• Missing-information follow-up

• Insurance verification

• Clinical eligibility review

• Branch acceptance

• Scheduling and staffing

• Admission readiness

• Patient admitted or referral closed

Each stage included assigned owners, required information, due dates, and completion criteria. This prevented referrals from advancing before essential documentation and approvals were in place.

Role-based work queues allowed employees to focus on the referrals requiring their attention. Intake coordinators could see new and incomplete submissions, insurance specialists could access cases awaiting verification, and clinical reviewers could prioritize referrals ready for eligibility assessment.

AI-Assisted Referral Packet Review with Claude

Quandary incorporated Claude as a secure, assistive document-intelligence layer within the referral process. Claude helped employees analyze approved referral documents, including discharge summaries, physician orders, medication lists, demographic records, insurance information, therapy notes, and care instructions.

Claude extracted relevant information from the referral packet and organized it into a structured case summary. Depending on the documents provided, the AI-assisted workflow could identify:

• Patient demographics and contact information

• Referring hospital and provider

• Primary and secondary diagnoses

• Requested home healthcare services

• Medication and treatment information

• Insurance and payer details

• Discharge date and anticipated start-of-care date

• Clinical risk indicators

• Required equipment or specialized services

• Potentially missing documentation

Instead of reading every page before understanding the case, employees received a concise summary highlighting the most important information. Claude also flagged inconsistencies or potentially missing items for further investigation.

The system maintained human oversight throughout the process. Employees reviewed and validated Claude’s output before extracted information was finalized or a referral advanced. The AI supported faster document review and decision-making without independently making clinical eligibility, coverage, or admission decisions.

EHR + Microsoft 365 Integration with Workato

Workato connected the referral platform with the organization’s existing EHR and Microsoft 365 environment. These integrations allowed information to move between systems without requiring employees to repeatedly copy and paste data.

Automated workflows synchronized approved referral information with the EHR, reducing duplicate data entry and improving record consistency. Workato also supported the secure exchange of documents and status information between Quickbase, Microsoft 365, and other operational systems.

When a referral changed status, Workato triggered the appropriate downstream action. For example, the platform could:

• Create or update the corresponding patient record in the EHR.

• Route approved documents to the appropriate repository.

• Notify the assigned clinical or insurance team.

• Alert branch staff when a patient was ready for scheduling.

• Escalate referrals approaching internal turnaround-time thresholds.

• Update referral status when required tasks were completed in another system.

This integration strategy preserved the organization’s existing technology investments while giving employees a unified operational experience.

Automated Documentation and Exception Management

The platform automatically checked each referral against defined documentation requirements. Requirements could vary based on the requested service, payer, state, branch, or referral source.

If required information was missing, the referral was routed into an exception workflow. The system identified the outstanding item, assigned responsibility for obtaining it, and tracked follow-up activity.

Automated reminders and escalation rules helped prevent incomplete referrals from sitting unnoticed in an employee’s inbox. Once the requested documentation was received and validated, the case returned to the appropriate workflow stage.

This exception-based approach allowed employees to concentrate on referrals requiring judgment or follow-up instead of manually checking the status of every case.

Standardized Insurance and Clinical Review Workflows

Quandary configured structured workflows for insurance verification and clinical review. Insurance specialists could document coverage status, authorization requirements, benefit limitations, and payer-specific conditions within the referral record.

Clinical reviewers received a complete case summary, validated documentation, and a standardized review checklist. The platform documented decisions, timestamps, notes, and approvals, creating a consistent audit trail across all locations.

Cases that met defined requirements moved forward, while referrals involving missing documentation, coverage concerns, clinical complexity, or service-area constraints were routed to the appropriate employee for review.

Real-Time Operational Dashboards

Quickbase dashboards gave branch managers and executives real-time visibility into referral operations across all 12 states.

Leadership could monitor:

• Referral volume by hospital, branch, region, and state

• Referrals awaiting documentation or review

• Average processing and admission turnaround times

• Referrals approaching service-level deadlines

• Acceptance, conversion, and closure rates

• Common reasons for referral delays or rejection

• Employee and team workloads

• Hospital referral patterns

• Patient admission readiness

• Performance trends across locations

Instead of waiting for employees to consolidate spreadsheet data, leaders could access current operational information and identify bottlenecks as they developed.

The Results

Faster Referrals and Greater Admission Capacity

The centralized platform transformed referral management from a fragmented administrative process into a coordinated, measurable workflow.

58% Reduction in Referral Processing Time

Standardized workflows, AI-assisted document review, automated routing, and system integrations reduced the time required to process referrals by 58%. Employees could identify complete, admission-ready referrals sooner and address missing information before it caused downstream delays.

Increased Admissions Without Additional Administrative Staff

By reducing manual document review, duplicate data entry, status tracking, and follow-up activity, the organization increased its capacity to process referrals without expanding its administrative workforce at the same rate as referral volume.

Elimination of Spreadsheet-Based Tracking

Quickbase replaced disconnected spreadsheets with a centralized referral record and standardized workflow. Employees across all locations could see the same current information, reducing version-control issues and duplicate work.

Improved Referral Visibility Across 12 States

Branch managers and regional leaders gained real-time visibility into incoming referrals, outstanding requirements, clinical-review status, and admission readiness. Teams could quickly identify which patients were ready to move forward and which required additional attention.

Reduced Manual Document Review

Claude generated structured summaries and highlighted potentially missing information, reducing the time employees spent searching through lengthy referral packets. Human validation ensured that employees remained responsible for final decisions.

Stronger Accountability and Auditability

Every referral included a documented history of status changes, employee actions, approvals, notes, and follow-up activities. This created a consistent operational record and improved accountability across intake, insurance, clinical, and scheduling teams.

Better Executive Reporting and Planning

Leadership gained reliable information about referral sources, conversion rates, turnaround times, regional demand, and operational capacity. These insights supported staffing decisions, hospital relationship management, market planning, and continued expansion.

Ultimately, the solution enabled the organization to admit patients faster, scale referral operations across 12 states, and improve coordination with more than 150 hospital systems—without replacing its core healthcare technology.