S group table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m m |
Ttenbergen (talk | contribs) m link fix |
||
| Line 16: | Line 16: | ||
|| '''used''' || yes/no || determines whether the lab will actually be imported | || '''used''' || yes/no || determines whether the lab will actually be imported | ||
|- | |- | ||
|| '''our_group''' || text || | || '''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 | || '''added_dt''' || Date/Time || DtTm the group was added; blank if it was added on original import | ||
Revision as of 13:09, 2017 September 12
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 |