L Pharm Flowsheet table: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) mNo edit summary |
TOstryzniuk (talk | contribs) 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 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. | ||
== Data Structure == | == Data Structure == | ||
Revision as of 16:58, 28 February 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.
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 datastructure, hopefully this will minimize need of doing that.
Legacy
- this will replace the L_Pharm table as of early 2012