L Pharm Flowsheet table: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) No edit summary |
Fschumacher (talk | contribs) No edit summary |
||
| Line 2: | Line 2: | ||
{{Discussion}} | {{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 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) | *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 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) | |||
== Data Structure == | == Data Structure == | ||
Revision as of 08:43, 12 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.
- 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 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.--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. -- Fred Schumacher 08:43, 2012 October 12 (CDT)
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