BUSINESS INTELLIGENCE SUB-GROUP Table 3: National Returns/Collections and Outputs Name of Return Who is return for? Brief description of Data provided (Inputs) Submission frequency Period covered Outputs/Publications Output frequency Time lag between collection and publication (months) Adult Social Care Learning Disability Stats (ESAY) Scottish Commission for Learning Disability (SCLD) (on behalf of the Scottish Govt) Data on the numbers of people with learning disabilities and / or autism in each local authority. Longitudinal Survey. Annual Census date in Oct A report about the number of people with learning disabilities and / or autism in Scotland is published every year. Link to Scottish Government website for further information: annual 7 months Social Care Survey Scottish Government 1. Self-Directed Support (full year) 2.Community Alarms and other telecare services (full year) 3. All Home Care services, Housing Support services, and Meals services during Census Week. Annual 1 Apr – 31 March (annual) Census week – National figures for Social Care services provided or purchased by Local Authorities in Scotland. Link to Scottish Government website for further information: annual 4 months Guardianship Logs Mental Welfare Commission Log of people for whom we have a record of a guardianship order registered with the Mental Welfare Commission Twice yearly As at list is provided None n/a n/a
Care Home Placements and Free Care Clients Scottish Government Aggregate report: numbers of residents in care homes and numbers of residents receiving free care. Return is for the January - March period only Free Personal and Nursing Care publication. Link to Scottish Government website for further information: Annual 2 months Eligibility Criteria and Waiting Times Survey Scottish Government Time intervals for clients in all Eligibility Categories between contact and completion of assessment and between completion of assessment and service delivery. Return is for the January - period only Jan- Mar Eligibility Criteria and Waiting Times - annual figures from the quarterly survey. Link to Scottish Government website for further information: Annual 2 months Adult Support and Protection (ASP) return Scottish Government Aggregate data collection: details of all referrals, source of referrals, investigations, case conferences (initial and review), Protection Orders granted, large scale investigations. Annual 1 Apr – 31 Mar Benchmarked report is sent out from SG. Return is under development. Useful for standardising processes across LAs to ensure consistency of approach to ASP. Link to Scottish Government website for further information: Annual 2/3 months Scottish Care Home Census (SCHC) Care Inspectorate collects the data on behalf of the Scot Government and ISD Number of residents in each care home on 31st March each year. Annual - completed by individual care homes Census date Data covers all adult care home establishments registered with the Care Inspectorate in Scotland. Data is available at Scotland and local authority level. Link to ISD website for further information: Annual 6 months Addictions Services ADP Report Scottish Government Collation of alcohol and drug stats for Glasgow City. Annual Collation of alcohol and drug stats for Glasgow City and Scotland. Link to Scottish Annual
Government website for further information: SMR25 - Scottish Drug Misuse Database (SDMD) ISD/Scottish Government Misuse of drugs: including client demographics, social profile, dependants, prescription profile and injecting / sharing information. Quarterly data upload to SDMD site SDMD offers a profile of the misuse of drugs, based on information about drug clients seen at a broad range of services across Scotland. Link to National Data Catalogue (ISD) website for further information: Quarterly Children's Services Looked After Children Collection Scottish Government Individual level data: Children Looked After - Placement type, children starting and ceasing to be looked after. Secure Care Accommodation - Bed complement, capacity and usage Annual 1 Aug – 31 Jul SG reports stats on Children Looked after and Secure Care by Local Authority and gives cross-UK comparisons. Link to Scottish Government website for further information: Annual 5 months Young People Eligible for Aftercare Services collection Scottish Government Individual data for Aftercare services Annual 1 Aug – 31 Jul SG reports stats on Aftercare services by Local Authority and gives cross-UK comparisons. Link to Scottish Government website for further information: Annual 5 months
Child Protection Collection Scottish Government Individual level data for all CP investigations, case conferences, reviews and transfers In/Out (of area), including the outcomes of these meetings held during the past 12 months. Annual 1 Aug – 31 Jul SG reports stats on Child Protection registrations and deregistrations within Scotland, and gives cross-UK child protection comparisons. Link to Scottish Government website for further information: Annual 5 months Homelessness HL1 Scottish Government Homelessness applications and assessments. Quarterly Last Quarter HL team upload the Glasgow data to SG and it back the next day. Link to Scottish Government website: Quarterly Glasgow data by return HL2 Scottish Government Households in temporary accommodation; households in non-permanent accommodation; households at risk of homelessness due to eviction; and households in unsuitable accommodation. Quarterly Last Quarter HL team upload the Glasgow data to SG and it comes back the next day. Link to Scottish Government website: Quarterly Glasgow data by return HL3 Scottish Government Monitors households in temporary accommodation under the homeless persons' legislation Quarterly Last Quarter HL team upload the Glasgow data to SG and it back the next day. Link to Scottish Government website: Quarterly Glasgow data by return Prevent 1 (Housing Options) Scottish Government Case level data collection to monitor housing options/ homelessness prevention. Quarterly Last Quarter HL team upload the Glasgow data to SG and it comes back the next day. Report provides information on housing options/ homelessness prevention in Scotland. Link to Scottish Government website: Quarterly Glasgow data by return
ARC Return Scottish Housing Regulator (SHR) ARC (Annual Return on the Charter) Annual Last Year Link to SHR website: annual Criminal Justice Community payback orders (CPOs) Scottish Government Details all CPOs in place over a 12 month period. Annual 1 Apr – 31 Mar SG CPO Annual Report covers four broad areas: the use of the unpaid work or other activity requirement; the use of requirements other than unpaid work; issues affecting services provided by other partners and the work underway to resolve them; and other relevant information. Link to Scottish Government website: annual 7 months Drug treatment and testing orders (DTTOs) Scottish Government Annual 1 Apr – 31 Mar Information on Drug Treatment and Testing Orders across local authority areas. Link to Scottish Government website: annual 7 months CJ Aggregate return Scottish Government Annual 1 Apr – 31 Mar Link to Scottish Government website: annual 7 months HR Local Authority SWS Staffing (LASWS) Collected by SSSC on behalf of the Scottish Government SWS staff annual census: post category, whole-time equivalent, gender of staff, age of staff, ethnicity and disability of staff, contract type, registration Annual Census on 31 Decr Workforce Data Report is published by Scottish Social Services Council (SSSC). annual 8 months
requirements, and number of vacancies are collected. Mental Health Officer return Collected by SSSC on behalf of the Scottish Government The survey covers those social workers employed as Mental Health Officers (MHOs) by Scottish Local Authorities. Annual - completed by HR Census 1 Dec MHO Report presents information on the number of practicing MHOs in post, MHO trainees, leavers, vacancies and staffing shortfalls and some key aspects of the work carried out by MHOs in Scotland. annual 8 months ISD Outputs 18 Week Referral to Treatment Statistics (aggregate return) ISD Monthly summaries of whole journey waiting times across NHS Scotland at end. Data collection began in 2009 and ISD began publishing 18 weeks RTT data in March 2011. Publication released quarterly. Monthly Last month NHS Waiting Times – 18 Weeks Referral to Treatment. Link to Scottish Government website: Quarterly TBC Alcohol Brief Interventions (ABIs) ISD Information on the number of alcohol interventions carried out across primary care, A&E and ante-natal and wider settings in Scotland, collected by NHS Boards and collated by ISD. Monitoring against ABI HEAT standard. TBC TBC Alcohol Brief - Interventions Annual Report. Link to ISD website for further information: Annual TBC
Delayed Discharges ISD Delayed Discharge in NHS Scotland. Patient based using CHI. Collects Date of Birth, Post Code, Date ready for Discharge, Principal reason for delay (approx 35 reasons summarised into 8 groups), Location and specialty at a census date. Cumulative bed days occupied by delayed discharge patients by age, reason and location. TBC TBC Delayed Discharges in Scotland Quarterly Publication Link to ISD website for further information: Quarterly TBC Drug & Alcohol Treatment Waiting Times ISD Details on the number of individual waits and the time waited from point of referral received to first treatment (namely: structured preparatory & motivational intervention, prescribed drug treatment, community based support/ rehabilitation and residential rehabilitation). Waiting data for drug and alcohol treatment in prison has been included in publications since September 2013. Quarterly ISD publication. Report contains information on the number of people seen for treatment; the length of time waited as well as of treatment accessed. Link to ISD website for further information: Quarterly TBC Drug Prevalence Study ISD Multiple systems covering • clients registered with specialist drug treatment services • drug-related hospital admissions • police reports to the TBC TBC Provides estimates of the national and local prevalence of problem drug use in Scotland Link to ISD website for further information: TBC TBC
NHS Boards and other organisations concerned with children’s health of oral disease prevalence at national and local levels. directed towards health improvements. Link to ISD website for further information: Sexual Health Key Clinical Indicator data ISD Sexual Health Key Clinical Indicators are collected by Health Boards: termination of pregnancy, and long acting reversible contraception (LARC). TBC TBC Key Clinical Indicator report on • Termination of pregnancy • Long Acting Reversible Contraception (LARC). Link to ISD website for further information: TBC TBC PIS ISD Prescribing Information System (PIS) Details of prescription dispensed in the community, prescription details, dispenser details, remuneration of drug items and patient CHI number. Link to ISD website for further information: TBC TBC 1.NHS Scotland Prescribing Statistics: Dispenser Remuneration Drugs used in rheumatic diseases and gout Medicines used in Mental Health Prescribing of smoking cessation products Prescription Cost Analysis Minor Ailment Service 2. Scottish Antimicrobial Prescribing Group Report on Antimicrobial Resistance and Use in Humans 3. Antibacterial Primary Care TBC TBC
13. ADP Reports 14. ScotPHO Alcohol Update 15. ScotPHO Drug and Alcohol Profiles 16. ScotPHO National Profiles 17. ScotPHO people profiles 18. Scottish Suicide Information Database Report 19. Health Inequalities/Informing Investment to reduce Health Inequalities 20. Cardiac Rehabilitation Audit 21. Disease Indicators 22. Place of Death from Cancer 23. Scottish Perinatal and Infant Mortality and Morbidity Report SMR04 ISD Scottish Morbidity Record 04 - Mental Health Inpatient and Day Case Collects patient based data on, day cases and inpatient admissions / discharges from Psychiatric Hospitals and Units. Includes demographics, location and diagnosis. TBC TBC Collects mental health patient based data on inpatient and day case episodes – various outputs 1. Mental health Hospital Inpatient care 2. Drug and Alcohol related hospital statistics 3. Adult Mental Health Benchmarking Toolkit 5. Child and Adolescent Mental Health Services (CAMHS) Benchmarking Balanced Scorecard 6. ScotPHO Alcohol Update 7. ScotPHO National Profiles TBC TBC
Chief Medical Officer for Scotland, under the Abortion Act 1967), for women age less than 20 at time of conception. CHSP-PS Child Health Systems Registration Board Child Health Systems Programme - Pre-School CHSP-PS is a call/recall system, which facilitates the process of Child Health Surveillance and records the results of surveillance examinations from shortly after birth until school entry. TBC TBC 1. Breastfeeding Statistics 2. Births in Scottish Hospitals Link to ISD webpage for further information: TBC TBC CHSP-S Child Health Systems Registration Board Child Health Systems Programme - School CHSP-S facilitates call/recall of primary and secondary school pupils for examination, immunisation, referral and follow up. TBC TBC 1. Primary 1 Body Mass Index (BMI) statistics 2. HPV Immunisation Uptake Statistics 3. Child Healthy Weight Interventions Statistics Link to ISD webpage for further information: TBC TBC Bowel Screening System (BoSS) NSD – National Services Division Bowel Screening System. Collects screening invitation and lab results of returned screening kits. TBC TBC Bowel Screening Programme Statistics. Link to ISD webpage for further information: TBC TBC GP17 (MIDAS) Practitioner Services Division Payment and information system for NHS General Dental Service. TBC TBC NHS Dental Statistics Fees and Treatments Registration and participation TBC TBC
future Health Visiting dataset recently undertaken. 4: ISD Portals Name of Portal Key Functions Link to Website NHS Performs NHS Performs aims to improve the understanding of, and accessibility to, timely information on the performance of Scottish hospitals and NHS Boards. It brings together information on how hospitals and NHS Boards within NHSScotland are performing. Through NHS Performs,