L Pharm Flowsheet table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
No 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
 
{{Discussion}}
*Collectors are having a hard time with the current pharmacy entry screen on laptop.  The list of drugs is vertical and makes veiwing and entry difficult.  Hard on neck, have to put laptop on its side to see drug.  Even when drugs list on angle, too many on list and it is hard to line up drug with correct field that the count should go in.  Tina or Fred, is there another way the set up pharm list so that it is more ergonomically better for viewing and entering.--[[User:TOstryzniuk|Trish Ostryzniuk]] 18:40, 2012 October 11 (CDT)
**An alternative approach would be to list all the drugs in a series of columns with drug label to the left and data entry field following, e.g., Heparin SQ: [__________]. This approach would take up more space on the form but I think it is doable. I'll mock up a prototype today and send it to you. -- [[User:Fschumacher|Fred Schumacher]] 08:43, 2012 October 12 (CDT)
***Collectors: An email was sent today Oct 12.12 showing a mock up of a change to pharmacy screen for viewing and entry.  Please comment here what you think of new idea.[[User:TOstryzniuk|Trish Ostryzniuk]] 11:15, 2012 October 12 (CDT)
*Having a difficult time trying to imagine this new format when I open it up. I can see it more clearly which is a plus. But why the big empty space to enter the number of days? And can we have yes or no for the drugs we don’t count the days for ? Thanks Shirley Not all the drugs are entered so I don’t know if it more user friendly.-[[User: SKiesman | Shirley Kiesman]]
 
 
 




Revision as of 16:10, 2012 October 12

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
Retrieved from "https://ccmdb.kuality.ca/index.php?title=L_Pharm_Flowsheet_table&oldid=29127"