L Log table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| 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 | '''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. | ||
Revision as of 09:44, 22 October 2012
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 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.
Data Structure
To see the data structure of this table, see most up-to-date ccmdb_data.mdb in Regional Server\data\Master CCMDB.mdb.