Forum Discussion
Capturing Patient Visits
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.