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
|