HSC Labs RE-import 2015-07

From CCMDB Wiki
Revision as of 09:32, 2020 July 24 by Ttenbergen (talk | contribs) (Text replacement - "Patient ID" to "Pat ID")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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.

Initial import went wrong and was reverted, see #wrong first import.

Import

  • got data exported by Pagasa from TMSX 2015-07-20, X:\CCMDB\HSC Lab imports\2015-07-20 (lab Export Ed's study number: 88922-99600)
  • found 1 record for which no counterpart existed in L_Log:
    • Study 98631, Location HSC_IICU, post import so Study# not in L_Log, but found corresponding Pat ID with HSC_SICU-18766 so changed imported data to that.
  • removed old import and re-imported with new parameters, see Centralized_data.mdb_Change_Log#2015-Jul-22 Ttenbergen 12:32, 2015 July 22 (CDT)

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, Blood_CS, Urine_CS, ABG

Historical

wrong first import

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));