Drugs Collected: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(24 intermediate revisions by 2 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 ===
=== counted drugs ===
<!-- query for full list -->
'' Consider using ctrl-f to find the drug you are looking for.
{| class="wikitable sortable"
|-
! width="34"| sort order
! width="148"| Individual drug or Class of drugs
!| Drugs in this group and/or alternate name of drug / Comments
 
|-  
|| 30
|| [[Antipseudomonals]]
|| piperacillin, piperacillin/tazobactam (Tazocin), ticarcillin, ticarcillin/clavulanate (Timentin)
 
|-  
|| 27
|| [[Azoles]] (antifungals)
|| {{Azole antifungals}}
 
|-  
|| 34
|| [[Carbapenems]]
|| {{Carbapenems}}
 
|-  
|| 33
|| [[fluoroquinolones]]
|| {{Fluoroquinolones}}
 
|-
|| 29
|| [[fungins]]
|| {{Fungin antifungals}}
 
|-
|| 36
|| [[vanco alternatives]]
|| {{Vanco alternatives}}
 
|-
|| 31
|| [[vancomycin]]
|| vancomycin (Vancocin)
 
|}
 
=== yes/no drugs ===
{{#cargo_query:
{{#cargo_query:
tables=Data_Element
tables=Drugs_Included, Data_Element
|fields=sort,_pageName, description
|join on=Drugs_Included._pageName = Data_Element._pageName
|where=field_name LIKE "pharm_%"
|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
|order by=sort
|limit=1000
|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
|default=no results were found
|max display chars=some number
|format=dynamic table
|format=dynamic table
|rows per page=500
|rows per page=50
}}
}}
<!-- old version
=== oral/nasogastric tube drugs===
{| class="wikitable sortable" style="color:#538DD5"
Be sure to collect all intravenous and oral preparations for each drug unless otherwise noted (e.g. specified continuous infusions would be an exception).
|-
!| sort order
!| Individual drug or Class of drugs
!| Drugs in this group and/or alternate name of drug / Comments
|-
|| 1
|| PPI
|| esomeprazole (nexium), pantoprazole (pantaloc) , omeprazole (pilosec), rabeprazole (aciphex, pariet), lansoprazole (prevacid), dexlansoprazole (kapidex or dexilant)
|-
|| 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">Not [[Pharmacy_collection#No_PCA | PCA]]. PCA is intermittent. </span>
|-
|| 12
|| propofol cont inf
|| &nbsp;
|-
|| 22
|| insulin cont inf
|| &nbsp;
|-
|| 57
|| amiodarones
|| &nbsp;
|-
|| 28
|| [[Pharm_amphotericin B|amphotericin B]]
|| amphotericin B (Fungizone), amphotericin B lipid complex, amphotericin B liposomal
|-
|| 58
|| [[Pharm anti-TB drugs | anti-TB drugs]]
|| Antimycobacterials: {{Classic TB drugs}}
|-
|| 51
|| [[Pharm bosentan | bosentan]]
|| Tracleer - Oral
|-
|| 25
|| corticosteroids
|| Exclude if only route is inhaled. (betamethasone, cortisone, hydrocortisone (Solu-Cortef), methylprednisolone (Solu-Medrol), prednisone, dexamethasone (decadron), budesonide (Entocort), prednisolone, triamcinolone (tricortone); <span style="color:red">NOT [https://en.wikipedia.org/wiki/Fludrocortisone fludrocortisone] (Florinef)</span> excluded because it has no immunosuppressive effects)
|-
|| 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
|| [[Pharm influenza drugs|influenza drugs]]
|| see [[Pharm influenza drugs]]
|-
|| 19
|| milrinone cont inf
||
|-
|| 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)
|-
|| 20
|| 3rd generation cephalosporins
|| {{3rd generation cephalosporins}}
|}
-->


=== autoList ===
'' Use ctrl-f to find the drug you are looking for. See [[Adding a drug to pharmacy collection]] for editing drugs. ''
Autmatically generated list based on wiki pages; can't replace the above because we decided to store the generica locally.  
<!-- query for currently collected list -->
{{#ask:  [[FieldCCMDBTab::Pharm]] [[DataElementEndDate::1 January 2100]]
{{#cargo_query:
| ?InTable = Table
tables=Drugs_Included, Data_Element
| ?FieldCCMDBTab= Tab
|join on=Drugs_Included._pageName = Data_Element._pageName
| ?FieldDataType= Data type
|fields=Data_Element.sort=sort, Data_Element._pageName=page,  drugs_included=drugs included, <!-- start_date=start, end_date=end -->
| ?FieldLength= length
|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0
| ?DataElementDescription=Description
|order by=sort DESC
| ?DataElementStartDate=Start date
|default=no results were found
| ?DataElementSortIndex=index
|format=table
| limit=1000
|rows per page=50
| default=none found
| format=table
}}
}}


== IT/Data ==
=== yes/no drugs ===
The master version of this list with the tool to create the image for the [[CCMDB.accdb]] is in Y:\CCMDB\Pharmacy. This is basically '''only''' the source code for [[CCMDB.accdb]]
{{#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]].
{{#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 ==
see [[:Category:Legacy Pharmacy]]
see [[:Category:Legacy Pharmacy]]


[[Category: Pharmacy]]
[[Category:Pharmacy]]

Latest revision as of 10:32, 30 July 2025

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.

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).

Use ctrl-f to find the drug you are looking for. See Adding a drug to pharmacy collection for editing drugs.

sort page drugs included
19 Vanco alternatives
  • linezolid (Zyvoxam)
  • daptomycin (Cubicin)
  • quinipristin/dalfopristin
18 Carbapenems
  • meropenem (Merrem)
  • imipenem (Primaxin)
  • doripenem (Doribax)
  • ertapenem (Invanz )
17 Fluoroquinolones
  • ciprofloxacin (Cipro)
  • moxifloxacin (Avelox)
  • levofloxacin (Levaquin)
  • norfloxacin (Noroxin)
  • ofloxacin (Floxin)
16 Vancomycin
  • Vancomycin
15 Antipseudomonals
  • piperacillin
  • piperacillin/tazobactam (Tazocin)
  • ticarcillin
  • ticarcillin/clavulanate (Timentin)
14 Fungins
  • caspofungin (Cancidas)
  • micafungin (Mycamine)
  • anidulafungin (Eraxis)
  • rezafungin
13 Azoles
  • fluconazole (diflucan)
  • itraconazole (sporanox)
  • ketoconazole (ziroral)
  • posaconazole (posanol)
  • voriconazole (Vfend)
  • econazole
  • miconazole
  • tioconazole
  • isavuconazole

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
  • esomeprazole (nexium)
  • pantoprazole (pantaloc)
  • omeprazole (pilosec)
  • rabeprazole (aciphex, pariet)
  • lansoprazole (prevacid)
  • dexlansoprazole (kapidex or dexilant)
(A2)H2 Blockers
  • ranitidine (zantac)
  • famotidine (pepcid)
  • cimetidine (tagamet)
  • nizatidine (tazac)
(A3)special upper GI bleeding agents
  • octreotide (sandostatin)
  • somatostatin (Stilamin)
(A4)vitamin K antagonists
  • warfarin (coumadin)
  • acenocoumarol (sintrom or sinthrome)
(A5)heparin cont inf by IV continuous infusion only
(A5)Heparin SQ
(A7)LMWH
  • dalteparin (fragmin)
  • enoxaparin (Lovenox)
  • tinzaparin (innohep)
  • nadroparin (fraxiparin)
(B1)direct thrombin inhibitors
  • argatroban
  • bivalirudin (angiomax)
  • lepirudin (refludan)
  • dabigatran (Pradax)
(B2)Heparinoids
  • danaparoid (Orgaran-DVT, Orgaran (HIT))
(B3)Factor Xa inhibitors
  • Fondaparinux (arixtra)
  • Rivaroxaban (xarelto)
  • Apixaban (Eliquis)
  • Edoxaban (Lixiana)
(B4)benzodiazepines cont inf
  • Alprazolam (Xanax®)
  • Clobazam (Onfi®, Sympazan®)
  • Clonazepam (Klonopin®
  • Clorazepate (Tranxene®)
  • Diazepam (Diastat®, Valium®, Valtoco®)
  • Estazolam (ProSom®)
  • Flurazepam (Dalmane)
  • Lorazepam (Ativan®, Loreev®)
  • Midazolam (Nayzilam®, Seizalam®, Versed®)
  • Oxazepam (Serax®)
  • Quazepam (Doral®)
  • Remimazolam (Byfavo®)
  • Temazepam (Restoril®)
  • Triazolam (Halcion®)
(B5)opioids cont inf (not PCA)
  • alfentanil (alfenta)
  • fentanyl (sublimaze)
  • hydromorphone (dilaudid)
  • morphine
  • meperidine (demerol)
  • sufentanil(sufenta)
(C1)propofol cont inf
(C2)dopamine cont inf
(C3)dobutamine cont inf
(C4)norepinephrine cont inf
  • Levophed
(C5)epinephrine cont inf
(D1)phenylephrine cont inf
  • Neo-Synephrine
(D2)vasopressin cont inf
(D3)milrinone cont inf
(D4)insulin cont inf
(D5)furosemide cont inf
  • Lasix
(E1)paralytics cont IV only
  • rocuronium (esmeron)
  • atracurium
  • pancuronium (pavulon)
  • cisatracurium
Only IV route, no epidural or intravertebral
(E2)corticosteroids
  • Exclude if only route is inhaled.
  • betamethasone, cortisone, hydrocortisone (Solu-Cortef), methylprednisolone (Solu-Medrol), prednisone, dexamethasone (decadron), budesonide (Entocort), prednisolone, triamcinolone (tricortone)
  • NOT fludrocortisone (Florinef) excluded because it has no immunosuppressive effects)
(E3)amphotericin B
  • amphotericin B (Fungizone)
  • amphotericin B lipid complex
  • amphotericin B liposomal
(E4)influenza drugs
  • oseltamivir (Tamiflu)
  • zanamivir (Relenza)
(E5)bosentan
  • Tracleer - Oral
(F1)viagra-type vasodilators
  • Sildenafil (Revatio or Viagra)
  • Tadalafil (Cialis)
(F2)amiodarones
(F3)anti-TB drugs
(F4)statins
  • atorvastatin (Lipitor)
  • fluvastatin (Lescol)
  • simvastatin (Zocor)
  • lovastatin (Mevacor)
  • pravastatin (Pravachol)
  • rosuvastatin (Crestor)

Legacy

see Category:Legacy Pharmacy

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Drugs_Collected&oldid=165977"