S group table

From CCMDB Wiki
Jump to navigationJump to search

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