The General / Acute and Inpatient Day Case dataset (SMR01) collects episode level data on hospital inpatient and day case discharges from acute specialities from hospitals in Scotland.
This is a subset of data for the Brain Health Data Pilot (BHDP).

ADR  > Brain Health - General Acute Inpatient and Day Case - Scottish Morbidity Record (SMR01) @ 63

https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/overview/what-is-edris/

The Brain Health Data Pilot (BHDP) project aims to be a shared database (like a library) of information for scientists studying brain health, especially for diseases like dementia, which affects about 900,000 people in the UK. Its main feature is a huge collection of brain images linked to routinely collected health records, both from NHS Scotland, which will help scientists learn more about dementia and other brain diseases. What is special about this database is that it will get better over time – as scientists use it and add their discoveries, it becomes more valuable. 

This is a subset of the General Acute Inpatient and Day Case - Scottish Morbidity Record  (SMR01) dataset for use in the Brain Health Data Pilot (BHDP) project. 

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.

Scottish Health Data

National Services Scotland ;,;Public Health Scotland

Format
Date (ddmmyy)

Field Length
6

Priority
Mandatory

Definition
Admission Date is the date on which an inpatient or day case admission occurs.

Recording Rules
The full date should be entered thus: 2 December 2004=
0	2	1	2	0	4
Points to Note
None.

Cross Checks

Date of Admission is checked to be in sequence with the other dates recorded.
The Patient’s Age is calculated between Date of Birth and Date of Admission, and is used in cross-checks with:
* Specialty
* Diagnosis
Duration of Stay (Stay) is calculated as the time between Date of Admission and Date of Discharge, and is used in cross-checks involving
* Management of Patient
* Significant Facility
* Diagnosis
SMR01 and SMR50 - Waiting Time (Wait) is calculated as the time between Date Placed on Waiting List (when present) and Date of Admission, and is used in cross-checks involving all the Diagnoses recorded.
SMR01 and SMR11 - If Admission Date equals Date of Birth and the Significant Facility is not 11 (Other), 12 (Postnatal Cot), 15 (Neonatal Unit) or 16 (Childrens Unit), the record will always be queried.
SMR02,SMR04 and SMR50 - Admission Date must not equal Date of Birth.
Admission Date is checked against Waiting List Date and, if both dates are the same, the record is queried.
SMR Validation - Admission-Date


Related items:

Day Case Admission
Inpatient Admission
Tags:
inpatient  day  case  sequence  SMR01  SMR02  SMR04

Admission Date

Episode Management Data

Format
Characters

Field Length
6
Priority
Mandatory

Definition
This item should be seen as describing the main medical (or social) condition managed/investigated during the patients stay.

Recording Rules
The main condition is the condition, diagnosed at the end of the episode of health care, primarily responsible for the patients need for treatment or investigation. If there is more than one such condition, the one held most responsible for the greatest use of resources should be selected. If no diagnosis was made, the main symptom, abnormal finding, or problem should be selected as the main condition.

Points to Note

For patients who have died, the main condition is not necessarily the same as the condition recorded as the cause of death.
The main condition should be decided by a senior member of the medical staff and recorded in the agreed place in the case notes, on the appropriate form or computer system.
If the main condition is coded to a pair of dagger and asterisk codes, the dagger should be entered as main condition.
If the main condition is an injury or other condition due to an external cause, the injury or condition should be entered as main condition with the external cause code following the injury (or injuries).
In the case of the admission record for SMR04 the admission diagnosis would be as defined in the recording rules (but as diagnosed at the beginning of the episode of healthcare). Further guidance is given in the SMR04 section of the electronic data manual.
Cross Checks

A check is made that each Diagnosis Code is valid as defined by the ICD classification. If not, an error will be reported.
A check is made that the use of the code (although listed in the ICD Classification) is actually permitted on the record type. If a discrepancy is found, an appropriate error or query will be reported.
Main condition is cross-checked against:
Sex
Age (except SMR02)
Rarity (except SMR00, and SMR02)
Admission Type (SMR01)
Length of Stay (SMR01 and SMR04)
Waiting Time (SMR01 only)
Discharge Type (SMR01)
Condition on Discharge (SMR02 only)
SMR Validation - Main Condition

Tags:
medical  social  managed  investigated  patient  stay  diagnosed  treatment  ICD10  classification  code  SMR00  SMR01  SMR02  SMR04

Main Condition/Principal Diagnosis/Problem Managed - ICD10

General Clinical Information

Format
Characters

Field Length
6

Priority
Local

Definition
In addition to the main condition, the record should, whenever possible, also list separately other conditions or problems dealt with during the episode of health care. Other conditions are defined as those conditions that co-exist or develop during the episode of healthcare and affect the management of the patient. Conditions related to an earlier episode that have no bearing on the current episode should not be recorded.

For further information on co-morbidities and other conditions, please refer to the Scottish Clinical Coding Standards, (in particular Coding Guidelines 21 November 2007) as held on the Terminology Website

Points to Note

Up to five other significant conditions may be recorded for SMR01 returns.
Other conditions should be recorded according to the rules outlined in Coding Guidelines 21 November 2007.
From April 2020,this data item is no longer required for national collection on SMR00, though may still be collected locally.
Priority changed from Mandatory (where applicable) to Local.
Cross Checks

As for main condition.
A main condition must be recorded before the Other Condition fields can be completed.
SMR Validation - Other Conditions

Tags:
addition  main  episode  problem  management  patient  coding  guidelines  care  significant  ICD10  SMR00  SMR01  SMR02  SMR04

Other Condition/Co-morbidity and Complication ICD10 2

Other Condition/Co-morbidity and Complication ICD10 3

Other Condition/Co-morbidity and Complication ICD10 4

Other Condition/Co-morbidity and Complication ICD10 5

Other Condition/Co-morbidity and Complication ICD10 6

Format
Characters

Field Length
8

Priority
Conditional

Definition
Main Operation/Treatment/Investigative Procedure/Intervention are those aspects of clinical care carried out on patients undergoing treatment:

for the prevention, diagnosis, care or relief of disease
for the correction of deformity or deficit, including those performed for cosmetic reasons
associated with pregnancy, childbirth or contraceptive or procreative management
Typically this will be:

surgical in nature: and/or
carries a procedural risk: and/or
carries an anaesthetic risk: and/or
requires specialist training: and/or
requires special facilities or equipment only available in an acute care setting.
Points to Note

Please refer to the general rules for recording operations/procedures.
Cross Checks

A check is made that each Operation Code is valid as defined by the OPCS Classification. If not, an error will be reported.
A check is made that the use of the OPCS code is actually permitted on the record type. If a discrepancy is found, an appropriate error or query will be reported.
If Main Operation is specified, but the Date of Main Operation is not given, an error will be reported.
Each operation can have one or two codes. Checks are made to ensure that an Approach, Technique, Site or Laterality code is not supplied on its own or with another such code. If it is an error will be reported.

SMR01
If a code is recorded in the second field of a pair as well as the first field, checks are made to ensure that either:
the two codes are a recognised pair or
the code in the second field is from one of the subsidiary Y or Z chapters.
For any two consecutive single-coded operations, a check is made to see if these could be combined as one dual-coded operation. If this is possible, a query is reported.
If the patient is a Day Case, a further check will be made on each Operation code to ensure that the Operation is appropriate for such cases. If not, an error or query will be reported.
If the patient is an Outpatient, a further check will be made on each Operation code to ensure that the Operation is appropriate for such cases. If not, a query will be reported.
Each Operation code is checked to ensure that it is compatible with the stated Sex.
If a discrepancy is found an error or a query will be reported.
SMR Validation - Main and Other Operation/Treatment/Investigative Procedure

Tags:
clinical  care  patients  code  classification  undergoing  treatment  surgical  anaesthetic  acute  SMR00  SMR01  SMR02  SMR04

Main Operation/Treatment/Investigative Procedure/Intervention - OPCS4

Format
Characters

Field Length
8

Priority
Conditional

Definition
These are the additional procedures performed on an individual patient at a particular time.

Points to Note

Up to three pairs of procedures, in addition to the main procedure, may be recorded for an inpatient or day case episode on the central return. Therefore, if more than four procedures are performed during an episode of care, the clinicians opinion should be sought on which are the most significant. Local systems may allow more than four procedures to be recorded.
Cross Checks

These are detailed in Main Operation/Treatment/Investigative Procedure/Intervention.
SMR Validation - Other Operation

Tags:
additional  patient  inpatient  day  case  episode  performed  SMR00  SMR01  SMR02  SMR04

Other Operation/Treatment/Intervention/Investigative Procedures (2) - OPCS4

Other Operation/Treatment/Intervention/Investigative Procedures (3) - OPCS4

Other Operation/Treatment/Intervention/Investigative Procedures (4) - OPCS4

Format
Date (ddmmyy)

Field Length
6

Priority
Conditional

Definition
This reflects the date the main operation was performed.

Recording Rules
The full date should be entered thus: 5 July 2004 = 05/07/04

Cross Checks

Date of Main Operation is checked to ensure it is in the correct sequence with other dates recorded.
An error will be reported if there is a Main Operation recorded but the Date of Main Operation has been omitted.
An error will be reported if an entry has been made for Date of Main Operation, but the Main Operation has been omitted.
SMR Validation - Date of Main Operation/Treatment/Investigative Procedure

Tags:
sequence  reported  performed  SMR00  SMR01  SMR02  SMR04

Date of Main Operation/Treatment/Investigative Procedure/Intervention

Format
Date (ddmmyy)

Field Length
6

Priority
Conditional

Definition
This reflects the date the other operation was performed.

Recording Rules
The full date should be entered thus: 5 July 2004 = 05/07/04

Cross Checks

Date of Other Operation is checked to ensure it is in the correct sequence with other dates recorded.
SMR Validation - Date of Other Operation

Tags:
performed  sequence  recorded  SMR00  SMR01  SMR02  SMR04

Date of Other Operation/Treatment/Intervention/Investigative Procedures 2

Date of Other Operation/Treatment/Intervention/Investigative Procedures 3

Date of Other Operation/Treatment/Intervention/Investigative Procedures 4

Format
Characters

Field Length
2

Priority
Optional

Definition
Ethnic group classifies the person according to their own perceived ethnic group and cultural background. (Scotland Census)

Points to Note

This is included as an Optional item, but may be made Mandatory at a later date in order to conform to UK-wide requirements.
This is the patients perception of his or her own ethnic group, and is intended to assist the monitoring of equality of access to NHS services..
For the A&E datamart, please ensure this data item is as complete as possible
Cross Checks
None.

Notes
The following list is the current ethnicity classification (2011 Census categories). This should be used by NHS Scotland organisations for local and SMR return purposes. Local systems may record more detailed codes as required but these must map to the categories for SMR return purposes.

The letters that appear in the group headings in the codes and value list refer to positions in the census list and are not valid SMR codes. Please only use the codes in the code list (1A, 1B etc.).

Codes and Values: Ethnic Group (Code order)

Group A - White
1A Scottish
1B Other British
1C Irish
1K Gypsy/ Traveller
1L Polish
1Z Other white ethnic group

Group B - Mixed or multiple ethnic groups
2A Any mixed or multiple ethnic groups

Group C - Asian, Asian Scottish or Asian British
3F Pakistani, Pakistani Scottish or Pakistani British
3G Indian, Indian Scottish or Indian British
3H Bangladeshi, Bangladeshi Scottish or Bangladeshi British
3J Chinese, Chinese Scottish or Chinese British
3Z Other Asian, Asian Scottish or Asian British

Group D - African
4D African, African Scottish or African British
4Y Other African

Group E - Caribbean or Black
5C Caribbean, Caribbean Scottish or Caribbean British
5D Black, Black Scottish or Black British
5Y Other Caribbean or Black

Group F - Other ethnic group
6A Arab, Arab Scottish or Arab British
6Z Other ethnic group

Group G - Refused/Not provided by patient
98 Refused/Not provided by patient

Group H - Not Known
99 Not Known

SMR Validation - Ethnic Group

Tags:
ethnicity  classification  census  person  perceived  cultural  background  categories  SMR00  SMR01  SMR02  SMR04

Ethnic Group

Patient Identification and Demographic Information

Format
Integer

Field Length
1

Priority
Local

Definition
A categorisation which divides the Scottish population into five equal categories based on the range of SIMD scores so that 20% of the population falls into each quintile (population weighted). 

Points to note

For SIMD2016 
Most Deprived Quintile = 1
Least Deprived Quintile = 5

SIMD Scotland Quintile

The index is an area based measure, calculated at data zone level and has seven domains (income, employment, education, housing, health, crime and geographical access). These have been combined into an overall index. Please note that SIMD values may appear for records prior to 1999, however ISD recommendations are to use SIMD for trend analyses from 1999 onwards. For trend analyses back to 1991, use the 2001 census based Carstairs deprivation.
For trend analyses back to before 1991, use the 1991 census based Carstairs deprivation. See the ISD website for further information.
Please indicate which SIMD version you would like for each selected variable.
 
Note on change in ordering of quintiles and deciles
Following the release of the SIMD 2009, ISD changed their ordering of quintiles and deciles to fit with the method that is used by the Scottish Government
(SG). For SIMD 2009, SIMD 2012 and future releases, the method is now: 1 = MOST deprived, 5 or 10 = LEAST deprived
 
 ISD analyses based on SIMD 2006 or SIMD 2004 will be left in their current format:  1 = LEAST deprived; 5 or 10 = MOST deprived. 
To avoid confusion, deprivation categories should always be fully labelled. For example, for SIMD 2012, 'decile 1 (most deprived)'… 'decile 10 (least deprived)'.
For time trend analyses combining SIMD 2004/2006 with SIMD 2009/2012 it is important to treat all deciles and quintiles in the same way. SIMD 2004/2006 deciles/quintiles should be reversed from 1=LEAST deprived, 5 or 10=MOST deprived to 1=MOST deprived, 5 or 10=LEAST deprived in order to keep the same convention for the deciles and quintiles throughout the analysis.

Scottish Index of Multiple Deprivation (SIMD)

Brain Health - General Acute Inpatient and Day Case - Scottish Morbidity Record (SMR01)

The index is an area based measure, calculated at data zone level and has seven domains (income, employment, education, housing, health, crime and geographical access). These have been combined into an overall index. Please note that SIMD values may appear for records prior to 1999, however ISD recommendations are to use SIMD for trend analyses from 1999 onwards. For trend analyses back to 1991, use the 2001 census based Carstairs deprivation.
For trend analyses back to before 1991, use the 1991 census based Carstairs deprivation. See the ISD website for further information.
Please indicate which SIMD version you would like for each selected variable.
 
Note on change in ordering of quintiles and deciles
Following the release of the SIMD 2009, ISD changed their ordering of quintiles and deciles to fit with the method that is used by the Scottish Government
(SG). For SIMD 2009, SIMD 2012 and future releases, the method is now: 1 = MOST deprived, 5 or 10 = LEAST deprived
 
 ISD analyses based on SIMD 2006 or SIMD 2004 will be left in their current format:  1 = LEAST deprived; 5 or 10 = MOST deprived. 
To avoid confusion, deprivation categories should always be fully labelled. For example, for SIMD 2012, "decile 1 (most deprived)"… "decile 10 (least deprived)".
For time trend analyses combining SIMD 2004/2006 with SIMD 2009/2012 it is important to treat all deciles and quintiles in the same way. SIMD 2004/2006 deciles/quintiles should be reversed from 1=LEAST deprived, 5 or 10=MOST deprived to 1=MOST deprived, 5 or 10=LEAST deprived in order to keep the same convention for the deciles and quintiles throughout the analysis.

Brain Health - General Acute Inpatient and Day Case - Scottish Morbidity Record (SMR01)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin