L Pharm Flowsheet table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
mNo edit summary
Line 1: Line 1:
The '''L_Pharm_Flowsheet''' table contains the data we collect in the [[CCMDB.mdb]] about the frequency at which certain [[Drugs Collected | 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
The '''L_Pharm_Flowsheet''' table contains the data we collect in the [[CCMDB.mdb]] about the frequency at which certain [[Drugs Collected | 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


Go to: [http://ccmdb.kuality.ca/index.php/Pharmacy_collection#size_and_orientation_of_labels Issue with current orientation of pharm lables]
Go to: [[Pharmacy_collection#size_and_orientation_of_labels | Issue with current orientation of pharm labels]]


== Data Structure ==
== Data Structure ==

Revision as of 09:02, 15 October 2012

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

Go to: Issue with current orientation of pharm labels

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