S group table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| Line 21: | Line 21: | ||
|} | |} | ||
[[Category: Data structure]] | [[Category:Data structure]] | ||
[[Category: DSM Labs Extract]] | [[Category:DSM Labs Extract]] | ||
Latest revision as of 11:05, 30 July 2025
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 |