ShowMe WorldCare End User Manual

ShowMe WorldCare contains several built-in reports. In general, selected reports only return data that a user is allowed to access based on their specific security permissions. Certain reports such as the cumulative reports may allow statewide data but not on an individual level. Although a user might be able to select a different jurisdiction or condition group than they are allowed to see in their security, no records will return.

Reports generate in a separate window and can be downloaded as PDF files or printed.

Please Note: Certain report types that involved potential exports of line-level protected health information (PHI) are only allowed for users in jurisdictions that have completed a data sharing agreement outline protective measures for that data with DHSS.

Cumulative Report

Cumulative reports are sometimes referred to as Weekly Place of Report and provide information on a selected week. It returns the number of conditions created for a specified time period and can be filtered by various fields such as Condition Group, Transmission Status, Resolution Status and Process Status. After making the desired selections, click Submit.

Although only groups, not specific conditions, can be selected on the Cumulative Report, the report returns a list of the specific conditions within the selected condition group(s). For example, if Heavy Metals is selected, the counts for Arsenic, Cadmium, Copper, and Mercury may appear in the report. To see which conditions are included in which group, please consult the Conditions by Report Group appendix at the end of this manual.

Some helpful tips for working with the Cumulative Report include:

• If no condition groups are selected, the report will return counts for all conditions which the user can access.
• When selecting condition groups, be sure to highlight the condition group and click the Add button to add the group to the selection box. The condition group is not fully selected until it appears in the selection box.
• Conditions which have no records meeting the criteria selected will not be listed on the report, even if they fall within the selected condition group. In other words, if there were no cases of a particular disease in the chosen time period, that disease will not be listed. Likewise, condition groups were set up based on the final condition list prepared by the DHSS programs. Conditions that have not yet transitioned to ShowMe WorldCare will not appear if their condition groups are selected.
• The Date Type defaults to Closed. In most situations, users may want to choose a different date type such as Create, Onset, or Last Updated.

The resulting report displays the cumulative number of records that met the specified criteria for that time period.

Custom Export

The Custom Export is a very powerful reporting tool. A user can choose specific values from designated fields to run queries. The first section contains various filters that can be used to select certain groups of records. The next section allows for Field selection. The user must identify which form they wish to pull data from, followed by a section on that form, followed by a field in that section. In the example below, the current field section is the New taste disorder fields located in the Signs and Symptoms section of the COVID Clinical form. (In other words, this question appears on the Clinical tab of COVID-19 condition records.) Clicking add moves the selected field to the Field list section. In this example, the query will return any COVID-19 condition records created during the month of August 2024 and will contain the fields First Name, Last Name, DOB and New taste disorder, as shown in the field list.

Within the Field List section, the value in the Field Alias column will appear as the column header in the report. In this screenshot, the First Name, Last Name and DOB field names are fairly obvious. However, the New taste disorder field will be named StandardSxNewTasteDi…Users can click in the Field Alias column of the table to create a custom name if desired. Here the Field Alias has been changed to New taste disorder.

The screenshot on the prior page will return all COVID records during that timeframe. To include only those records in which the person had a New taste disorder in the report, the Field Filter button can be used.

After making all desired selections, click Generate File at the bottom of the screen. This report returns a line list of data.

The Custom Export contains a Templates feature so that specific queries can be saved for reuse. For example, DHSS could develop a basic template for pulling a list of cases of a particular condition. After loading the template, but before actually generating the file, users can make any customizations needed, such as selecting a different jurisdiction, filtering for a particular investigator, updating the dates of concern, etc., before clicking the Generate File button. This prevents the template list from filling up with multiple reports that are only slightly different. However, there are a couple of precautions that need to be taken to keep this feature user-friendly.

• Please DO NOT resave a template created by someone else. This will impact the template for any other users that may need it, and the template will have to be rebuilt.
• Before creating and saving a new template, please review the existing templates to see if a similar template exists that can be slightly modified. This will keep the list shorter and easier to use.
• When creating a new template, please keep it generic so it can apply to more users. For example, instead of creating a county-specific version of an export such as “New Mercury Cases in ABC County”, save a “New Mercury Cases” template so it can apply to ANY system user if they select their own county after loading the template and before generating the file. If the template list becomes so long that it is difficult to use, DHSS may have to begin removing templates that seem duplicative. (This was previously an issue in EpiTrax and templates had to be removed based on the number of complaints about the long list.)

De-Identified Reports

The De-Identified Report generates a pivot table which allows data to be further analyzed in Microsoft Excel.

EPI Curve

The EPI Curve report greats a graph showing the number of confirmed cases by disease week compares this to a specified historic baseline.

Ranged Reports

The Ranged Reports provide several quick options with filters. The query screen differs with each report type. Examples of report types that can be run from within the Ranged Reports menu are:

• Cumulative Disease Report
• Form Export
• Image Export
• Incident & Investigation Export
• Outbreak/Investigation/Group Event Export
• Outbreak/Investigations By Disease Report
• RVCT Export (Tuberculosis)
• RVCT FollowUp 1 Export (Tuberculosis)
• RVCT FollowUp 2 Export (Tuberculosis)

Real Time Graphs

This report allows various types of data to be displayed in graphical format. Users can set various parameters. Options for Output Type include:

• Disease Incidence by Age Group
• Disease Incidence by Race/Ethnicity
• Frequency and Incidence Rates by Jurisdiction for Specific Region
• Incidence Rates by Age Group
• Incidence Rates by Month
• Incidence Rates by Race/Ethnicity
• Incidence Rates by Year
• Number of Cases by Age Group
• Number of Cases by Month
• Number of Cases by Nationality
• Number of Cases by Race/Ethnicity
• Number of Cases by Year