This website places cookies on your device to help us improve our service to you. To find out more about the cookies, see our Privacy and Cookies notice
ISD Scotland better information, better decisions, better health

Scottish Drug Misuse Database

Drug Misuse

NHS National Services Scotland ISD Scotland & NHS National Services Scotland

Scottish Drug Misuse Database

About the database

The Scottish Drug Misuse Database (SDMD) is an important and widely used national information source on the misuse of drugs in Scotland. The SDMD is based on systematic recording of a national dataset on clients seen at a broad range of services across Scotland. The database holds information on demographic and behavioural characteristics of new clients coming to the attention of medical services (general practice, hospital etc.) and specialist drug services (statutory and non-statutory). The dataset covers:

  • demographic information
  • presenting information
  • prescription profile
  • illicit drug profile
  • injecting/ sharing details
  • social profile
  • dependent children
  • contact with services

The aims of the database are to:

  • monitor presenting problem use
  • collect information about clients presenting to services for assessment of their care/ treatment needs pertaining to drug misuse
  • help identify, or confirm, trends
  • inform discussion about service provision
  • provide data for the Alcohol and Drug Partnerships (ADPs) for taking forward the drug misuse strategy
  • provide information in support of monitoring targets set by the Scottish Government

Electonic data submission

Two methods of electronic data submission are possible in the new system, both of which use a secure internet connection. The first is an online form. Service providers log onto the application and submit data directly to ISD via a web form. The second is a file upload facility within the application. This will allow a local system administrator to log onto the application and submit a batch file of data from their local system directly to ISD, at given points in time.

Background information

Web System Guidance Notes [Download Excel file 252KB]

SMR25b Guidance Notes [Download Excel file 56KB]

System FAQs [Download Excel file 102KB]

SMR25a Dataset [Download PDF file 85KB]

SMR25b Dataset [Download PDF file 89KB]

Protecting Personal Information Leaflet [Download PDF file 199KB]


General enquiries:

Graeme Reid
Database Manager
Graeme manages the Scottish Drug Misuse Database and database team, ensuring quality and timeliness of data, and leads the development, co-ordination and delivery of training.
Tel: 0141 282 2257

For queries relating to analysis, reporting or publications:
Scottish Drug Misuse Database
Data Management Services
ISD Scotland
Gyle Square
1 South Gyle Crescent
EH12 9EB


© ISD Scotland 2010
Information Services Division,
NHS National Services Scotland,
Gyle Square,
1 South Gyle Crescent,
Edinburgh EH12 9EB,
Tel: 0131 275 7050  
Contact Us

About Information Services Division | Contact Us | Accessibility | Complaints
Copyright | Terms and Conditions | Privacy | Freedom of Information

ISD is a division of NHS NSS
Working at the very heart of the health service, NSS delivers services critical to frontline patient care and in support of the efficient and effective operation of NHS Scotland. Visit the NSS Website for more information