Indicator Dashboard

The portion of the “Panel” dashboard shown contains three indicators.  The first displays a bar graph of active patients.  The second shows patient how complete the patients contact information is for having both a phone and email lised.  The third shows percentages of active patients seen within certain intervals.

Drill down

Each indicator will have Drill Down as an option to review the demographics relating to the information shown in the graph.

Here in the Patient Contact Information drilldown the first row shows that Ms Abracadabra is missing email data.    Click on the link (14) to go to the master demographic in question to update.

Use the Action dropdown for one of a number of Actions for checked demographic(s).

Most templates will allow you to bulk set ticklers to checked patients

Other possible actions include bulk updates to the disease registry.

The code selected by the indicator and its common language equivalent are shown.  If you confirm then each checked demographics disease registry entry will be updated with the diagnosis (if not already present) and a list of the demographics involved will be sent to your inbox.

REALLY ADVANCED Roll your own

Some of the functionality described above is specific to OSCAR 19 and involves additional indicator XML settings than mentioned below.  You can create your own template based on the following blank which is generally compatible with OSCAR 19 as well as recent forks.  See the video tutorial at https://youtu.be/ADj6Bz_gTfg

<?xml version="1.0" encoding="UTF-8"?>
<indicatorTemplateXML>
    <author>PHC</author>
    <uid></uid>
    <heading>
        <category>This is the broad category of related indicators that shows up in the blue bar eg Vulnerable Population</category>
        <subCategory>this is grey bar entry eg Chronic Kidney Disease</subCategory>
        <name>this is the per graph specific indicators name eg eGFR</name>
        <metricSetName>can be left blank</metricSetName>
        <metricLabel>can be left blank</metricLabel>
        <definition>Something useful to show up on clicking info eg Providers Population age 18 and older who have eGFR measurements by CKD Stage.</definition>
        <framework>Based on whatever you like</framework>
        <frameworkVersion>01-30-2018</frameworkVersion>
        <notes>Shows up when you click on info</notes>
    </heading>
    <indicatorQuery>
        <version>03-30-2021</version>
        <params>
            <!-- constants, the example shows what you would use for reports on adults.  You need to use ${provider} for the placeholder in your SQL -->
            <parameter id="provider" name="provider_no" value="loggedInProvider" />
            <parameter id="pstatus" name="Patient Status" value="'AC'" />
        </params>
        <range>
            <!-- numerical constraints, the example shows what you would use for reports on adults.  use ${lowerLimit.age} for the placeholder in the SQL -->
            <lowerLimit id="age" label="Min Age" name="Age" value="18" />
        </range>
        <query>
            <!-- Indicator SQL Query here.  Craft your query to result counts which will then be graphed -->
        </query>
    </indicatorQuery>
    <drillDownQuery>
        <version>03-30-2021</version>
        <params>
            <!-- constants, the example shows what you would use for reports on adults.  You need to use ${provider} for the placeholder in your SQL -->
            <parameter id="provider" name="provider_no" value="loggedInProvider" />
            <parameter id="pstatus" name="Patient Status" value="'AC'" />
        </params>
        <range>
            <!-- numerical constraints, the example shows what you would use for reports on adults.  use ${lowerLimit.age} for the placeholder in the SQL -->
            <lowerLimit id="age" label="Min Age" name="Age" value="18" />
        </range>
        <displayColumns>
             <!-- which columns will you display in the drill down.  Usually they start with the first three below -->
            <column id="demographic" name="d.demographic_no" title="Patient Id" primary="true" />
            <column id="name" name="CONCAT( d.last_name, ', ', d.first_name )" title="Patient Name" primary="false" />
            <column id="dob" name="DATE_FORMAT( CONCAT(d.year_of_birth,'-',d.month_of_birth,'-',d.date_of_birth), '%m-%d-%Y' )" title="Patient DOB (mm-dd-yyyy)" primary="false" />
        </displayColumns>
        <exportColumns>
            <!-- which columns will you allow for downloading, usually duplicate of the ones you display but can be different -->
        </exportColumns>
        <drillDownActions>
            <action id="tickler" name="Tickler"/> <!-- this allows ticklers to be set for the relevant demographics -->
            <action id="dxUpdate" name="Disease Registry Update" value="585"/> <!-- the value is the disease registry code to add -->
            <action id="patientStatusUpdate" name="Set Patient Inactive"/>
        </drillDownActions>
        <query>
            <!-- Drilldown SQL Query here Craft your query to provide values for the display and export columns-->
        </query>
    </drillDownQuery>   
</indicatorTemplateXML>