Forum Discussion
Capturing Patient Visits
what's the expected output based on the sample data you provided?
I am hoping to have either a measure or a calculated column the returns "Compliant", Not-compliant", or "Discharged" regarding each patient visit row.
The criteria for compliance:
- Patients needs to be seen at least once a month (regardless of visit type). If there are any months were a patient doesn't have a visit they are Non-compliant.
- Patient need to record a Quarterly or Annual visit once every three months. If there are no quarterly or annual visits in a three month span they are also Not-compliant.
- If an empolyee has an Effective End Date entry they are designated Discharged
I hope this makes sense.
based on the sample data, two patients have end date, so the output is discharged. only cindy has two records and visit monthly, so we mark her as monthly visit, the rest leave blank, is that what you want?
Hi Ryan, The discharge output is correct. The "monthly" output is not correct. Monthly is a visit type. The only 3 output categories would be Compliant, Not-compliant, or Discharged. If a patient had months were they were not seen then they would be not compliant. If a patient didn't have a a quarterly or annual visit every three months then they would be not-compliant. This might be better to do as a measure instead of calc column. Most patients have multiple rows for each of their visit types on the respective dates. I essentially want to evaluate all of there dates and visit types and determine compliant, not compliant or discharched.