Drugs Collected: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 5: Line 5:
==Pharmacy List==
==Pharmacy List==
=== Counted drugs ===
=== Counted drugs ===
'' Use ctrl-f to find the drug you are looking for. Edit the lists of drugs on the data item pages themselves. ''
<!-- query for full list -->
{{#cargo_query:
{{#cargo_query:
tables=Drugs_Included, Data_Element
tables=Drugs_Included, Data_Element
|join on=Drugs_Included._pageName = Data_Element._pageName
|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 -->
|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
|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table"
|order by=sort
|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
|default=no results were found
|format=dynamic table
|format=dynamic table
Line 17: Line 19:
}}
}}


<!-- query for full list -->  
'' 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:
{{#cargo_query:
tables=Drugs_Included, Data_Element
tables=Drugs_Included, Data_Element
|join on=Drugs_Included._pageName = Data_Element._pageName
|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
|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"
|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0
|order by=sort
|order by=sort DESC
|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
|format=dynamic table
|format=table
|rows per page=50
|rows per page=50
}}
}}


=== yes/no drugs ===
=== yes/no drugs ===
Click {{#cargo_query:
{{#cargo_query:
tables=Data_Element, Drugs_Included,  
tables=Data_Element, Drugs_Included,  
|join on=Data_Element._pageName = Drugs_Included._pageName  
|join on=Data_Element._pageName = Drugs_Included._pageName  
Line 39: Line 40:
|order by=CCMDB_label
|order by=CCMDB_label
|limit=0
|limit=0
|more results text= here
|default=no results were found
|default=no results were found
|more=here
|more results text=Click hereto see the full list with names of the data in the table etc.
|no html
|no html
}} to 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]].  
The (letternumber) at the beginning of the line is the column/row in [[CCMDB.accdb]].  

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
  • 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

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