L Log table: Difference between revisions

Revision as of 09:44, 22 October 2012 view source Ttenbergen (talk \| contribs) CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators 92,362 edits mNo edit summary ← Older edit		Revision as of 09:44, 22 October 2012 view source Ttenbergen (talk \| contribs) CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators 92,362 edits mNo edit summary Newer edit →
Line 1:		Line 1:
	'''L_Log''' is the main table where the basic patient information is stored. An entry is needed in L_Log in order to makes sense of entries in the other [[L ~~files~~]].		'''L_Log''' is the main table where the basic patient information is stored. An entry is needed in L_Log in order to makes sense of entries in the other [[L-tables]].

	As of [[CCMDB.mdb_Change_Log_2012#ver_2012-10-19\|ver_2012-10-19]] the data for y/n drugs for [[pharmacy collection]] is also stored in L_Log. Each patient will have a yes or no for each of them, so from a relational data perspective it made sense to put them there.		As of [[CCMDB.mdb_Change_Log_2012#ver_2012-10-19\|ver_2012-10-19]] the data for y/n drugs for [[pharmacy collection]] is also stored in L_Log. Each patient will have a yes or no for each of them, so from a relational data perspective it made sense to put them there.