Drugs Collected: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Text replacement - " ccmdb.accdb" to " CCMDB.accdb") |
Ttenbergen (talk | contribs) m (→Counted drugs) |
||
(24 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
'''''see [[Pharmacy collection]] for collection instructions''''' | '''''see [[Pharmacy collection]] for collection instructions''''' | ||
The drugs in brackets () are the brand names | The drugs in brackets () are the brand names. If a specific drug/brand name is not listed on the wiki but you think it is part of one of the drug categories we collect, please flag this on the respective wiki page. | ||
==Pharmacy List== | ==Pharmacy List== | ||
=== Counted drugs === | |||
<!-- query for full list --> | |||
{{#cargo_query: | |||
tables=Drugs_Included, Data_Element | |||
|join on=Drugs_Included._pageName = Data_Element._pageName | |||
|fields=Data_Element.sort=sort, Data_Element._pageName=page, drugs_included=drugs included, start_date=start, end_date=end | |||
|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" | |||
|order by=sort | |||
|limit=0 | |||
|more results text=Click here for the full list of drugs we have ever counted, with start and stop dates. | |||
|default=no results were found | |||
|format=dynamic table | |||
|rows per page=50 | |||
}} | |||
'' Use ctrl-f to find the drug you are looking for. Edit the lists of drugs on the data item pages themselves. '' | |||
'' | <!-- query for currently collected list --> | ||
{{#cargo_query: | |||
tables=Drugs_Included, Data_Element | |||
{| | |join on=Drugs_Included._pageName = Data_Element._pageName | ||
| | |fields=Data_Element.sort=sort, Data_Element._pageName=page, drugs_included=drugs included, <!-- start_date=start, end_date=end --> | ||
|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0 | |||
|order by=sort DESC | |||
! | |default=no results were found | ||
|format=table | |||
|rows per page=50 | |||
| | }} | ||
| | |||
| | |||
| | |||
| | |||
=== yes/no drugs === | === yes/no drugs === | ||
{ | {{#cargo_query: | ||
tables=Data_Element, Drugs_Included, | |||
|join on=Data_Element._pageName = Drugs_Included._pageName | |||
|fields=Data_Element.sort=table sort, Data_Element._pageName=page, Data_Element.CCMDB_label, drugs_included=drugs included, start_date=start, end_date=end | |||
|where=Data_Element.tables HOLDS "L_Log table" and Data_Element._pageName LIKE "pharm%" | |||
|order by=CCMDB_label | |||
|limit=0 | |||
|default=no results were found | |||
|more results text=Click hereto see the full list with names of the data in the table etc. | |||
|no html | |||
}} | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
The (letternumber) at the beginning of the line is the column/row in [[CCMDB.accdb]]. | |||
The | {{#cargo_query: | ||
tables=Data_Element, Drugs_Included, | |||
|join on=Data_Element._pageName = Drugs_Included._pageName | |||
|fields=CONCAT("[[", Data_Element._pageName, "{{!}}", Data_Element.CCMDB_label, "]]")=drug, drugs_included=drugs included | |||
|where=Data_Element.tables HOLDS "L_Log table" and Data_Element._pageName LIKE "pharm%" AND DATEDIFF(end_date,NOW()) >= 0 | |||
|order by=CCMDB_label | |||
|limit=500 | |||
|rows per page=50 | |||
}} | |||
== Legacy == | == Legacy == |
Latest revision as of 18:14, 2021 December 1
see Pharmacy collection for collection instructions
The drugs in brackets () are the brand names. If a specific drug/brand name is not listed on the wiki but you think it is part of one of the drug categories we collect, please flag this on the respective wiki page.
Pharmacy List
Counted drugs
Click here for the full list of drugs we have ever counted, with start and stop dates.
Use ctrl-f to find the drug you are looking for. Edit the lists of drugs on the data item pages themselves.
sort | page | drugs included |
---|---|---|
19 | Vanco alternatives |
|
18 | Carbapenems |
|
17 | Fluoroquinolones |
|
16 | Vancomycin |
|
15 | Antipseudomonals |
|
14 | Fungins |
|
13 | Azoles |
|
yes/no drugs
Click hereto see the full list with names of the data in the table etc.
The (letternumber) at the beginning of the line is the column/row in CCMDB.accdb.
drug | drugs included |
---|---|
(A1)PPI |
|
(A2)H2 Blockers |
|
(A3)special upper GI bleeding agents |
|
(A4)vitamin K antagonists |
|
(A5)heparin cont inf | by IV continuous infusion only |
(A5)Heparin SQ | |
(A7)LMWH |
|
(B1)direct thrombin inhibitors |
|
(B2)Heparinoids |
|
(B3)Factor Xa inhibitors |
|
(B4)benzodiazepines cont inf |
|
(B5)opioids cont inf (not PCA) |
|
(C1)propofol cont inf | |
(C2)dopamine cont inf | |
(C3)dobutamine cont inf | |
(C4)norepinephrine cont inf |
|
(C5)epinephrine cont inf | |
(D1)phenylephrine cont inf |
|
(D2)vasopressin cont inf | |
(D3)milrinone cont inf | |
(D4)insulin cont inf | |
(D5)furosemide cont inf |
|
(E1)paralytics cont IV only |
|
(E2)corticosteroids |
|
(E3)amphotericin B |
|
(E4)influenza drugs |
|
(E5)bosentan |
|
(F1)viagra-type vasodilators |
|
(F2)amiodarones | |
(F3)anti-TB drugs |
|
(F4)statins |
|