Drugs Collected: Difference between revisions
TOstryzniuk (talk | contribs) TOstryzniuk moved page Drugs Collected to Legacy Drugs Collected Jan1.12toSept.12: Will keep old table and just start new article |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (129 intermediate revisions by 7 users not shown) | |||
| Line 1: | Line 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 === | |||
<!-- 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]] | |||