S mapping lab table: Difference between revisions

Newer edit →

@@ Line 8: / Line 8: @@
 !| description
 |-
-|| '''GRPTEST''' || text ||
+|| Our_Lab_Name || text || destination column in [[L Labs Flowsheet DSM table]]
 |-
-|| '''GRPDESC''' || text  ||
+|| Their_Lab_Name || text ||  value in [[DSM Lab Extract]]
 |-
-|| '''count''' || long integer ||
+|| testCode || type ||  value in [[DSM Lab Extract]]
 |-
-|| '''used''' || yes/no ||
+|| lastcount || type || count in the first set of data where this was encountered
 |-
-|| '''our_group''' || text ||
+|| admin || Yes/No||  administrative only, was used during initial decisions which to include
 |-
-|| '''added_dt''' || Date/Time ||
+|| unlikely || Yes/No|| administrative only, was used during initial decisions which to include
+|-
+|| date_listed || Yes/No||  date lab test was first encountered and included in the list
+|-
+|| CBC || Yes/No||
+|-
+|| PT || Yes/No||
+|-
+|| PTT || Yes/No||
+|-
+|| INR || Yes/No||
+|-
+|| Creatinine || Yes/No||
+|-
+|| MG || Yes/No ||
+|-
+|| SGPT_ALT || Yes/No||
+|-
+|| Troponin || Yes/No||
+|-
+|| ABG || Yes/No||  not used, not consistenly available in DSM data
+|-
+|| Sputum_CS || Yes/No|| not used, see [[S group table]]
+|-
+|| Blood_CS || Yes/No||  not used, see [[S group table]]
+|-
+|| Urine_CS || Yes/No||  not used, see [[S group table]]
+|-
+|| __APACHE_RELATED__ || text || just a separator for the set of columns
+|-
+|| AaDO2 || Yes/No|| not used (that would be messy)
+|-
+|| Arterial_pH || Yes/No||  not used
+|-
+|| PO2 || Yes/No||  not used
+|-
+|| SerCO2 || Yes/No||  not used
+|-
+|| Na || Yes/No||  not used
+|-
+|| K || Yes/No||  not used
+|-
+|| CREAT || Yes/No|| Apache Creatinine, likely same as Creatinine
+|-
+|| HCT || Yes/No|| See CBC above? HCT%...
+|-
+|| WBC || Yes/No||  not used
+|-
+|| __Garland__ || text|| separator for the items Dr Garland initially wanted to discuss
+|-
+|| Lactate || Yes/No || item Dr Garland initially wanted to include
 |}
 [[Category: Data structure]]
 [[Category: DSM Labs Extract]]