Drugs Collected: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
mNo edit summary
Line 32: Line 32:


=== yes/no drugs ===
=== yes/no drugs ===
<!--
|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0
|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0
-->
{{#cargo_query:
{{#cargo_query:
tables=Data_Element
tables=Data_Element, Drugs_Included,
|fields=sort,_pageName=page, CCMDB_label =label, description,  start_date=start, end_date=end
|join on=Data_Element._pageName = Drugs_Included._pageName
|where=field_name NOT LIKE "%Complete" and field_name LIKE "pharm_%"  
|fields=Data_Element.sort=sort, Data_Element._pageName=page, Drugs_Included._pageName=DIP, drugs_included=drugs included,  start_date=start, end_date=end
|where=Data_Element.tables HOLDS "L_Log table"
|order by=sort
|order by=sort
|limit=1000
|limit=500
|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
<!-- old version

Revision as of 14:10, 25 November 2021

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

Use ctrl-f to find the drug you are looking for. Edit the lists of drugs on the data item pages themselves.

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

    • Click here for the full list of drugs we have ever counted, with start and stop dates.

    yes/no drugs

    sort page DIP drugs included start end
    sort page DIP drugs included start end
    1 D ID field 1988-07-11 2300-01-01
    2 ClientGUID field 2022-08-29 2300-01-01
    2 ClientVisitGUID field 2022-08-29 2300-01-01
    2 LastName field 1988-07-11 2300-01-01
    3 FirstName field 1988-07-11 2300-01-01
    4 PHIN field 1988-07-11 2300-01-01
    5 Date of Birth 1988-07-11 2300-01-01
    6 SentDtTm field 1988-07-11 2300-01-01
    6 Chart number 1988-07-11 2300-01-01
    7 Start Date field 2011-02-25 2300-01-01
    8 Start Time field 2011-02-25 2300-01-01
    9 Notes field 1988-07-11 2300-01-01
    12 DC Treatment 1988-07-11 2022-05-10
    16 Province field 1988-07-11 2300-01-01
    17 Sex field 1988-07-11 2300-01-01
    26 R Filter Field 1988-07-11 2019-01-01
    33 Postal Code field 2012-01-01 2300-01-01
    34 LastOpened DtTm field 2016-04-14 2100-01-01
    35 Pre acute living situation field 2016-07-01 2300-01-01
    36 Pre-admit Inpatient Institution field 2016-07-01 2300-01-01
    37 Previous Location field 2016-07-01 2300-01-01
    38 Previous Service field 2016-07-01 2022-09-07
    39 Off ward field 2016-07-01 2020-01-29
    40 Service/Location field 2016-07-01 2300-01-01
    42 Visit Admit DtTm field 2003-01-01 2300-01-01
    43 Accept DtTm field 2016-07-01 2022-04-22
    44 Accept DtTm missing field 2016-07-01 2022-04-22
    46 Dispo DtTm field 2016-07-01 2300-01-01
    47 Transfer Ready DtTm field 1999-06-01 2020-10-15
    48 TR info status field 2016-05-05 2020-10-15
    48 Ap SapsSysBP field 1988-07-11 2014-05-13
    55 Admit Type for APACHE II 1988-07-11 2300-01-01
    56 Chronic Health APACHE 2022-02-17
    57 Temperature 1988-07-11 2300-01-01
    61 HR 1988-07-11 2300-01-01
    62 RR 1988-07-11 2300-01-01
    63 AP Verbal field 1988-07-11 2300-01-01
    63 AP Motor field 1988-07-11 2300-01-01
    63 AP Eye field 1988-07-11 2300-01-01
    67 GCS sedated field 2016-09-22 2021-06-15
    68 PO2 1988-07-11 2300-01-01
    69 PCO2 1988-07-11 2300-01-01
    70 PH 1988-07-11 2300-01-01
    71 Serum CO2 1988-07-11 2300-01-01
    72 Na 1988-07-11 2300-01-01
    73 K 1988-07-11 2300-01-01
    75 WBC 1988-07-11 2300-01-01
    76 Creatinine (APACHE) 1988-07-11 2300-01-01
    77 ARF (APACHE) 1988-07-11 2300-01-01
    80 RecordStatus field 2013-04-24 2300-01-01
    91 LastChanged DtTm field 2021-01-06 2999-12-31
    92 Pharm Vitamin K antagonists field Pharm Vitamin K antagonists field
    • warfarin (coumadin)
    • acenocoumarol (sintrom or sinthrome)
    		 2012-01-01 2300-01-01
    93 Pharm Heparin cont inf Pharm Heparin cont inf by IV continuous infusion only 2012-01-01 2300-01-01
    94 Pharm Direct thrombin inhibitors Pharm Direct thrombin inhibitors
  • argatroban
  • bivalirudin (angiomax)
  • lepirudin (refludan)
  • dabigatran (Pradax)
    		•  2012-01-01 2300-01-01
    95 Pharm Heparinoids Pharm Heparinoids
  • danaparoid (Orgaran-DVT, Orgaran (HIT))
    		•  2012-01-01 2300-01-01
    96 Pharm Factor Xa inhibitors Pharm Factor Xa inhibitors
  • Fondaparinux (arixtra)
  • Rivaroxaban (xarelto)
  • Apixaban (Eliquis)
  • Edoxaban (Lixiana)
    		•  2012-01-01 2300-01-01
    97 Pharm Dopamine cont inf 2012-01-01 2300-01-01
    98 Pharm Dobutamine cont inf 2012-01-01 2300-01-01
    99 Pharm Norepinephrine cont inf Pharm Norepinephrine cont inf
  • Levophed
    		•  2012-01-01 2300-01-01
    100 Pharm Epinephrine cont inf Pharm Epinephrine cont inf
  • No epidural or intravertebral
    		•  2012-01-01 2300-01-01
    101 Pharm Phenylephrine cont inf Pharm Phenylephrine cont inf
  • Neo-Synephrine
    		•  2012-01-01 2300-01-01
    102 Pharm Vasopressin cont inf 2012-01-01 2300-01-01
    103 Pharm Milrinone cont inf 2012-01-01 2300-01-01
    104 Pharm Paralytics cont inf Pharm Paralytics cont inf
  • rocuronium (esmeron)
  • atracurium
  • pancuronium (pavulon)
  • cisatracurium
    • Only IV route, no epidural or intravertebral    		 2012-01-01 2300-01-01
    105 Pharm corticosteroids Pharm 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)
    		 2012-01-01 2300-01-01
    106 Pharm amphotericin B Pharm amphotericin B
  • amphotericin B (Fungizone)
  • amphotericin B lipid complex
  • amphotericin B liposomal
    		•  2012-01-01 2300-01-01
    107 Pharm macrolides 2012-01-01 2013-03-17
    108 Pharm 1st or 2nd generation cephalosporins 2012-01-01 2013-08-07
    109 Pharm 4th generation cephalosporins 2012-01-01 2013-02-28
    110 Pharm antistaph penicillins 2012-01-01 2013-02-19
    111 Pharm aminoglycosides 2012-01-01 2013-03-05
    112 Pharm influenza drugs Pharm influenza drugs
  • oseltamivir (Tamiflu)
  • zanamivir (Relenza)
    		•  2012-01-01 2300-01-01
    113 Pharm bosentan Pharm bosentan
  • Tracleer - Oral
    		•  2012-01-01 2300-01-01
    114 Pharm viagra-type vasodilators Pharm viagra-type vasodilators
  • Sildenafil (Revatio or Viagra)
  • Tadalafil (Cialis)
    		•  2012-01-01 2300-01-01
    115 Pharm special upper GI bleeding agents Pharm special upper GI bleeding agents
  • octreotide (sandostatin)
  • somatostatin (Stilamin)
    		•  2012-01-01 2300-01-01
    116 Pharm amiodarones 2012-01-01 2300-01-01
    117 Pharm anti-TB drugs Pharm anti-TB drugs
  • Antimycobacterials: Ethambutal (Ethambutol; Etibi), Isoniazid (INH), Rifabutin (mycobutin), Pyrazinamide (rifater), Rifampicin, Rifampin, Streptomycin,ethionamide, prothionamide, cycloserine, terizidone
    		•  2012-01-01 2300-01-01
    118 Pharm statins Pharm statins
  • atorvastatin (Lipitor)
  • fluvastatin (Lescol)
  • simvastatin (Zocor)
  • lovastatin (Mevacor)
  • pravastatin (Pravachol)
  • rosuvastatin (Crestor)
    		•  2012-01-01 2300-01-01
    119 Pharm PPI Pharm PPI
  • esomeprazole (nexium)
  • pantoprazole (pantaloc)
  • omeprazole (pilosec)
  • rabeprazole (aciphex, pariet)
  • lansoprazole (prevacid)
  • dexlansoprazole (kapidex or dexilant)
    		•  2012-01-01 2300-01-01
    120 Pharm H2 blockers Pharm H2 blockers
  • ranitidine (zantac)
  • famotidine (pepcid)
  • cimetidine (tagamet)
  • nizatidine (tazac)
    		•  2012-01-01 2300-01-01
    121 Pharm furosemide Pharm furosemide
  • Lasix
    		•  2012-01-01 2300-01-01
    122 Pharm heparin sq 2012-01-01 2300-01-01
    123 Pharm LMWH Pharm LMWH
  • dalteparin (fragmin)
  • enoxaparin (Lovenox)
  • tinzaparin (innohep)
  • nadroparin (fraxiparin)
    		•  2012-01-01 2300-01-01
    124 Pharm benzodiazepines Pharm benzodiazepines
  • 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®)
    		•  2012-01-01 2300-01-01
    125 Pharm opioids Pharm opioids
  • alfentanil (alfenta)
  • fentanyl (sublimaze)
  • hydromorphone (dilaudid)
  • morphine
  • meperidine (demerol)
  • sufentanil(sufenta)
    		•  2012-01-01 2300-01-01
    126 Pharm propofol 2012-01-01 2300-01-01
    127 Pharm insulin 2012-01-01 2300-01-01

    Legacy

    see Category:Legacy Pharmacy

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