CCMDB Wiki

Drugs Collected: Difference between revisions

← Older edit
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(13 intermediate revisions by 2 users 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._pageName=DIP, 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
|rows per page=50
|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).


<!-- query for full list -->  
'' Use ctrl-f to find the drug you are looking for. See [[Adding a drug to pharmacy collection]] for editing drugs. ''
<!-- 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._pageName=DIP, 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 ===
<!--
{{#cargo_query:
|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0
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:
{{#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  
|fields=Data_Element.sort=sort, Data_Element._pageName=page, Drugs_Included._pageName=DIP, drugs_included=drugs included,  start_date=start, end_date=end
|fields=CONCAT("[[", Data_Element._pageName, "{{!}}", Data_Element.CCMDB_label, "]]")=drug, drugs_included=drugs included
|where=Data_Element.tables HOLDS "L_Log table"
|where=Data_Element.tables HOLDS "L_Log table" and Data_Element._pageName LIKE "pharm%" AND DATEDIFF(end_date,NOW()) >= 0
|order by=sort
|order by=CCMDB_label
|limit=500
|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
|format=dynamic table
|rows per page=50
|rows per page=50
}}
}}
<!-- old version
{| class="wikitable sortable" style="color:#538DD5"
|-
!| 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}}
|}
-->


== 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"