Drugs Collected: Difference between revisions

(127 intermediate revisions by 7 users not shown)

Line 1:

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.

'''''see [[Pharmacy collection]] for collection instructions'''''

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

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

{{#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=drugs included, start_date=start, end_date=end

|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table"

|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

|format=dynamic table

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

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

{{#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=drugs included,

|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0

|order by=sort DESC

|default=no results were found

|format=table

|rows per page=50

}}

=== yes/no drugs ===

{{#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 ==

see [[:Category:Legacy Pharmacy]]

[[Category:Pharmacy]]

@@ Line 1: / Line 1: @@
-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.
+'''''see [[Pharmacy collection]] for collection instructions'''''
-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.
+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 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 ===
+<!-- 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=drugs included,  start_date=start, end_date=end
+|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table"
+|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
+|format=dynamic table
+|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).
+'' 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:
+tables=Drugs_Included, Data_Element
+|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 -->
+|where=Data_Element.tables HOLDS "L_Pharm_Flowsheet table" AND DATEDIFF(end_date,NOW()) >= 0
+|order by=sort DESC
+|default=no results were found
+|format=table
+|rows per page=50
+}}
+=== yes/no drugs ===
+ {{#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 ==
+see [[:Category:Legacy Pharmacy]]
+[[Category:Pharmacy]]