Pharmacy.mdb: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) mNo edit summary |
TOstryzniuk (talk | contribs) mNo edit summary |
||
| Line 3: | Line 3: | ||
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]]. | 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 | *currently the Pharmacy items SENT in for each patient does not show up in your EXCEL sheet. The EXCEL sent sheet is the one that shows what values were sent under each column of data for each patient. | ||
[[Category:Data Repository]] | [[Category:Data Repository]] | ||
[[Category:Pharmacy]] | [[Category:Pharmacy]] | ||
Revision as of 13:52, 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. The EXCEL sent sheet is the one that shows what values were sent under each column of data for each patient.