Information Systems:Reporting Oxycodone sales to Health Canada

From uniWIKI
Jump to navigation Jump to search

We have to report sales of oxycodone to Health Canada. To build a detailed Excel file, go to InfoNet / uniVIEW / Health Canada / Monthly Reports. Key in a date range, select 'Oxycodone' from the report type drop down box, and press ‘Search’. Then press ‘Export to Excel’.

To see what items will be included, or to add or remove an item

- Go to a command line, key in ‘Unity’ and press enter

- 2 Start uniPharm Extensions

- 1 VA Company (PRODUCTION)

- 7 UWD Tables Menu

- 1 Work with UX Extension Tables

- Under ‘Start display at’ (upper left hand corner) key in ITMGRP and press enter

Table ITMGRPHDR defines any group of items that can be selected in InfoNet Sales Order Inquiry. At the moment, there is just one. 

 8/18/14   09:03:05   uniPHARM -- PRODUCTION               TBRUP001/HEADER     
                        CSU -- Show Table Entries          CSU Release   6.0   
UX ITMGRPHDR  TABLE                         Table Library: RCSUTILPRD          
UniPHARM Extensions                         Type                               
group of Items Header                       U USER CONTROLLED                  
                                                                               
                        Start Display at    Display Order                      
                                            N By Element Name                  
                                                                               
           2=Update   4=Cancel  5=Display   A=Audit Info                       
                                                                               
       Element    Description/Data                         Sort                
       HC01       Health Canada Oxycodone Prods                                
                                                                               
                                                                               
       F5=Refresh     F6=Add new elements        F12=Previous

To see what items will be included in this selection, append the element code of the group you want, ie ‘HC01’, to ‘ITMGRP’. So, look at table ‘ITMGRPHC01’. You can then use option ‘5=elements’, and ‘F6=Add new elements’ or ‘4=Cancel’.

Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Reporting_Oxycodone_sales_to_Health_Canada&oldid=9137"