S group table
The S_group table in DSM Labs Consistency check.accdb contains the possible values of lab groupings as imported from DSM. See Lab identification in the DSM data#group of records for more info how it is used.
Data Structure
| field | type | description |
|---|---|---|
| GRPTEST | text | value in DSM Lab Extract |
| GRPDESC | text | value in DSM Lab Extract |
| count | long integer | count of labs, usually in the first batch where this lab was seen; inconsistently filled out, we could get rid of it. |
| used | yes/no | determines whether the lab will actually be imported |
| our_group | text | name in lab column in L_Labs_DSM table |
| added_dt | Date/Time | DtTm the group was added; blank if it was added on original import |