S group table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The ''' | {{DISPLAYTITLE:s_group table}}The '''s_group''' table in [[DSM Labs Consistency check.accdb]] contains the possible values of lab '''[[Lab identification in the DSM data#group of records|groupings]]''' as imported from DSM. See [[Lab identification in the DSM data#group of records]] for more info how it is used. | ||
== Data Structure == | == Data Structure == | ||
| Line 8: | Line 8: | ||
!| description | !| description | ||
|- | |- | ||
|| '''GRPTEST''' || text || value in | || '''GRPTEST''' || text || value in [[DSM Lab Extract]] | ||
|- | |- | ||
|| '''GRPDESC''' || text || value in | || '''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. | || '''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. | ||
| 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 || lab | || '''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 | ||
Latest revision as of 15:23, 2023 May 17
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 |