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.