The purpose of this workbook is to provide dashboards to replicate as closely as possible the analysis provided by NHS England in the IAPT monthly activity reports. These reports are available from their site here or a Tableau workbook is available on our iaptus site here
Please remember that the NHS England reports are based on a snapshot of data provided after the month end. These dashboards will reflect the data that is currently in iaptus (as per the last refresh date shown at the bottom of the dashboards) and so may have been updated since submission to NHS England.
List of available Dashboards
Current list and descriptions of available dashboards.
Data Download
You can either download the data directly from within the dashboard view or by going into the Dashboard Tables Workbook.
Referrals Received
Referrals with a referral request received date in the period
Source of referral
Referrals with a referral request received date in the period by source of referral for mental health
No activity
Open referrals in the period by days waiting since last treatment
1st assess
Referrals with first assessment by days waited for a first assessment
No 1st assess
Referrals yet to have a first assessment by days waiting for a first assessment
No 1st assess disch
Referrals that ended in the period before assessment
1st treat
Referrals with first treatment care contact (entered treatment) by mean and median days waited
1st treat wait
Referrals with first treatment care contact (entered treatment) by days waited for a first treatment
1st treat disch
Referrals that finished a course of treatment by mean and median days waited for first treatment
1st treat disch wait
Referrals that finished a course of treatment by number of days waited for first treatment
No 1st treat
Referrals yet to have a first treatment at the period end
No 1st treat disch
Referrals that ended in the period before treatment
2nd treat
Referrals with second treatment by days waited for second treatment
Discharge reason
Referrals that ended in the period by end code
Referral progress
Referrals that ended in the period by referral progress
Attendance
Appointments in the period by attended or did not attend code
Cons Mechanism
Attended and unplanned appointments in the reporting period by consultation mechanism
Treat appts
Treatment appointments for referrals that ended in the period and at least two treatment appointments
Therapy type
Number of attended treatment appointments in the period by therapy type
Therapy appts
Mean number of treatment appointments for referrals that ended in the period and completed treatment by therapy type
WASAS
Referrals ended and finished a course of treatment having at least two scores on WASAS dimension
Sick pay
Referrals with an end date in the period that finished a course of treatment where patient moved off sick pay
Wait
Average days waiting for referrals with an end date in the period
