Forum Discussion
Capturing Patient Visits
could you pls provde the sample data(not the screenshot) and the expected output
I added the expected output above and included a screenshot of what I was working on. Does this give you enough information to go on ryan_mayu ?
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?