This file describes the format for the SCTS export file 3.7 - 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 103 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, www.ccad.org.uk

1,	1.01 - Hospital identifier. Text (single value)
2,	1.02 - Local Patient Identifier. Text (single value)
3,	1.03 - NHS Number. Text (single value)
4,	1.04 - Patient Name (Surname). Text (single value)
5,	1.05 - Patient Name (Forename). Text (single value)
6,	1.06 - Birth Date. Date (dd/mm/yyyy)
7,	1.07 - Sex. Text (single value)
8,	1.08 - Administrative Category. Text (single value)
9,	1.09 - Postcode Of Usual Address. Text (single value)
10,	2.01 - Angina status pre-surgery. Text (single value)
11,	2.02 - Dyspnoea status pre-surgery. Text (single value)
12,	2.03 - Number of Previous MIs. Text (single value)
13,	2.04 - Interval between surgery and last Q-wave MI. Text (single value)
14,	2.05 - Previous PCI. Text (single value)
15,	2.06 - Date of last PCI. Date (dd/mm/yyyy)
16,	2.07 - Previous cardiac, vascular or thoracic surgical interventions. Text (multivalue ; separated)
17,	2.08 - Date of last cardiac operation. Date (dd/mm/yyyy)
18,	2.09 - Diabetes management. Text (single value)
19,	2.10 - History of hypertension. Text (single value)
20,	2.11 - Cigarette smoking history. Text (single value)
21,	2.12 - Renal disease at time of surgery. Text (multivalue ; separated)
22,	2.13 - History of pulmonary disease. Text (single value)
23,	2.14 - History of neurological disease. Text (multivalue ; separated)
24,	2.15 - Carotid Bruits. Text (single value)
25,	2.16 - History of neurological dysfunction. Text (single value)
26,	2.17 - Extracardiac arteriopathy. Text (single value)
27,	2.18 - Pre-operative heart rhythm. Text (single value)
28,	2.19 - Left or right heart catheterisation. Text (single value)
29,	2.20 - Date of last catheterisation. Date (dd/mm/yyyy)
30,	2.21 - Extent of coronary vessel disease. Text (single value)
31,	2.22 - Left main stem disease. Text (single value)
32,	2.23 - PA systolic. Numeric (integer)
33,	2.24 - Aortic valve gradient. Numeric (integer)
34,	2.25 - Left Ventricular End Diastolic Pressure. Numeric (integer)
35,	2.26 - Mean Pulmonary Artery Wedge Pressure / Left Atrial Pressure. Numeric (integer)
36,	2.27 - Ejection Fraction. Numeric (integer)
37,	2.28 - Ejection fraction category. Text (single value)
38,	2.29 - Intravenous nitrates or any heparin. Text (single value)
39,	2.30 - Cardiogenic shock (Pre-Operation). Text (single value)
40,	2.31 - Intravenous inotropes prior to anaesthesia. Text (single value)
41,	2.32 - Ventilated PreOp. Text (single value)
42,	2.33 - Intra-aortic balloon pump used. Text (multivalue ; separated)
43,	2.34 - Reason for Intra-aortic balloon pump use. Text (single value)
44,	2.35 - Operative urgency. Text (single value)
45,	2.36 - Number of previous heart operations. Numeric (integer)
46,	2.37 - Height. Numeric (integer)
47,	2.38 - Weight. Numeric (real)
48,	3.01 - Admission Date. Date (dd/mm/yyyy)
49,	3.02 - Date and time of operation. DateTime (dd/mm/yyyy hh:mm)
50,	3.03 - Responsible Consultant Surgeon. Text (single value)
51,	3.04 - Responsible Consultant Anaesthetist. Text (single value)
52,	3.05 - First Operator. Text (single value)
53,	3.06 - First operator grade. Text (single value)
54,	3.07 - First operator - Calman year of trainee. Text (single value)
55,	3.08 - First assistant. Text (single value)
56,	3.09 - First assistant grade. Text (single value)
57,	3.10 - First assistant - Calman year of trainee. Text (single value)
58,	3.11 - Cardiac Procedures. Text (single value)
59,	3.12 - Other Cardiac Procedures. Text (multivalue ; separated)
60,	3.13 - Other thoracic and vascular procedures. Text (multivalue ; separated)
61,	3.14 - Total number of distal coronary anastamoses. Numeric (integer)
62,	3.15 - Graft Site. Text (multivalue ; separated)
63,	3.16 - Graft Conduit. Text (multivalue ; separated)
64,	3.17 - Graft Anastomosis. Text (multivalue ; separated)
65,	3.18 - Number of valves replaced/repaired. Numeric (integer)
66,	3.19 - Aortic valve haemodynamic pathology. Text (single value)
67,	3.20 - Mitral valve haemodynamic pathology. Text (single value)
68,	3.21 - Tricuspid valve haemodynamic pathology. Text (single value)
69,	3.22 - Pulmonary valve haemodynamic pathology. Text (single value)
70,	3.23 - Aortic valve explant type. Text (single value)
71,	3.24 - Mitral valve explant type. Text (single value)
72,	3.25 - Tricuspid valve explant type. Text (single value)
73,	3.26 - Pulmonary valve explant type. Text (single value)
74,	3.27 - Native aortic valve pathology. Text (multivalue ; separated)
75,	3.28 - Native mitral valve pathology. Text (multivalue ; separated)
76,	3.29 - Native tricuspid valve pathology. Text (multivalue ; separated)
77,	3.30 - Native pulmonary valve pathology. Text (multivalue ; separated)
78,	3.31 - Native aortic valve other pathology. Text (single value)
79,	3.32 - Native mitral valve other pathology. Text (single value)
80,	3.33 - Native Tricuspid valve other pathology. Text (single value)
81,	3.34 - Native pulmonary valve other pathology. Text (single value)
82,	3.35 - Reason for repeat aortic valve replacement. Text (multivalue ; separated)
83,	3.36 - Reason for repeat mitral valve replacement. Text (multivalue ; separated)
84,	3.37 - Reason for repeat tricuspid valve replacement. Text (multivalue ; separated)
85,	3.38 - Reason for repeat pulmonary valve replacement. Text (multivalue ; separated)
86,	3.39 - Other reason for repeat aortic valve replacement. Text (single value)
87,	3.40 - Other reason for repeat mitral valve replacement. Text (single value)
88,	3.41 - Other reason for repeat tricuspid valve replacement. Text (single value)
89,	3.42 - Other reason for repeat pulmonary valve replacement. Text (single value)
90,	3.43 - Aortic valve procedure. Text (single value)
91,	3.44 - Mitral valve procedure. Text (single value)
92,	3.45 - Tricuspid valve procedure. Text (single value)
93,	3.46 - Pulmonary valve procedure. Text (single value)
94,	3.47 - Aortic valve implant type. Text (single value)
95,	3.48 - Mitral valve implant type. Text (single value)
96,	3.49 - Tricuspid valve implant type. Text (single value)
97,	3.50 - Pulmonary valve implant type. Text (single value)
98,	3.51 - Aortic implant prosthesis name. Text (single value)
99,	3.52 - Aortic implant prosthesis model. Text (single value)
100,	3.53 - Aortic valve or ring serial number. Text (single value)
101,	3.54 - Aortic valve or ring size (mm). Numeric (integer)
102,	3.55 - Mitral implant prosthesis name. Text (single value)
103,	3.56 - Mitral implant prosthesis model. Text (single value)
104,	3.57 - Mitral valve serial number. Text (single value)
105,	3.58 - Mitral valve size. Numeric (integer)
106,	3.59 - Tricuspid implant prosthesis name. Text (single value)
107,	3.60 - Tricuspid implant prosthesis model. Text (single value)
108,	3.61 - Tricuspid valve serial number. Text (single value)
109,	3.62 - Tricuspid valve size. Numeric (integer)
110,	3.63 - Pulmonary implant prosthesis name. Text (single value)
111,	3.64 - Pulmonary implant prosthesis model. Text (single value)
112,	3.65 - Pulmonary valve serial number. Text (single value)
113,	3.66 - Pulmonary valve size. Numeric (integer)
114,	3.67 - Number of aorta segments operated on. Numeric (integer)
115,	3.68 - Aortic pathology - Root. Text (multivalue ; separated)
116,	3.69 - Aortic procedure - Root. Text (single value)
117,	3.70 - Aortic pathology - Ascending. Text (multivalue ; separated)
118,	3.71 - Aortic procedure - Ascending. Text (single value)
119,	3.72 - Aortic pathology - Arch. Text (multivalue ; separated)
120,	3.73 - Aortic procedure - Arch. Text (single value)
121,	3.74 - Aortic pathology - Descending. Text (multivalue ; separated)
122,	3.75 - Aortic procedure - Descending. Text (single value)
123,	3.76 - Aortic pathology - Abdominal. Text (multivalue ; separated)
124,	3.77 - Aortic procedure - Abdominal. Text (single value)
125,	3.78 - Cardiopulmonary bypass. Text (single value)
126,	3.79 - Predominant method of myocardial protection. Text (single value)
127,	3.80 - Cardioplegia - Solution. Text (single value)
128,	3.81 - Cardioplegia - Temperature. Text (multivalue ; separated)
129,	3.82 - Cardioplegia - Infusion mode. Text (multivalue ; separated)
130,	3.83 - Cardioplegia - Timing. Text (single value)
131,	3.84 - Non-cardioplegic myocardial protection. Text (single value)
132,	3.85 - Cumulative bypass time. Numeric (integer)
133,	3.86 - Cumulative cross clamp time. Numeric (integer)
134,	3.87 - Total circulatory arrest time. Numeric (integer)
135,	4.01 - Reoperation. Text (multivalue ; separated)
136,	4.02 - New post-operative stroke. Text (single value)
137,	4.03 - New haemofiltration or dialysis post-operatively. Text (single value)
138,	4.04 - Discharge destination from cardiothoracic ward. Text (single value)
139,	4.05 - Patient Status at discharge. Text (single value)
140,	4.06 - Date of discharge / Date of death. 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