Outpatient Appointments and Attendances - Scottish Morbidity Record (SMR00)

Preview of JSON file

{
  "required": {
    "gatewayId": "68",
    "gatewayPid": "2ef288fa-8a08-409a-9294-35ebd392f814",
    "issued": "2024-10-08T11:28:18.224Z",
    "modified": "2024-10-08T11:28:18.224Z",
    "version": "3.0.0",
    "revisions": [
      {
        "version": "2.0.0",
        "url": "https://healthdatagateway.org//dataset/68?version=2.0.0"
      },
      {
        "url": "https://healthdatagateway.org//dataset/68?version=3.0.0",
        "version": "3.0.0"
      }
    ]
  },
  "summary": {
    "abstract": "The Outpatients (SMR00) dataset collects episode level data from patients on new and follow up appointments at outpatient clinics in all specialities (except A&E and Genito-Urinary Medicine).",
    "contactPoint": "phs.edris@phs.scot",
    "keywords": "Outpatient",
    "datasetType": "Health and disease",
    "datasetSubType": "Not applicable",
    "populationSize": -1,
    "description": "An SMR00 is generated for outpatients receiving care in the specialties listed when:\n\n-they attend a medical consultant outpatient clinic;\n-they meet with a consultant or senior member of his/her team outwith an outpatient clinic session (including the patient's home).\n-they attend a clinic run by a nurse or an AHP identified as the Health Care Professional Responsible for Care for that clinic and who has legal and clinical responsibility for that patient.\n\nThe dataset is generally fully complete and ready for analysis three month preceding the current date.  So for example at the end of August, data is available until the end of May.",
    "shortTitle": "Outpatient Appointments and Attendances - Scottish Morbidity Record (SMR00)",
    "title": "Outpatient Appointments and Attendances - Scottish Morbidity Record (SMR00)",
    "publisher": {
      "name": "Public Health Scotland",
      "gatewayId": "c40be7ce-f0ca-4fd8-b63c-0632593d2507"
    },
    "inPipeline": "Not available"
  },
  "coverage": {
    "pathway": "All of secondary care in relation to appointments and attendances",
    "spatial": "United Kingdom,Scotland",
    "followUp": "Other",
    "typicalAgeRange": "0-150",
    "datasetCompleteness": "https://publichealthscotland.scot/services/data-management/data-management-in-secondary-care-hospital-activity/scottish-morbidity-records-smr/completeness/"
  },
  "provenance": {
    "origin": {
      "purpose": "Care",
      "source": "EPR",
      "collectionSituation": "Secondary care - Outpatients",
      "imageContrast": "Not stated"
    },
    "temporal": {
      "startDate": "1997-03-31T23:00:00Z",
      "timeLag": "1-2 months",
      "accrualPeriodicity": "Monthly",
      "distributionReleaseDate": "2024-10-28T00:00:00Z"
    }
  },
  "accessibility": {
    "access": {
      "deliveryLeadTime": "Not applicable",
      "jurisdiction": "GB",
      "dataController": "Public Health Scotland",
      "dataProcessor": "National Services Scotland",
      "accessRights": "https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/services-we-offer/",
      "accessService": "Scottish National Safe Haven / Trusted Research Environment: https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/national-safe-haven-nsh/",
      "accessRequestCost": "https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/cost-of-services/",
      "accessServiceCategory": "TRE/SDE"
    },
    "usage": {
      "dataUseLimitation": "General research use",
      "dataUseRequirement": "Institution-specific restrictions;,;Not for profit use"
    },
    "formatAndStandards": {
      "vocabularyEncodingSchemes": "NHS SCOTLAND NATIONAL CODES",
      "conformsTo": "NHS SCOTLAND DATA DICTIONARY",
      "languages": "en",
      "formats": "text;,;csv"
    }
  },
  "linkage": {
    "associatedMedia": "https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/overview/what-is-edris/ , https://www.researchdata.scot/media/ulqc4y1y/outpatient-appointments-and-attendances-scottish-morbidity-record-smr00-variables.pdf"
  },
  "structuralMetadata": [
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "DOB",
          "dataType": "Date (ddmmyy)",
          "sensitive": false,
          "description": "Date of birth"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "AGE_IN_YEARS",
          "dataType": "INTEGER",
          "sensitive": false,
          "description": "Age"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "AGE_IN_MONTHS",
          "dataType": "INTEGER",
          "sensitive": false,
          "description": "Age in months"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "SEX",
          "dataType": "Characters",
          "sensitive": false,
          "description": "1 = male, 2 = female"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "ETHNIC_GROUP",
          "dataType": "Characters",
          "sensitive": true,
          "description": "ETHNIC GROUP"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "CLINIC_DATE",
          "dataType": "Date (ddmmyy)",
          "sensitive": false,
          "description": "Clinic Date"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "SPECIALTY",
          "dataType": "Characters",
          "sensitive": false,
          "description": "A1 General Medicine\nA11 Acute Medicine\nA2 Cardiology\nA3 Clinical Genetics\nA4 Tropical Medicine\nA6 Infectious Diseases\nA7 Dermatology\nA8 Endocrinology\nA81 Endocrine\nA82 Diabetes\nA9 Gastroenterology\nAB Geriatric Medicine\nAC Homoeopathy\nAD Medical Oncology\nAF Paediatrics\nAG Renal Medicine \nAH Neurology\nAJ Integrative Care\nAK Occupational Medicine\nAM Palliative Medicine\nAP Rehabilitation Medicine\nAQ Respiratory Medicine\nAR Rheumatology\nAV Clinical Neurophysiology\nAW Allergy\nC1 General Surgery\nC11 General Surgery (excl. Vascular)\nC12 Vascular Surgery\nC13 Oral and Maxillofacial Surgery\nA21 Paediatric Cardiology\nAA Genito-Urinary Medicine\nAFA Community Child Health\nAT Medical Ophthalmology\nC2 Accident & Emergency\nC3 Anaesthetics\nC31 Pain Management \nC4 Cardiothoracic Surgery\nC41 Cardiac Surgery\nC42 Thoracic Surgery\nC5 Ear, Nose & Throat\nC51 Audiological Medicine\nC6 Neurosurgery\nC7 Ophthalmology\nC8 Trauma & Orthopaedic Surgery\nC9 Plastic Surgery\nC91 Cleft Lip and Palate Surgery\nCA Paediatric Surgery\nCB Urology\nCC Intensive Care Medicine\nD1 Community Dental Practice\nD3 Oral Surgery\nD4 Oral Medicine\nD5 Orthodontics\nD6 Restorative Dentistry\nD8 Paediatric Dentistry\nD61 Restorative Dentistry - Endodontics\nD62 Restorative Dentistry - Periodontics\nD63 Restorative Dentistry - Prosthodontics\nDC Surgical Dentistry\nDD Fixed & Removable Prosthodontics\nDE Special Care Dentistry\nE11 GP Obstetrics\nE12 GP Other than Obstetrics\nF2 Gynaecology\nF3 Obstetrics\nF31 Obstetrics Antenatal\nF32 Obstetrics Postnatal\nF4 Community Sexual & Reproductive Health\nG1 General Psychiatry\nG1A Community Psychiatry\nG2 Child & Adolescent Psychiatry\nG21 Child Psychiatry\nG22 Adolescent Psychiatry\nG3 Forensic Psychiatry\nG4 Psychiatry of Old Age\nG5 Learning Disability (Mental Handicap)\nG6 Psychotherapy\nG61 Behavioural Psychotherapy\nG62 Child & Adolescent Psychotherapy\nG63 Adult Psychotherapy\nH1 Clinical Radiology \nH2 Clinical Oncology\nJ3 Chemical Pathology \nJ4 Haematology\nJ5 Immunology\nR1 Chiropody/Podiatry\nR2 Clinical psychology\nR3 Dietetics\nR4 Occupational Therapy\nR5 Physiotherapy\nR6 Speech and Language Therapy\nR11 Surgical Podiatry\nRF Prosthetics/orthotics\nRF1 Prosthetics\nRF2 Orthotics\nRJ Orthoptics\nRU Arts Therapies\nRU1 Art Therapy\nRU2 Drama Therapy\nRU3 Music Therapy\nRU4 Dance Therapy\nRU5 Mistletoe Therapy\nRU6 Acupuncture\nRU7 Bowen Therapy\nRU8 Counselling\nT2 Midwifery\nT21 Community Midwifery\nT3 Mental health nursing\nT31 Community psychiatric nursing\nT4 Learning disability nursing\nT41 Community learning disability nursing"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "SIGNIFICANT_FACILITY",
          "dataType": "Characters",
          "sensitive": false,
          "description": "11 Other (including all Standard Specialty Wards 1K, Day Bed Unit 1J) \n31 Outpatient Department\n32 Accident & Emergency Department\n33 Day Hospital\n34 Health Centre\n35 GP Surgery Premises\n36 Patient’s Home\n37 Other Community Premises\n38 Rapid Access Chest Pain Clinic\n39 Ambulatory Emergency Care Unit"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "PATIENT_CATEGORY",
          "dataType": "Characters",
          "sensitive": true,
          "description": "1 Amenity \n2 Paying \n3 NHS \n4 Overseas visitor - liable to pay for treatment \n5 Overseas visitor – not liable to pay (reciprocal arrangements) \n8 Other (including hospice)"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "REFERRAL_SOURCE",
          "dataType": "Characters",
          "sensitive": false,
          "description": "1 GP\n2 Consultant at this Heath Board/ Health Care Provider\n4 Consultant from a Heath Board/ Health Care Provider outwith this\n Health Board area\n5 Self referral\n6 Prison/Penal Establishments (including Police Station)\n7 Judicial\n8 Local Authority/Voluntary Agency\n9 Other (includes Armed Forces)\nA Accident and Emergency Department\nB Optometrist/Optician\nC Allied Health Professional (AHP)\nD Dental Practitioner\nE Community Health Service\n (excluding Optometrist/Optician and Allied Health Professional (AHP))\nN NHS24\nR Patient Initiated Return"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "REFERRAL_TYPE",
          "dataType": "Characters",
          "sensitive": false,
          "description": "1 New Outpatient: Consultation and Management\n2 New Outpatient: Consultation only\n3 Follow-up/Return Outpatien"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "REFERRAL_REASON_1",
          "dataType": "Characters",
          "sensitive": false
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "REFERRAL_REASON_2",
          "dataType": "Characters",
          "sensitive": false
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "REFERRAL_REASON_3",
          "dataType": "Characters",
          "sensitive": false
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "REFERRAL_REASON_4",
          "dataType": "Characters",
          "sensitive": false
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "CLINIC_ATTENDANCE",
          "dataType": "Characters",
          "sensitive": false,
          "description": "1 Patient was seen \n5 Patient attended but was not seen (CNW: Could Not Wait)\n8 Patient did not attend and gave no prior warning (DNA)"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "ATTENDANCE_FOLLOW_UP",
          "dataType": "Characters",
          "sensitive": false,
          "description": "1 Admission as an Inpatient\n2 Further Outpatient Appointment with same Consultant in same \nSpecialty\n3 Discharge\n4 Onto Waiting List for admission\n5 Referral to another Consultant/HCP\n8 Not applicable"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "MAIN_CONDITION",
          "dataType": "Characters",
          "sensitive": false,
          "description": "Main condition - ICD10 code"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "OTHER_CONDITION_1",
          "dataType": "Characters",
          "sensitive": false,
          "description": "Other condition 1 - ICD10 code"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "OTHER_CONDITION_2",
          "dataType": "Characters",
          "sensitive": false,
          "description": "Other condition 2 - ICD10 code"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "OTHER_CONDITION_3",
          "dataType": "Characters",
          "sensitive": false,
          "description": "Other condition 3 - ICD10 code"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "OTHER_CONDITION_4",
          "dataType": "Characters",
          "sensitive": false,
          "description": "Other condition 4 - ICD10 code"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "OTHER_CONDITION_5",
          "dataType": "Characters",
          "sensitive": false,
          "description": "Other condition 5 - ICD10 code"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "MAIN_OPERATION",
          "dataType": "Characters",
          "sensitive": false,
          "description": "Main Operation - OPCS4 code"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "OTHER_OPERATION_1",
          "dataType": "Characters",
          "sensitive": false,
          "description": "Other Operation - OPCS4 code"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "OTHER_OPERATION_2",
          "dataType": "Characters",
          "sensitive": false,
          "description": "Other Operation - OPCS4 code"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "OTHER_OPERATION_3",
          "dataType": "Characters",
          "sensitive": false,
          "description": "Other Operation  - OPCS4 code"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "DATE_OF_MAIN_OPERATION",
          "dataType": "Date (ddmmyy)",
          "sensitive": false,
          "description": "Date of main operation"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "DATE_OF_OTHER_OPERATION_1",
          "dataType": "Date (ddmmyy)",
          "sensitive": false,
          "description": "Date of other operation 1"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "DATE_OF_OTHER_OPERATION_2",
          "dataType": "Date (ddmmyy)",
          "sensitive": false,
          "description": "Date of other operation 2"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "DATE_OF_OTHER_OPERATION_3",
          "dataType": "Date (ddmmyy)",
          "sensitive": false,
          "description": "Date of other operation 3"
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "HBRES_CURRENTDATE",
          "dataType": "Characters",
          "sensitive": false,
          "description": "Patient's NHS Scotland Health Board of Residence according to HB configuration as at current date."
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "HBTREAT_CURRENTDATE",
          "dataType": "Characters",
          "sensitive": false,
          "description": "NHS Scotland Health Board where treatment took place according to configuration as at current date."
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "LOCATION",
          "dataType": "Characters",
          "sensitive": false,
          "description": "This is the reference number of any building or set of buildings where the event took place."
        }
      ]
    },
    {
      "name": "SMR00",
      "columns": [
        {
          "name": "MODE_OF_CLINICAL_INTERACTION",
          "dataType": "Characters",
          "sensitive": false,
          "description": "Mode of Clinical Interaction identifies the setting where contact between a Health Care Professional and a patient/carer takes place"
        }
      ]
    }
  ],
  "tissuesSampleCollection": [
    {
      "materialType": "None/not available"
    }
  ]
}