Forum Discussion

cnel's avatar
cnel
Frequent Visitor
3 years ago

Capturing Patient Visits

I am trying to capture patient visits to determine if they are compliant or not. There is a column [Visit Type], which includes Intial Visit, Quarterly visit, Monthly visit, Annual Visit, Acute/foll...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

could you pls provde the sample data(not the screenshot) and the expected output

  • cnel's avatar
    cnel
    Frequent Visitor
    3 years ago

    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 ? 

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      3 years ago

      what's the expected output based on the sample data you provided?

      • cnel's avatar
        cnel
        Frequent Visitor
        3 years ago

        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.