https://owl.unipharm.com/mediawiki/index.php?action=history&feed=atom&title=Information_Systems%3AHow_To_Run_Amenity_Health_Reports 2026-09-01T13:44:45Z Revision history for this page on the wiki MediaWiki 1.35.4 https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:How_To_Run_Amenity_Health_Reports&diff=9987&oldid=prev 2017-11-21T20:49:09Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 20:49, 21 November 2017</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>There is now a user interface to run these reports here:</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[https://infonet.unipharm.com/unipharm/in2_arcust.pgm]</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>===Old instructions===</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Until we build a user interface on InfoNet to allow a user to run the Amenity Healthcare query on their own we will have to manually run it and e-mail the reports. It has been agreed upon that we will run the query for the following three stores:</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Until we build a user interface on InfoNet to allow a user to run the Amenity Healthcare query on their own we will have to manually run it and e-mail the reports. It has been agreed upon that we will run the query for the following three stores:</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-9631:rev-9987:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:How_To_Run_Amenity_Health_Reports&diff=9631&oldid=prev 2017-10-25T17:25:40Z

<p>Created page with &quot;Until we build a user interface on InfoNet to allow a user to run the Amenity Healthcare query on their own we will have to manually run it and e-mail the reports. It has bee...&quot;</p> <p><b>New page</b></p><div>Until we build a user interface on InfoNet to allow a user to run the Amenity Healthcare query on their own we will have to manually run it and e-mail the reports. It has been agreed upon that we will run the query for the following three stores:<br /> <br /> * Memorial (#12424)<br /> * Qualicum (#12425)<br /> * Nanoose (#12426)<br /> <br /> The query will be run every Monday morning. If there is a holiday on Monday run it on Tuesday. The query will be run for the previous week (Sunday to Saturday). Be sure to change the date in the 3 locations that it is specified in each SQL query. The SQL files are located in \\superserver\tech\common\Saved SQL Queries\Amenity Health Custom Report\ The files will be renamed as follows:<br /> <br /> * 4001 Qualicum (Sep. 03 - Sep. 09, 2017).xlsx<br /> * 4002 Nanoose (Sep. 03 - Sep. 09, 2017).xlsx<br /> * 4003 Memorial (Sep. 03 - Sep. 09, 2017).xlsx<br /> <br /> Of course replace the dates with the dates that are actually run. Send all three reports by email to RickyZ and ChristineD.<br /> <br /> <br /> [[Category: How-to pages]]</div>

Darrenf