Iteration 4 Architecture

This wiki page describes the architecture for Iteration 4 of the SCOOP project.

Context

The architecture context is basically the same as the previous iteration; however, we are looking at enriching the E2E exporter to contribute back to the community.

/iteration1/images/architecture/IT1-Context.png

This iteration is being deployed to a laboratory environment (non production) at UVic.

There are two practices being simulated in this iteration (i.e. two endpoint) via discrete virtual machines.

Logical View

/iteration1/images/architecture/IT1-Systems.png

There are a number of architectural changes planned for this iteration of SCOOP.

1. We are continuing to enhance and refactor OSCAR to export the patient summary document, either for a single individual or by batch for all individuals with a record in the EMR

2. The middleware (relay-service.rb) Mirth is no longer used as the middleware. Instead, a simple ruby webservice will transfer individual summary documents between the EMR and the hQuery Gateway. It will not perform any aggregation or transformation.

3. hQuery Hub will be investigated as to how we can extend the reporting functionality of the resultant queries. This will allow for future iterations to have a more meaningful result for the researcher by providing a better view of the information.

Constraints

Privacy Individual information never leaves the practice. Early feedback from discussions with the faculty physicians UBC highlighted their stewardship of patient information as a serious matter. There’s a genuine concern that anonymous data collected may be used for unintended research purposes in the future. Several are concerned by the risks of data aggregation, even when the data is de-identified.

Open Source As SCOOP development is sponsored with public funds it will be released as open source for any one to use. In addition, SCOOP will only rely on free, open source components so that its use is accessible to any individual/group.

OSCAR In addition to being open source, OSCAR is the EMR used by many UBC clinical faculty and physicians. A few of these faculty members will the initial SCOOP users. For this reason, OSCAR will be the first supported EMR.

Design View

Software design of the export feature in OSCAR

We will attempt to stay true to the MVC design. Velocity based templating requires both a template and a data model. We have opted to make the Patient object draw on all the pre-existing DAOs and models and have PatientExport group up the relevant fields for easy velocity access. Most of the heavy code work will be found in E2EVelocityExport.java and e2etemplate.vm, and DemographicExportAction4.java acts as the Event Handler and file management for the export function.

Software design for new hQuery enhancements

Our question draws on demographics, medications and laboratory results; all of which are supported by hQuery's API. There shouldn't be any changes to hQuery this iteration.

Query Design

Since hQuery follows the map-reduce paradigm for gathering and returning results, we will also be using a mapping and reducing design.

Map

function map(patient) {
    var targetMedicationCodes = {
        "whoATC": ["C01AA05"],
        "HC-DIN": ["02281236", "02281228", "02281201", "02245428", "02245427",
            "02245426", "02048264", "02048272", "0021415", "00698296", "00647470"]
};

    var targetLabCodes = {
        "LOINC": ["45066-8", "2160-0", "33914-3", "50044-7", "48642-3", "48643-1"]
};

    var ageLimit = 65;

    var drugList = patient.medications();
    var resultList = patient.results();

    var now = new Date();
    var start = new Date(2000, 6, 1);
    var end = addDate(now, 0, 1, 0);

    function addDate(date, y, m, d) {
        var n = new Date(date);
        n.setFullYear(date.getFullYear() + (y || 0));
        n.setMonth(date.getMonth() + (m || 0));
        n.setDate(date.getDate() + (d || 0));
        return n;
    }

    // Checks if patient is older than ageLimit
    function population(patient) {
        return (patient.age(now) >= ageLimit);
    }

    // Checks for Creatinine labs performed within the last year
    function hasLabCode() {
        return resultList.match(targetLabCodes, addDate(now, -1, 0, 0), end).length;
    }

    // Checks for existence of Digoxin
    function hasMedication() {
        return drugList.match(targetMedicationCodes, start, end).length;
    }

    function hasCurrentMedication() {
        for (var i = 0; i < drugList.length; i++) {
            var tmpArray = new hQuery.CodedEntryList();
            tmpArray[0] = drugList[i];
            if (tmpArray.match(targetMedicationCodes)) {
                var drugStart = drugList[i].indicateMedicationStart().getTime();
                var drugEnd = drugList[i].indicateMedicationStop().getTime();

                // Check if drug is within the right time
                if (drugEnd >= now && drugStart <= now) {
                    return true;
                }
            }
        }
        return false;
    }

    emit('total_pop', 1);

    if (population(patient)) {
        //emit("senior_pop: " + patient.given() + " " + patient.last(), 1);
        emit("senior_pop", 1);
        if (hasLabCode()) {
            if (hasMedication() && hasCurrentMedication()) {
                //emit("Digoxin: " + patient.given() + " " + patient.last(), 1);
                //emit("Creatinine: " + patient.given() + " " + patient.last(), 1);
                var c = patient.results();
                for (var i = 0; i < c.length; i++) {
                    if (c[i].interpretation().code() == "A") {
                        //emit("Abnormal Creatinine: " + patient.given() + " " + patient.last(), 1);
                        emit("senior_pop_digoxin_creatinine_abnormal", 1);
                    }
                }
            }
        }
    }
}

Reduce

Since our reduction function works for a wide range of inputs, it will remain the same as previous iterations.

function reduce(key, values) {
    var result = 0;

    while (values.hasNext()) {
        result += values.next();
    }

    return result;
}

Data View

Introduction to E2E E2E, or EMR to EMR, is a CDA specification being developed by BC's PITO organization. Its main purpose is to create a standard in which EMR data can be transmitted to other Canadian EMRs in a standardized way.

Overview of E2E sections (including image)

Scope of content for Iteration 4 In order to sufficiently return value back to the OSCAR community, we need to implement a minimally functional full E2E exporter. As such, our scope includes all sections and content that is defined as required by the E2E specification.

Technology Selection

OSCAR An Open Source EMR system used by many private physicians. This is way that individual information is captured - and the user interface for the physician practioner end user.

relay-service.rb This is an open source ruby script developed by the SCOOP project. Its main purpose is to allow E2E documents stored within a specified directory to be passed into the query gateway by restful web service calls.

hQuery Gateway The query gateway is a web based application that provides the back end for executing queries. The query gateway which exposes a query API, accepts queries, runs those queries against the patient data, and returns the results of the query back to the query composer.

hQuery Composer The query composer is a web based application that provides the front end for creating, managing, and executing queries. Those queries are executed against the query gateway which exposes a query API, accepts queries, runs those queries against the patient data, and returns the results of the query back to the query composer.

Scoop Endpoint refers to all the non-EMR SCOOP software components that will reside at a practice in the future. This indludes hquery gateway, Mirth, and Mirth Rest adapter.

SCOOP Hub This is the application that the researcher uses to ask a "question" of the Research Network. This includes features for query management, policy enforcement, privacy management, and security. Currently, hQuery composer is the only software system in the hub - but more design and enhancements are needed.

• Libraries: template