54.165.33.144

1y ago
6 Views
1 Downloads
3.39 MB
277 Pages
Last View : 3d ago
Last Download : 3m ago
Upload by : Baylee Stein
Transcription

Horizon Clinicals Horizon Clinicals Horizon Meds Manager Technical Guide Release 8.1 April 2005 Document ID HMM08010503

Copyright notice Copyright 2005 McKesson Corporation and/or one of its subsidiaries. All Rights Reserved. Use of this documentation and related software is governed by a license agreement. This documentation and related software contain confidential, proprietary and trade secret information of McKesson Information Solutions and are protected under United States and international copyright and other intellectual property laws. Use, disclosure, reproduction, modification, distribution, or storage in a retrieval system in any form or by any means is prohibited without the prior express written permission of McKesson Information Solutions. This documentation and related software are subject to change without notice. Publication date April 2005 Printed in U.S.A. Product and version Horizon Meds Manager Release 8.1 McKesson publication number HMM08010503 Corporate address McKesson Information Solutions 5995 Windward Parkway Alpharetta, GA 30005 404-338-6000 Reader comments Any comments or suggestions regarding this publication are welcomed and should be forwarded to the attention of: McKesson Information Solutions 1241 Carwood Court Montgomery, AL 36117 or sent by e-mail to: HMMDocumentation@mckesson.com Trademarks Horizon Meds Manager and Horizon Clinicals are registered trademarks of McKesson Information Solutions LLC. All other product and company names may be trademarks or registered trademarks of their respective companies.

Horizon Meds Manager Technical Guide Table of Contents Table of Contents About This Document. ix Chapter 1 – Site Preparation. 1 Overview . 1 Installation Specifications . 2 Multiple Table Spaces in Oracle. 3 Horizon Meds Manager Possible Report, Interface, and Application Scenarios . 4 System Diagrams . 8 Chapter 2 – System Setup. 17 Overview . 17 Installing Database Client Software and Setting ODBCs . 18 Oracle 8.1.7 Client Setup . 18 Upgrading the Oracle Client Driver to 8.1.7.8c. 26 ODBC Creation for Oracle 8.1.7 Client. 31 MS-SQL Client Setup – Windows 2000 Professional. 33 ODBC Setup for MS-SQL Client. 34 Installing Horizon Meds Manager on the Interface/Report/Citrix Servers. 38 Installing Horizon Meds Manager From CD . 38 Running the Batch File After Setup . 42 MDAC Installation. 42 Copying the Crystal Reports .dll Files to the System32 Folder . 43 Copying the Calendar License File. 43 Creating the Horizon Meds Manager Icon on the Application Server. 44 Final Steps to Complete the Installation . 46 Installing Horizon Meds Manager on a Workstation . 49 Installing Horizon Meds Manager From CD . 50 Running the Batch File After Setup . 54 MDAC Installation. 54 Copying the Crystal Reports .dll Files to the System32 Folder . 55 Copying the Calendar License File. 55 Configuring a Workstation for Automatic Updates. 56 Configuring the Production (Live) Environment for Automatic Updates . 56 Configuring the Test Environment for Automatic Updates. 59 Final Steps to Complete the Installation . 60 Creating the Test, Train, and History Databases for Oracle. 63 Creating the Test and Train Databases. 64 Completing the Necessary Configurations in Horizon Meds Manager . 65 Creating the History Database . 66 Copying an Oracle Production Database When the Database is Running . 67 Copying an Oracle Production Database When the Database is Shut Down73 Creating Services . 80 Command Syntax . 80 Examples. 81 April 2005 Horizon Meds Manager Technical Guide Release 8.1 iii

Table of Contents Horizon Meds Manager Technical Guide Creating the MED-Server Service . 81 Creating the Report Server Service. 81 Creating Automatic Processor Services . 82 Creating Interface Services . 83 The Event Viewer . 83 Removing Services . 84 Shutting Down Horizon Meds Manager and All Connected Users . 85 Overview. 85 Applying a Horizon Meds Manager Service Pack on the Server. 89 Overview. 89 Important Preliminary Steps . 89 Applying the Service Pack on the Server . 91 Chapter 3 – Peripherals. 95 Overview . 95 Supported Printers. 96 Laser Printers . 96 Label Printers. 96 Supported Printer Drivers . 97 Supported Print Servers . 98 Horizon Meds Manager Printing . 99 Horizon Meds Manager Report Servers . 100 Configuring Report Servers . 100 Report Server Types. 102 Report File Processing . 102 Troubleshooting the Report Servers. 103 Report Server Status Codes. 104 Changing the Report Server Status Code to Reprint a Print Job . 105 SQL Statements to Change Print Job Status . 106 Report Server Logs. 108 Log File Samples . 109 Reports With Non-Standard Parameters Cannot Be Printed By the Report Server . 109 Standard Report Parameters. 110 Zebra Thermal Printers . 112 Zebra Print Server Requirements. 113 Zebra Thermal Printer Requirements . 113 Zebra Printer Setup Instructions. 114 Resetting Zebra Printer Configuration . 114 Installing the Seagull Printer Drivers . 115 Adjusting Settings to Align Labels . 117 Intermec Thermal Printers . 121 Intermec Print Server Requirements . 122 Intermec Thermal Printer Requirements . 122 Intermec Printer Setup Instructions for Horizon Meds Manager. 124 Setting the DIP Switches on Intermec Printers. 126 Adjusting Settings to Align Labels . 127 Okidata – Model 320 Turbo Printers. 130 Print Server Requirements . 131 Okidata Dot Matrix Printer Requirements. 131 iv Horizon Meds Manager Technical Guide Release 8.1 April 2005

Horizon Meds Manager Technical Guide Table of Contents Creating Label Forms in Windows 2000 Server/Citrix (Okidata Printers Only) . 133 Changing to Epson Emulation Mode for Okidata 320 Turbo Printers. 136 Windows 2000 TCP/IP Printer Port Setup Instructions. 136 Setting Up Printer Sets in Horizon Meds Manager. 141 Overview. 141 Printer Sets Initialization . 141 Adding Printer Sets. 142 Setting Up Default Printers for the Batch. 142 Printer Troubleshooting Checklists. 144 General Printer Troubleshooting Questions . 146 Printing Speed Issues. 146 Print Output Not Correct . 147 Network Configuration . 147 Application Print Services Configuration . 147 Adjusting Label Alignment Settings (Intermec). 149 Adjusting Label Alignment Settings (Zebra) . 150 Billing Exception Report . 151 Cannot Create Scratch Storage (Power Error On the Server) . 151 Cannot Log On To Crystal. 151 Cannot Modify Rotation Setting (180º) Setting . 152 Cart Fill Only Prints Patient Header – Does Not Print Medications . 153 Charges to Patient Per Unit Report . 153 Crystal Error 500 (Not Enough Memory for Operation) . 154 Crystal Error 505 on PEStartPrintJob. 154 Crystal Error 505 Error in File path:filename . 156 Crystal Error 505 No Print Destination Specified or Invalid Print Destination. 157 Crystal Error 507 Invalid File Name. 158 Crystal Error 507 Unable to Print to path of called report . 158 Crystal Error 515 (Not Enough Memory for Operation) . 159 Crystal Error 515 (Error in Formula: Error in File) – Citrix . 160 Crystal Error 534 Error Detected by Database DLL (Oracle) . 160 Crystal Error 534 Error Detected by Database DLL (MS-SQL) . 162 Crystal Error 545 (Request Cancelled by the User) . 163 Crystal Error 998-997 on PEStartPrintJob.htm. 164 Language Monitor Errors (on Interface/Report/Application Server) . 164 Language Monitor Errors (on Interface/Report/Application Server – Print Server/Spooler) . 165 Printing IVListing.rpt Error . 166 Setting Up MAR Printing (Centralized and Decentralized) . 166 Error: Report Server Rpt Svr Name Mar.rpt Has Exceeded Allowable Run Time. 167 System Lockup When Trying to Print Intervention Report. 168 Report Server Names/Printer Not Showing Up in Drop-down Box (Printer Sets) . 168 Data Loss With Printing – Print Jobs Getting Lost After Entering the Print Queue. 168 Dialog Box From Report Requesting Value Will Hang Report Server . 169 Error: “Memory Cannot Be Read” From Client Workstation . 169 Adjusting Zebra Printer Settings. 170 April 2005 Horizon Meds Manager Technical Guide Release 8.1 v

Table of Contents Horizon Meds Manager Technical Guide Adjusting Intermec Printer Settings . 173 Clearing Print Queue/Print Spooler . 176 Correcting Label Alignment (Okidata) . 177 Hung Print Jobs – Due to Network Issues. 178 Reports Dependent Upon MED-Archive Running . 178 Print Jobs Not Coming Out on Printer . 179 Report Server Has Been Down Too Long . 180 Report Server Is Hung. 180 Steps to Print Bar Codes on Labels . 182 Verifying Bar Codes are Printing Correctly. 182 Workload History Report Prints With No Content (Blank) . 183 SQL Script to Ensure Bar Codes Are Set Up Correctly. 183 Top Margin Cut Off Using HP Laser Jet Printers. 183 Top Margin Cut Off Using Zebra Printer. 184 Printing Return Label to Window Prints Blank Label to Window . 185 Drug Descriptions Not Appearing on Reports . 185 Unable to Print Bar Codes. 188 Unable to Print Bar Code on Label: "Error You are Trying to Create a Bar Code that Already Exists" . 188 Zebra or Intermec Labels Will Not Print. 189 Error Code 5, Access Denied . 190 Chapter 4 – Backup and Recovery. 193 Overview . 193 Backing Up the Horizon Meds Manager System. 194 Restoring the Horizon Meds Manager System. 195 Database Backup and Recovery (MS-SQL). 196 Recommended Database Backup Plans. 197 Production Database . 197 History Database . 198 Test Database . 199 Train Database . 200 MS-SQL Database Backup Plans . 201 Master Database . 201 Model, Msdb, Pubs, Tempdb Databases . 202 Oracle Backup Plan. 203 Chapter 5 – Change Control Procedures. 205 Overview . 205 Downloading Files from the McKesson Download Central Site . 206 Extracting ZIP Files . 206 Using the MED-SQL Utility . 207 Applying a Service Pack to Horizon Meds Manager . 211 Chapter 6 – First DataBank . 213 Overview . 213 Chapter 7 – Archiving. 215 Overview . 215 vi Horizon Meds Manager Technical Guide Release 8.1 April 2005

Horizon Meds Manager Technical Guide Table of Contents Chapter 8 – Interface Operations . 217 Overview . 217 Chapter 9 – System Operations. 219 Overview . 219 Resetting a User’s Horizon Meds Manager Password . 220 Overview. 220 Resetting a User’s Horizon Meds Manager Password Using Oracle . 220 Resetting a User’s Horizon Meds Manager Password Using MS-SQL . 221 Password Encryption. 223 Overview. 223 Encrypting User Passwords . 223 Configuring the System for Retail Functionality. 224 Updating Charge Codes . 225 Overview. 225 Running the Charge Number Update Utility . 226 Setting Up An Assignment To Filter Errors In the Work Queue . 227 Horizon Meds Manager’s Handling of Time Changes . 230 Time Change Impact . 230 Setting Up the Automatic Processor in Assignments to Handle a SEND CHARGE FILE Action. 234 Rebuilding a Report Server . 235 Rebuilding an Interface Server . 237 Rebuilding an MS-SQL Database Server. 239 Chapter 10 – System Information. 241 Overview . 241 Horizon Meds Manager System User Accounts. 242 Sources and Actions Recorded in the Transaction Log . 243 Transaction Sources. 243 Transaction Actions . 249 Horizon Meds Manager System Files. 255 Overview. 255 Files Inserted Into the WINNT\Crystal Directory. 255 System Files That Are Replaced or Added . 260 Files Installed In the Drivers Directory. 261 System Files That Are Updated If Needed . 261 Custom Crystal Report Files With Citrix . 262 Additional File Types . 263 Revision History. 265 April 2005 Horizon Meds Manager Technical Guide Release 8.1 vii

Table of Contents viii Horizon Meds Manager Technical Guide Horizon Meds Manager Technical Guide Release 8.1 April 2005

Horizon Meds Manager Technical Guide About This Document About This Document Overview Horizon Meds Manager, part of the Horizon family of client/server systems, provides a single solution for the enterprise-wide pharmacy. The system supports acute care, outpatient, and retail settings in single or multi-facility operations. This Technical Guide provides technical and system setup information regarding the Horizon Meds Manager system. Audience The Horizon Meds Manager Technical Guide is designed for users, database and system administrators, and other technical specialists. Document key The following formatting conventions are used throughout the Horizon Meds Manager Technical Guide. April 2005 Format Indicates “” a reference to another section of this document Bold a reference to a button, field, or table; also indicates emphasis on a critical instruction or step Courier information that is displayed on a window or a screen Courier bold text that you must type on a window or a screen Italics a reference to another document; also indicates emphasis on certain words (Example: do not delete this file) Horizon Meds Manager Technical Guide Release 8.1 ix

About This Document x Horizon Meds Manager Technical Guide Horizon Meds Manager Technical Guide Release 8.1 April 2005

Horizon Meds Manager Technical Guide Chapter 1 – Site Preparation Chapter 1 – Site Preparation Overview Introduction This chapter contains the minimum operating system and database requirements for the installation of Horizon Meds Manager. It also includes system diagrams that address the business logic behind the Horizon Meds Manager architecture and the hardware preparation required prior to installing Horizon Meds Manager on various operating platforms. In this chapter This chapter contains the following topics: April 2005 Topic See Page Overview 1 Installation Specifications 2 Multiple Table Spaces in Oracle 3 Horizon Meds Manager Possible Report, Interface, and Application Scenarios 4 System Diagrams 8 Horizon Meds Manager Technical Guide Release 8.1 1

Chapter 1 – Site Preparation Horizon Meds Manager Technical Guide Installation Specifications Please contact your McKesson account executive to obtain an updated list of supported database management systems, operating systems, report writer software, and Internet browser requirements, along with the hardware and software requirements for the Database Server, the Interface Server, and the workstations. 2 Horizon Meds Manager Technical Guide Release 8.1 April 2005

Horizon Meds Manager Technical Guide Chapter 1 – Site Preparation Multiple Table Spaces in Oracle The Horizon Meds Manager database has been set up to use multiple table spaces in Oracle. The following list describes the table spaces. The site may choose to rename the table spaces, if desired. MainTableSpace - this table space contains all of the tables that are expected to grow after initial system setup. These are primarily patient-related tables. IndexTableSpace - this table space contains all of the indexes for tables in MainTableSpace. SmallTableSpace - this table space contains all of the other tables in the database. It is relatively small and should not grow significantly. SmallIndexTableSpace - this table space contains all of the indexes for tables in SmallTableSpace. FDBTableSpace - this table space contains all of the First DataBank tables. FDBIndexTableSpace - this table space contains all of the indexes for tables in FDBTableSpace. The Master Configuration table contains a column for each of these table space names. When a create script is run in MED-SQL, Horizon Meds Manager will prompt for these table space names and then save those values to the Master Configuration table. MED-SQL determines the table space to which each table should belong by reading a table named Database Structure, and creating each table in the appropriate table space based on the information in the Master Configuration table. April 2005 Horizon Meds Manager Technical Guide Release 8.1 3

Chapter 1 – Site Preparation Horizon Meds Manager Technical Guide Horizon Meds Manager Possible Report, Interface, and Application Scenarios Overview This section provides different backup scenarios in instances where the report or interface servers fail. Scenario #1 The first possible scenario is a low-cost solution providing the minimum hardware to function with no redundancy of software or hardware. It relies on a backup of the server to be kept up-to-date in order to rebuild the server. This could cause considerable down time in the event of a hardware failure. This scenario consists of a single server running all of the Horizon Meds Manager services for both the production and test databases, including all interface engines. It also houses the application and pushes it out to the client in the event an update is needed. This server also houses all of the printers used by the pharmacy for all printing. Al

McKesson Information Solutions 5995 Windward Parkway Alpharetta, GA 30005 404-338-6000 Reader comments Any comments or suggestions regarding this publication are welcomed and should be forwarded to the attention of: McKesson Information Solutions 1241 Carwood Court Montgomery, AL 36117 or sent by e-mail to: HMMDocumentation@mckesson.com

Related Documents:

The VHF Frequencies Two Meters (2M) – 144 MHz to 148 MHz The Weak Signal part of the band is 144.0 MHz to about 144.5 MHz CW ONLY from 144.0 MHz to 144.1 MHz SSB Calling Frequency is 144.200 MHz RANGE– Modest station 150 –

Amtex Systems, Inc. 144 0 Amzur Technologies, Inc 144 14 Analysts International Corporation dba AIC Analysts Corporation 144 0 Apex Systems, Inc 144 30 . KMQ Enterprises, Inc. 144 39 Knovitas LLC 129 0 Latavco Consulting Group, LLC 93 39 Loblolly Consulting, LLC 103 29 Logic House, Ltd 144 54

Volume 36, Number 21 July 15, 2019 Publication Pages 483-1092 PLEASE NOTE: This is not the official version of the Oklahoma Administrative Code. . USDOT number required 165:30-10-3. Liability insurance 165:30-10-5. Deleterious Substance Transport Permit 165:30-10-7. Hazardous waste transportation 165:30-10-9. Minimum standards Part 3 .

FREQUENTLY ASKED QUESTIONS ABOUT RULE 144 AND RULE 145 Understanding Rule 144 under the Securities Act of 1933 What is Rule 144? Rule 144 permits public resales of the following, without having to register the resale with the Securities and Exchange Commission (the SEC): unregistered securities acquired directly from

1.25 in/33 mm Cable (OD) 18.2 mm Initial installation two 144-F cables Total capacity 2 x 144 F 288 F Figure 7. Standard 288-fiber loose tube cable placed in a standard duct compared to two 144-fiber cables placed in a microduct system Figure 8. Upgrade path utilizing a 144-fiber cable in microducts Figure 6. Payout of a 144-fiber MiniXtend .

List of Tables and Appendices ii r.144.2 Abstract vi r.144.3 1 Introduction 1 r.144.4 2 Methodology 7 r.144.5 3 Productivity of Teak Plantations 16 r.144.6 . available, no other money yield tables for teak in Kerala have since been published. Perhaps with teak prices changing on a monthly basis, money yield

Noegel, Seth 11 Vermilion Catholic 1A 158.90 165.3 415 230 405 1050 2 Purpera, Joseph 11 Catholic HS of Pointe Coupee 1A 157.70 165.3 360 300 365 1025 3 Windham, Jackson 12 Calvary 1A 155.30 165.3 385 225 405 1015 4 Seguin, Rory 12 Central Private 1A 158.10 165.3 375 210 405 990 5

From The N3UJJ.COM Document Library m 144/440 MHz FM DUAL BANDER TH-79A 144/430 MHz FM DUAL BANDER TH-79A 144/430 MHz FM DUAL BANDER TH-79E INSTRUCTION MANUAL