Create Coded Observation Query for ART Drug Regimens

[John Haskew]

Hi,

We are implementing a version of OpenMRS 1.9.x with MoH in an HIV clinic Provincial General Hospital in Kenya, with more than 7,000 patients currently registered.

We are in the process of creating standard MoH reporting templates and are familiar with the process of creating cohort queries -> dimensions -> indicator defintions -> report definitions and use of excel templates etc.

What we cannot get working is the inclusion of Regimens within cohort queries (please note NOT the cohort builder). We would like to be able to create indicators based on number of people started on ART for example.

All drugs / combinations are listed within ANTIRETROVIRAL DRUGS concepts. However, searching for use of this concept in cohort queries lists 0 patients.

If anyone has any experience / ideas of how to get regimens working within cohort queries we would be most grateful.

Many thanks,

John Haskew

[Darius Jazayeri]

Hi John,

Where are you recording the drug regimens? You have to make sure that you are doing the right query for the specific data representation you've chosen.

E.g. if you are storing regimens in the drug_order table, from the Regimens tab on the patient dashboard, then quickly peeking at the reporting module's source code, I think there is not actually a cohort query for searching for this. (Though I know that some of the Rwanda and/or PIH reporting modules must have cohrt queries defined for this.)

If you're representing your regimens as obs or obs groups, you'll need to use the relevant obs cohort query.

-Darius

-- OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implem...@openmrs.org
Unsubscribe: implementers...@openmrs.org

[Rowan Seymour]

We have a few drug order related cohort definitions in some of our modules, like:

http://emr.moh.gov.rw/svn/modules/rwandaMoHreports/src/org/openmrs/module/rwandamohreports/definition/evaluator/DrugOrderCohortDefinitionEvaluator.java

http://emr.moh.gov.rw/svn/modules/rwandaMoHreports/src/org/openmrs/module/rwandamohreports/definition/DrugOrderCohortDefinition.java

We modified this one recently because although it was able to check if a patient was on drug A+B+C (a simple AND operation), but we needed it to be able to exclude a patient on drugs A+B+C+D (where D is another ARV drug and thus A+B+C+D is a different regimen), but include a patient on A+B+C+Z (where Z is an unrelated drug). 

So thats what the masterDrugSetIds and exactlyAll properties are for. The former can store a list of all ARV drugs and the latter specifies that you want patients on only the drugs you specify.

It would be great to see this functionality in the core reporting module soon

-Rowan

[Ben Wolfe]

Rowan

If you create a ticket in the Reporting module project for this, please report back the ticket id.  If there are votes on the ticket it will move up in the priority queue.  And if you attach a patch, it will move all the faster. :-)

Ben