Data source
The data in this dashboard is sourced from PRIMHD.
Technical notes
Percentage of tāngata whai ora with whānau engagement
- Activity start date is >= start date of selected quarter and <= end date of selected
- Tāngata whai ora with an activity
- Activity type is not
- T35 Did not attend
- T08 Care/liaison co-ordination contacts
- Activity setting is not
- WR – Written correspondence
- SM – SMS text messaging
- OM – Other social media/E therapy
- Activity Unit Type is CONTACT
- Team setting is not I Inpatient
- Team type is not
- 01 Inpatient team
- 05 Forensic team
- 08 Residential/accommodation team
- 26 Intellectual disability
3. Tāngata whai ora with whānau activity
- Activity Type is one of:
- T32 – Contact with family/whānau, consumer not present
- T36 – Contact with family/whānau, tāngata whai ora/consumer present
- and/or Family/whānau involvement = 1 Yes
- Activity type is not T35 did not attend
- Activity setting is not
- WR – Written correspondence
- SM – SMS text messaging
- OM – Other social media/E therapy
4. % of tāngata whai ora with whānau engagement in a quarter = Tāngata whai ora with whānau activity/ tāngata whai ora with an activity
First whānau engagement activity in episode of care
The process of service episode reconstruction is as follows:
1. Exclude any out of scope referrals, which are referrals where contact is not necessarily expected. These are any referrals that meet any of these criteria:
- ReferralEndCode is RI, RO or DZ – referral was declined or discharged with no direct contact required
- TeamType is 24 or 26 – integrated primary access and choice and intellectual disability teams
- Referral end code is in (DM, DG, DD, ID) AND there does not exist an in-scope activity on the referral – referral ended in a way that indicates contact may not have been expected, and there was no activity.
2. Within each unique combination of tangata whai ora and organisation, combine all overlapping in scope referrals into service episodes. This can be achieved in various ways, but the KPI programme uses a ‘gaps and islands’ approach:
- Sort referrals by referral start date, referral end date, referral ID
- Calculate the ranked order for each referral (sorting by referral start date, referral end date, and then referral ID to tiebreak)
- For each referral calculate the previous end date, which is the maximum Referral End Date of any referral with a lower ranked order (effectively the latest end date of any referral that started before this referral for this tangata whai ora at this organisation)
- For each referral compare referral start date to previous end date to determine whether this is an index referral or overlap
- if referral Start Date <= previous end date this referral overlaps a previous referral and should roll into that service episode; set Index Referral?=0
- if referral start date> Previous end date this referral starts a new service episode; set Index referral?=1
- For each referral count the number of index referrals that have previously occurred for this tangata whai ora at this organisation, and append that value to the Organisation ID and HCU to form a globally unique service episode ID. For example the service episode for client ABC1234 at organisation G-0000 would be named G-0000_ABC1234_0; G-oo0o_ABC1234_1; etc.
- Service Episode Start Date= referral start date of the index referral in each service episode.
3. Within each service episode identify the earliest in-scope activity on any referral in the service episode
- Exclude all activities where either of these criteria are met:
- ActivitySetting is one of these
- WR – Written correspondence
- SM – SMS text messaging
- OM – Other social media, e-therapy
- Activity type is one of these:
- T08 Care/liaison coordination contacts
- T24 Work opportunity/Employment/Vocational
- T33 Seclusion
- T35 Did not attend
- T37 On leave
- T43 Community support contacts
- T44 Advocacy
- T45 Peer support
- T52 Health coaching contact
- TCR MOH internal reference.
- Rank all remaining in-scope activities by activity start datetime, and then referral ID and activity ID
- Calculate the ranked order for each in-scope activity (sorting by activity start datetime, and then referral ID and activity ID to tiebreak)
- Where Ranked Order = 1, this is the first in scope activity on the service episode
- First in-scope activity start datetime = activity start datetime of this first in-scope activity. This determines the time period for analysis.
4. Find the first whānau engagement datetime activity
- Activity Type is one of:
- T32 – Contact with family/whānau, consumer not present
- T36 – Contact with family/whānau, tāngata whai ora/consumer present
- and/or family/whānau involvement = 1 Yes
- Activity type is not T35 did not attend
- Activity setting is not:
- WR – Written correspondence
- SM – SMS text messaging
- OM – Other social media/E-therapy
5. Calculate additional service episode metadata for use in analysis:
- Initial Team Type = Team Type of the index referral
- Age at service episode start = age in years on the referral start date
6. Calculate the difference between the first in-scope activity start datetime and first whānau engagement datetime. For each episode group as follows:
- 14 days in under (Potential for a few negative number not an in scope activity)
- 15 to 28 days
- 29+ days
- No whānau contact
7. Exclude initial team type:
- 01 Inpatient team
- 05 Forensic team
- 08 Residential/accommodation team
- 26 Intellectual disability
8. Only include episodes with a third in-scope activity.
