| 12345678910111213141516 |
- care_month join client on care_month.client_id = client.id Start date? 2022-01-01 (care_month.start_date = '2022-01-01')
- care_month join client on care_month.client_id = client.id Enrolled in RPM? YES (client.is_enrolled_in_rm = 'YES')
- care_month join client on care_month.client_id = client.id Enrolled in RPM? NO (client.is_enrolled_in_rm = 'NO' OR client.is_enrolled_in_rm IS NULL OR client.is_enrolled_in_rm = 'UNKNOWN')
- care_month join client on care_month.client_id = client.id Have cellular device? YES (SELECT COUNT(client_bdt_device.id) FROM client_bdt_device JOIN bdt_device bd on client_bdt_device.device_id = bd.id WHERE client_bdt_device.client_id = client.id) > 0
- care_month join client on care_month.client_id = client.id Have been seen w/in 90 days? YES (DATE_PART('day', care_month.start_date::timestamp - client.most_recent_completed_mcp_note_date::timestamp) <= 90)
- care_month join client on care_month.client_id = client.id Have been seen w/in 90 days? NO (client.most_recent_completed_mcp_note_date is null OR (DATE_PART('day', care_month.start_date::timestamp - client.most_recent_completed_mcp_note_date::timestamp) > 90))
- care_month join client on care_month.client_id = client.id Have been spoken to this month? YES (care_month.has_anyone_interacted_with_client_about_rm_outside_note = TRUE)
- care_month join client on care_month.client_id = client.id Have been spoken to this month? NO (care_month.has_anyone_interacted_with_client_about_rm_outside_note IS NULL OR care_month.has_anyone_interacted_with_client_about_rm_outside_note = FALSE)
- care_month join client on care_month.client_id = client.id Have no unstamped meas.? YES (care_month.rm_num_measurements_not_stamped_by_mcp = 0)
- care_month join client on care_month.client_id = client.id Have no unstamped meas.? NO (care_month.rm_num_measurements_not_stamped_by_mcp > 0)
- care_month join client on care_month.client_id = client.id Have 16 or more meas. days? YES (care_month.number_of_days_with_remote_measurements >= 16)
- care_month join client on care_month.client_id = client.id Have 16 or more meas. days? NO (care_month.number_of_days_with_remote_measurements < 16)
- care_month join client on care_month.client_id = client.id Have 20 or more billing mins.? YES (care_month.rm_total_time_in_seconds_by_mcp >= 1200)
- care_month join client on care_month.client_id = client.id Have 20 or more billing mins.? NO (care_month.rm_total_time_in_seconds_by_mcp < 1200)
- care_month join client on care_month.client_id = client.id Have subscribed to SMS? YES (client.send_sms_on_bdt_measurement = TRUE)
- care_month join client on care_month.client_id = client.id Have used the device? YES (client.most_recent_cellular_bp_measurement_at IS NOT NULL OR most_recent_cellular_weight_measurement_at IS NOT NULL)
|
