L Pharm Flowsheet table

The L_Pharm_Flowsheet table contains the data we collect in the CCMDB.mdb about the frequency at which certain drugs are used in the ICU setting. The new tab was added to CCMDB.mdb for the new Pharmacy collection process which started January 1, 2012 for all Critical Care units in the Region

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.

Spares

Added spare1 - spare6 to table before rolling out to collectors in anticipation of future changes. Easy to add to form and to send procedure, much more complicated to add to local data structure, hopefully this will minimize need of doing that.

Legacy

• this will replace the L_Pharm table as of January 1, 2012