Entities enrolled in multiple programs

Hi everyone,

I am using tracker to manage community health data of around 30k patients using 15 chronic disease programs + Maternal care program. Sometimes a patient might be enrolled in more than 1 program.

Is it possible to generate a list of patients currently enrolled in a program?

To make things more sophisticated, I have requirements to find the list of patients who are enrolled in multiple programs. Also to find aggregate numbers. Is it possible?

For example, I want to know the patients who are having HIV and TB.

And patients enrolled in Maternal care program who are also in HIV program.

Is there an out of the box report framework that I can use, or do I have to create custom SQLs to get these details?

···

​Thanks in advance

,

  • Arun Paul