Docs
Search
⌃K

Healthcare

Digital heath companies use LogicLoop to manage patient care, increase engagement, and manage system logistics.

Upcoming prescription refills for patients

Select all patients who have an upcoming refill.
View SQL Query
SELECT
*
FROM
patients
WHERE
refill_date < current_date + interval '7 days'
Send them a text reminding them to pick up their meds.

Collect on unpaid claims

Detect claims that still have not been paid for 90 days.
View SQL Query
SELECT
*
FROM
claims
WHERE
status = 'unpaid'
AND created_at > current_date - interval '90 days'
Send out an email to the insurance provider to collect.

Lab results taking too long to process

Detect lab results that have not been processed in over 30 days.
View SQL Query
SELECT
*
FROM
lab_results
WHERE
status != 'complete'
and created_at > current_date - interval '30 days'
Alert the team on Slack to investigate.

Update vaccination status

Select all patients that had a COVID vaccine at least 7 days ago.
View SQL Query
SELECT
*
FROM
patient
WHERE
covid_vaccine_taken_at < current_date - interval '7 days'
Update the status of those patients to 'Fully Vaccinated' by writing to your data source.

Alert on poor lab conditions

Alert if humidity levels in the lab room are too high.
View SQL Query
SELECT
humidity
FROM
lab_stats
WHERE
humidity > 75
Send a PagerDuty alert for someone to investigate.