CCMDB Wiki

Drugs Collected: Difference between revisions

← Older edit
m Rifampicin
m Text replacement - "[[Category: " to "[[Category:"
 
(51 intermediate revisions by 3 users 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. Some of the brand names are included. If collectors or other program members come across any other brand names that are commonly used, please add them to the chart below. 
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.
 
If you print this list and make annotations to it please consider putting the annotations on the wiki so that we can all benefit from them.
 
If drug is '''not listed in the category then it means it is not collected''', just ensure that you have the updated list from the wiki for the brand names as a few have been added since going live.


==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
}}
=== oral/nasogastric tube drugs===
Be sure to collect all intravenous and oral preparations for each drug unless otherwise noted (e.g. specified continuous infusions would be an exception).


=== counted drugs ===
'' Use ctrl-f to find the drug you are looking for. See [[Adding a drug to pharmacy collection]] for editing drugs. ''
''This is a sortable table. Click the up/down arrows in a column to sort by that column. Sorting by the sort order column sorts the drugs as they are on the laptop.
<!-- query for currently collected list -->
 
{{#cargo_query:
'' Consider using ctrl-f to find the drug you are looking for.
tables=Drugs_Included, Data_Element
{| class="wikitable sortable"
|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 -->
!  width="34"| sort order
|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0
! width="148"| Individual drug or Class of drugs
|order by=sort DESC
!| Drugs in this group and/or alternate name of drug / Comments
|default=no results were found
 
|format=table
|-  
|rows per page=50
|| 30
}}
|| antipseudomonal PCNs
|| piperacillin, piperacillin/tazobactam (Tazocin), ticarcillin, ticarcillin/clavulanate (Timentin)
 
|-
|| 27
|| azoles (antifungals)
|| fluconazole (diflucan), itraconazole (sporanox), ketoconazole (ziroral), posaconazole (posanol), voriconazole (Vfend)
 
|-  
|| 34
|| carbapenems
|| <span style="color:red">(NOT ertapenem);</span> meropenem (Merrem), imipenem (Primaxin), doripenem (Doribax)
 
|-
|| 33
|| fluoroquinolones
|| ciprofloxacin (Cipro), moxifloxacin (Avelox), levofloxacin (Levaquin), norfloxacin (Noroxin), ofloxacin (Floxin)
 
|-
|| 29
|| fungins
|| caspofungin (Cancidas), micafungin (Mycamine) , anidulafungin (Eraxis)
 
|-
|| 36
|| vanco alternatives
|| linezolid (Zyvoxam), daptomycin (Cubicin), quinipristin/dalfopristin
 
|-
|| 31
|| vancomycin
|| Vancocin
 
|}


=== yes/no drugs ===
=== yes/no drugs ===
{| class="wikitable sortable" style="color:#538DD5"
{{#cargo_query:
|-
tables=Data_Element, Drugs_Included,  
!| sort order
|join on=Data_Element._pageName = Drugs_Included._pageName
!| Individual drug or Class of drugs
|fields=Data_Element.sort=table sort, Data_Element._pageName=page, Data_Element.CCMDB_label, drugs_included=drugs included, start_date=start, end_date=end
!| Drugs in this group and/or alternate name of drug / Comments
|where=Data_Element.tables HOLDS "L_Log table" and Data_Element._pageName LIKE "pharm%"
|-
|order by=CCMDB_label
|| 1
|limit=0
|| PPI
|default=no results were found
|| esomeprazole (nexium), pantoprazole (pantaloc) , omeprazole (pilosec), rabeprazole (aciphex, pariet), lansoprazole (prevacid), dexlansoprazole (kapidex or dexilant)
|more results text=Click hereto see the full list with names of the data in the table etc.
|-
|no html
|| 2
}}  
|| H2-Blockers
|| ranitidine (zantac), famotidine (pepcid), cimetidine (tagamet), nizatidine (tazac)
|-
|| 23
|| furosemide cont inf
|| Lasix
|-
|| 4
|| heparin SQ
|| &nbsp;
|-
|| 6
|| LMWH
|| dalteparin (fragmin), enoxaparin (Lovenox), tinzaparin (innohep), nadroparin (fraxiparin)
|-
|| 10
|| benzodiazepines cont inf
|| lorazepam (ativan), diazepam (valium), midazolam (versed)
|-
|| 11
|| opioids cont inf
|| alfentanil (alfenta), fentanyl (sublimaze), hydromorphone (dilaudid), morphine, meperidine (demerol), sufentanil(sufenta)  /  <span style="color:red">[[Pharmacy_collection#No_PCA | Not PCA]] </span>. PCA is intermittent. Discussed and agreed by ICU task team - Dr. Allan Garland.
|-
|| 12
|| propofol cont inf
|| &nbsp;
|-
|| 22
|| insulin cont inf
|| &nbsp;
|-
|| 57
|| amiodarones
|| &nbsp;
|-
|| 28
|| amphotericin B
|| amphotericin B (Fungizone), amphotericin B lipid complex, amphotericin B liposomal
|-
|| 58
|| anti-TB drugs
|| Isoniazid (INH), Rifabutin (mycobutin), Ethambutal (Ethambutol; Etibi), Pyrazinamide (rifater), Streptomycin, Rifampicin (or is it rifampin? once I know I will update CCMDB.mdb)
|-
|| 51
|| [[bosentan]]
|| Tracleer - Oral
|-
|| 25
|| corticosteroids
|| (betamethasone, cortisone, hydrocortisone (Solu-Cortef), methylprednisolone (Solu-Medrol), prednisone, dexamethasone (decadron), budesonide (Entocort), prednisolone, triamcinolone (tricortone); <span style="color:red">NOT fludrocortisone (Florinef)</span>
|-
|| 7
|| direct thrombin inhibitors
|| argatroban, bivalirudin (angiomax), lepirudin (refludan), dabigatran (Pradax)
|-
|| 14
|| dobutamine cont inf
|| &nbsp;
|-
|| 13
|| dopamine cont inf
|| &nbsp;
|-
|| 16
|| epinephrine cont inf
|| [[Pharmacy_collection#No_epidural_or_intravertebral_administration |<span style="color:red">No epidural or intravertebral</span>]]
|-
|| 9
|| factor Xa inhibitors
|| Fondaparinux (arixtra), Rivaroxaban (xarelto), Apixaban (Eliquis)
|-
|| 5
|| heparin cont inf
|| ''by IV continuous infusion only''
|-
|| 8
|| heparinoids
|| danaparoid (Orgaran-DVT, Orgaran (HIT))
|-
|| 48
|| influenza drugs
|| tamiflu, oseltamivir (Tamiflu), zanamivir (Relenza)
|-
|| 19
|| milrinone cont inf
|| &nbsp;
|-
|| 15
|| norepinephrine cont inf
|| Levophed
|-
|| 24
|| paralytics cont inf
|| rocuronium (esmeron), atracurium, pancuronium (pavulon), cisatracurium; <span style="color:red"> Only IV route</span>, [[Pharmacy_collection#No_epidural_or_intravertebral_administration |<span style="color:red">No epidural or intravertebral</span>]]
|-
|| 17
|| phenylephrine cont inf
|| Neo-Synephrine
|-
|| 56
|| special upper GI bleeding agents
|| octreotide (sandostatin) or somatostatin (Stilamin) 
|-
|| 60
|| statins
|| atorvastatin (Lipitor), fluvastatin (Lescol), simvastatin (Zocor), lovastatin (Mevacor), pravastatin (Pravachol), rosuvastatin (Crestor)
|-
|| 18
|| vasopressin cont inf
|| &nbsp;
|-
|| 52
|| viagra-type vasodilators
|| Sildenafil (Revatio or Viagra),Tadalafil (Cialis)
|-
|| 3
|| vitamin K antagonists
|| warfarin (coumadin), acenocoumarol (sintrom or sinthrome)
|}


== IT/Data ==
The (letternumber) at the beginning of the line is the column/row in [[CCMDB.accdb]].  
The master version of this list with the tool to create the image for the ccmdb.mdb is in Y:\CCMDB\Pharmacy. This is basically '''only''' the source code for ccmdb.mdb
{{#cargo_query:
*Technical support people that have access to Y are: [[User: fschumacher | Fred Schumacher]] and [[User:Ttenbergen|Ttenbergen]].
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 ==
see [[:Category:Legacy Pharmacy]]
see [[:Category:Legacy Pharmacy]]


[[Category: Pharmacy]]
[[Category:Pharmacy]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Drugs_Collected"