(ツ)_/¯ Help us keep this space current! Please submit a HITS ticket if you notice out-of-date content, broken links, or to request new content to be added.

Case management utilization data across specified date ranges

Request

I would like to request the following data for a presentation on CMHC's case management program:

  • Total CM ICs attended for the following date ranges:
    • 8/15/17-5/31/18
    • 8/15/18-5/31/19
    • 8/15/19-5/31/20
    • 8/15/20-5/31/21
    • 8/15/21-5/31/22
    • 8/14/22-12/31/22
  • Total CM Brief Consults attended for the following date range:
    • 1/1/23-5/31/23
  • Total CM Post-Hosp ICs attended for the following date ranges:
    • 8/15/17-5/31/18
    • 8/15/18-5/31/19
    • 8/15/19-5/31/20
    • 8/15/20-5/31/21
    • 8/15/21-5/31/22
    • 8/14/22-5/31/23

How-to

Summary of steps

Steps with screenshots

  1. Log into the Healthyhorns staff intranet. In the “Dashboards” drop-down menu (top toolbar), select “CMHC Dashboard.”

  2. Select the “Visit Date Range Comparison” tab.

  3. On this dashboard, you can select 2 date ranges at a time. First, use the date range filters to select your desired date range. You can use the calendar picker or type in dates with the keyboard.

  4. Then, use the visit type drop down menu to select desired visit type(s). Use the “All” check box to de-select all visit types.

  5. Next, type in the visit type you are looking for and check the box to select. Repeat to select multiple visit types.

  6. Repeat steps 1-5 on the right-hand side of the dashboard:

  7. For this request, I’ll pull two date ranges at a time to come up with the desired data. Here are the other two date ranges: