open menu
hugs

The Administrative Data Research Network is an ESRC-funded project that ran from October 2013 - July 2018. It is currently at the end of its funding cycle and is no longer taking applications. Administrative data research will be taken forward in a new project, to be launched later in 2018.

SMR01 – General/Acute Inpatient and Day Case, 1981-

Title Details

SN:
888033
Title:
SMR01 – General/Acute Inpatient and Day Case, 1981-
Principal investigator(s):
Information Services Division - NHS National Services Scotland
Data collector(s):
Information Services Division - NHS National Services Scotland

Subject Categories

  • Health services and medical care - Health

Abstract

  • Abstract copyright ADRN.

    The General / Acute and Inpatient Day Case dataset (SMR01) collects episode level data on hospital inpatient and day case charges from acute specialities from hospitals in Scotland.

    The dataset contains patient identifiers such as name, date of birth, Community Health Index number, NHS number, postcode and ethnicity and episode management data. Of particular interest to researchers would be variables such as where the episode took place, admission type (includes patient injury classifications such as self-inflicted or home accident), waiting times, patients condition (as classified under ICD-10), operations, and discharge location. A wide variety of geographical data is also included in the dataset including Scottish Index of Multiple Deprivation and Carstairs measures, census output area, NHS Board, Electoral Ward and Parliamentary constituency.

    The dataset is part of a wide range of health related administrative data collected by the Information Services Division (ISD), on behalf of the NHS National Services Scotland (part of NHS Scotland). ISD has been the authoritative source of Scottish national healthcare statistics for over 50 years. The data is used to enhance decisions about Scottish health care to improve the health of the people of Scotland. ISD is part of the SHIP (ScottisH Informatics Programme), a Scotland wide research platform for the collation, management, dissemination and analysis of Electronic Patient Records. As part of SHIP, ISD delivers Electronic Data Research and Innovation Service (eDRIS), a one stop shop for health research designed to provide a single point of contact and to assist researchers in study design, approvals and data (non-patient or patient identifiable) access in a secure environment (the NSS National Safe Haven).

    Data about General / Acute Inpatient and Day Case patients has been collected on Scottish residents since 1960. The number of patients receiving treatment each year averages around 1.4 million patients a year. Records are routinely available for research purposes from 1981, while electronic records start from 1968. In 1997 revisions were made to the dataset in order to better fit NHS Scotland reporting requirements. Separate data catalogues pre and post 1997 which reflect these changes are available in the Documentation section.

    Data is supplied by Hospital Boards to ISD on a continual basis throughout the year, which have targets to submit their data within six weeks. The dataset is generally fully complete three month preceding the current date. So for example at the end of August, data is available until the end of May.

    The General / Acute Inpatient and Day Case data covers all residents in Scotland that receive care in hospital and general acute specialities. The NHS Information Centre collects similar information for England and Wales. In Northern Ireland, the Hospital Information Branch of the Department of Health, Social Services and Public Safety do likewise.

    The General / Acute Inpatient and Day Case dataset is permanently linked with ISD’s Mental Health Inpatient dataset (SMR04), Scottish Cancer Registry (SMR06) and the National Records of Scotland Death Records from 1980 onwards. This linked dataset is more commonly known as the Scottish Morbidity Database (SMD) and is the most useful for research purposes due to the wealth of information that it holds. Researchers can apply to access this linked dataset, the individual datasets or the individual datasets linked to a new dataset via the Privacy Advisory Committee.

    The following geographical measures are available:

    • NHS Board of Residence
    • Council Area
    • Local Government District
    • UK Parliamentary Constituency
    • Scottish Parliamentary Constituency
    • Electoral Ward
    • NUTS
    • Community Health Partnership
    • Data Zone
    • 2001 Census Output Area
    • 1991 Census Output Area
    • Postcode
    • Grid References
    • Urban / Rural Codes
    • Scottish Index of Multiple Deprivation measures
    • Carstairs Deprivation 2001
    • Carstairs Deprivation 1991

    On April 1st 2006 the configuration of NHS Boards was changed with NHS Argyll & Clyde being dissolved. The larger part of its area moved into NHS Greater Glasgow with the remainder moving to NHS Highland.

    Geriatric Long Stay records (SMR50) were included in the General / Acute Inpatient and Day Case dataset from 1st October 2007.

    In April 1996 diagnostic codes changed from ICD9 to ICD10. Further information on ICD10 is available in the Documentation section.

    The ISD Data Quality Assurance team is responsible for and ensuring SMR datasets are accurate, consistent and comparable across time and between sources. A new patient management system was introduced in 2009. This affected the amount of SMR returns made. Since 1989, information from the SMR01’s has been used to plan the financial management of hospitals so this should ensure that completeness of ascertainment is high.

    There are no known, major systematic data quality issues, but it is always wise for researchers unfamiliar with the data to check with their data suppliers and to raise any questions about data quality. Note that, in general, more recent data from ISD is likely to be of higher quality than that of, say, the 1960s.

    Research Usage and Linkage

    The General / Acute Inpatient and Day Case dataset is used for a wide variety of purposes by NHS Scotland and the Scottish Government to improve health care services. It is also used for a wide variety of health and epidemiological research purposes. This dataset is also part of the Scottish Morbidity Database.

    The General / Acute Inpatient and Day Case dataset records a patient’s CHI number so it is possible to link data to other indexed datasets deterministically. The CHI number is attached by ISD to historical records retrospectively.

    The General / Acute Inpatient and Day Case dataset is also part of ISD Scotland’s linked database known as the Scottish Morbidity Database (SMD). The database links together the Scottish Cancer Registry (SMR06), mental health dataset (SMR04), and National Records of Scotland Death Records with the General / Acute Inpatient and Day Case dataset (SMR01). The Scottish Health Survey provides a detailed picture of health of the Scottish population and researchers can also apply to use a linked Scottish Health Survey and Scottish Morbidity Database dataset.

    The SMR01 is not routinely linked by ISD but ad-hoc linkages have been made to the Outpatient (SMR00) dataset.

    The Scottish Longitudinal Study (SLS) provides a detailed picture of the health and social status of the people of Scotland. The SLS can be linked to the General / Acute Inpatient and Day Case dataset and other NHS Scotland health administrative datasets (further information is available in the Documentation section).

    The ISD Scotland Medical Record Linkage team could potentially link the General / Acute Inpatient and Day Case dataset with other external data sources, and Privacy Advisory Committee (PAC) approval will still be required if using patient identifiable data.


Coverage, universe, methodology

Time period:
1981 -
Country:
Scotland
Observation units:
Events and processes
Kind of data:
Individual (micro) level
Universe:
National
All residents in Scotland that receive care in hospital and general acute specialities from 1968 (electronic records).

Time dimensions:
Repeated cross-sectional study
Sampling procedures:
No sampling (total universe)
Number of units:
Approximately 1.4 million records per year
Method of data collection:

Compilation or synthesis of existing material

Data is supplied by Hospital Boards to ISD on a continual basis throughout the year.


Frequency of release:
Annual
Data Updated:
Continuously

Administrative and access information

Copyright:
Crown copyright
Access conditions:
ADRN
Availability:
Contact the Network

Documentation


Publications

By principal investigator(s):

  • Information Services Division Scotland (2007) Using the Linked Scottish Health Survey to Predict Hospitalisation & Death., National Health Service.
  • Information Services Division Scotland (2009) Alcohol attributable mortality and morbidity:, National Health Service.
  • Scottish Health Informatics Programme (2012) A Blueprint for Health Records Research in Scotland, Scottish Health Informatics Programme.

Resulting from secondary analysis:

  • Stockton, D., Doherty, V.R., Brewster, D.H. (2001) 'Risk of cancer in patients with dermatomyositis or polymyositis, and follow-up implications:', British Journal of Cancer, 85(1), pp. 41-45. 10.1054/bjoc.2001.1699
  • Stewart, S., McIntyre, K., Capewell, S., McMurray, J.J.V. (2002) 'Heart failure in a cold climate:', Journal of the American College of Cardiology, 39(5), pp. 760-766. 10.1016/S0735-1097
  • Kyaw, M.H., Christie, P., Clarke, S.C., Mooney, J.D., Ahmed, S., Jones, I.G., Campbell, H. (2003) 'Invasive Pneumococcal Disease in Scotland, 1999-2001:', Pneumococcal Record Linkage, 37, pp. 1283-1291. 10.1086/379016
  • Murphy, N.F., Stewart, S., MacIntyre, K., Capewell, S., McMurray, J.J.V. (2004) 'Seasonal variation in morbidity and mortality related to atrial fibrillation', International Journal of Cardiology, 97(2), pp. 283-288. http://dx.doi.org/10.1016/j.ijcard.2004.03.041
  • Brewster, D.H., Stockton, D.L., Dobbie, R., Bull, D., Beral, V. (2005) 'Risk of breast cancer after miscarriage or induced abortion:', Journal of Epidemiology and Community Health, 59, pp. 283-287.
  • Parker, M.C., Wilson, M.S., Menzies, D., Sunderland, G., Clark, D.N., Knight, A.D., Crowe, A.M. (2005) 'The SCAR-3 study:', Colorectal Disease, 7(6), pp. 551-558. 10.1111/j.1463-1318.2005.00857.x
  • Parker, M.C., Wilson, M.S., Menzies, D., Sunderland, G., Thompson, J.N., Clark, D.N., Knight, A.D., Crowe, A.M. (2005) 'Colorectal surgery:', Colorectal Disease, 6(6), pp. 506-511.
  • Scottish Executive Social Research (2005) National Investigation into Drug Related Deaths in Scotland, 2003, Substance Misuse Research Programme.
  • Bhopal, R., Fischbacher, C.M., Steiner, M., Chalmers, J., Povey, C., Jamieson, J., Knowles, D. (2006) Ethnicity and health in Scotland:, Edinburgh, UK: University of Edinburgh.
  • Grant, H.W., Parker, M.C., Wilson, M.S., Menzies, D., Sunderland, G., Thompson, J.N., Clark, D.N., Knight, A.D., Crow, A.M., Ellis, H. (2006) 'Population-based analysis of the risk of adhesion-related readmissions after abdominal surgery in children', Journal of Pediatric Surgery, 41(8), pp. 1453-1456. 10.1016/j.jpedsurg.2006.04.023
  • MacDonald, A., Straughn, J., Sutton, M. (2006) Healthy Life Expectancy Measurement in Scotland.
  • Camidge, D.R., Stockton, D.L., Frame, S., Wood, R., Bain, M., Bateman, D.N. (2007) 'Hospital admissions and deaths relating to deliberate self-harm and accidents within 5 years of a cancer diagnosis:', British Journal of Cancer, 96, pp. 752 - 757. 10.1038/sj.bjc.6603617
  • Fischbacher, C.M., Bhopal, R., Povey, C., Steiner, M., Chalmers, J., Mueller, G., Jamieson, J., Knowles, D. (2007) 'Record linked retrospective cohort study of 4.6 million people exploring ethnic variations in disease:', BMC Public Health, 7(142). 10.1186/1471-2458-7-142
  • Ford, I., Murray, H., Packard, C.J., Shepherd, J., Macfarlane, P.W., Cobbe, S.M. (2007) 'Long-Term Follow-up of the West of Scotland Coronary Prevention Study', New England Journal of Medicine, 357(15), pp. 1477-1486. 10.1056/NEJMoa065994
  • Hanlon, P., Lawder, R., Elders, A., Clark, D., Walsh, D., Whyte, B., Sutton, M. (2007) 'An analysis of the link between behavioural, biological and social risk factors and subsequent hospital admission in Scotland', Journal of Public Health, 29(4), pp. 405-412. doi:10.1093/pubmed/fdm062
  • Grant, H.W., Parker, M.C., Wilson, M.S., Menzies, D., Sunderland, G., Thompson, J.N., Clark, D.N., Knight, A.D., Crowe, A., Ellis, H. (2008) 'Adhesions after abdominal surgery in children', Journal of Pediatric Surgery, 43(1), pp. 152-157. 10.1016/j.jpedsurg.2007.09.038
  • Anandan, C., Gupta, R., Simpson, C.R., Fischbacher, C., Sheikh, A. (2009) 'Epidemiology and disease burden from allergic disease in Scotland:', Journal of The Royal Society of Medicine, 102, pp. 431-442. 10.1258/jrsm.2009.090027
  • Cardy, A.H., Torrance, N., Clark, D., Miedzybrodzka, Z., Sharp, L. (2009) 'Amniocentesis in the second trimester and congenital talipes equinovarus in the offspring:', Prenatal Diagnosis, 29, pp. 613-619. 10.1002/pd.2233
  • Hay, G., Gannon, M., Casey, J., McKeganey, N. (2009) Estimating the National and Local Prevalence of Problem Drug Misuse in Scotland, Glasgow, UK: University of Glasgow.
  • Jeffrey, S., Stone, D.H., Blamey, A., Clark, D., Cooper, C., Dickson, K., Mackenzie, M., Major, K. (2009) 'An evaluation of police reporting of road casualties', Injury Prevention, 15(1), pp. 13-18. 10.1136/ip.2008.018630
  • McDonald, S., Hutchinson, S.J., Bird, S.M., Graham, L., Robertson, C., Mills, P.R., Hayes, P., Dillon, J.F., Goldberg, D.J. (2009) 'Association of self-reported alcohol use and hospitalization for an alcohol-related cause in Scotland:', Addiction, 104(4), pp. 593-602. 10.1111/j.1360-0443.2009.02497.x
  • McLernon, D.J., Donnan, P.T., Ryder, S., Roderick, P., Sullivan, F.M., Rosenberg, W., Dillon, J.F. (2009) 'Health outcomes following liver function testing in primary care:', Family Practice, 26, pp. 251-259. http://dx.doi.org/10.1093/fampra/cmp025
  • Lewsey, J.D., Gillies, M., Jhund, P.S., Chalmers, J.W.T., Redpath, A., Briggs, A., Walters, M., Langhorne, P., Capewell, S., McMurray, J.J.V., MacIntyre, K. (2009) 'Sex Differences in Incidence, Mortality, and Survival in Individuals With Stroke in Scotland, 1986 to 2005', Stroke, 40(4), pp. 1038-1043. 10.1161/STROKEAHA.108.542787
  • McCafferty, S., Doherty, T., Sinnott, R.O., Watt, J. (2010) 'e-Infrastructures supporting research into depression, self-harm and suicide', Philosophical Transactions of The Royal Society A Mathematical Physical and Engineering Sciences, 368(1925), pp. 3845-3858. 10.1098/rsta.2010.0142
  • Gray, L., Batty, G.D., Craig, P., Stewart, C., Whyte, B., Finlayson, A., Leyland, A.H. (2010) 'Cohort Profile: The Scottish Health Surveys Cohort:', International Journal of Epidemiology, 39(2), pp. 345-350. 10.1093/ije/dyp155
  • Love, E.R., Bhattacharya, S., Smith, N.C., Bhattacharya, S. (2010) 'Effect of interpregnancy interval on outcomes of pregnancy after miscarriage:', British Medical Journal, 341. http://dx.doi.org/10.1136/bmj.c3967
  • Nicholls, R.J., Clark, D.N., Kelso, L., Crowe, A.M., Knight, A.D., Hodgkins, P., Satsangi, J. (2010) 'Nationwide linkage analysis in Scotland implicates age as the critical overall determinant of mortality in ulcerative colitis', Alimentary Pharmacology & Therapeutics, 31(12), pp. 1310-1321. 10.1111/j.1365-2036.2010.04302.x
  • de Oliveira, C., Watt, R., Hamer, M. (2010) 'Toothbrushing, inflammation, and risk of cardiovascular disease:', British Medical Journal, 340. http://dx.doi.org/10.1136/bmj.c2451
  • Smith, G.C.S., Wood, A.M., White, I.R., Pell, J.P., Hattie, J. (2010) 'Birth Weight and the Risk of Cardiovascular Disease in the Maternal Grandparents', American Journal of Epidemiology, 171(6), pp. 736-744. 10.1093/aje/kwp448
  • Anwar, H., Fischbacher, C.M., Leese, G.P., Lindsay, R.S., MCKnight, J.A., Wild, S.H. (2011) 'Assessment of the under-reporting of diabetes in hospital admission data:', Diabetic Medicine, 28(12), pp. 1514-1519. 10.1111/j.1464-5491.2011.03432.x
  • Bhopal, R., Fischbacher, C.M., Povey, C., Chalmers, J., Mueller, G., Steiner, M., Brown, H., Brewster, D.H., Bansal, N. (2011) 'Cohort Profile:', International Journal of Epidemiology, 40, pp. 1168-1175. 10.1093/ije/dyq118
  • Dibben, C., Atherton, I., Doherty, J., Baldacchino, A. (2011) 'Differences in 5-year survival after a 'homeless' or 'housed' drugs-related hospital admission:', Journal of Epidemiology & Community Health, 65(9), pp. 780-785. 10.1093/ije/dyq118
  • Kennedy, N.A., Clark, D.N., Bauer, J., Crowe, A.M., Knight, A.D., Nicholls, R.J., Satsangi, J. (2011) 'Nationwide linkage analysis in Scotland to assess mortality following hospital admission for Crohn's disease:', Alimentary Pharmacology and Therapeutics, 35(1), pp. 142-153. 10.1111/j.1365-2036.2011.04906.x
  • Lawder, R., Grant, I., Storey, C., Walsh, D., Whyte, B., Hanlon, P. (2011) 'Epidemiology of hospitalization due to alcohol-related harm:', Public Health, 125(8), pp. 533-539. http://dx.doi.org/10.1016/j.puhe.2011.05.007
  • Mc Donald, S.A., Hutchinson, S.J., Bird, S.M., Robertson, C., Mills, P.R., Dillon, J.F., Goldberg, D.J. (2011) 'Hospitalisation for an alcohol-related cause among injecting drug users in Scotland:', International Journal of Drug Policy, 22(1), pp. 63-69. 10.1016/j.drugpo.2010.04.003
  • Smith, G., Wood, A., Pell, J., Hattie, J. (2011) 'Recurrent miscarriage is associated with a family history of ischaemic heart disease:', An International Journal of Obstetrics & Gynaecology, 118(5), pp. 557-563. 10.1111/j.1471-0528.2010.02890.x
  • Williamson, A.E. (2011) Patients repeatedly removed from GP lists:, PhD thesis, University of Glasgow.
  • Lone, N.I., Simpson, C., Kavanagh, K., Robertson, C., McMenamin, J., Ritchie, L., Sheikh, A. (2012) 'Seasonal Influenza Vaccine Effectiveness in the community (SIVE):', British Medical Journal Open, 2. 10.1136/bmjopen-2012-001019
  • McFarlane, H.J., Girdwood, I., Bhaskar, A., Clark, D., Webster, N.R. (2012) 'The influence of surgery on the onset of symptomatic coronary artery disease', Anaesthesia, 67(2), pp. 110-114. 10.1111/j.1365-2044.2011.07019.x.
  • Geue, C., Lewsey, J., Lorgelly, P., Govan, L., Hart, C., Briggs, A. (2012) 'Spoilt for Choice:', Health Economics, 21(10), pp. 1201-1216. 10.1002/hec.1785
  • Teckle, P., Hannaford, P., Sutton, M. (2012) 'Is the health of people living in rural areas different from those in cities?', BMC Health Service Research, 12(43). 10.1186/1472-6963-12-43
  • Gillies, M., Jhund, P.S., MacTeague, K., MacIntyre, P., Allardyce, J., Batty, G.D., MacIntyre, K. (2012) 'Prior psychiatric hospitalization is associated with excess mortality in patients hospitalized with non-cardiac chest pain:', European Heart Journal, 33(6), pp. 760-767. 10.1093/eurheartj/ehr401
  • Rhouma, O., McMahon, A.D., Conway, D.I., Armstrong, M., Welbury, R., Goodall, C. (2013) 'Facial injuries in Scotland 2001-2009:', British Journal of Oral and Maxillofacial Surgery, 51(3), pp. 211-216. 10.1016/j.bjoms.2012.04.267)


Page last updated: 20/09/2017