Difference between revisions of "Information Systems:How To Run Amenity Health Reports"
(Created page with "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...") |
m |
||
| Line 1: | Line 1: | ||
| + | There is now a user interface to run these reports here: |
||
| + | |||
| + | [https://infonet.unipharm.com/unipharm/in2_arcust.pgm] |
||
| + | |||
| + | ===Old instructions=== |
||
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: |
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: |
||
Latest revision as of 13:49, 21 November 2017
There is now a user interface to run these reports here:
Old instructions
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:
- Memorial (#12424)
- Qualicum (#12425)
- Nanoose (#12426)
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:
- 4001 Qualicum (Sep. 03 - Sep. 09, 2017).xlsx
- 4002 Nanoose (Sep. 03 - Sep. 09, 2017).xlsx
- 4003 Memorial (Sep. 03 - Sep. 09, 2017).xlsx
Of course replace the dates with the dates that are actually run. Send all three reports by email to RickyZ and ChristineD.