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.

Last modified 1yr ago