HSC Labs RE-import 2015-07

There is some HSC Lab data that was downloaded into TMSX after we did our final upload to CFE of the whole of TMSX. So, we need to import this into CFE.

We did an initial import of the remaining doanloadable HSC lab data that was downl

labs that were imported

According to Labs_-_Legacy_Article#HSC_used_to_be_downloaded the following were downloaded. dupilcating here only to format with what they are called in L_Labs_Flowsheet.

CBC, PT_PTT, Creatinine, MG, SGPT_ALT, Troponin, Sputum_CS, Urine_CS, ABG

Historical

There was an initial attempt to import this data, but it contained wrong data. The values that were imported all had D_Labs_Flowsheet_ID ending in "_i2014-12-30". 2015-07-20 We will run the following query to eliminate these prior to a corrected import:

DELETE L_Labs_Flowsheet.D_Labs_Flowsheet_ID
FROM L_Labs_Flowsheet
WHERE (((InStr([D_Labs_Flowsheet_ID],"_i2014-12-30")>0)=True));