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
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
firstcount	type	count in the first set of data where this was encountered
date_listed	Yes/No	date lab test was first encountered and included in the list