S group table: Difference between revisions

Revision as of 16:23, 17 May 2023

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.

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

Revision as of 14:09, 12 September 2017 view source Ttenbergen (talk \| contribs) CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators 92,574 edits m link fix ← Older edit		Revision as of 16:23, 17 May 2023 view source Ttenbergen (talk \| contribs) CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators 92,574 edits mNo edit summary Newer edit →
Line 1:		Line 1:
	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.		{{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 ==