s_mapping_lab table
Jump to navigation
Jump 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 |
| 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 |