S group table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m |
Ttenbergen (talk | contribs) m m |
||
| 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 || | || '''our_group''' || text || destination column in [[L Labs Flowsheet 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 10:21, 2017 August 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 | destination column in L Labs Flowsheet DSM table |
| added_dt | Date/Time | DtTm the group was added; blank if it was added on original import |