L Pharm Flowsheet table: Difference between revisions
Ttenbergen (talk | contribs) m (→Data Structure: link fix) |
Ttenbergen (talk | contribs) m (Ttenbergen moved page L Pharm Flowsheet to L Pharm Flowsheet table: consistent naming) |
(No difference)
|
Revision as of 12:52, 2016 December 29
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.
Data for the drugs which are only collected as yes/no is stored in L_Log.
Data Structure
To see the data structure of this table, see most up-to-date ccmdb_data.mdb in Regional Server\data\Master\CCMDB data.mdb.
snapshot of structure
- L_Pharm_ID
- Pat_ID
- entry_date
- PPI
- H2-Blockers
- Heparin SQ
- LMWH
- benzodiazepines cont inf
- opioids cont inf
- propofol cont inf
- insulin cont inf
- furosemide cont inf
- azoles
- fungins
- antipseudomonals
- vancomycin
- fluoroquinolones
- carbapenems
- vanco alternatives
- 3rd generation cephalosporins
- ceftazidime
- tigecyline
- (spares 1-6)
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
moving yes/no drugs out
yes/no drugs were initially stored in this table as well but were moved to table L_Log as of CCMDB.mdb_Change_Log_2012#ver_2012-10-19.
initiation
L_Pharm_Flowsheet replaced the L_Pharm table as of January 1, 2012 for the new Pharmacy collection process which started January 1, 2012 for all Critical Care units in the Region