S mapping lab table

From CCMDB Wiki
Jump to navigationJump to search

The S_mapping_lab table in DSM Labs Consistency check.accdb contains the possible values of individual labs as imported from DSM. See Lab identification in the DSM data#individual record for more info how it is used.

Data Structure

field type description
Our_Lab_Name text destination column in L_Labs_DSM table
Their_Lab_Name text value in DSM Lab Extract
testCode type value in DSM Lab Extract
lastcount type count in the first set of data where this was encountered
admin Yes/No administrative only, was used during initial decisions which to include
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