HSC Labs RE-import 2015-07: Difference between revisions

(12 intermediate revisions by 2 users not shown)

Line 1:

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~~

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

~~According~~ to [[~~:Category:Legacy Labs~~]] ~~the following were downloaded.~~

== Import ==

* got data exported by Pagasa from TMSX 2015-07-20, {{S:\MED\MED_CCMED}}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.accdb]]_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:

Line 14:

Line 23:

[[Category:Legacy Labs]]

[[Category: Legacy Labs]]

@@ Line 1: / Line 1: @@
 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
+Initial import went wrong and was reverted, see [[#wrong first import]].
-According to [[:Category:Legacy Labs]] the following were downloaded.
+== Import ==
+* got data exported by Pagasa from TMSX 2015-07-20, {{S:\MED\MED_CCMED}}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.accdb]]_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".
 -07-20 We will run the following query to eliminate these prior to a corrected import:
@@ Line 14: / Line 23: @@
+[[Category:Legacy Labs]]
-[[Category: Legacy Labs]]