Skip to content

Latest commit

 

History

History
107 lines (81 loc) · 7.47 KB

mtl_session02_see.md

File metadata and controls

107 lines (81 loc) · 7.47 KB
title author date output
MTL Session 2 - Learner See
Team PSD
May 2019
github_document html_document pdf_document word_document ioslides_presentation slidy_presentation powerpoint_presentation
default
default
default
default
default
default
default

Today we're modeling to learn how to check our patient data and team trends.

Done and Do (15 minutes)

Done Do
We identified our Team Vision, selected our Team Lead and set a standing team meeting time. We logged in to mtl.how/data to look at the splash page. We will select and review Team Data for MTL.

Learning Objectives

  1. Describe the decisions your team made in producing your team data table.
  2. Test out whether your expectations about team historical trends are displayed in the "viz" tabs.
  3. Apply your clinical expertise to identify new information about a team patient in the "data" tabs.

In-session Exercise (30 minutes)

MTL on BISL

1. Using the Internet Explorer browser, go to mtl.how/data. First select your VISN and then select your facility.

2. Explore the information available in the BISL sharepoint splash page

  • Click on the View dropdown. What View options are there and what do they mean?

    • Count: Aggregate Data for Viz trends
    • Data: Sortable report of data
    • Diag: Diagnostic data
    • Enc: Encounter types of visits
    • HF: Health Factors data related to visits
    • Meas: Measures or flag names
    • Viz: Visualization of trends
  • What filtering options are available?

    • Filter to your clinic or division to see trends for the last two years.

Your Team Data Folder

3. Scroll to your team folder at the bottom of the page. Open the data_ui folder and open your data_ui file in Excel.

  • Select your station using the control tab. If you have any issues with permissions, Team PSD can help you.
  • Click "Get Clinic List" and it will pull in clinics for your facility.

4. Go to the ClinicSelection tab. Use columns C-H to select the clinics that make up your team.

  • You can sort and filter by Clinic Name, Division Name, Physical Location, Primary and Secondary Stopcode.
  • Or, if your team has designated provider clinics, you can select by provider name.
  • Note: This will pull all clinics used in the last two years (including de-activated clinics: denoted by "ZZ"). You can see the de-activated clinics in column I.
  • Follow the instructions in Box A2.
  • After filtering, click add all. Fine tune your selections by double-clicking on the clinic name in column A (to remove) or column C (to add).

5. To view your team patient data and your team trends click on "Get-Patient-level Data." We will not do this in-session today.

  • You already have a fresh data UI file to work with already in your team data folder.
  • We will learn about the "Create Team Data Table for Sim UI" button in our next team meeting.

NOTE: It takes some time to run a query from your team data UI to the VA Corporate Data Warehouse.

  • On average (depending on the size of your team) it may take 15 minutes or so for your team data UI to pull in fresh data. And, Microsoft Excel will be unresponsive until the data UI has finished pulling in your data.

6. Click to view the "viz" tabs, which show team trends.

  • There are team trends for diagnoses, encounters, health factor data (e.g., suicide plans, evidence-based practice templates), and measures from mental health assistant.
  • What stands out to you?
  • What is most important to you to check out first?
  • What is most surprising?

7. Click to view the "data" tabs, which show your team's individual patient information.

  • Patients who have requested restricted access to their information have asterisks (****) in Column F & G. If you are a VA provider, you can still identify patients from Column H.
  • Patient information correponds to the same categories as the team trends: diagnoses, encounters, health factor data (e.g., suicide plans, evidence-based practice templates), and measures from mental health assistant.
  • Providers can filter to find specific patients, or produce reports.
  • What data tab would you use to find out how many current patients on the team are engaged in a specific evidence-based psychotherapy? What column shows you the session number (EBP template) that the patient is on?
  • What viz tab would you use to see what the most common service encounters or visits are?
  • Are there services that have been increasing over time? Are there services that have been descreasing over time?

With the team trends (viz) and team patient (data) information in the data UI, your team can efficiently use team meetings to focus on the interrelated issues of care coordination and team quality improvement.

Done and Do (15 minutes)

Done Do
We selected the clinics that make up our team for the Team Data. Review the HF, Diag, Enc and SP tabs in Team Data to find a patient (zoom in) and find a team trend (zoom out).