 INSERT INTO gpconnect.encounters
   (nhsNumber, sectionDate, htmlPart, provider, lastUpdated)
 VALUES (
-  9000000084, '2013-04-16 00:00:01',
-  "<table><thead><tr><th>16-Apr-2013</th><th>GP Surgery - Dr Emis Test</th></tr></thead><tbody><tr><td/><td><div>No additional details available</div></td></tr></tbody></table>",
-  "INPS", '2016-07-25 12:00:00'
+  9000000084, '2016-10-03 12:17:00',
+  "<table><thead><tr><th>03 Oct 2016</th><th>Emis Test - EMISWebCR1 50002</th></tr></thead><tbody><tr><td/><td>Comment note : - This is confidential.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2016-10-03 15:47:00',
+  "<table><thead><tr><th>03 Oct 2016</th><th>Emis Test - EMISWebCR1 50002</th></tr></thead><tbody><tr><td/><td>Referral : .</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2016-10-03 12:10:00',
+  "<table><thead><tr><th>03 Oct 2016</th><th>Emis Test - EMISWebCR1 50002</th></tr></thead><tbody><tr><td/><td>Clinical document : This is confidential - test.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2003-05-26 09:22:00',
+  "<table><thead><tr><th>26 May 2003</th><th>Brian Harding - EMIS PCS Test Practice 1</th></tr></thead><tbody><tr><td/><td>Result : Full blood count - FBC - Normal - No Action.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2003-05-26 09:22:00',
+  "<table><thead><tr><th>26 May 2003</th><th>Brian Harding - EMIS PCS Test Practice 1</th></tr></thead><tbody><tr><td/><td>Result : Blood glucose level - glucose 6.3 ? fasting, repeat fasting blood glucose. Tumour marker levels - Normal - No Action. Thyroid function test - Normal - No Action. GFR calculated abbreviated MDRD - Normal - No Action. (Non Coded Event - Lipid Profile ) - chol 6.6. Liver function test - Normal - No Action. Renal profile - Normal - No Action.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2003-05-26 09:22:00',
+  "<table><thead><tr><th>26 May 2003</th><th>Brian Harding - EMIS PCS Test Practice 1</th></tr></thead><tbody><tr><td/><td>Result : (Non Coded Event - anti - HBs ) - Normal - No Action.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2002-06-12 09:22:00',
+  "<table><thead><tr><th>12 Jun 2002</th><th>Neil Burgess - EMIS PCS Test Practice 1</th></tr></thead><tbody><tr><td/><td>Result : Microbiology - Seen and dealt with.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2002-06-11 09:22:00',
+  "<table><thead><tr><th>11 Jun 2002</th><th>Neil Burgess - EMIS PCS Test Practice 1</th></tr></thead><tbody><tr><td/><td>Result : Plasma glucose level - Normal - No Action. Biochemical test - Normal - No Action. Thyroid function test - Normal - No Action. Cardiac enzymes - Normal - No Action. GFR calculated abbreviated MDRD - Normal - No Action. (Non Coded Event - Lipid Profile ) - Just out of normal range - Ok. Liver function test - Normal - No Action. (Non Coded Event - Renal Profile ) - Normal - No Action.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2002-06-11 09:22:00',
+  "<table><thead><tr><th>11 Jun 2002</th><th>Neil Burgess - EMIS PCS Test Practice 1</th></tr></thead><tbody><tr><td/><td>Result : Full blood count - FBC - Normal - No Action.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2002-06-27 09:22:00',
+  "<table><thead><tr><th>27 May 2002</th><th>Neil Burgess - EMIS PCS Test Practice 1</th></tr></thead><tbody><tr><td/><td>Result : Microbiology - Normal - No Action.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2002-06-25 09:22:00',
+  "<table><thead><tr><th>25 May 2002</th><th>Neil Burgess - EMIS PCS Test Practice 1</th></tr></thead><tbody><tr><td/><td>Result : (Non Coded Event - REJECTED BIOCHEMISTRY ) - Normal - No Action.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2002-05-14 09:22:00',
+  "<table><thead><tr><th>14 May 2002</th><th>Neil Burgess - EMIS PCS Test Practice 1</th></tr></thead><tbody><tr><td/><td>Result : Full blood count - FBC - Just out of normal range - Ok.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2002-05-14 09:22:00',
+  "<table><thead><tr><th>14 May 2002</th><th>Neil Burgess - EMIS PCS Test Practice 1</th></tr></thead><tbody><tr><td/><td>Result : (Non Coded Event - REJECTED BIOCHEMISTRY) - Normal - No Action.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
+),
+(
+  9000000084, '2000-06-13 09:22:00',
+  "<table><thead><tr><th>13 Jun 2000</th><th>Neil Burgess - EMIS PCS Test Practice 1</th></tr></thead><tbody><tr><td/><td>Problems : - Generalised non-specific abdominal tenderness.<br/>Examination (heading) : O/E Blood Pressure Reading.<br/>Social history : Never smoked tobacco.</td></tr></tbody></table>",
+  "EMIS", '2016-07-25 12:00:00'
 );
 
 INSERT INTO gpconnect.immunisations
   (id, html, provider, lastUpdated)
 VALUES (
   9000000084,
-  "<div><div><div><table><tbody><tr><td>19-Mar-2013</td><td><em>Influenza vaccination</em></td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>142934010</td></tr><tr><td>Time recorded</td><td>19-Mar-2013 09:57:51</td></tr><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>d9a1523e-ee3c-45cd-bc21-623a766292a9</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c36ccf3a-6960-435a-a560-46bb74502553</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>21-Jan-2013</td><td><em>First pandemic influenza vaccination</em></td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>308411000000113</td></tr><tr><td>Time recorded</td><td>21-Jan-2013 11:54:23</td></tr><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>260b502c-faa7-47b8-a5f0-70a91f5cd517</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c36ccf3a-6960-435a-a560-46bb74502553</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>02-Jan-2006</td><td><em>Influenza vaccination</em></td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>142934010</td></tr><tr><td>Time recorded</td><td>30-Nov-2007</td></tr><tr><td>Person recorded</td><td>Dr Adam Walton</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>6cefa127-d65a-40b6-b0fb-85217c08c5e5</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c36ccf3a-6960-435a-a560-46bb74502553</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>06-Jan-2005</td><td><em>Influenza vaccination</em></td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>142934010</td></tr><tr><td>Time recorded</td><td>04-Dec-2006</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>2e9a5aab-542e-425b-8ff5-4917cc658566</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c36ccf3a-6960-435a-a560-46bb74502553</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>12-Dec-2003</td><td><em>Influenza vaccination</em></td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>142934010</td></tr><tr><td>Time recorded</td><td>08-Nov-2005</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>94aa643f-eedc-45c8-ac45-e87b5d7468ac</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c36ccf3a-6960-435a-a560-46bb74502553</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>28-Nov-2002</td><td><em>Pneumococcal vaccination</em></td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>22068011</td></tr><tr><td>Time recorded</td><td>25-Oct-2004</td></tr><tr><td>Person recorded</td><td>Mrs Catherine Reeves</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>41e23bb8-0be4-4e54-921e-6875aedf4d63</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c36ccf3a-6960-435a-a560-46bb74502553</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>28-Nov-2002</td><td><em>Influenza vaccination</em></td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>142934010</td></tr><tr><td>Time recorded</td><td>25-Oct-2004</td></tr><tr><td>Person recorded</td><td>Mrs Catherine Reeves</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>9007643c-7e60-4bd8-9c27-1730e5fb805e</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c36ccf3a-6960-435a-a560-46bb74502553</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr></tbody></table></div></div></div>",
+  "<div><table><tbody><tr><th>Date</th><th>Vaccination</th><th>Details</th></tr><tr><td>04 Oct 2016</td><td>First DTP (triple)+polio vacc.</td><td>Manufacturer : fred<br />Batch: 1<br />Injection Location: Right arm<br />Expiry Date: 04-Oct-2016</td></tr></tbody></table><h2>Refusals</h2>There are no immunisations in the patient's record</div>",
   "EMIS",
   '2016-08-24 12:00:00'
 );
 
-INSERT INTO gpconnect.investigations
+
+INSERT INTO gpconnect.medications_html
   (id, html, provider, lastUpdated)
 VALUES (
-  9000000084,
-  "	<div><h2>Recent Tests</h2><div><div><table><thead><tr><th>Date</th><th>!</th><th>Investigation</th><th>Result</th><th>Range</th></tr></thead><tbody><tr><td>23-Jan-2013</td><td/><td><em>Urine blood test = +</em></td><td>-</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>259831011</td></tr><tr><td>Time recorded</td><td>23-Jan-2013 12:07:41</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>31b1d6f6-8680-4abf-8885-65f3f4fbea54</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>14-Dec-2012</td><td/><td><em>Sputum inspection</em> : nice</td><td>-</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>260952014</td></tr><tr><td>Time recorded</td><td>14-Dec-2012 16:09:45</td></tr><tr><td>Associated Text</td><td>nice</td></tr><tr><td>Record element identifier</td><td>d8fcff2c-91c2-41ac-a80c-4857a2a45eb2</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>14-Dec-2012</td><td/><td><em>Blood pH abnormal</em> : slightly acidic</td><td>-</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>259499019</td></tr><tr><td>Time recorded</td><td>14-Dec-2012 16:09:27</td></tr><tr><td>Associated Text</td><td>slightly acidic</td></tr><tr><td>Record element identifier</td><td>469f705f-2920-4c5e-aed7-ea60b1c21fcc</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>19-Jan-2006</td><td/><td><em>Peak exp. flow rate: PEFR/PFR</em></td><td> 440.000 l/minute</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>236671000006112</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>711b8b95-e6e4-4184-a0e4-8880a5165e88</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>19-Jan-2006</td><td/><td><em>Forced expired volume in 1 second</em></td><td> 3.500 litres</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>764481000006119</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>eec888de-79e8-4092-a25d-c93f95634276</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>19-Jan-2006</td><td/><td><em>Forced vital capacity - FVC</em></td><td> 410.000 litres</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>764741000006116</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>be10493b-6557-492e-84df-cd99f93abacf</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>19-Jan-2006</td><td/><td><em>FEV1/FVC percent</em></td><td> 85.000 %</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>457080011</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>bb5ab061-4b5f-43fc-b869-7ba06d5669d4</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>19-Jan-2006</td><td/><td><em>Spirometry</em></td><td>-</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>135511000006112</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>d296df4c-b6cc-4cf2-a6ec-8cb2be9505fd</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>19-Jan-2006</td><td/><td><em>Phlegm examination</em> : BT taken</td><td>-</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>231621000006117</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Associated Text</td><td> BT taken</td></tr><tr><td>Record element identifier</td><td>c0dbb9c7-4d16-4c5b-9a97-7d200972047b</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr></tbody></table></div></div><h2>Biochemistry</h2><div><div><table><thead><tr><th>Date</th><th>!</th><th>Investigation</th><th>Result</th><th>Range</th></tr></thead><tbody><tr><td>14-Dec-2012</td><td/><td><em>Blood pH abnormal</em> : slightly acidic</td><td>-</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>259499019</td></tr><tr><td>Time recorded</td><td>14-Dec-2012 16:09:27</td></tr><tr><td>Associated Text</td><td>slightly acidic</td></tr><tr><td>Record element identifier</td><td>469f705f-2920-4c5e-aed7-ea60b1c21fcc</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr></tbody></table></div></div><h2>ECG</h2><div><div><table><thead><tr><th>Date</th><th>!</th><th>Investigation</th><th>Result</th><th>Range</th></tr></thead><tbody><tr><td>There are no ECG records in the patient's record</td></tr></tbody></table></div></div><h2>Haematology</h2><div><div><table><thead><tr><th>Date</th><th>!</th><th>Investigation</th><th>Result</th><th>Range</th></tr></thead><tbody><tr><td>17-Jul-2005</td><td/><td><em>Basophil count</em></td><td> 0.020 10*9/L</td><td>0.000 - 0.10010*9/L</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>70669012</td></tr><tr><td>Time recorded</td><td>15-Jun-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>11ff02bf-234c-416a-b22e-1414474cfe57</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>17-Jul-2005</td><td/><td><em>Eosinophil count</em></td><td> 0.250 10*9/L</td><td>0.000 - 0.40010*9/L</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>119575019</td></tr><tr><td>Time recorded</td><td>15-Jun-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>0ecc533e-f956-414a-b553-702cf784fffb</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>17-Jul-2005</td><td/><td><em>Monocyte count</em></td><td> 0.670 10*9/L</td><td>0.200 - 0.80010*9/L</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>112567012</td></tr><tr><td>Time recorded</td><td>15-Jun-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>a2d72c0f-0fa1-4a1f-849b-26b3fa69a9a7</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>17-Jul-2005</td><td/><td><em>Lymphocyte count</em></td><td> 2.720 10*9/L</td><td>1.500 - 4.00010*9/L</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>124165010</td></tr><tr><td>Time recorded</td><td>15-Jun-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>672b91d8-cf01-4d75-8d84-a3a1f3518711</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>17-Jul-2005</td><td/><td><em>Neutrophil count</em></td><td> 4.120 10*9/L</td><td>2.000 - 7.50010*9/L</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>51268016</td></tr><tr><td>Time recorded</td><td>15-Jun-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>211f5e08-dd88-4b68-9acb-4b5938eed9de</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>17-Jul-2005</td><td/><td><em>Platelet count</em></td><td> 188.000 10*9/L</td><td>150.000 - 400.00010*9/L</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>102928018</td></tr><tr><td>Time recorded</td><td>15-Jun-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>0f84d928-d2d4-4001-a79f-2ee35c2a451e</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>17-Jul-2005</td><td/><td><em>Red blood cell distribution width</em></td><td> 14.000 %</td><td>11.000 - 15.000%</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>187341000000114</td></tr><tr><td>Time recorded</td><td>15-Jun-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>bb561736-27b2-4fb3-836b-d644334e20a3</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr></tbody></table></div></div><h2>Imaging</h2><div><div><table><thead><tr><th>Date</th><th>!</th><th>Investigation</th><th>Result</th><th>Range</th></tr></thead><tbody><tr><td>19-Jan-2006</td><td/><td><em>Spirometry</em></td><td>-</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>135511000006112</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>d296df4c-b6cc-4cf2-a6ec-8cb2be9505fd</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr></tbody></table></div></div><h2>Microbiology</h2><div><div><table><thead><tr><th>Date</th><th>!</th><th>Investigation</th><th>Result</th><th>Range</th></tr></thead><tbody><tr><td>There are no Microbiology records in the patient's record</td></tr></tbody></table></div></div><h2>Cytology</h2><div><div><table><thead><tr><th>Date</th><th>!</th><th>Investigation</th><th>Result</th><th>Range</th></tr></thead><tbody><tr><td>There are no Cytology records in the patient's record</td></tr></tbody></table></div></div><h2>Others</h2><div><div><table><thead><tr><th>Date</th><th>!</th><th>Investigation</th><th>Result</th><th>Range</th></tr></thead><tbody><tr><td>14-Dec-2012</td><td/><td><em>Sputum inspection</em> : nice</td><td>-</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>260952014</td></tr><tr><td>Time recorded</td><td>14-Dec-2012 16:09:45</td></tr><tr><td>Associated Text</td><td>nice</td></tr><tr><td>Record element identifier</td><td>d8fcff2c-91c2-41ac-a80c-4857a2a45eb2</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>19-Jan-2006</td><td/><td><em>Phlegm examination</em> : BT taken</td><td>-</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>231621000006117</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Associated Text</td><td> BT taken</td></tr><tr><td>Record element identifier</td><td>c0dbb9c7-4d16-4c5b-9a97-7d200972047b</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr></tbody></table></div></div><h2>Physiology</h2><div><div><table><thead><tr><th>Date</th><th>!</th><th>Investigation</th><th>Result</th><th>Range</th></tr></thead><tbody><tr><td>19-Jan-2006</td><td/><td><em>Peak exp. flow rate: PEFR/PFR</em></td><td> 440.000 l/minute</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>236671000006112</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>711b8b95-e6e4-4184-a0e4-8880a5165e88</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>19-Jan-2006</td><td/><td><em>Forced expired volume in 1 second</em></td><td> 3.500 litres</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>764481000006119</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>eec888de-79e8-4092-a25d-c93f95634276</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>19-Jan-2006</td><td/><td><em>Forced vital capacity - FVC</em></td><td> 410.000 litres</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>764741000006116</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>be10493b-6557-492e-84df-cd99f93abacf</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr><tr><td>19-Jan-2006</td><td/><td><em>FEV1/FVC percent</em></td><td> 85.000 %</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>457080011</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>bb5ab061-4b5f-43fc-b869-7ba06d5669d4</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr></tbody></table></div></div><h2>Urinalysis</h2><div><div><table><thead><tr><th>Date</th><th>!</th><th>Investigation</th><th>Result</th><th>Range</th></tr></thead><tbody><tr><td>23-Jan-2013</td><td/><td><em>Urine blood test = +</em></td><td>-</td><td>-</td></tr><tr><td/><td><table><tbody><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Snomed code</td><td>259831011</td></tr><tr><td>Time recorded</td><td>23-Jan-2013 12:07:41</td></tr><tr><td>Associated Text</td><td/></tr><tr><td>Record element identifier</td><td>31b1d6f6-8680-4abf-8885-65f3f4fbea54</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr></tbody></table></td></tr></tbody></table></div></div></div>",
+  9000000084, "<div><h2>Current Acutes</h2><table><tbody><tr><th>Start Date</th><th>Drug</th><th>Scheduled end</th><th>Days duration</th><th>Details</th></tr><tr><td>03 Oct 2016</td><td>Paracetamol 500mg / Metoclopramide 5mg tablets - 100 tablet - Two At Onset Of Attack Then One Every 4 Hours When Necessary, Max 6 In 24 Hours</td><td>20 Oct 2016</td><td>17</td><td>Acute Issue  </td></tr></tbody></table><h2>Current Repeats</h2><table><tbody><tr><th>Start Date</th><th>Drug</th><th>Last Issued</th><th>Review Date</th><th>No Issued</th><th>Max Issued</th><th>Details</th></tr><tr><td>03 Oct 2016</td><td>Ibuprofen 10% gel - 50 gram - Apply Up To Three Times A Day</td><td>03 Oct 2016</td><td>31 Oct 2016</td><td>1</td><td></td><td></td></tr></tbody></table><h2>Past Acutes</h2><table><tbody><tr><th>Start Date</th><th>Drug</th><th>Scheduled end</th><th>Days duration</th><th>Details</th></tr><tr><td></td><td>Amitriptyline 25mg tablets - 28 tablet(s) - TAKE ONE DAILY</td><td>12 May 1999</td><td>0</td><td>Acute Issue  </td></tr><tr><td>12 May 1999</td><td>Amitriptyline 25mg tablets - 28 tablet(s) - TAKE ONE DAILY</td><td>12 May 1999</td><td>0</td><td>Acute Issue  </td></tr></tbody></table><h2>Past Repeats</h2>There is no Past Medication Repeats in the patient's record</div>",
   "EMIS",
   '2016-08-24 12:00:00'
 );
 
-INSERT INTO gpconnect.medications_html
+INSERT INTO gpconnect.observations
   (id, html, provider, lastUpdated)
 VALUES (
-  9000000084,
-  "<div><div><div><div><span>Acute Medication</span></div><div><table><tbody><tr><td>01-Feb-2013</td><td><em>Co-codamol 15mg/500mg tablets,</em> One Or Two To Be Taken Four Times A Day,33 tablet</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>2875341000033110</td></tr><tr><td>Prescription Date</td><td>01-Feb-2013</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>01-Feb-2013 13:35:56</td></tr><tr><td>Record element identifier</td><td>8a61f3f3-e046-43a4-8165-bb9235cccc60</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr></tbody></table></div></div><div><div><span>Repeat Medication</span></div><div><table><tbody><tr><td>04-Nov-2006</td><td><em>Salbutamol 100micrograms/dose inhaler CFC free,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1222341000033110</td></tr><tr><td>Date Authorised Until</td><td>04-Dec-2006</td></tr><tr><td>Issue Date</td><td>04-Nov-2006</td></tr><tr><td>Number of Issues</td><td>0</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Prescription Date</td><td>04-Nov-2006</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Eileen Walton</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>04-Nov-2006</td></tr><tr><td>Record element identifier</td><td>18e30f64-a28a-4816-b24b-e98911d02e72</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>18-Aug-2006</td><td><em>Clenil Modulite 100micrograms/dose inhaler (Trinity-Chiesi Pharmaceuticals Ltd),</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>3943341000033113</td></tr><tr><td>Date Authorised Until</td><td>17-Feb-2007</td></tr><tr><td>Issue Date</td><td>18-Aug-2006</td></tr><tr><td>Number of Issues</td><td>5</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Prescription Date</td><td>18-Aug-2006</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>19-Jan-2006</td></tr><tr><td>Record element identifier</td><td>f6b7d3c2-194d-43b1-a4a2-c839789a9451</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>04-Nov-2006</td><td><em>Simvastatin 40mg tablets,</em> TAKE ONE DAILY,56 tablet</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1337541000033111</td></tr><tr><td>Date Authorised Until</td><td>30-Dec-2006</td></tr><tr><td>Issue Date</td><td>04-Nov-2006</td></tr><tr><td>Number of Issues</td><td>6</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Prescription Date</td><td>04-Nov-2006</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>18-Nov-2005</td></tr><tr><td>Record element identifier</td><td>e48c305e-846c-46ea-8c4e-b04cf5e7e40a</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr></tbody></table></div></div><h2>Past Medication</h2><table><thead><tr><th>Last Issue</th><th>Drug / Dose / Quantity</th></tr></thead></table><div><div><span>Past Medication</span></div><div><table><tbody><tr><td>29-Oct-2006</td><td><em>Salbutamol 100micrograms/dose inhaler CFC free,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1222341000033110</td></tr><tr><td>Prescription Date</td><td>29-Oct-2006</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>19-Jan-2006</td></tr><tr><td>Record element identifier</td><td>2ab3a98c-bd57-40a3-8c05-e606dcc1415e</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>13-Oct-2005</td><td><em>Atorvastatin 10mg tablets,</em> ONE AT NIGHT,56 TABLET(S)</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>91941000033117</td></tr><tr><td>Prescription Date</td><td>13-Oct-2005</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>08-Jan-2004</td></tr><tr><td>Record element identifier</td><td>81153566-1952-421a-9194-f77bb0864d4d</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>28-Aug-2005</td><td><em>Miconazole 2% cream,</em> BD,30 Gram(s)</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>906741000033118</td></tr><tr><td>Prescription Date</td><td>28-Aug-2005</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Kathleen Bray</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>28-Aug-2005</td></tr><tr><td>Record element identifier</td><td>b27b8c63-07b6-495a-82a0-7f6d1854cc58</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>16-Jul-2005</td><td><em>Miconazole 2% / Hydrocortisone 1% cream,</em> APPLY TWICE DAILY,30 gram</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1846441000033113</td></tr><tr><td>Prescription Date</td><td>16-Jul-2005</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>16-Jul-2005</td></tr><tr><td>Record element identifier</td><td>e9d3b70c-46ca-4162-909b-f69f96a0fd41</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>27-Feb-2004</td><td><em>Atorvastatin 10mg tablets,</em> ONE AT NIGHT,56 TABLET(S)</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>91941000033117</td></tr><tr><td>Prescription Date</td><td>27-Feb-2004</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>08-Jan-2004</td></tr><tr><td>Record element identifier</td><td>54620f9f-7863-4487-939e-87982324b4bb</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>05-Dec-2003</td><td><em>Amoxicillin 500mg capsules,</em> 1TDS,15 capsule(s)</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>3079241000033113</td></tr><tr><td>Prescription Date</td><td>05-Dec-2003</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>05-Dec-2003</td></tr><tr><td>Record element identifier</td><td>2059cbcb-c41e-4100-8872-87c2745c83dc</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>05-Dec-2003</td><td><em>Codeine 15mg/5ml linctus,</em> 10MLS TDS,250 ml</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>368441000033116</td></tr><tr><td>Prescription Date</td><td>05-Dec-2003</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>05-Dec-2003</td></tr><tr><td>Record element identifier</td><td>d5950809-39d8-4320-b159-e47fba16972c</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>13-Mar-2003</td><td><em>Diclofenac sodium 50mg gastro-resistant tablets,</em> 1TDSPC,40 tablet(s)</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1922841000033119</td></tr><tr><td>Prescription Date</td><td>13-Mar-2003</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>13-Mar-2003</td></tr><tr><td>Record element identifier</td><td>009ff4d2-aa24-4711-b384-07e7d099f349</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr></tbody></table></div></div><h2>Medication Issues</h2><table><thead><tr><th>Last Issue</th><th>Drug / Dose / Quantity</th></tr></thead></table><div><div><span>Medication Issues</span></div><div><table><tbody><tr><td>01-Feb-2013</td><td><em>Co-codamol 15mg/500mg tablets,</em> One Or Two To Be Taken Four Times A Day,33 tablet</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>2875341000033110</td></tr><tr><td>Prescription Date</td><td>01-Feb-2013</td></tr><tr><td>Date Authorised Until</td><td>06-Feb-2013</td></tr><tr><td>Issue Date</td><td>01-Feb-2013</td></tr><tr><td>Number of Issues</td><td>1</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>01-Feb-2013 13:36:35</td></tr><tr><td>Record element identifier</td><td>435cbda9-b72f-4995-8f38-29e2022f1997</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>04-Nov-2006</td><td><em>Simvastatin Tablets 40 mg,</em> TAKE ONE DAILY,56 tablet</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1337541000033111</td></tr><tr><td>Prescription Date</td><td>09-Dec-2005</td></tr><tr><td>Date Authorised Until</td><td>30-Dec-2006</td></tr><tr><td>Issue Date</td><td>04-Nov-2006</td></tr><tr><td>Number of Issues</td><td>6</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Eileen Walton</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>04-Nov-2006</td></tr><tr><td>Record element identifier</td><td>8a1561a8-57b1-4138-bdd9-a79ab8169fac</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>29-Oct-2006</td><td><em>Salbutamol Cfc-free inhaler 100 micrograms/puff,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1222341000033110</td></tr><tr><td>Prescription Date</td><td>19-Jan-2006</td></tr><tr><td>Date Authorised Until</td><td>30-Apr-2007</td></tr><tr><td>Issue Date</td><td>29-Oct-2006</td></tr><tr><td>Number of Issues</td><td>3</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Carol Fitzgerald</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>29-Oct-2006</td></tr><tr><td>Record element identifier</td><td>7fc7f603-7193-45e0-af47-03579ac01b53</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>18-Aug-2006</td><td><em>Clenil Modulite Cfc-free inhaler 100 micrograms/actuation,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>3943341000033113</td></tr><tr><td>Prescription Date</td><td>19-Jan-2006</td></tr><tr><td>Date Authorised Until</td><td>17-Feb-2007</td></tr><tr><td>Issue Date</td><td>18-Aug-2006</td></tr><tr><td>Number of Issues</td><td>5</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Sharon Cook</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>18-Aug-2006</td></tr><tr><td>Record element identifier</td><td>7cd503dd-1e6d-4200-a998-8dfcd4483a00</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>18-Aug-2006</td><td><em>Simvastatin Tablets 40 mg,</em> TAKE ONE DAILY,56 tablet</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1337541000033111</td></tr><tr><td>Prescription Date</td><td>09-Dec-2005</td></tr><tr><td>Date Authorised Until</td><td>30-Dec-2006</td></tr><tr><td>Issue Date</td><td>04-Nov-2006</td></tr><tr><td>Number of Issues</td><td>6</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Sharon Cook</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>18-Aug-2006</td></tr><tr><td>Record element identifier</td><td>cb1dd835-27b7-449f-a0b5-a45827464f4a</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>18-Aug-2006</td><td><em>Salbutamol Cfc-free inhaler 100 micrograms/puff,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1222341000033110</td></tr><tr><td>Prescription Date</td><td>19-Jan-2006</td></tr><tr><td>Date Authorised Until</td><td>30-Apr-2007</td></tr><tr><td>Issue Date</td><td>29-Oct-2006</td></tr><tr><td>Number of Issues</td><td>3</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Sharon Cook</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>18-Aug-2006</td></tr><tr><td>Record element identifier</td><td>7b81051a-e805-4f37-b0d2-5580d645d338</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>15-Jun-2006</td><td><em>Clenil Modulite Cfc-free inhaler 100 micrograms/actuation,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>3943341000033113</td></tr><tr><td>Prescription Date</td><td>19-Jan-2006</td></tr><tr><td>Date Authorised Until</td><td>17-Feb-2007</td></tr><tr><td>Issue Date</td><td>18-Aug-2006</td></tr><tr><td>Number of Issues</td><td>5</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Kathleen Bray</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>15-Jun-2006</td></tr><tr><td>Record element identifier</td><td>365dedb1-ad32-4ca8-8863-96b48c42ef3e</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>15-Jun-2006</td><td><em>Simvastatin Tablets 40 mg,</em> TAKE ONE DAILY,56 tablet</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1337541000033111</td></tr><tr><td>Prescription Date</td><td>09-Dec-2005</td></tr><tr><td>Date Authorised Until</td><td>30-Dec-2006</td></tr><tr><td>Issue Date</td><td>04-Nov-2006</td></tr><tr><td>Number of Issues</td><td>6</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Kathleen Bray</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>15-Jun-2006</td></tr><tr><td>Record element identifier</td><td>ba53b60c-05b3-40e3-9a95-ded999f1fa1e</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>15-Jun-2006</td><td><em>Salbutamol Cfc-free inhaler 100 micrograms/puff,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1222341000033110</td></tr><tr><td>Prescription Date</td><td>19-Jan-2006</td></tr><tr><td>Date Authorised Until</td><td>30-Apr-2007</td></tr><tr><td>Issue Date</td><td>29-Oct-2006</td></tr><tr><td>Number of Issues</td><td>3</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Kathleen Bray</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>15-Jun-2006</td></tr><tr><td>Record element identifier</td><td>a8ac25ef-8da0-47e0-b180-c53642c97d05</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>06-Apr-2006</td><td><em>Clenil Modulite Cfc-free inhaler 100 micrograms/actuation,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>3943341000033113</td></tr><tr><td>Prescription Date</td><td>19-Jan-2006</td></tr><tr><td>Date Authorised Until</td><td>17-Feb-2007</td></tr><tr><td>Issue Date</td><td>18-Aug-2006</td></tr><tr><td>Number of Issues</td><td>5</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Kathleen Bray</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>06-Apr-2006</td></tr><tr><td>Record element identifier</td><td>ce4cca58-2368-4c10-95be-0f6b92764114</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>06-Apr-2006</td><td><em>Simvastatin Tablets 40 mg,</em> TAKE ONE DAILY,56 tablet</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1337541000033111</td></tr><tr><td>Prescription Date</td><td>09-Dec-2005</td></tr><tr><td>Date Authorised Until</td><td>30-Dec-2006</td></tr><tr><td>Issue Date</td><td>04-Nov-2006</td></tr><tr><td>Number of Issues</td><td>6</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Kathleen Bray</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>06-Apr-2006</td></tr><tr><td>Record element identifier</td><td>a3e3974c-cb74-4bb4-b218-f1e6c12c151b</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>06-Apr-2006</td><td><em>Salbutamol Cfc-free inhaler 100 micrograms/puff,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1222341000033110</td></tr><tr><td>Prescription Date</td><td>19-Jan-2006</td></tr><tr><td>Date Authorised Until</td><td>30-Apr-2007</td></tr><tr><td>Issue Date</td><td>29-Oct-2006</td></tr><tr><td>Number of Issues</td><td>3</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Kathleen Bray</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>06-Apr-2006</td></tr><tr><td>Record element identifier</td><td>b4297e5f-53d5-4d29-b83c-51c67802db57</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>17-Feb-2006</td><td><em>Clenil Modulite Cfc-free inhaler 100 micrograms/actuation,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>3943341000033113</td></tr><tr><td>Prescription Date</td><td>19-Jan-2006</td></tr><tr><td>Date Authorised Until</td><td>17-Feb-2007</td></tr><tr><td>Issue Date</td><td>18-Aug-2006</td></tr><tr><td>Number of Issues</td><td>5</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Kathleen Bray</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>17-Feb-2006</td></tr><tr><td>Record element identifier</td><td>81abff55-5d85-45f9-b093-0198db0365a5</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>17-Feb-2006</td><td><em>Simvastatin Tablets 40 mg,</em> TAKE ONE DAILY,56 tablet</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1337541000033111</td></tr><tr><td>Prescription Date</td><td>09-Dec-2005</td></tr><tr><td>Date Authorised Until</td><td>30-Dec-2006</td></tr><tr><td>Issue Date</td><td>04-Nov-2006</td></tr><tr><td>Number of Issues</td><td>6</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Kathleen Bray</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>17-Feb-2006</td></tr><tr><td>Record element identifier</td><td>9e54e963-3073-4c22-bfdf-e56240736d40</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>17-Feb-2006</td><td><em>Salbutamol Cfc-free inhaler 100 micrograms/puff,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1222341000033110</td></tr><tr><td>Prescription Date</td><td>19-Jan-2006</td></tr><tr><td>Date Authorised Until</td><td>30-Apr-2007</td></tr><tr><td>Issue Date</td><td>29-Oct-2006</td></tr><tr><td>Number of Issues</td><td>3</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Kathleen Bray</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>17-Feb-2006</td></tr><tr><td>Record element identifier</td><td>4d38b5ed-c2db-4df7-8a98-61503d4f2387</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>19-Jan-2006</td><td><em>Clenil Modulite Cfc-free inhaler 100 micrograms/actuation,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>3943341000033113</td></tr><tr><td>Prescription Date</td><td>19-Jan-2006</td></tr><tr><td>Date Authorised Until</td><td>17-Feb-2007</td></tr><tr><td>Issue Date</td><td>18-Aug-2006</td></tr><tr><td>Number of Issues</td><td>5</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>19-Jan-2006</td></tr><tr><td>Record element identifier</td><td>463312c4-62ca-4bf2-967c-089a730ac91e</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>19-Jan-2006</td><td><em>Salbutamol Cfc-free inhaler 100 micrograms/puff,</em> TWO PUFFS UP TO FOUR TIMES A DAY WHEN REQUIRED.,1 inhaler</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1222341000033110</td></tr><tr><td>Prescription Date</td><td>19-Jan-2006</td></tr><tr><td>Date Authorised Until</td><td>30-Apr-2007</td></tr><tr><td>Issue Date</td><td>29-Oct-2006</td></tr><tr><td>Number of Issues</td><td>3</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>19-Jan-2006</td></tr><tr><td>Record element identifier</td><td>b52ee605-c2cd-48b1-9bcd-99931d9586ae</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>09-Dec-2005</td><td><em>Simvastatin Tablets 40 mg,</em> TAKE ONE DAILY,56 tablet</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>1337541000033111</td></tr><tr><td>Prescription Date</td><td>09-Dec-2005</td></tr><tr><td>Date Authorised Until</td><td>30-Dec-2006</td></tr><tr><td>Issue Date</td><td>04-Nov-2006</td></tr><tr><td>Number of Issues</td><td>6</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Current</td></tr><tr><td>Person recorded</td><td>Mrs Sharon Cook</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>09-Dec-2005</td></tr><tr><td>Record element identifier</td><td>4e4c7afd-adf8-4847-8a0c-45275e3ae4e4</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>13-Oct-2005</td><td><em>Atorvastatin Tablets 10 mg,</em> ONE AT NIGHT,56 TABLET(S)</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>91941000033117</td></tr><tr><td>Prescription Date</td><td>08-Jan-2004</td></tr><tr><td>Date Authorised Until</td><td>08-Dec-2005</td></tr><tr><td>Issue Date</td><td>13-Oct-2005</td></tr><tr><td>Number of Issues</td><td>11</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Kathleen Bray</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>13-Oct-2005</td></tr><tr><td>Record element identifier</td><td>89cfca23-dc66-4df5-a2b9-b864f98c4c4c</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>28-Aug-2005</td><td><em>Miconazole Nitrate Cream 2 %,</em> BD,30 Gram(s)</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>906741000033118</td></tr><tr><td>Prescription Date</td><td>28-Aug-2005</td></tr><tr><td>Date Authorised Until</td><td>28-Aug-2005</td></tr><tr><td>Issue Date</td><td>28-Aug-2005</td></tr><tr><td>Number of Issues</td><td>1</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Kathleen Bray</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>28-Aug-2005</td></tr><tr><td>Record element identifier</td><td>f5d9ed11-d35b-44fd-a5a6-e6489e227617</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr><tr><td>27-Aug-2005</td><td><em>Atorvastatin Tablets 10 mg,</em> ONE AT NIGHT,56 TABLET(S)</td></tr><tr><td></td><td><table><tbody><tr><td>Snomed code</td><td>91941000033117</td></tr><tr><td>Prescription Date</td><td>08-Jan-2004</td></tr><tr><td>Date Authorised Until</td><td>08-Dec-2005</td></tr><tr><td>Issue Date</td><td>13-Oct-2005</td></tr><tr><td>Number of Issues</td><td>11</td></tr><tr><td>Number of Authorised Issues</td><td>0</td></tr><tr><td>Additional Instructions</td><td>Not known</td></tr><tr><td>Status of medication</td><td>Past</td></tr><tr><td>Person recorded</td><td>Mrs Sharon Cook</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Time recorded</td><td>27-Aug-2005</td></tr><tr><td>Record element identifier</td><td>55643635-8800-4cca-b80e-e022f1ffd8d1</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>c51b8b6c-d923-4912-bf48-14a0c8e32258</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr></tbody></table></div></div></div></div>",
+  9000000084, "<table><th>Date</th><th>Entry</th><th>Value</th><th>Range</th><th>Details</th><tr><td>26 May 2003</td><td>Percentage basophils</td><td>1 %</td><td>0.000 and 2.000</td><td /></tr><tr><td>26 May 2003</td><td>Basophil count</td><td>0.1 10*9/L</td><td>0.000 and 0.100</td><td /></tr><tr><td>26 May 2003</td><td>Percentage eosinophils</td><td>3 %</td><td>0.000 and 7.000</td><td /></tr><tr><td>26 May 2003</td><td>Eosinophil count</td><td>0.2 10*9/L</td><td>0.000 and 0.400</td><td /></tr><tr><td>26 May 2003</td><td>Percentage monocytes</td><td>8 %</td><td>2.000 and 10.000</td><td /></tr><tr><td>26 May 2003</td><td>Monocyte count</td><td>0.5 10*9/L</td><td>0.200 and 0.800</td><td /></tr><tr><td>26 May 2003</td><td>Percentage lymphocytes</td><td>35 %</td><td>15.000 and 45.000</td><td /></tr><tr><td>26 May 2003</td><td>Lymphocyte count</td><td>2.4 10*9/L</td><td>1.000 and 4.000</td><td /></tr><tr><td>26 May 2003</td><td>Percentage neutrophils</td><td>54 %</td><td>40.000 and 75.000</td><td /></tr><tr><td>26 May 2003</td><td>Neutrophil count</td><td>3.8 10*9/L</td><td>2.000 and 7.500</td><td /></tr><tr><td>26 May 2003</td><td>Red blood cell distribution width</td><td>12.9 %</td><td>11.500 and 14.500</td><td /></tr><tr><td>26 May 2003</td><td>Mean corpusc. Hb. conc. (MCHC)</td><td>33.7 g/dL</td><td>31.500 and 35.000</td><td /></tr><tr><td>26 May 2003</td><td>Mean corpusc. haemoglobin(MCH)</td><td>31.7 pg</td><td>27.000 and 32.000</td><td /></tr><tr><td>26 May 2003</td><td>Mean corpuscular volume (MCV)</td><td>94 fL</td><td>80.000 and 100.000</td><td /></tr><tr><td>26 May 2003</td><td>Haematocrit</td><td>0.439 </td><td>0.400 and 0.500</td><td /></tr><tr><td>26 May 2003</td><td>Red blood cell (RBC) count</td><td>4.66 10*12/L</td><td>4.500 and 5.500</td><td /></tr><tr><td>26 May 2003</td><td>Platelet count</td><td>238 10*9/L</td><td>150.000 and 450.000</td><td /></tr><tr><td>26 May 2003</td><td>Total white cell count</td><td>7 10*9/L</td><td>4.000 and 11.000</td><td /></tr><tr><td>26 May 2003</td><td>Haemoglobin estimation</td><td>14.8 g/dL</td><td>13.000 and 18.000</td><td /></tr><tr><td>26 May 2003</td><td>Fasting blood glucose level</td><td>6.3 mmoL/L</td><td>3.600 and 6.100</td><td /></tr><tr><td>26 May 2003</td><td>Prostate specific antigen</td><td>0.83 ug/L</td><td /><td /></tr><tr><td>26 May 2003</td><td>Serum TSH level</td><td>2.77 mu/L</td><td>0.400 and 5.000</td><td /></tr><tr><td>26 May 2003</td><td>GFR calculated abbreviated MDRD</td><td /><td /><td>  Frusemide Tablets 40 mg od 28 tablets</td></tr><tr><td>26 May 2003</td><td>Serum cholesterol/HDL ratio</td><td>6 </td><td /><td /></tr><tr><td>26 May 2003</td><td>Serum LDL cholesterol level</td><td>4 mmol/L</td><td /><td /></tr><tr><td>26 May 2003</td><td>Serum HDL cholesterol level</td><td>1.1 mmol/L</td><td>0.700 and 1.900</td><td /></tr><tr><td>26 May 2003</td><td>Serum triglycerides</td><td>3.3 mmol/L</td><td>0.400 and 2.300</td><td /></tr><tr><td>26 May 2003</td><td>Serum total cholesterol level</td><td>6.6 mmol/L</td><td>3.600 and 5.700</td><td /></tr><tr><td>26 May 2003</td><td>Serum albumin</td><td>43 g/L</td><td>35.000 and 50.000</td><td /></tr><tr><td>26 May 2003</td><td>Serum alkaline phosphatase</td><td>84 u/L</td><td>30.000 and 150.000</td><td /></tr><tr><td>26 May 2003</td><td>Serum alanine aminotransferase level</td><td>35 u/L</td><td>10.000 and 35.000</td><td /></tr><tr><td>26 May 2003</td><td>Serum total bilirubin level</td><td>10 umol/L</td><td>3.000 and 21.000</td><td /></tr><tr><td>26 May 2003</td><td>Serum urea level</td><td>6.6 mmol/L</td><td>2.500 and 6.700</td><td /></tr><tr><td>26 May 2003</td><td>Serum creatinine</td><td>77 umol/L</td><td>62.000 and 115.000</td><td /></tr><tr><td>26 May 2003</td><td>Serum potassium</td><td>4.5 mmol/L</td><td>3.500 and 5.400</td><td /></tr><tr><td>26 May 2003</td><td>Serum sodium</td><td>141 mmol/L</td><td>136.000 and 145.000</td><td /></tr><tr><td>26 May 2003</td><td>anti-HBs</td><td /><td /><td>  Awaiting MRI scan to look at anatomy</td></tr><tr><td>12 Jun 2002</td><td>Helicobacter blood test</td><td /><td /><td>  Reversibility with Salamol EB 200mcgs</td></tr><tr><td>11 Jun 2002</td><td>Plasma glucose level</td><td>6.5 mmol/L</td><td /><td /></tr><tr><td>11 Jun 2002</td><td>Serum urate level</td><td>0.34 mmol/L</td><td>0.210 and 0.400</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum TSH level</td><td>1.62 mu/L</td><td>0.400 and 5.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum lactate dehydrogenase level</td><td>221 u/L</td><td>125.000 and 243.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum creatine kinase level</td><td>77 u/L</td><td>30.000 and 200.000</td><td /></tr><tr><td>11 Jun 2002</td><td>GFR calculated abbreviated MDRD</td><td>84 ml/min</td><td /><td /></tr><tr><td>11 Jun 2002</td><td>Total cholesterol:HDL ratio</td><td>5.3 </td><td /><td /></tr><tr><td>11 Jun 2002</td><td>Serum LDL cholesterol level</td><td>3.9 mmol/L</td><td /><td /></tr><tr><td>11 Jun 2002</td><td>Serum HDL cholesterol level</td><td>1.1 mmol/L</td><td>0.700 and 1.900</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum triglycerides</td><td>1.7 mmol/L</td><td>0.400 and 2.300</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum total cholesterol level</td><td>5.8 mmol/L</td><td>3.600 and 5.700</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum albumin</td><td>41 g/L</td><td>30.000 and 48.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum alkaline phosphatase</td><td>84 u/L</td><td>30.000 and 150.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum alanine aminotransferase level</td><td>28 u/L</td><td>10.000 and 35.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum total bilirubin level</td><td>11 umol/L</td><td>3.000 and 21.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum urea level</td><td>4.4 mmol/L</td><td>2.500 and 6.700</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum creatinine</td><td>89 umol/L</td><td>62.000 and 115.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum potassium</td><td>4.6 mmoL/L</td><td>3.500 and 5.100</td><td /></tr><tr><td>11 Jun 2002</td><td>Serum sodium</td><td>142 mmol/L</td><td>136.000 and 145.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Percentage basophils</td><td>1 %</td><td>0.000 and 2.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Basophil count</td><td>0.1 10*9/L</td><td>0.000 and 0.100</td><td /></tr><tr><td>11 Jun 2002</td><td>Percentage eosinophils</td><td>3 %</td><td>0.000 and 7.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Eosinophil count</td><td>0.2 10*9/L</td><td>0.000 and 0.400</td><td /></tr><tr><td>11 Jun 2002</td><td>Percentage monocytes</td><td>7 %</td><td>2.000 and 10.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Monocyte count</td><td>0.5 10*9/L</td><td>0.200 and 0.800</td><td /></tr><tr><td>11 Jun 2002</td><td>Percentage lymphocytes</td><td>33 %</td><td>15.000 and 45.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Lymphocyte count</td><td>2.3 10*9/L</td><td>1.000 and 4.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Percentage neutrophils</td><td>56 %</td><td>40.000 and 75.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Neutrophil count</td><td>4 10*9/L</td><td>2.000 and 7.500</td><td /></tr><tr><td>11 Jun 2002</td><td>Red blood cell distribution width</td><td>12.3 %</td><td>11.500 and 14.500</td><td /></tr><tr><td>11 Jun 2002</td><td>Mean corpusc. Hb. conc. (MCHC)</td><td>33.5 g/dL</td><td>31.500 and 35.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Mean corpusc. haemoglobin(MCH)</td><td>31.6 pg</td><td>27.000 and 32.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Mean corpuscular volume (MCV)</td><td>95 fL</td><td>80.000 and 100.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Haematocrit</td><td>0.443 </td><td>0.400 and 0.500</td><td /></tr><tr><td>11 Jun 2002</td><td>Red blood cell (RBC) count</td><td>4.69 10*12/L</td><td>4.500 and 5.500</td><td /></tr><tr><td>11 Jun 2002</td><td>Platelet count</td><td>239 10*9/L</td><td>150.000 and 450.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Total white cell count</td><td>7.1 10*9/L</td><td>4.000 and 11.000</td><td /></tr><tr><td>11 Jun 2002</td><td>Haemoglobin estimation</td><td>14.8 g/dL</td><td>13.000 and 18.000</td><td /></tr><tr><td>27 May 2002</td><td>Helicobacter blood test</td><td /><td /><td>  Scanty coase creps</td></tr><tr><td>25 May 2002</td><td>REJECTED BIOCHEMISTRY</td><td /><td /><td>  Diarrhoea disappeared</td></tr><tr><td>14 May 2002</td><td>Percentage basophils</td><td>1 %</td><td>0.000 and 2.000</td><td /></tr><tr><td>14 May 2002</td><td>Basophil count</td><td>0.1 10*9/L</td><td>0.000 and 0.100</td><td /></tr><tr><td>14 May 2002</td><td>Percentage eosinophils</td><td>2 %</td><td>0.000 and 7.000</td><td /></tr><tr><td>14 May 2002</td><td>Eosinophil count</td><td>0.1 10*9/L</td><td>0.000 and 0.400</td><td /></tr><tr><td>14 May 2002</td><td>Percentage monocytes</td><td>8 %</td><td>2.000 and 10.000</td><td /></tr><tr><td>14 May 2002</td><td>Monocyte count</td><td>0.6 10*9/L</td><td>0.200 and 0.800</td><td /></tr><tr><td>14 May 2002</td><td>Percentage lymphocytes</td><td>35 %</td><td>15.000 and 45.000</td><td /></tr><tr><td>14 May 2002</td><td>Lymphocyte count</td><td>2.4 10*9/L</td><td>1.000 and 4.000</td><td /></tr><tr><td>14 May 2002</td><td>Percentage neutrophils</td><td>54 %</td><td>40.000 and 75.000</td><td /></tr><tr><td>14 May 2002</td><td>Neutrophil count</td><td>3.7 10*9/L</td><td>2.000 and 7.500</td><td /></tr><tr><td>14 May 2002</td><td>Red blood cell distribution width</td><td>12.5 %</td><td>11.500 and 14.500</td><td /></tr><tr><td>14 May 2002</td><td>Mean corpusc. Hb. conc. (MCHC)</td><td>34.6 g/dL</td><td>31.500 and 34.500</td><td /></tr><tr><td>14 May 2002</td><td>Mean corpusc. haemoglobin(MCH)</td><td>32.2 pg</td><td>27.000 and 32.000</td><td /></tr><tr><td>14 May 2002</td><td>Mean corpuscular volume (MCV)</td><td>93 fL</td><td>80.000 and 96.000</td><td /></tr><tr><td>14 May 2002</td><td>Haematocrit</td><td>0.427 </td><td>0.400 and 0.500</td><td /></tr><tr><td>14 May 2002</td><td>Red blood cell (RBC) count</td><td>4.59 10*12/L</td><td>4.200 and 6.500</td><td /></tr><tr><td>14 May 2002</td><td>Platelet count</td><td>231 10*9/L</td><td>150.000 and 450.000</td><td /></tr><tr><td>14 May 2002</td><td>Total white cell count</td><td>6.9 10*9/L</td><td>4.000 and 11.000</td><td /></tr><tr><td>14 May 2002</td><td>Haemoglobin estimation</td><td>14.8 g/dL</td><td>13.000 and 18.000</td><td /></tr><tr><td>14 May 2002</td><td>REJECTED BIOCHEMISTRY</td><td /><td /><td>  Still feels like thick mucous from chest - causing choking</td></tr><tr><td>13 Jun 2000</td><td>Systolic blood pressure</td><td>140 mm Hg</td><td /><td /></tr><tr><td>13 Jun 2000</td><td>Diastolic blood pressure</td><td>84 mm Hg</td><td /><td /></tr></table>",
   "EMIS",
-  '2016-08-24 12:00:00'
+  '2016-07-25 12:00:00'
 );
+
 
 INSERT INTO gpconnect.problems
   (id, html, provider, lastUpdated)
 VALUES (
-  9000000084,
-  "<div><div><div><div><span>Current Problems</span></div><div><table><tbody><tr><td>14-Jan-2013</td><td><em>Adverse reaction to aspirin</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>465251000006116</td></tr><tr><td>Time recorded</td><td>14-Jan-2013 15:13:27</td></tr><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Significant</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>3bcdfe6f-becf-480d-bae7-e640fc007066</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>14-Jan-2013</td><td><em>Lasting power of attorney personal welfare</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>635331000000116</td></tr><tr><td>Time recorded</td><td>14-Jan-2013 12:10:02</td></tr><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Significant</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>150d6b10-d5f4-48d3-b6f4-e195c23f2bd0</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>14-Jan-2013</td><td><em>Blindness and low vision</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>515791000006112</td></tr><tr><td>Time recorded</td><td>14-Jan-2013 12:07:40</td></tr><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Significant</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>35311104-40fe-403f-a0f6-dba5d1affd83</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>14-Dec-2012</td><td><em>Blood pH abnormal</em> : slightly acidic</td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>259499019</td></tr><tr><td>Time recorded</td><td>14-Dec-2012 16:09:27</td></tr><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Significant</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>469f705f-2920-4c5e-aed7-ea60b1c21fcc</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>08-Jan-2004</td><td><em>Pure hypercholesterolaemia</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>398852019</td></tr><tr><td>Time recorded</td><td>05-Dec-2005</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Significant</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>d1477923-4a8e-4694-94a1-2c215d6ae625</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>08-Jan-2004</td><td><em>Chronic obstructive pulmonary disease</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>475431013</td></tr><tr><td>Time recorded</td><td>05-Dec-2005</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Significant</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>c2f719b9-73ad-44b8-8bbd-f662bab84417</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>Not Known</td><td><em>Asthma</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>301485011</td></tr><tr><td>Time recorded</td><td>17-Dec-2007</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Significant</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>dcfd0d43-a8f8-4d78-950e-d7d6204ec0ed</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr></tbody></table></div></div><div><div><span>Past Problems</span></div><div><table><tbody><tr><td>14-Jan-2013</td><td><em>Dog allergy</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>634501000000119</td></tr><tr><td>Time recorded</td><td>14-Jan-2013 15:13:42</td></tr><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Minor</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>8d77288e-3550-4850-82ac-a68ad904653e</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>14-Dec-2012</td><td><em>Accidental burning or scalding caused by chocolate</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>446041000006112</td></tr><tr><td>Time recorded</td><td>14-Dec-2012 11:18:43</td></tr><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Minor</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>0ed92cde-55e3-4efc-bb9f-380e1d7456a6</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>16-Jul-2005</td><td><em>Fungal infection of skin</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>797031000006118</td></tr><tr><td>Time recorded</td><td>13-Jun-2007</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Minor</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>1f7d4261-4fc4-4213-aabc-fca32ec45032</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>21-Oct-2004</td><td><em>Obesity</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>2535065012</td></tr><tr><td>Time recorded</td><td>18-Sep-2006</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Minor</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>2786f6d7-cfd1-4c3b-82fd-756084c956e8</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>05-Dec-2003</td><td><em>Chest infection</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>546411000006111</td></tr><tr><td>Time recorded</td><td>01-Nov-2005</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Minor</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>ecbc2be0-2344-4eae-a3d1-497d3003679d</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>21-Mar-2003</td><td><em>Chronic obstructive pulmonary disease</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>475431013</td></tr><tr><td>Time recorded</td><td>15-Feb-2005</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Minor</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>9b9609cf-e0b2-4f3e-b363-3e9bae1d591a</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>2000</td><td><em>Acute exacerbation of asthma</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>419211018</td></tr><tr><td>Time recorded</td><td>09-Jun-2004</td></tr><tr><td>Person recorded</td><td>Mrs Sharon Cook</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Significant</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>be1d1d86-4bad-4cfa-b0a5-35fbab324a3c</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>2000</td><td><em>Motor vehicle traffic accidents (MVTA)</em> : Chest OK. Pretty good at the moment</td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>697351000006117</td></tr><tr><td>Time recorded</td><td>09-Jun-2004</td></tr><tr><td>Person recorded</td><td>Mrs Sharon Cook</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Significant</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>11c0e36b-076c-4437-8641-42a5170bc98a</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>1999</td><td><em>Motor vehicle traffic accidents (MVTA)</em> : Chest OK. Pretty good at the moment</td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>697351000006117</td></tr><tr><td>Time recorded</td><td>09-Jun-2004</td></tr><tr><td>Person recorded</td><td>Mrs Sharon Cook</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Significant</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>5360f7d8-a323-47d1-a40b-089995ec5a02</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>17-Apr-1997</td><td><em>Asthma</em> : Try 10 days oral steroids and see friday week</td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>301485011</td></tr><tr><td>Time recorded</td><td>15-Mar-2004</td></tr><tr><td>Person recorded</td><td>Miss Maureen Whitehouse</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Significant</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>45cb1617-4152-4199-a9ab-be0d4f09f283</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>1992</td><td><em>Motor vehicle traffic accidents (MVTA)</em></td></tr><tr><td/><td><table><tbody><tr><td>Snomed code</td><td>697351000006117</td></tr><tr><td>Time recorded</td><td>09-Jun-2004</td></tr><tr><td>Person recorded</td><td>Mrs Sharon Cook</td></tr><tr><td>Role of person</td><td>Clerical Worker</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td>Significant</td></tr><tr><td>Linked medication</td><td/></tr><tr><td>Linked problems</td><td/></tr><tr><td>Record element identifier</td><td>dbe5732c-c4ef-4f26-8b21-2a82c9ac0041</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>83bd81fc-824c-4b4d-a7f3-deb71e24aa27</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr></tbody></table></div></div></div></div>",
+  9000000084, "<div><h2>Active Problems</h2><table><tbody><tr><th>Start Date</th><th>Entry</th><th>Significance</th><th>Details</th></tr><tr><td>03 Oct 2016</td><td>This is confidential</td><td /><td /></tr><tr><td>29 Sep 2016</td><td>This is confidential</td><td /><td /></tr></tbody></table><h2>Inactive Problems</h2><table><tbody><tr><th>Start Date</th><th>End Date</th><th>Entry</th><th>Significance</th><th>Details</th></tr><tr><td>02 Oct 1988</td><td>02 Oct 1988</td><td>Trigger finger - acquired -  Still coughing up some thick globules phlegm - leading again to choking</td><td> Major</td><td><br />Episodicity : FIRST</td></tr><tr><td>17 Jul 1988</td><td>17 Jul 1988</td><td>Cardiological referral -  Try 10 days oral steroids and see friday week</td><td> Major</td><td><br />Episodicity : FIRST</td></tr><tr><td>17 Jul 1988</td><td>17 Jul 1988</td><td>Right bundle branch block</td><td> Major</td><td><br />Episodicity : FIRST</td></tr><tr><td>17 Jul 1988</td><td>17 Jul 1988</td><td>This is confidential</td><td /><td /></tr><tr><td>04 Jul 1988</td><td>04 Jul 1988</td><td>Meibomian cyst infected</td><td> Major</td><td><br />Episodicity : FIRST</td></tr><tr><td>31 Jan 1982</td><td>31 Jan 1982</td><td>Motor vehicle traffic accidents (MVTA)</td><td> Major</td><td><br />Episodicity : FIRST</td></tr></tbody></table></div>",
   "EMIS",
   '2016-08-24 12:00:00'
 );

INSERT INTO gpconnect.clinicalitems
  (id, html, provider, lastUpdated)
VALUES (
  9000000084,
  "<div><div><div><span>Examinations</span></div><div><table><tbody><tr><td>19-Jan-2006</td><td><em>O/E Blood Pressure Reading</em></td><td>110/79 mm Hg</td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>254063019</td></tr><tr><td>Time recorded</td><td>20-Nov-2008 16:16:12</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>fe7edddd-326c-756c-62d6-d49935cbe1b1</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>3c7eacf9-1fa6-4242-82e3-6dc559b206ac</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>17-Jul-2005</td><td><em>O/E Blood Pressure Reading</em></td><td>103/61 mm Hg</td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>254063019</td></tr><tr><td>Time recorded</td><td>20-Nov-2008 16:16:13</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>e2684816-ac85-b057-f776-14510b65e1fc</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>3c7eacf9-1fa6-4242-82e3-6dc559b206ac</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>16-Jul-2005</td><td><em>O/E Blood Pressure Reading</em></td><td>103/61 mm Hg</td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>254063019</td></tr><tr><td>Time recorded</td><td>20-Nov-2008 16:16:12</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>95a7be9d-1a9a-e25c-da2c-a0239f4986d2</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>3c7eacf9-1fa6-4242-82e3-6dc559b206ac</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>22-Oct-2004</td><td><em>O/E Blood Pressure Reading</em></td><td>104/70 mm Hg</td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>254063019</td></tr><tr><td>Time recorded</td><td>20-Nov-2008 16:16:13</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>e698a925-dbfe-038f-0cb1-0ba4f0f3d1c4</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>3c7eacf9-1fa6-4242-82e3-6dc559b206ac</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>21-Oct-2004</td><td><em>O/E Blood Pressure Reading</em></td><td>104/70 mm Hg</td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>254063019</td></tr><tr><td>Time recorded</td><td>20-Nov-2008 16:16:12</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>d4a33bf2-4839-912f-b948-a05d43232bf0</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>3c7eacf9-1fa6-4242-82e3-6dc559b206ac</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>08-Jan-2004</td><td><em>O/E Blood Pressure Reading</em></td><td>102/75 mm Hg</td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>254063019</td></tr><tr><td>Time recorded</td><td>20-Nov-2008 16:16:11</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>8f225f5a-e77b-f358-1a88-dfa4a2e625d7</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>3c7eacf9-1fa6-4242-82e3-6dc559b206ac</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>21-Mar-2003</td><td><em>O/E Blood Pressure Reading</em></td><td>116/76 mm Hg</td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>254063019</td></tr><tr><td>Time recorded</td><td>20-Nov-2008 16:16:11</td></tr><tr><td>Person recorded</td><td>Mrs Victoria Herbert</td></tr><tr><td>Role of person</td><td>Community Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>3899330f-cc48-cf00-88a6-8233b00d6673</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>3c7eacf9-1fa6-4242-82e3-6dc559b206ac</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr><tr><td>09-Mar-2003</td><td><em>O/E Blood Pressure Reading</em></td><td>116/82 mm Hg</td></tr><tr><td /><td><table><tbody><tr><td>Snomed code</td><td>254063019</td></tr><tr><td>Time recorded</td><td>20-Nov-2008 16:16:11</td></tr><tr><td>Person recorded</td><td>Dr Robert Burns</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Significance</td><td /></tr><tr><td>Linked medication</td><td /></tr><tr><td>Linked problems</td><td /></tr><tr><td>Record element identifier</td><td>b7231046-e65a-8429-c1a2-6bd86808704f</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>3c7eacf9-1fa6-4242-82e3-6dc559b206ac</td></tr><tr><td>Extract time</td><td>08-Apr-2013</td></tr></tbody></table></td></tr></tbody></table></div></div></div>",
  "EMIS",
  '2016-08-24 12:00:00'
);

  (id, html, provider, lastUpdated)
VALUES (
  9000000084,
  "<div><h2>Current Allergies and Sensitivities</h2><table><tbody><tr><th>Start date</th><th>Details</th></tr><tr><td>03 Oct 2016</td><td>This is confidential</td></tr></tbody></table></div>",
  "EMIS",
  '2016-08-24 12:00:00'
);
