Please complete the spreadsheet for all adult patients (aged 16 and older) that suffered a subarachnoid haem
(coded by the ICD10 codes listed overleaf (worksheet 2)) during the period:
01/10/2010 - 30/09/2011
Each row of the spreadsheet should contain data pertaining to an individual patient.
Some sample data has been entered, which can be removed before adding data for your hospital/trust.
Please provide data about the patient and their admission to hospital including details of their transfer in and
As well as any related procedures they might have had during this admission (listed on worksheet 5).
To help you complete the spreadsheet, 'Source of admission' codes and 'discharge destination' codes are list
And National Specialty codes are listed on worksheet 8.
Fields marked with '*' are required fields, please ensure that this information is included
otherwise we will not be able to process your speadsheet.
If there were no patients that had a subarachnoid haemorrhage during the data collection period, please cont
The deadline for the return of the spreadsheet is 30th March 2012
Please password protect the spreadsheets using the instructions provided overleaf (worksheet 4), before
returning this data to via firstname.lastname@example.org , and telephone the password to 0207 600 1893
Before submitting data to NCEPOD, please check:
All key fields are complete
All NHS numbers are 10 digits
Thank you very much for your help with this study.
suffered a subarachnoid haemorrhage
a for your hospital/trust.
details of their transfer in and (if applicable) out of hospital.
sted on worksheet 5).
rge destination' codes are listed on worksheets 6 & 7
collection period, please contact NCEPOD to inform us.
eaf (worksheet 4), before
Diagnostic Codes for Subarachnoid Haemorrhage
I60.0 Subarachnoid haemorrhage from carotid siphon and bifurcation
I60.1 Subarachnoid haemorrhage from middle cerebral artery
I60.2 Subarachnoid haemorrhage from anterior communicating artery
I60.3 Subarachnoid haemorrhage from posterior communicating artery
I60.4 Subarachnoid haemorrhage from basilar artery
I60.5 Subarachnoid haemorrhage from vertebral artery
I60.6 Subarachnoid haemorrhage from other intracranial arteries
I60.7 Subarachnoid haemorrhage from intracranial artery, unspec
I60.8 Other subarachnoid haemorrhage
I60.9 Subarachnoid haemorrhage, unspecified
Hospital Information Patient Information
Hospital type: Please
select A-F*: (A) Large
DGH (>500 beds) (B)Small
DGH (<500 beds) (C)
Date of Birth* Sex (Male/
Trust Hospital hospital (D) Tertiary NHS No. * Hospital No.
centre (E) Other Tertiary
specialist centre (F) Other
hospial type *answers may be
Sometown NHS hospital trust Aparticular DGH A 2455687265 sgg4852647 2/21/1977 f
Sometown NHS hospital trust Themain UTH CD 6589654721 reg54824145 7/27/1969 m
Sometown NHS hospital trust Aparticular DGH A 5687953245 dddftt14113 1/23/1960 m
Smoetown NHS hospital trust ThemainUTH CD 6987245789 aw5q73m 2/22/1977 m
Admission/Discharge information Admitting Clinician informatio
This is the consultant clinician
dd/mm/yyyy dd/mm/yyyy If transferred to care the patient was under on
another hospital admission
from another If transferred to
Source of , please state if
hospital, Discharge another hospital ,
admission* hospital is a
please write destination* (see please write name
(see sheet 3 Date of specialist
name of sheet 3 for codes) of hospital (if
Date of for notes) discharge/death ( If Neurosurgical Title of
hospital (if available)
Admission still inpatient, write centre (if info is Consultant
NA ) available)
3/12/2011 51 NA 3/13/2011 51 Themain UTH Yes Dr
4/23/2011 51 Aparticular DGH 5/1/2011 79 NA Dr
7/2/2011 19 NA 7/5/2011 79 NA Dr
5/6/2011 19 NA 5/13/2011 19 NA Dr
Admitting Clinician information* 1st Clinician with Consultant Episode coded to SAH (if not the Admitting Clinician)
This is the consultant clinician whose 3 digit National This is the consultant clinician whose care the patient was under when
care the patient was under on Specialty Function first diagnosed with SAH i.e. SAH was not coded to the 1st (admission)
admission Code (see sheet) Consultant Episode
Initials of Surname of
Speciality of Consultant Title of Consultant Initials of Consultant Surname of Consultant
A Andee 300 Dr A Non
R Youbetter 101
M Ayooh 180
B Welle 430
Admitting Clinician) Information on procedure(s)
Date of procedure (if
3 digit National
multiple procedures, Clinician performing procedure (if multiple procedures, write d
Specialty Function If Yes Please
write the date of the performing first procedure)
Code (see sheet) write in this
Did this patient have any of first procedure)
the procedures listed on
sheet 5 at this hospital multiple
during this admission*
Speciality of Consultant (Y/N) first DD/MM/YYYY Title Initial Name of Surgeon
Y L33.2 4/25/2011 Mr A Neurosurgeon
y O01.2 5/12/2011 Mr B Neurosurgeon
multiple procedures, write details of clinician
Did this patient have multiple
Specialty of surgeon (please use
procedures (on the list on sheet 5)
national specialty codes provided)
during this admission?
ANY ADDITIONAL COMMENTS
HOW TO PASSWORD PROTECT A SPREADSHEET (MS Excel 2003)*
1. Open spreadsheet.
2. Single click on ‘File’ button.
3. Single click on ‘Save As’ in the drop down menu.
4. Single click on ‘Tools’ button in the top right corner of the pop up box.
5. Single click on ‘General Options’ in the drop down menu.
6. Type a password of your choice in the ‘Password to Open’ text box.
7. Single click on ‘OK’ button.
8. A box should pop up titled ‘Confirm Password’. Type your chosen password in the text box.
9. Single click on ‘OK’ button.
10. The pop up box should disappear, leaving the ‘Save As’ box. Type file name in appropriate text box
(Paediatric Surgery - Hospital name).
11. Single click ‘Save’ button.
*NB for MS excel 2007, click the 'office button' (top left of the screen) and select 'Prepare', then 'Encrypt
document' from the drop down menus and insert then confirm a password before saving your
spreadsheet as normal.
The file should now be password protected – that is, it cannot be opened without a password. To test this,
close the file, then attempt to re-open it. Microsoft Excel should open up, but no data/spreadsheet should
appear.Instead you should be prompted for a password, and if you enter the wrong password, or click
cancel, the spreadsheet should not open.
Please telephone NCEPOD to inform us of the password on 0207 600 1893
Codes for procedures potentially related to intervention for SAH
L33.1 Excision of aneurysm of cerebral artery
L33.2 Clipping of aneurysm of cerebral artery
L33.3 Ligation of aneurysm of cerebral artery NEC
L33.4 Obliteration of aneurysm of cerebral artery NEC
L33.8 Other specified operations on aneurysm of cerebral artery
L34.4 Open embolisation of cerebral artery
L34.8 Other specified other open operations on cerebral artery
L35.1 Percutaneous transluminal embolisation of cerebral artery
L35.3 Percutaneous transluminal insertion cerebral artery stent
L35.8 Other specified transluminal operations on cerebral artery
L35.9 Unspecified transluminal operations on cerebral artery
O01.1 Percutaneous transluminal coil embolisation of small aneurysm
O01.2 Percutaneous transluminal coil embolisation of medium aneurysm
O01.3 Percutaneous transluminal coil embolisation of large aneurysm
O01.4 Percutaneous transluminal coil embolisation of giant aneurysm
O01.8 Other specified transluminal coil embolisation of aneurysm of artery
O01.9 Unspecified transluminal coil embolisation of aneurysm of artery
O02.3 Percutaneous transluminal balloon assisted coil embolisation of single aneur
O03.3 Percutaneous transluminal stent assisted coil embolisation of single aneurys
In combination with: Y53 Approach to organ under image control
Z35 Cerebral artery
aneurysm of artery
urysm of artery
mbolisation of single aneurysm of artery
bolisation of single aneurysm of artery
The coded source of admission to a Hospital Provider Spell or a Nursing Episode when the PATIENT i
19 Usual place of residence unless listed below, for example, a private dwelling whethe
29 Temporary place of residence when usually resident elsewhere (e.g. hotels, residential educ
39 Penal establishment, Court, or police station
49 NHS other hospital provider - high security psychiatric accommodation in an NHS hospital p
51 NHS other hospital provider - ward for general patients or the younger physically dis
52 NHS other hospital provider - ward for maternity patients or neonates
53 NHS other hospital provider - ward for patients who are mentally ill or have learning disabilit
54 NHS run care home
65 Local Authority residential accommodation ie where care is provided
66 Local Authority foster care
79 Babies born in or on the way to hospital
85 Non-NHS (other than Local Authority) run care home
87 Non NHS run hospital
88 Non-NHS (other than Local Authority) run Hospice
NB: Code 51 should not be used if the PATIENT arrives at an Accident and Emergency Department and is admit
l or a Nursing Episode when the PATIENT is in a Hospital Site or a Care Home.
for example, a private dwelling whether owner occupied or owned by Local Authority, housing association or other la
ent elsewhere (e.g. hotels, residential educational establishments)
iatric accommodation in an NHS hospital provider (NHS trust)
al patients or the younger physically disabled or A & E department
patients or neonates
ho are mentally ill or have learning disabilities
ere care is provided
ident and Emergency Department and is admitted to the same Hospital Provider.
thority, housing association or other landlord. This includes wardened accommodation but not residential accommoda
odation but not residential accommodation where health care is provided. It also includes patients with no fixed abode
o includes patients with no fixed abode.
Discharge destination codes
Usual place of residence unless listed below, for example, a private dwelling whether owner occupie
Temporary place of residence when usually resident elsewhere (includes hotel, residential educational establis
Repatriation from high security psychiatric accommodation in an NHS Hospital Provider (NHS Trust)
Penal establishment or police station
High Security Psychiatric Hospital, Scotland
NHS other hospital provider - high security psychiatric accommodation
NHS other hospital provider - medium secure unit
NHS other hospital provider - ward for general PATIENTS or the younger physically disabled
NHS other hospital provider - ward for maternity PATIENTS or neonates
NHS other hospital provider - ward for PATIENTS who are mentally ill or have learning disabilities
NHS run Care Home
Local Authority residential accommodation ie where care is provided
Local Authority foster care
Non-NHS run hospital - medium secure unit
Non-NHS (other than Local Authority) run Care Home
Non-NHS run hospital
Non-NHS (other than Local Authority) run Hospice
ng whether owner occupied or owned by local authority, housing association or other landlord. This includes wardene
esidential educational establishment)
rovider (NHS Trust)
r other landlord. This includes wardened accommodation but not residential accommodation where health care is prov
commodation where health care is provided. It also includes PATIENTS with no fixed abode.
Code Treatment Function Title Comments
100 GENERAL SURGERY Includes sub-categories not elsewhere listed e.g. endocrin
102 TRANSPLANTATION SURGERY Includes pre- and post-operative care for major organ tran
103 BREAST SURGERY Includes treatment for cancer, suspected neoplasms, cyst
104 COLORECTAL SURGERY Surgical treatment of disorders of the lower intestine (colo
105 HEPATOBILIARY & PANCREATIC SURGERY Includes liver surgery, but liver transplantation should be r
106 UPPER GASTROINTESTINAL SURGERY
107 VASCULAR SURGERY
110 TRAUMA & ORTHOPAEDICS
120 ENT Ear, nose and throat
140 ORAL SURGERY
141 RESTORATIVE DENTISTRY Endodontics, Periodontics and Prosthodontics are all part
142 PAEDIATRIC DENTISTRY
144 MAXILLO-FACIAL SURGERY Mouth, jaw and face related surgery.
160 PLASTIC SURGERY
161 BURNS CARE To be used by recognised specialist units and associated
170 CARDIOTHORACIC SURGERY Should only be used where there are no separate services
171 PAEDIATRIC SURGERY This is paediatric general surgery
172 CARDIAC SURGERY
173 THORACIC SURGERY
174 CARDIOTHORACIC TRANSPLANTATION To be used by recognised specialist units and associated
180 ACCIDENT & EMERGENCY
191 PAIN MANAGEMENT Complex pain disorders requiring diagnosis and treatmen
190 ANAESTHETICS This can be used in out-patients only. Pain Management s
192 CRITICAL CARE MEDICINE also known as Intensive Care Medicine
300 GENERAL MEDICINE Includes sub-categories not elsewhere listed e.g. metabol
303 CLINICAL HAEMATOLOGY Excludes ANTICOAGULANT SERVICE see 324
304 CLINICAL PHYSIOLOGY Physiological measurement including ECG (e.g. exercise
305 CLINICAL PHARMACOLOGY
306 HEPATOLOGY Also known as liver medicine
307 DIABETIC MEDICINE
308 BLOOD AND MARROW TRANSPLANTATION Previously in Clinical Haematology. Includes haemopoietic
309 HAEMOPHILIA Previously in Clinical Haematology
310 AUDIOLOGICAL MEDICINE The medical specialty concerned with the investigation, di
311 CLINICAL GENETICS To be used by recognised specialist units and associated
312 not a Treatment Function
313 CLINICAL IMMUNOLOGY and ALLERGY Should only be used where there are no separate services
315 PALLIATIVE MEDICINE
316 CLINICAL IMMUNOLOGY
317 ALLERGY The diagnosis and management of allergic disease (abno
318 INTERMEDIATE CARE Intermediate care encompasses a range of multi-disciplin
319 RESPITE CARE
321 PAEDIATRIC CARDIOLOGY
322 CLINICAL MICROBIOLOGY
323 SPINAL INJURIES To be used by recognised specialist units and associated
324 ANTICOAGULANT SERVICE The monitoring and control of anticoagulant therapy includ
325** SPORT AND EXERCISE MEDICINE The diagnosis and management of medical problems cau
327** CARDIAC REHABILITATION Rehabilitation service for PATIENTS with or recovering fro
328** STROKE MEDICINE For stroke services excluding Transient Ischaemic Attack
329** TRANSIENT ISCHAEMIC ATTACK A multidisciplinary service for rapid diagnosis and treatme
340 RESPIRATORY MEDICINE Also known as Thoracic Medicine
341 RESPIRATORY PHYSIOLOGY Physiological measurement of the function of the respirato
342** PROGRAMMED PULMONARY REHABILITATION A multidisciplinary programme of care for PATIENTS with
343** ADULT CYSTIC FIBROSIS Specialised, multidisciplinary service concerned with the d
350 INFECTIOUS DISEASES
352 TROPICAL MEDICINE
360 GENITOURINARY MEDICINE
370 MEDICAL ONCOLOGY The diagnosis and treatment, typically with Chemotherapy
371 NUCLEAR MEDICINE
401 CLINICAL NEUROPHYSIOLOGY The study of the central and peripheral nervous systems t
421 PAEDIATRIC NEUROLOGY
422 NEONATOLOGY Special Care, High Dependency and Intensive Care.
424 WELL BABIES Care given by the mother/substitute with medical and neo
430 GERIATRIC MEDICINE
450 DENTAL MEDICINE SPECIALTIES Includes oral medicine.
460 MEDICAL OPHTHALMOLOGY
500 not a Treatment Function
501 OBSTETRICS The management of pregnancy and childbirth including m
502 GYNAECOLOGY Disorders of the female reproductive system. Includes pla
503 GYNAECOLOGICAL ONCOLOGY
510 Retired Record as Obstetrics, antenatal clinic can be used as a lo
520 Retired Record as Obstetrics, postnatal clinic can be used as a lo
560 MIDWIFE EPISODE
600 not a Treatment Function
610 Retired Record as Obstetrics
620 Retired Use the appropriate function under which the patient is tre
650 PHYSIOTHERAPY The treatment of human function and movement to help p
651 OCCUPATIONAL THERAPY The use of specific activities to limit the effects of disability
652 SPEECH AND LANGUAGE THERAPY The assessment, treatment and help to prevent speech, la
653 PODIATRY Also known as Chiropody. The diagnosis and treatment o
654 DIETETICS The application of the science of nutrition to devise eating
655 ORTHOPTICS The diagnosis and treatment of visual problems involving
656 CLINICAL PSYCHOLOGY The diagnosis and treatment of emotional and behavioura
657** PROSTHETICS The supply of prosthetics for PATIENTS.
658** ORTHOTICS The supply of orthoses for PATIENTS.
659** DRAMATHERAPY The use of drama and theatre techniques including role pl
660** ART THERAPY The use of art techniques including clay, paint and paper f
661** MUSIC THERAPY The use of music and all of its facets to help clients to imp
662** OPTOMETRY The diagnosis and non-surgical treatment of disorders of
800 CLINICAL ONCOLOGY (previously RADIOTHERAPY) The diagnosis and treatment, typically with radiotherapy, o
810 not a Treatment Function
811 INTERVENTIONAL RADIOLOGY Not to be used for diagnostic imaging.
812 DIAGNOSTIC IMAGING The production and interpretation of high quality images o
834** MEDICAL VIROLOGY The diagnosis and management and prevention of virus a
840 AUDIOLOGY Physiological measurement and diagnosis of hearing diso
900 not a Treatment Function
901 not a Treatment Function
950 not a Treatment Function Use the appropriate function under which the patient is tre
960 not a Treatment Function Use the appropriate function under which the patient is tre
† Code 500 is not acceptable for Central Returns including Hospital Episode Statistics
** The functionality to report these TREATMENT FUNCTION CODES is available in the latest release of the Commiss
TREATMENT FUNCTION CODES should be used for all aggregate Central Returns unless otherwise stated eg Na
GENERAL MEDICAL PRACTITIONER, NURSE and Allied Health Professional/ Biomedical Scientist/ Clinical Scien
Joint Consultant Clinic ACTIVITY should be recorded against the TREATMENT FUNCTION which best describes th
es not elsewhere listed e.g. endocrine surgery.
st-operative care for major organ transplants except heart and lung (see Cardiothoracic Transplantation). Excludes corneal grafts.
r cancer, suspected neoplasms, cysts and post-cancer reconstructive surgery. Excludes cosmetic surgery.
disorders of the lower intestine (colon, anus and rectum)
, but liver transplantation should be recorded in 102 Transplantation Surgery
ntics and Prosthodontics are all part of Restorative Dentistry
nised specialist units and associated outreach services only
where there are no separate services for Cardiac Surgery and Thoracic Surgery
nised specialist units and associated outreach services only. Includes pre- and post-operative services.
ers requiring diagnosis and treatment by a specialist multi-professional team
ut-patients only. Pain Management should be recorded in 191.
ve Care Medicine
es not elsewhere listed e.g. metabolic medicine.
GULANT SERVICE see 324
ement including ECG (e.g. exercise testing, stress testing), gastrointestinal physiology, cardiac physiology, vascular technology, urodynamic
Haematology. Includes haemopoietic stem cell transplantation.
y concerned with the investigation, diagnosis and management of patients with disorders of balance, hearing, tinnitus and auditory communic
nised specialist units and associated outreach services only.
where there are no separate services for Clinical Immunology and Allergy
anagement of allergic disease (abnormal immune responses to external substances) and the exclusion of allergic causes in other conditions
compasses a range of multi-disciplinary services designed to safeguard independence by maximising rehabilitation and recovery after illness
nised specialist units and associated outreach services only.
ontrol of anticoagulant therapy including the initiation and/or supervision of oral anticoagulant therapy and the determination of anticoagulant
anagement of medical problems caused by physical activity, the prevention of related injury and disease and the role of exercise in disease t
for PATIENTS with or recovering from heart related conditions such as heart attacks or from procedures such as coronary artery bypass su
xcluding Transient Ischaemic Attack - see TREATMENT FUNCTION CODE 329
rvice for rapid diagnosis and treatment of PATIENTSpresenting with suspected Transient Ischaemic Attack and mini-strokes to minimise the
ement of the function of the respiratory system. Includes Sleep Studies (the diagnosis and treatment of sleep disordered breathing, including
ogramme of care for PATIENTS with chronic respiratory impairment that is individually tailored and designed to optimise the individual's phys
iplinary service concerned with the diagnosis, assessment and management of PATIENTS with cystic fibrosis. This TREATMENT FUNCTIO
eatment, typically with Chemotherapy, of PATIENTS with cancer.
ral and peripheral nervous systems through the recording of bioelectrical activity. Includes EEG.
ependency and Intensive Care.
ther/substitute with medical and neonatal nursing advice if needed
pregnancy and childbirth including miscarriages but excluding planned terminations.
ale reproductive system. Includes planned terminations.
, antenatal clinic can be used as a local sub-specialty if required
, postnatal clinic can be used as a local sub-specialty if required
unction under which the patient is treated
man function and movement to help people to achieve their full physical potential. The use of physical approaches to promote, maintain and r
ctivities to limit the effects of disability and promote independence in all aspects of daily life.
atment and help to prevent speech, language and swallowing difficulties.
pody. The diagnosis and treatment of disorders, diseases and deformities of the feet.
science of nutrition to devise eating plans for patients to treat medical conditions. The promotion of good health by helping to facilitate a pos
eatment of visual problems involving eye movement and alignment.
eatment of emotional and behavioural disorders.
etics for PATIENTS.
es for PATIENTS.
d theatre techniques including role play, voice work and storytelling for therapeutic purposes.
ques including clay, paint and paper for therapeutic purposes and as a means of communication.
d all of its facets to help clients to improve or maintain their health.
n-surgical treatment of disorders of the eye and vision care.
eatment, typically with radiotherapy, of patients with cancer.
nterpretation of high quality images of the body to diagnose injuries and disease, e.g. x-rays, ultrasound, MRI, PET or CT scans.
anagement and prevention of virus and related infections, in hospital and in the community including HIV/AIDS, other blood-borne infections
ement and diagnosis of hearing disorders, and the rehabilitation of patients with hearing loss.
unction under which the patient is treated
unction under which the patient is treated
in the latest release of the Commissioning Data Sets and the associated CDS-XML Schema Release (6-1-1). These TREATMENT FUNCT
eturns unless otherwise stated eg National Workforce Data Set uses MAIN SPECIALTY CODES
/ Biomedical Scientist/ Clinical Scientist ACTIVITY should be recorded against the TREATMENT FUNCTION under which the PATIENT is tr
T FUNCTION which best describes the specialised service
. Excludes corneal grafts.
gy, vascular technology, urodynamics, and ophthalmic and vision science. Does not include Clinical Neurophysiology, Audiology or Respirato
aring, tinnitus and auditory communication. Excludes audiology and hearing tests.
of allergic causes in other conditions.
habilitation and recovery after illness or injury
nd the determination of anticoagulant dosage. This can be used in out-patients only.
and the role of exercise in disease treatment.
es such as coronary artery bypass surgery to ensure that they achieve their full potential in terms of physical and psychological health.
ack and mini-strokes to minimise the chance of a full stroke occurring and maximise the chances of independent living after a stroke.
sleep disordered breathing, including upper airway resistance syndrome and sleep apnoea).
gned to optimise the individual's physical and social performance and autonomy.
brosis. This TREATMENT FUNCTION CODE should be used by recognised specialist centres only.
proaches to promote, maintain and restore wellbeing.
od health by helping to facilitate a positive change in food choices amongst individuals, groups and communities.
MRI, PET or CT scans.
V/AIDS, other blood-borne infections like hepatitis B and C and newly emerging viruses such as SARS and avian flu.
6-1-1). These TREATMENT FUNCTION CODES cannot be transmitted in XML Schemas for the previous versions of the Commissioning Da
TION under which the PATIENT is treated
urophysiology, Audiology or Respiratory Physiology.
ical and psychological health.
ependent living after a stroke.
us versions of the Commissioning Data Sets (6-0 and 6-1)