Board Analytics - TN

Overview

The Tennessee Board Analytics dashboard provides a comprehensive view of key metrics and trends related to Commercial, Medicare and Medicaid patients in Tennessee. It provides deep insights into rosters, retention, patient volume, visits and seen rates. Metrics can be observed by many attributes such as location, market segment, insurance product, clinical line of business and patient demographics.

Dashboard Definitions

• Unique Consumers: Number of unique people in the rosters. If the roster has a member with 2+ member IDs, it only counts once

• Unique Members: Number of unique members based on the master member ID. The master member ID comes from the roster member ID and any other elements that need to be concatenated (e.g., -01) to develop a unique member ID

• Qualifying Visits: Primary Care (which includes Telehealth visits) + Urgent Care visits as defined in the cohort_appt_type_definitions (primary care visit, telehealth phone, telehealth video and urgent care visit). You can contact the Sanitas data team to get the latest appointment types managed table.

• Seen Status (priority order):

  • Seen This Calendar Year - a consumer who has a Qualifying Visit in the current calendar year

  • Future Visit Scheduled - a consumer who has NOT been Seen This Calendar Year AND has a future Qualifying Visit scheduled this calendar year

  • Seen Prior Calendar Year - a consumer who has NOT been seen This Calendar Year AND does NOT have a Future Visit Scheduled AND has a Qualifying Visit in the prior calendar year

  • Inactives - a consumer who has NOT been seen This Calendar Year AND does NOT have a Future Visit Scheduled AND has a Qualifying Visit before the prior calendar year

  • Not Seen - a consumer who does NOT qualify for any of the above conditions and therefore has not had a Qualifying Visit

• Roster Adds: patients who are new to a roster in a given month

• Roster Deletes - patients who fell off the roster from one month to the next

• Roster Retained - patients who stayed on the roster from month to month (historical trends)

• Tenure: How many months the member has been in a roster. For example: 13-24 months.

Dashboard Tabs

• Active Roster:

• Panel Attribution:

• YTD Roster:

• Retention:

• Patient Volume:

• Visit Counts:

Dashboard ABCs

Tabs

Upon opening a dashboard, you will be directed to the first tab by default, which is typically a national view for Sanitas USA users who need to see all states consolidated into one tab. To see a more granular view (State, Region, Location), you should navigate to the additional tabs, if applicable.

Controls

Controls allow you to filter or refine the data displayed within a dashboard. Utilize the down arrow to expose all available control options for a dashboard. Once selected, controls will remain set even if you navigate to a different tab.

Reset Controls

Utilize the reset arrow located above the controls to reset the options before navigating to a new tab or attempting to apply new criteria.

Downloading Pages

Each page can be downloaded by clicking on the export icon in the top right corner of the page. This will create a PDF document that can be downloaded or printed.

Downloading Individual Charts, Tables or Data

You can also download individual charts, tables or data. To do so, click on a chart to display the ellipsis (three dots) in the top right corner. Clicking on this ellipsis will allow you the option to download in cvs and/or excel formats.

Scroll

Most dashboards and visuals extend beyond the available area exposed on a user's window. Dashboards and visuals are scrollable, don't forget to utilize the navigation bars or your middle mouse wheel to do so.