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 telemedicine web camera.
Step 4: Construct measures based on the length of time elapsed (in days) between initial referral and care contact received, as follows:
ASD01 - Number of new referrals for suspected autism starting during the reporting period
Count of all unique referrals between the reporting period start date and reporting period end date
ASD02 - Number of new referrals for suspected autism starting in the reporting period having a first appointment recorded
Count of all unique referrals between the reporting period start date and reporting period end date where the care contact date is not null
ASD03 - Number of new referrals for suspected autism in the reporting period receiving a first appointment in 13 weeks or less
Count of all unique referrals from ASD01 for which the time elapsed between referral date and care contact date is equal to or less than 91 days (13 weeks)
ASD04 - Proportion of new referrals for suspected autism in the reporting period receiving a first appointment in 13 weeks or less
Proportion of the unique referrals from ASD01 for which the time elapsed between referral date and care contact date is less than or equal to 91 days (13 weeks), displayed as a percentage
ASD05 - Number of new referrals for suspected autism in the reporting period receiving a first appointment between 13 weeks and 26 weeks
Count of all unique referrals from ASD01 for which the time elapsed between referral date and care contact date is between 92 days and 182 days (13 weeks - 26 weeks)
ASD06 - Proportion of new referrals for suspected autism in the reporting period receiving a first appointment between 13 weeks and 26 weeks
Proportion of the unique referrals from ASD01 for which the time elapsed between referral date and care contact date is between 92 days and 182 days (13 weeks - 26 weeks), displayed as a percentage
ASD07 - Number of new referrals for suspected autism in the reporting period receiving a first appointment at more than 26 weeks
Count of all unique referrals from ASD01 for which the time elapsed between referral date and care contact date is more than or equal to 183 days (26 weeks)
ASD08 - Proportion of new referrals for suspected autism in the reporting period receiving a first appointment at more than 26 weeks
Proportion of the unique referrals from ASD01 for which the time elapsed between referral date and care contact date is more than or equal to 183 days (26 weeks), displayed as a percentage
ASD09 - Number of new referrals for suspected autism in the reporting period not having a first appointment recorded
Number of unique referrals from ASD01 for which the contact date is null