oct_epic: Story B - Update the Agg Care Appointment Supply Data Notes Documentation in Data UI

[emilymetcalf114]

cross_ref #2743

The documentation needs to be clearer that:

CC, MM, PSY are using appt/wk for appointment supply (75%ile, etc.) in any given week and Team (AGG) care is using hrs/wk for appointment supply

Clearly this documentation is not sufficient for facilitators to read it an understand what it is doing.

There is also a typo: says hours in the text but appt/wk at the end

There is also a typo in the legend:

[ghost]

This documentation for appointment supply is clear in the context of the legacy excel tool. However, it does not translate well to the new power BI tool.

[lzim]

@epearman - Thanks for the legacy screenshot. We want to identify the best location of this information in Power BI and get it in PROD

• [x] Change appt/wk to hrs/wk only in Team (AGG) Care to be consistent with a calculation of the number of visits multiplied by the most common duration
• [x] Edit second sentence [DRAFT TEXT BELOW]: Visits of different durations were standardized to hrs/wk. Visit count medians were multipled by the most common visit duration of each type: 1 hr for Intake, Psy, EBPsy, & Group (6 pts per group), 30 minutes for CC & MM, and 15 minutes for team adjunct services.

array documented: select 'Appointment Supply (median)' as Label, [Intake] as intake, [psy] as psy, [ebpsy] as ebpsy, [cc]0.5 as cc, [mm]0.5 as mm , [adjunct]0.25 as adjunct, ([group]1.0/6) as 'group'

@jamesmrollins - Need documentation to cover Other Services going to 0, when Intake flow is Revealed

• [ ] Update Session 6 SEE documentation @emilymetcalf114 and @emilyPearman
• [x] Update Session 6 SAY documentation @emilymetcalf114 and @emilyPearman

FYI: @emilymetcalf114

[ghost]

Documentation updated for Monday Blue MTL live team: in testing instance.

• [x] @emilymetcalf114 Can you check the documentation on the test site?

[emilymetcalf114]

FYI @epearman On 10/27/2022 after hq_workflow I checked 3 tabs in the test pipeline for the VISN mtg on Monday

• Team (AGG) Care tab - Legend
• Team Care Descriptions - Appointment Supply (median)
• Team Care Details - Appointment Supply (median)

All 3 are updated to be accurate and clear!

[emilymetcalf114]

10/31 - @emilymetcalf114 submitted a pull request to @epearman with

• [ ] updates to the session 6 SAY guide

@lzim I reviewed the session 6 SEE guide and SAY-checklist, and they do not provide any detail on measures or individual modules, so I couldn't find a good place to include this documentation.