This file describes the format for the BCIS export file 5.1.2 - bcis.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 - Patient Case Record Number - Text (single value)
3,	1.03 - NHS Number - Text (single value)
4,	1.04 - Patient Surname - Text (single value)
5,	1.05 - Patient Forename - Text (single value)
6,	1.06 - Patient Date of Birth - Date (dd/mm/yyyy)
7,	1.07 - Patient Gender - Text (single value)
8,	1.08 - Patient Ethnic Group - Text (single value)
9,	1.09 - Patient Admin status - Text (single value)
10,	1.10 - Patient Post Code - Text (single value)
11,	2.01 - Clinical Syndrome - Text (single value)
12,	2.02 - Indication for Intervention - Text (single value)
13,	2.03 - Procedure Urgency - Text (single value)
14,	2.04 - Cardiogenic shock pre-anaesthesia (pre-procedure for PCI) - Text (single value)
15,	2.05 - CCS classification for stable angina - Text (single value)
16,	2.06 - NYHA classification for cardiac disease - Text (single value)
17,	2.07 - Symptom onset (ACS) - DateTime (dd/mm/yyyy hh:mm)
18,	2.08 - Arrival in Hospital (ACS) - DateTime (dd/mm/yyyy hh:mm)
19,	2.09 - Admission route (ACS) - Text (single value)
20,	2.10 - Presenting ECG (ACS) - Text (single value)
21,	2.11 - Recent Lysis (ACS) - Text (single value)
22,	2.12 - Cardiac Enzymes/Markers Raised - Text (single value)
23,	2.13 - Previous MI - Text (single value)
24,	2.14 - Previous CABG - Text (single value)
25,	2.15 - Previous PCI - Text (single value)
26,	2.16 - Diabetes - Text (single value)
27,	2.17 - Height - Numeric (integer)
28,	2.18 - Weight - Numeric (real)
29,	2.19 - LV Function assessment - Text (single value)
30,	2.20 - LV Ejection Fraction - Numeric (integer)
31,	2.21 - N grafts present - Numeric (integer)
32,	2.22 - N grafts patent PreOp - Numeric (integer)
33,	2.23 - LMain PreOp - Text (single value)
34,	2.24 - LADprox PreOp - Text (single value)
35,	2.25 - LADother PreOp - Text (single value)
36,	2.26 - RCA PreOp - Text (single value)
37,	2.27 - LCX PreOp - Text (single value)
38,	2.28 - Flow in IRA PreOp (ACS) - Text (single value)
39,	3.01 - Date/Time arrival at hospital (for MINAP) or Procedure Date (for all other datasets) - DateTime (dd/mm/yyyy hh:mm)
40,	3.02 - Consultant Responsible for Procedure - Text (single value)
41,	3.03 - Primary Operator - Text (single value)
42,	3.04 - Primary Operator status - Text (single value)
43,	3.05 - Second Operator - Text (single value)
44,	3.06 - Second Operator status - Text (single value)
45,	3.07 - Third Operator - Text (single value)
46,	3.08 - Third Operator status - Text (single value)
47,	3.09 - Vessels attempted - Text (multivalue ; separated)
48,	3.10 - N Vessels attempted - Numeric (integer)
49,	3.11 - N Lesions attempted - Numeric (integer)
50,	3.12 - N Chronic Occlusions attempted - Numeric (integer)
51,	3.13 - N Restenoses attempted - Numeric (integer)
52,	3.14 - N InStent stenoses attempted - Numeric (integer)
53,	3.15 - N Stents used - Numeric (integer)
54,	3.16 - N Drug Eluting Stents used - Numeric (integer)
55,	3.17 - Drug(s) eluted by stent(s) - Text (multivalue ; separated)
56,	3.18 - GP IIb/IIIa drug(s) used during procedure - Text (multivalue ; separated)
57,	3.19 - Diagnostic device(s) used during procedure - Text (multivalue ; separated)
58,	3.20 - Procedural device(s) used - Text (multivalue ; separated)
59,	3.21 - Athero-thrombus removal device(s) used - Text (multivalue ; separated)
60,	3.22 - Brachytherapy device(s) used - Text (multivalue ; separated)
61,	3.23 - Emboli protection device(s) used - Text (multivalue ; separated)
62,	3.24 - Circulatory support - Text (multivalue ; separated)
63,	3.25 - Arterial management - Text (multivalue ; separated)
64,	3.26 - Time of IRA reperfusion (ACS) - DateTime (dd/mm/yyyy hh:mm)
65,	3.27 - LMain PostOp - Text (single value)
66,	3.28 - LADprox PostOp - Text (single value)
67,	3.29 - LADother PostOp - Text (single value)
68,	3.30 - RCA PostOp - Text (single value)
69,	3.31 - LCX PostOp - Text (single value)
70,	3.32 - N Lesions success - Numeric (integer)
71,	3.33 - N grafts patent PostOp - Numeric (integer)
72,	3.34 - Flow in IRA PostOp (ACS) - Text (single value)
73,	3.35 - Procedure report/comment - Text (single value)
74,	3.36 - Device failure - Text (single value)
75,	4.01 - PCI Hospital Outcome - Text (multivalue ; separated)
76,	4.02 - Enzymes PostOp - Text (single value)
77,	4.03 - Status at discharge - Text (single value)
78,	4.04 - Discharge Date - Date (dd/mm/yyyy)
79,	5.01 - Local Procedure Identifier - Text (single value)
80,	5.02 - Cholesterol - Numeric (real)
81,	5.03 - Smoking status - Text (single value)
82,	5.04 - Family history of CAD - Text (single value)
83,	5.05 - Medical history - Text (multivalue ; separated)
84,	5.06 - History of renal disease - Text (single value)
85,	5.07 - Ventilated PreOp - Text (single value)
86,	5.08 - Q Wave on ECG - Text (single value)
87,	5.09 - ECG ischaemia - Text (single value)
88,	5.10 - Drug therapy PreOp - Text (multivalue ; separated)
89,	5.11 - Follow on (Adhoc) procedure - Text (single value)
90,	5.12 - Training procedure - Text (single value)
91,	5.13 - Research procedure - Text (single value)
92,	5.14 - Research title - Text (single value)
93,	5.15 - Arterial access - Text (multivalue ; separated)
94,	5.16 - Largest balloon/stent used - Numeric (real)
95,	5.17 - Longest balloon/stent used - Numeric (integer)
96,	5.18 - Procedural Complication - Text (multivalue ; separated)
97,	5.19 - Arterial Complications - Text (multivalue ; separated)
98,	5.20 - Time to bypass - Numeric (integer)
99,	5.21 - Transfer to theatre - Text (single value)
100,	5.22 - Why no IIb/IIIA during procedure - Text (single value)
101,	5.23 - Indication for stent - Text (single value)
102,	5.24 - Surgical cover - Text (single value)
103,	5.25 - LMS Protected - Text (single value)

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