Pharmacy.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (removing send info relevant to collectors, adding to Editing Pharmacy collection)
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{LegacyContent
|explanation=The [[Pharmacy collection]] data is now stored in [[Centralized_data.mdb]].
|successor=[[L_Pharm_Flowsheet table]] in [[Centralized_data.mdb]]
|content= 
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 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.accdb]].
 


[[Category:Data Repository]]
}}
[[Category:Pharmacy]]
[[Category: Pharmacy]]

Latest revision as of 13:22, 2021 June 29

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

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.accdb.