Drugs Collected: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (→‎IT/Data: no more image generation stuff...)
Line 15: Line 15:
|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._pageName=DIP, drugs_included=drugs included, <!-- start_date=start, end_date=end -->
|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_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0
|order by=sort
|default=no results were found
|format=dynamic table
|rows per page=50
}}
<!-- 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._pageName=DIP, 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"
|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

Revision as of 13:10, 2021 November 25

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.

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

counted drugs

Consider using ctrl-f to find the drug you are looking for.

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
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 description
    sort page description
    92 Pharm Vitamin K antagonists field True if drug in field name was given
    93 Pharm Heparin cont inf True if a continuous infusion of Heparin was given
    94 Pharm Direct thrombin inhibitors True if drug in field name was given
    95 Pharm Heparinoids True if drug in field name was given
    96 Pharm Factor Xa inhibitors True if drug in field name was given
    97 Pharm Dopamine cont inf True if drug in field name was given
    98 Pharm Dobutamine cont inf True if drug in field name was given
    99 Pharm Norepinephrine cont inf True if drug in field name was given
    100 Pharm Epinephrine cont inf True if drug in field name was given
    101 Pharm Phenylephrine cont inf True if drug in field name was given
    102 Pharm Vasopressin cont inf True if drug in field name was given
    103 Pharm Milrinone cont inf True if drug in field name was given
    104 Pharm Paralytics cont inf True if drug in field name was given
    105 Pharm corticosteroids True if drug in field name was given
    106 Pharm amphotericin B True if drug in field name was given
    107 Pharm macrolides True if drug in field name was given
    108 Pharm 1st or 2nd generation cephalosporins True if drug in field name was given
    109 Pharm 4th generation cephalosporins True if drug in field name was given
    110 Pharm antistaph penicillins True if drug in field name was given
    111 Pharm aminoglycosides True if drug in field name was given
    112 Pharm influenza drugs True if influenza drugs were given
    113 Pharm bosentan True if drug in field name was given
    114 Pharm viagra-type vasodilators True if drug in field name was given
    115 Pharm special upper GI bleeding agents True if drug in field name was given
    116 Pharm amiodarones True if drug in field name was given
    117 Pharm anti-TB drugs True if drug in field name was given
    118 Pharm statins True if drug in field name was given
    119 Pharm PPI True if drug in field name was given
    120 Pharm H2 blockers True if drug in field name was given
    121 Pharm furosemide True if drug in field name was given
    122 Pharm heparin sq True if drug in field name was given
    123 Pharm LMWH True if drug in field name was given
    124 Pharm benzodiazepines True if drug in field name was given
    125 Pharm opioids True if drug in field name was given
    126 Pharm propofol True if drug in field name was given
    127 Pharm insulin True if drug in field name was given

    autoList

    Autmatically generated list based on wiki pages; can't replace the above because we decided to store the generica locally.

     TableTabData typelengthDescriptionStart dateindex
    AntipseudomonalsL_Pharm_Flowsheet tablePharmnumberintegerantipseudomonals contains manually collected doses of antipseudomonals that were given.11 July 198815
    AzolesL_Pharm_Flowsheet tablePharmnumberintegerazoles contains manually collected doses of azoles that were given.11 July 198813
    CarbapenemsL_Pharm_Flowsheet tablePharmnumberintegercarbapenems contains manually collected doses of carbapenems that were given.11 July 198818
    FluoroquinolonesL_Pharm_Flowsheet tablePharmnumberintegerfluoroquinolones contains manually collected doses of fluoroquinolones that were given.11 July 198817
    FunginsL_Pharm_Flowsheet tablePharmnumberintegerfungins contains manually collected doses of fungins that were given.11 July 198814
    Pharm Direct thrombin inhibitorsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 201294
    Pharm Dobutamine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 201298
    Pharm Dopamine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 201297
    Pharm Epinephrine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012100
    Pharm Factor Xa inhibitorsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 201296
    Pharm H2 blockersL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012120
    Pharm Heparin cont infL_Log tablePharmbooleannot enteredTrue if a continuous infusion of Heparin was given1 January 201293
    Pharm HeparinoidsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 201295
    Pharm LMWHL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012123
    Pharm Milrinone cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012103
    Pharm Norepinephrine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 201299
    Pharm PPIL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012119
    Pharm Paralytics cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012104
    Pharm Phenylephrine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012101
    Pharm Vasopressin cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012102
    Pharm Vitamin K antagonists fieldL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 201292
    Pharm amiodaronesL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012116
    Pharm amphotericin BL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012106
    Pharm anti-TB drugsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012117
    Pharm benzodiazepinesL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012124
    Pharm bosentanL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012113
    Pharm corticosteroidsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012105
    Pharm furosemideL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012121
    Pharm heparin sqL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012122
    Pharm influenza drugsL_Log tablePharmbooleannot enteredTrue if influenza drugs were given1 January 2012112
    Pharm insulinL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012127
    Pharm opioidsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012125
    Pharm propofolL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012126
    Pharm special upper GI bleeding agentsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012115
    Pharm statinsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012118
    Pharm viagra-type vasodilatorsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012114
    Vanco alternativesL_Pharm_Flowsheet tablePharmnumberintegervanco alternatives contains manually collected doses of vanco alternatives that were given.11 July 198819
    VancomycinL_Pharm_Flowsheet tablePharmnumberintegervancomycin contains manually collected doses of vancomycin that were given.11 July 198816

    Legacy

    see Category:Legacy Pharmacy

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