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
|