S mapping lab table

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