Reporting in Sumac Case Management for Health and Social Services
Sumac has many built-in reports, as well as precise searching and flexible export options to customize your reporting.
Using search and export for custom ad-hoc reporting
Built-in Reports
There are many built-in reports that are useful for the Mental Health Case Management module. For more information on basic concepts and built-in reports, see this article.
Analyze & Report has been renamed Reports
Mental Health specific Reporting
Program Usage
There are two easy options for gathering your program usage data to report to funders.
Option 1
From Case Management, select Case Plan. You can search by date range or contact type or opt to show all. Then select Quick Count under Reports. Drag Program Name Name and Status the left to the right of the window and click OK.
Click "Quick Count"
Option 2 is to perform a search and export the data. From the Sumac Console, expand Specialized and select Service Plan.
In Search Type, select Service Plan Field, Initial Assessment - Program Name ID and select the program name. Click Search. This allows you to search by the name of a Program that your Organization offers.
If you want to run a report on the overall usage of the program, skip to the next step. If you would like report on the program usage in a specific time period, click the "+" and add the criteria "When Changed" to add a specific date range.
Click the columns button and add the Days in Program column by dragging them from the left of the screen to the right. Once you are satisfied with the "Fields To Show" click "OK"
Additionally, you can Export the report created. Click Export in the left-hand menu. Select the file type you wish (ie, comma-separated (.csv) and click "Export."
The result is a spreadsheet that you can use to tally the total service time provided for each service type.
Other reporting ideas to explore in your Mental Health Database
Case Plan:
- Number of service plans by program in a month/year. (for this report, you set the date range at the top of the screen and then run a quick count report).
- Active, inactive, and on-hold cases.
- Number of cases by reason for exit.
Case Activity:
- Number of tickets in a month per Case Manager.
- Number of tickets by program name.
- Total Time spent on specific programs.
- Total Time spent by Case workers.
Other built-in reports to explore
There are many other reports that will help you manage your organization. Start by exploring these build-in reports:
Volunteer & Staff Tasks
- Assigned workers
- Tasks in Date Range
- Volunteers By Type
Time Dockets
Client (both detail and summary)
- Program (both detail and summary)
- Worker (detail, detail list, summary)
- Years (excellent for volunteer recognition!)