Centralized import from Ed.mdb: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 35: | Line 35: | ||
uses queries | uses queries | ||
*pharmacymdb_to_L_Pharm_flowsheet | *pharmacymdb_to_L_Pharm_flowsheet | ||
** imports variables from pharmacy.mdb into L_Pharm_flow for the following fields, '''regardless of date''' | |||
***PPI, [H2-Blockers], [Heparin SQ], LMWH, [benzodiazepines cont inf], [opioids cont inf], [propofol cont inf], [Insulin cont inf], [Furosemide cont inf], azoles, fungins, [antipseudomonal PCNs], vancomycin, fluoroquinolones, carbapenems, ertapenem, [vanco alternatives], [3rd generation cephalosporins], ceftazidime, tigecycline (ignore square brackets, this was taken directly from SQL) | |||
*pharmacymdb_to_L_Log | *pharmacymdb_to_L_Log | ||
** will set checkboxes for pharmacy fields in L_Log to "true" if value in pharmacy.mdb is > 0 | ** will set checkboxes for pharmacy fields in L_Log to "true" if value in pharmacy.mdb is > 0 | ||