SMR Completeness

In order to make sensible use of the national SMR databases for areas such as clinical governance, performance management and outcome measurement it is necessary to take a view on the completeness of each database at regular intervals. Strictly speaking, only individual NHS providers will know exactly how complete their SMR submissions are, and the extent of any backlog. However, it is possible to provide an indicator of completeness by making use of recent historical SMR submissions and outstanding submission reports from NHS Providers. SMR data is expected to be received by ISD up to 6 weeks following the end of the month of discharge/clinic.

This page provides a means of downloading two Excel workbooks :

• SMR vs SMR Comparison Charts (SMRSMR0708.zip )(2.24MB) showing the number of SMRs on each national database over the most recent 24 months (by way of a month-by-month comparison between the latest 12 month period, and the previous 12 months).
  
  The workbook is structured in pairs of spreadsheets, each dedicated to a particular SMR scheme (00s, 01s, etc.). One sheet (of the pair) has three drop-down menus, allowing the user to select any combination of NHSScotland Provider, Hospital/Clinic Location, and Specialty. The other sheet displays a completeness 'chart' for the selected criteria, depicting the number of records held on the national database for each month.
  
  
• SMR Completeness Estimates (SMREstimates.xls) (116KB) showing the percentage of SMR completeness for all NHS Boards by location, for the last four quarters expected to be complete and for each calendar/financial year.  The tables and supporting charts are calculated by comparing SMR backlogs and submissions to expected annual totals.  These estimates are supported by information provided by NHS Boards.

Should you require any further information please contact:

Nicola Flood- Data Monitoring Team
email Nicola.Flood@isd.csa.scot.nhs.uk
tel 0131 275 6078