L Pharm: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
The '''L_Pharm''' table contains the data we collect on the PDA and in the [[CCMDB.mdb]] about the frequency and quantity at which drugs are used in the ICU setting. Also see [[Pharmacy Data in the ICU]].  
The '''L_Pharm''' table contains the data we collect on the PDA and in the [[CCMDB.mdb]] about the frequency and quantity at which drugs are used in the ICU setting. Also see [[Pharmacy Collection]].  


== to do before de-stubbing ==
== to do before de-stubbing ==

Revision as of 05:19, 25 July 2008

The L_Pharm table contains the data we collect on the PDA and in the CCMDB.mdb about the frequency and quantity at which drugs are used in the ICU setting. Also see Pharmacy Collection.

to do before de-stubbing

  • explain data structure

Data Integrity Rules

  • check that there are not more drug days than LOS
  • check that doses is not greater than s_drugs MaxDoses for a given drug
  • run comparative checks to ensure drugs and priority unique for this patient


Template:Stub