Reports User Guide¶
The Way Back (TWB) Support Service Minimum Data Set is an extension of the Primary Mental Health Care Minimum Data Set (PMHC MDS); current PMHC MDS online User Guide for Reports is available to be viewed at https://docs.pmhc-mds.com/projects/user-documentation/en/latest/reporting.html.
How to produce a Wayback report¶
The Way Back Quarterly reporting function allows users to automatically populate The Way Back Quarterly Report using data contained in the PMHC MDS. This spreadsheet will then require some manual completion before providing to Beyond Blue or your PHN.
You can produce the Wayback report by following these steps:
- Navigate to the Reports tab
- Click the Wayback tab
- Select the Financial Year
- Select the Reporting Period
- Select the name of the Provider Organisation from the drop down list, if not pre-filled
- Click the blue Request button
- A dialogue box will be displayed, showing that the file is being requested from the server
- When the file is ready, a ‘File ready for download’ message will be displayed
- Click the blue Download button
- An Excel spreadsheet will be downloaded to your computer
11. The spreadsheet will then require some manual completion of information not available to the PMHC-MDS system.
- Once complete send it on to Beyond Blue or your PHN.
Many of the items reported are summarised over two time periods - reporting period and year to date. The former is always a full quarter worth of data as selected in the drop down boxes on the report generation page, unless the most recent quarter has been selected in which case it will be all data from the start of the current quarter until the day the report is generated. Financial years are listed in the report dropdowns with both relevant calendar years listed (e.g. 2020 - 2021). The year to date figure is always from July 1 of the earlier calendar year until either the end of the selected reporting period or the date the report was generated if the current quarter is selected.
The first section of the report explicitly details the dates covered by the reporting period and the year to date, as well as identifying the time at which it was generated.
- New Client Episodes
- This is the number of episodes commenced during the relevant period (reporting or YTD). A key concept here is the episode start date. This is defined as the date of the earliest contact, even if the client is a no-show, but only if there is at least one attended contact during the reporting period.
- Number of Completed Episodes (Exits)
- Any episode with an Episode - End Date during the relevant period.
- Number of Completed Episodes (Service Complete)
- The subset of Completed Episodes as defined immediately above that have an Episode - Completion Status of 1: Episode closed - treatment completed
- Number of Administratively Closed Episodes
- The subset of Completed Episodes as defined above that have an Episode - Completion Status between 2 and 6 inclusive, indicating an administrative closure.
The first three elements in the Client Profile summarise new episodes by client gender:
- The number of episodes started during the relevant period where the Client - Gender is indicated as 1: Male
- The number of episodes started during the relevant period where the Client - Gender is indicated as 2: Female
- The number of episodes started during the relevant period where the Client - Gender is indicated as 3: Other
The next 2 elements summarise new episodes for clients in at risk groups
- Aboriginal and Torres Strait Islander
- The number of episodes started during the relevant period where the Client - Aboriginal and Torres Strait Islander Status was 1,2 or 3, indicating Aboriginal or Torres Strait Islander origin or both.
- The number of episodes started during the relevant period where the client indicates a TWB Episode - Sexual Orientation other than 1: Straight or heterosexual or 9: Not stated.
The final section in the Client Profile is Age Profile, summarising the number of new episodes in the relevant period by the client’s age group at the time the episode began. This is derived from Client - Date of Birth, using only records where Client - Estimated Date of Birth Flag is not a dummy date (code 8) and is not missing (code 9).
The Referral Profile summarises referral criteria (essentially eligibility codes) and sources for episodes starting in the reporting period. There is no corresponding profile for the Year To Date.
- Primary Referral Criteria
- The number of episodes starting in the reporting period with TWB Episode – Eligibility Type Code: 1
- Secondary Referral Criteria
- The number of episodes starting in the reporting period with TWB Episode – Eligibility Type Code: 2
- Referral Source
The number of episodes starting in the reporting period with Episode - Referrer Organisation Type codes of:
- Hospital ED
- 7: Emergency Department
- Hospital Ward
- 5: Public Hospital
- 6: Private Hospital
- Community Mental Health Service
- 4: Public mental health service
- All the other codes (1-3,8-21,98,99)
Service Contact Data¶
The service contact section of the report is concerned exclusively with the Service Contact - Modality. For all contacts in the relevant period it is a simple count of the number of contact each modality:
- 1: Face to Face
- 2: Telephone
- 3: Video
- 4: Internet-based
Client Measures and Experience¶
Information about three clinical measures is reported in this section. For each measure there are three summary statistics:
- The number of episodes with (valid) initial measures collected during the reporting period
- The number of episodes with (valid) final measures collected during the reporting period
- The number of episodes with (valid) final measures collected during the reporting period that also have (valid) initial measures (not necessarily during the reporting period)
Information about collection occasions - including dates and reasons - is available in the Collection Occasion specification documentation. A critical feature of a collection occasion is its “reason”, which is actually about the point in the clients’ journey when the measure was taken. For reporting purposes this can be either “inital” (i.e. start of the episode) or final (end of the episode). Note however that the collection occasion dates need not be the same as the episode start and end dates. Measures can be collected on any day.
The specific measures of interest are the K10+, the WHO-5, and the SIDAS. Information about these measures - including what constitutes a valid measure - can be accessed in the Collection Occasion Key Concepts documentation.
Although there should be no cases where an episode has multiple instances of a particular measure taken at any collection occasion identified as initial or final, if such an anomaly occurs the CO is still included as having the initial/final/paired measure. In other words the technical definition of “having a measure” is interpreted as “having one or more instances of the relevant measure”.
Issues and Risks¶
This section counts client deaths and suicide attempts during the relevant reporting period and year-to-date. Details about such events are available in the TWB Critical Incident - Date documentation. Codes 2 and 3 comprise deaths; code 1 indicates a suicide attempt.
Key Performance Indicators¶
The KPIs produced by the automated reports are all based on particular events occurring within a certain number of days of a precipitating event. KPIs pertain to the reporting period only.
Each KPI reports a reference population (the number in the ‘Calc B’ column) and the subset of that population that meets the criteria in the ‘Target Metric’ column (‘Calc A’). Note that a population in this case means a count of episodes, not a number of people. The ratio is presented as a percentage in the ‘% Achieved During’ column.
Business days are defined as Monday to Friday inclusive, unless they are listed in this document which has been derived from information at the Digital Transformation Office. The business day calculator takes into account the jurisdiction (state or territory of the service). A week is defined as 5 business days.
Correspondence with Primary Nominated Professional on Entry to the Service¶
The reference population here is the number of episodes for which the client’s Primary Nominated Professional was contacted during the reporting period (described in more detail in the TWB Episode - Primary Nominated Professional Consent Date documentation ). This date is defined as the date that consent was obtained. The numerator is the number of these episodes for which correspondence was sent advising them of their client’s participation in The Way Back Support Service within three business days of consent being obtained. The business days is computed as TWB Episode - Primary Nominated Professional Contact Entry Date minus TWB Episode - Primary Nominated Professional Contact – Entry Date.
Correspondence with Primary Nominated Professional on Exit from the Service¶
This is the equivalent of the above for notifying a PNP of a client’s _exit_ from the service. The relevant population is all episodes with an end date during the reporting period and have a TWB Episode - Primary Nominated Professional in the range 1-6 or 98. The numerator includes the subset of these episodes where the TWB Episode - Primary Nominated Professional Contact Exit Date is within 3 days of the Episode - End Date.
Safety Plan Update / Development¶
The relevant episodes here are those where the first and second attended service contacts fall within the reporting period, and the the episode has an initial collection occasion with a corresponding TWB Plan - Plan Type equal to 1: Safety Plan. The numerator is the subset of these episodes for which the collection occasion date is before or on the same day as the second attended contact.
Support Plan Development¶
The relevant episodes here are those where there the first attended service contact is within the reporting period, and the the episode has an initial collection occasion with a corresponding TWB Plan - Plan Type equal to 2: Support Plan. The numerator is the subset of these episodes for which the collection occasion date is not more than 10 days after the initial service contact.