This file describes the format for the SCTS export file v4.1.2 - scts.csv The file is a CSV (comma separated variable) file. All values (even empty ones) must be enclosed in quotes(""). Each line (record) of the file must be properly terminated with a CRLF (carriage return and line feed, ASCII characters 13 and 10 in decimal, 0D and 0A in hex). Each line (record) is made up of 168 variables (fields) in the prescribed order. A complete list of variable is shown below. The first number is the position of the variable followed by a comma then a tab, the next number is the dataset number, then a hyphen, followed by the field description, followed by a full stop then the datatype. Details about the legal values for the fields can be found in the dataset. 1.01 Hospital Identifier Text (single value) 1.02 Local patient identifier Freetext 1.03 NHS Number Freetext 1.04 Patient Name (Surname) Freetext 1.05 Patient Name (Forename) Freetext 1.06 Date of Birth Date (dd/mm/yyyy) 1.07 Sex Text (single value) 1.08 Administrative Category Text (single value) 1.09 Postcode Freetext 2.01 Angina status pre-surgery Text (single value) 2.02 Dyspnoea status pre-surgery Text (single value) 2.03 Number of previous Mis Text (single value) 2.04 Interval between surgery and last MI Text (single value) 2.05 Previous PCI Text (single value) 2.07 Previous cardiac surgery Text (multivalue ; separated) 2.08 Date of last cardiac operation Date (dd/mm/yyyy) 2.09 Diabetes management Text (single value) 2.1 History of hypertension Text (single value) 2.11 Cigarette smoking history Text (single value) 2.12.0 Actual creatinine at time of Surgery Number (Integer) 2.12.1 Renal function/Dialysis Text (single value) 2.13 History of pulmonary disease Text (single value) 2.14 History of neurological disease Text (multivalue ; separated) 2.16 History of neurological dysfunction Text (single value) 2.17 Extracardiac arteriopathy Text (single value) 2.18 Pre-operative heart rhythm Text (single value) 2.19 Left heart catheterisation Text (single value) 2.2 Date of last catheterisation Date (dd/mm/yyyy) 2.21 Extent of cardiac vessel disease Text (single value) 2.22 Left main stem disease Text (single value) 2.23 PA systolic Number (Integer) 2.24.1 Severity of Aortic Valve Stenosis (EOA in cm2) Number (real) 2.24.2 Severity of Aortic Valve Stenosis (Gradient mmHg) Number (real) 2.24.3 Category of aortic valve stenosis Text (single value) 2.27 Left ventricular Function Number (Integer) 2.28 Ejection fraction category Text (single value) 2.29 Intravenous nitrates or any heparin Text (single value) 2.3 Cardiogenic shock (Pre-Operation) Text (single value) 2.31 Intravenous inotropes prior to anaesthesia Text (single value) 2.32 Ventilated (Pre-Operation) Text (single value) 2.33.0.1 Intra-aortic balloon pump used (pre) Text (single value) 2.33.0.2 Intra-aortic balloon pump used (intra) Text (single value) 2.33.0.3 Intra-aortic balloon pump used (post) Text (single value) 2.33.1.1 Impeller device used (pre) Text (single value) 2.33.1.2 Impeller device used (intra) Text (single value) 2.33.1.3 Impeller device used (post) Text (single value) 2.33.2.1 Ventricular assist device used (pre) Text (single value) 2.33.2.2 Ventricular assist device used (intra) Text (single value) 2.33.2.3 Ventricular assist device used (post) Text (single value) 2.33.3.1 Other support device used (pre) Text (single value) 2.33.3.2 Other support device used (intra) Text (single value) 2.33.3.3 Other support device used (post) Text (single value) 2.34.0.1 Reason for intra-aortic balloon pump use (pre) Text (single value) 2.34.0.2 Reason for intra-aortic balloon pump use (intra) Text (single value) 2.34.0.3 Reason for intra-aortic balloon pump use (post) Text (single value) 2.34.1.1 Reason for impeller device use (pre) Text (single value) 2.34.1.2 Reason for impeller device use (intra) Text (single value) 2.34.1.3 Reason for impeller device use (post) Text (single value) 2.34.2.1 Reason for ventricular assist device use (pre) Text (single value) 2.34.2.2 Reason for ventricular assist device use (intra) Text (single value) 2.34.2.3 Reason for ventricular assist device use (post) Text (single value) 2.34.3.1 Reason for use of Other support device (pre) Text (single value) 2.34.3.2 Reason for use of Other support device (intra) Text (single value) 2.34.3.3 Reason for use of Other support device (post) Text (single value) 2.35 Operative urgency Text (single value) 2.36 Number of previous heart operations Number (Integer) 2.37 Height Number (real) 2.38 Weight Number (real) 3.01 Admission date Date (dd/mm/yyyy) 3.02 Date and time of operation Date (dd/mm/yyyy hh:mm) 3.03 Responsible Consultant Surgeon Freetext 3.04 Responsible Consultant Anaesthetist Freetext 3.05 First Operator Freetext 3.06 First operator grade Text (single value) 3.07 First operator - Calman year of trainee Text (single value) 3.08 First assistant Freetext 3.09 First assistant grade Text (single value) 3.1 First assistant - Calman year of trainee Text (single value) 3.11.1 CABG Text (single value) 3.11.2 Valve Text (single value) 3.11.3 Major aortic Text (single value) 3.11.4 Cardiac procedures - Other Text (single value) 3.12 Other cardiac procedures Text (multivalue ; separated) 3.14 Total number of distal coronary anastamoses Number (Integer) 3.15 Graft site Text (multivalue ; separated) 3.16 Graft Conduit Text (multivalue ; separated) 3.17 Graft Anastomosis Text (multivalue ; separated) 3.18 Number of valves replaced/repaired Number (Integer) 3.19 Aortic valve haemodynamic pathology Text (single value) 3.2 Mitral valve haemodynamic pathology Text (single value) 3.21 Tricuspid valve haemodynamic pathology Text (single value) 3.22 Pulmonary valve haemodynamic pathology Text (single value) 3.23 Aortic valve type Text (single value) 3.24 Mitral valve type Text (single value) 3.25 Tricuspid valve type Text (single value) 3.26 Pulmonary valve type Text (single value) 3.27 Native aortic valve pathology Text (multivalue ; separated) 3.28 Native mitral valve pathology Text (multivalue ; separated) 3.29 Native tricuspid valve pathology Text (multivalue ; separated) 3.3 Native pulmonary valve pathology Text (multivalue ; separated) 3.31 Native aortic valve other pathology Freetext 3.32 Native mitral valve other pathology Freetext 3.33 Native tricuspid valve other pathology Freetext 3.34 Native pulmonary valve other pathology Freetext 3.35 Reason for repeat aortic valve operation Text (multivalue ; separated) 3.36 Reason for repeat mitral valve operation Text (multivalue ; separated) 3.37 Reason for repeat tricuspid valve operation Text (multivalue ; separated) 3.38 Reason for repeat pulmonary valve operation Text (multivalue ; separated) 3.39 Other reason for repeat aortic valve replacement Freetext 3.4 Other reason for repeat mitral valve replacement Freetext 3.41 Other reason for repeat tricuspid valve replacement Freetext 3.42 Other reason for repeat pulmonary valve replacement Freetext 3.43 Aortic valve procedure Text (single value) 3.44 Mitral valve procedure Text (single value) 3.45 Tricuspid valve procedure Text (single value) 3.46 Pulmonary valve procedure Text (single value) 3.47 Aortic valve implant type Text (single value) 3.48 Mitral valve implant type Text (single value) 3.49 Tricuspid valve implant type Text (single value) 3.5 Pulmonary valve implant type Text (single value) 3.51 Aortic implant prosthesis name Freetext 3.52 Aortic implant prosthesis model Freetext 3.53 Aortic valve or ring serial number Freetext 3.54 Aortic valve or ring size (mm) Number (Integer) 3.55 Mitral implant prosthesis name Freetext 3.56 Mitral implant prosthesis model Freetext 3.57 Mitral valve serial number Freetext 3.58 Mitral valve size Number (Integer) 3.59 Tricuspid implant prosthesis name Freetext 3.6 Tricuspid implant prosthesis model Freetext 3.61 Tricuspid valve serial number Freetext 3.62 Tricuspid valve size Number (Integer) 3.63 Pulmonary implant prosthesis name Freetext 3.64 Pulmonary implant prosthesis model Freetext 3.65 Pulmonary valve serial number Freetext 3.66 Pulmonary valve size Number (Integer) 3.67 Number of aorta segments operated on Number (Integer) 3.68.1 Aortic pathology - Root Segment Code 1 Text (multivalue ; separated) 3.69.1 Aortic procedure - Root Segment Code 1 Text (single value) 3.70.1 Aortic pathology - Ascending Segment Code 2 Text (multivalue ; separated) 3.71.1 Aortic procedure - Ascending Segment Code 2 Text (single value) 3.72.1 Aortic pathology - Arch Segment Code 3 Text (multivalue ; separated) 3.73.1 Aortic procedure - Arch Segment Code 3 Text (single value) 3.74.1 Aortic pathology - Descending Aorta Segment Code 4 Text (multivalue ; separated) 3.75.1 Aortic procedure - Descending Aorta Segment Code 4 Text (single value) 3.76.1 Aortic pathology - Abdominal Segment Code 5 Text (multivalue ; separated) 3.77.1 Aortic procedure - Abdominal Segment Code 5 Text (single value) 3.78 Cardiopulmonary bypass Text (single value) 3.79 Predominant method of myocardial protection Text (single value) 3.8 Cardioplegia - Solution Text (single value) 3.81 Cardioplegia - Temperature Text (multivalue ; separated) 3.82 Cardioplegia - Infusion mode Text (multivalue ; separated) 3.83 Cardioplegia - Timing Text (single value) 3.84 Non-cardioplegic myocardial protection Text (single value) 3.85 Cumulative bypass time Number (Integer) 3.86 Cumulative cross clamp time Number (Integer) 3.87 Total circulatory arrest time Number (Integer) 3.9 Presentation Text (multivalue ; separated) 3.91 Aetiology Text (single value) 3.95 Neuroprotection Text (multivalue ; separated) 4.01 Return to Theatre Text (multivalue ; separated) 4.01.1 Deep Sternal wound infection Text (single value) 4.01.2 Deep Sternal wound infection treatment Text (single value) 4.02 New post-operative neurological dysfunction Text (multivalue ; separated) 4.03 New haemofiltration or dialysis post-operatively Text (single value) 4.04 Discharge destination from cardiothoracic ward Text (single value) 4.05 Patient status at discharge Text (single value) 4.06 Date of discharge / Date of death in hospital Date (dd/mm/yyyy) Format of an export file: "value 1","value 2","","",......"value 102","Value 103" "value 1","value 2","","",......"value 102","Value 103" "value 1","value 2","","",......"value 102","Value 103" Note: Empty quotes ("") to highlight how to handle empty values. ..... signifies the continuation of the values