L Log table

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.

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.