Pharmacy.mdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
TOstryzniuk (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
The access file [[Regional Server]]\Output\Pharmacy.mdb will be the data store for [[Pharmacy collection]] as of 2012-01-01. | The access file [[Regional Server]]\Output\Pharmacy.mdb will be the data store for [[Pharmacy collection]] as of 2012-01-01. | ||
When [[sending]] patients, data from the [[L_Pharm_Flowsheet]] table for all | When [[sending]] patients, data from the [[L_Pharm_Flowsheet]] table for all patients being sent (i.e. patients with FinalCheck true) will be appended to the table '''pharmacy''' by the query '''Send_Pharmacy''' in [[CCMDB.mdb]]. | ||
*currently the Pharmacy items SENT in for each patient does not show up in your EXCEL sheet | |||
[[Category:Data Repository]] | [[Category:Data Repository]] | ||
[[Category:Pharmacy]] | [[Category:Pharmacy]] |
Revision as of 13:38, 2012 February 29
The access file Regional Server\Output\Pharmacy.mdb will be the data store for Pharmacy collection as of 2012-01-01.
When sending patients, data from the L_Pharm_Flowsheet table for all patients being sent (i.e. patients with FinalCheck true) will be appended to the table pharmacy by the query Send_Pharmacy in CCMDB.mdb.
- currently the Pharmacy items SENT in for each patient does not show up in your EXCEL sheet