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
This article tells you how to search using the search panel. You can also use Search Builder to find the contacts you need to report on. Once you have the search results showing in your list, select the columns of data you want to see in your report and export the results of your search into a spreadsheet for further analysis or formatting.
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 Specialized, again select Program Usage. 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 Days in Program the left to the right of the window and click OK.
Click "Quick Count"
This gives you an interesting breakdown. You might discover that 75% of your clients spend about a month in a specific program, which means you need to increase the number of case workers available for that program. Or potentially 75% of your programs require only 30 minute appointments, which means you can increase the number of appointments in a day.
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!)
Our products got an upgrade!
Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!
Related Articles
Societ Academy - Sumac Case Management
Sumac Case Management Series This series of four short webinars will teach you everything you'll need to know about using Sumac for Case Management. We've kept each segment short so you can work these sessions into your schedule. You can register for ...Case Management for Health and Social Services: Overview
Sumac's Mental Health Case Management Module is built with the needs of a Mental Health organization in mind. It allows you to keep a record of clients' cases, manage workflow tasks, track program participation for the clients to report to funders, ...Case Management Dashboard Statistics
This article explains where the statistics that appear on your Dashboard for Case Management come from. Active Clients - quick access to the organization's current client list. This is a count of client contacts with ONE OR MORE Case Plan records ...Reporting in Sumac Case Management for Hospices
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 This article tells you how to search using the search panel. You can also ...Health & Social Services Configuration Data Preparation Instructions
Introduction This page is meant to provide you with information on how to populate your health & social services case management specific data into the Health & Social Services build template that you downloaded from the template-based migration ...
Societ Academy
Learn what you need to know, any time. Free!
- High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
- Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
- A certificate of completion - you can request a certificate of completion for every session you attend.