Aggregate (mSERS)

Aggregate surveillance data can exist in a variety of forms, but the main feature is that it lacks detailed information on specific cases. Aggregate data typically include the number of cases for a specific region and time period. This information can monitor the number of cases but lacks the individual-level data required for specific analyses [Reference].

In SORMAS, diseases can be activated as case-based or aggregate. A list of all diseases in SORMAS as well as whether they are typically case-based or aggregate are summarized on GitHub: Disease Configuration Options

The Aggregate (formerly “mSERS“ in SORMAS) module can be accessed through the ribbon menu on the left.

Aggregate reporting

Filters

Existing aggregate reports can be filtered based on various filters including:

Region
District
Facility
Point of Entry
Disease
From a week in a specific year, to a week in a specific year.

To make the filters active, click “APPLY FILTERS”. To reset filter values to default, click “RESET FILTERS”.

Filter results may be grouped by region, district, facility or point of entry, by using the “Grouping” drop-down. Display zero-value entries by selecting the “Show 0-rows for disease(s)” option.

New aggregate report

To create a new aggregate report, click the “NEW AGGREGATE REPORT” button on the the top right. A new form will appear.

Select the timeframe (last week, this week, specify [custom year and epi week]), region, district and optionally, the facility and point of entry that the data will be captured for.

Enter the total number of cases for each disease, indicating the suspect cases (C), laboratory confirmed cases (L) and deaths (D).

Click “Save” at the bottom of the page to save your changes.

Export

To export Aggregate data based on the active filters and directory setting, click the “EXPORT” button. A comma separated values (CSV) file will download to your device.

Report Data

Filters

To view report data on where aggregate reporting originates from (i.e. which users created which data), click on the “REPORT DATA” tab.

User reports can be filtered based on various filters including:

Region
District
Facility
Point of Entry
Disease
From a week in a specific year, to a week in a specific year

To make the filters active, click “APPLY FILTERS”. To reset filter values to default (remove all filters), click “RESET FILTERS”.

Export

To export Aggregate report data based on the active filters and directory setting, click the “EXPORT” button. A comma separated values (CSV) file will download to your device.