Step 1: Get all records with suspected autism (MHSDS Reason for referral = '25' - suspected autism) as the referral reason within the reporting period from tables MHS101 and MHS103
Step 2: Join these referral records to the master patient index (MHS001) to allow demographic information to be gained for each patient
Step 3: Link the combined referral and demographic records to the first attended care contact date recorded for each referral, ensuring that this contact is the earliest associated with each referral. Types of contact considered for this analysis are face to face or video consultation.
Step 4: Link the combined referral and demographic records to the diagnoses data.
Step 5: Construct measures based on the length of time elapsed (in days) between initial referral and care contact received, as follows:
ASD11 - Number of open "suspected autism" referrals in the month
Count of all unique referrals open at some point in each month between the reporting period start date and reporting period end date
ASD12 - Number of new "suspected autism" referrals in the month
Count of all unique referrals starting in each month between the reporting period start date and reporting period end date
ASD13 - Number of closed "suspected autism" referrals in the month
Count of all unique referrals discharged in each month between the reporting period start date and reporting period end date
ASD14 - Number of open, "suspected autism" referrals in the month that do not appear in any subsequent month whether discharged or not
Count of all unique referrals open at some point in each month that do not appear in a subsequent month, whether discharged or not, between the reporting period start date and reporting period end date
ASD16 - Number of patients with an open "suspected autism" referral in the month
Count of all unique patients with at least one referral open at some point in each month between the reporting period start date and reporting period end date
ASD16a - Number of patients with an open 'suspected autism' referral in the month that has been open for at least 13 weeks
Count of all unique patients with at least one referral that has been open for at least 13 weeks open at some point in each month between the reporting period start date and reporting period end date
ASD17 - Number of patients with more than one open "suspected autism" referral in the month
Count of all unique patients with at more than one referral open at some point in each month between the reporting period start date and reporting period end date
ASD18 - Number of patients with an open 'suspected autism' referral in the month, that has been open for at least 13 weeks, receiving a first appointment within 13 weeks
Count of all unique patients with at least one open referral from ASD16a for which the time elapsed between referral date and care contact date is equal to or less than 91 days (13 weeks)
ASD19 - Proportion of patients with an open 'suspected autism' referral in the month, that has been open for at least 13 weeks, receiving a first appointment within 13 weeks
Proportion of all unique patients with at least one open referral from ASD16a for which the time elapsed between referral date and care contact date is equal to or less than 91 days (13 weeks). This is calculated as ASD18 divided by ASD16a.
ASD20 - Number of patients which have an open "suspected autism" referral in the month receiving at least one care contact in the month
Count of all unique patients with at least one open referral from ASD16 for who have at least one care contact within the month
ASD21 - Number of patients with an open "suspected autism" referral receiving an autism diagnosis in the month
Count of all unique patients with at least one open referral from ASD16 who also have an autism diagnosis within the month
ASD23 - Number of patients with an open "suspected autism" referral receiving a Mental and Behavioural disorder diagnosis in the month that is not an autism diagnosis
Count of all unique open referrals from ASD11 who also have a non-autism F chapter ICD-10 diagnosis within the month
ASD24 - Number of patients with an open "suspected autism" referral receiving a non-Mental and Behavioural disorder diagnosis recorded in the month
Count of all unique open referrals from ASD11 who also have a non-autism and non-F chapter ICD-10 diagnosis within the month