307x Filetype PDF File size 0.31 MB Source: msh.org
Part I: Policy and economic issues Part II: Pharmaceutical management Part III: Management support systems
Planning and administration
Organization and management
Information management
48 Monitoring and evaluation
49 Pharmaceutical management information systems
50 Computers in pharmaceutical management
Human resources management
chapter 50
Computers in pharmaceutical management
Summary 50.2 illustrations
50.1 Uses of computers in pharmaceutical Figure 50-1 Summary of illustrative integrated
management 50.3 pharmaceutical supply management software
50.2 When and how to computerize 50.3 and characteristics 50.10
Benefits and limitations of computerization • Starting the Table 50-1 Computer applications for pharmaceutical
computerization process • Computer software: options and management 50.3
guidelines • General-purpose software • Special-purpose Table 50-2 Computer hardware specifications 50.8
commercial software • Utility programs • Network Table 50-3 Select features of registration software 50.15
software • Custom software • Open source software • boxes
Computer hardware: options and guidelines • Geographic Box 50-1 Key steps in the computerization process 50.4
information systems Box 50-2 Illustrative phases in computerization 50.4
50.3 Specialized software for pharmaceutical management Box 50-3 RxSolution 50.12
and control 50.9 Box 50-4 Standard reports for supply management
Quantification of pharmaceutical requirements • Basic software 50.13
data analysis and production of formulary manuals • Box 50-5 Developing a website or posting materials to the
Procurement and inventory management • Hospital Web 50.17
pharmacy management software • Accounting and Box 50-6 Lessons for successful computerization 50.18
financial management • Drug use reviews •
Pharmaceutical product registration country studies
50.4 Electronic communications and medicine CS 50-1 Sample computerization experiences 50.5
information 50.14 CS 50-2 Using handheld computers in pharmaceutical
Electronic communications • Medicine information • management 50.9
Developing a website CS 50-3 Creating an Internet-based information system for
50.5 Maintenance and support requirements 50.16 HIV treatment in Haiti 50.14
Staff recruitment and training • Protecting data • annex
Maintaining computers Annex 50-1 Building a product master file in a
50.6 Lessons for successful computerization in database 50.22
pharmaceutical management 50.18
Assessment guide 50.19
References and further readings 50.19
Glossary 50.21
copyright management sciences for health 2012
©
50.2 InFoRMATIon MAnAGEMEnT
suMMary
Users should first define what functions or tasks com- • output and peripheral devices (monitor, printer,
puters will be used for, identify appropriate software for modem, network card, speakers)
those functions, and then select hardware that is capable Software refers to instructions that can be understood
of using the software efficiently. and executed by the computer. Categories include—
A computerization process is easier when— • The operating system, which coordinates and directs
• Efficient manual procedures exist information for the microprocessor
• Staff members are capable of, and interested in, • General-purpose software, such as word processing,
learning to use computers spreadsheets, and database management software
• Funds have been allocated for training, mainte- • Special-purpose software, such as presentation
nance, and equipment upgrades graphics, project management, and accounting soft-
• A reliable power supply exists ware
Pharmaceutical management programs should usu- • Utility programs, such as antivirus, file backup, and
ally begin with basic word processing and spreadsheet data recovery programs
applications. Users can then gain experience and develop • Specialized pharmaceutical management software,
support systems for supplies, repairs, and security. often a custom-programmed database application
Specialized pharmaceutical management programs are When used effectively, computer systems save money,
often used for quantification of pharmaceutical require- promote efficiency, and improve the quality of services.
ments, procurement, inventory management, or However, poorly conceived or implemented computer
medicine-use analysis. systems waste money, decrease efficiency, and distract
Medicine information is increasingly available through attention from other management improvements.
electronic communications systems. Most pharmaceuti- This chapter discusses the uses of computers in phar-
cal supply systems have access to Internet communica- maceutical management and examines special issues in
tions. Two main options are available: e-mail and World computerizing pharmaceutical management informa-
Wide Web browsers. Use of the Internet for international tion. It also includes specifications for computer applica-
communications has become increasingly important. tions in pharmaceutical management, considerations for
Central to most pharmaceutical management applications hardware selection, and requirements for maintaining
is a product master file, including product name, strength, and supporting computers. Preparing data for comput-
dosage form, therapeutic category, route of administra- erization is discussed, along with coding systems and
tion, and packaging. A coding system with a unique iden- definitions of units. This chapter focuses on personal
tifier for each drug product must be developed. computers because they are the most widely used by
essential medicines programs. Instructing users in par-
Personal computers, or PCs, can be used in all aspects of ticular software programs or making recommendations
the pharmaceutical management cycle. Hardware refers for the purchase of a specific piece of hardware or soft-
to the computer’s electronic and mechanical parts, which ware is beyond the scope of this chapter.
include— The question today is usually not whether but rather how
• A microprocessor chip and how much to computerize. Even more important,
• Memory chips (RAM, for random-access memory) however, is how to computerize efficiently. This chapter
• Input devices (keyboard, flash drive, mouse, scanner) provides guidelines to help decision makers computerize
• Storage devices (hard disk drive, CD-RoM, mag- their operations effectively.
netic tape)
50 / Computers in pharmaceutical management 50.3
50.1 Uses of computers in pharmaceutical Table 50-1 Computer applications for pharmaceutical
management management
Computers can be used in all aspects of the pharmaceutical area of activity uses
management cycle, from selection to use. Using commu- Project planning • Workplans
nication devices, users can exchange or share information • Simulation programs
with other computers at the same site through a local area • Annual reports
network (LAn) or with computers anywhere in the world. Selection • Preparation of essential medicines lists
The term computers here also encompasses devices such as • Literature searches
personal digital assistants (PDAs) and handheld and pocket Requirements planning • Quantification of pharmaceutical needs
devices such as “smartphones.” Table 50-1 summarizes some • ABC analysis
• Weight and volume analysis of kits
of the many current computer applications for pharmaceuti- Financing • Budget management
cal management. • Pharmaceutical sales monitoring
• Accounting
• Financial analysis
50.2 When and how to computerize Procurement • Tender document preparation
• Tender monitoring
Computer technology changes quickly, with machines con- • Bid analysis
tinually becoming faster, more capable, and less expensive. • Preparing purchase orders and
receiving reports
The benefits of computers in managing pharmaceuticals • Monitoring of order status
depend on the choice of tools, the commitment to using the Inventory control • Monitoring of stock positions
tools, and the ability to overcome the hurdles involved in • Monitoring of expiry dates
incorporating computers into the organization. no standard • Prediction of reorder dates and
formula exists for successful computerization in pharma- quantities
ceutical management, but rather a mix of elements applies; • Invoicing
the right mix can yield great benefits. Transport • Vehicle routing and scheduling
• Weight and volume calculation
Benefits and limitations of computerization • Transport voucher preparation
Pharmaceutical • Database of registration data
registration and control • Adverse reaction reporting
Some of the benefits of computerization are to— • Medicines recalls
Medicines information • Formulary preparation
• Simplify and speed up complex tasks • Literature searches
• Increase accuracy by checking spelling, calculations, • Data storage and transfer
and data integrity • Pharmaceutical bulletin production
• Update and access information quickly • Training material preparation
• Automate repetitive tasks Rational use • Formulary
• Provide management information for decision making • Standard treatment schedule
• Allow organizations to expand operations • Calculation of WHO medicine-use
indicators
• Streamline administrative processes • Survey analysis
• Generate timely reports without repetition • Training (simulation games)
Personnel management • Training software
nevertheless, computers do have limitations. They cannot • Personnel records
assume responsibilities, make decisions, define problems, set • Supervision monitoring
objectives, improve the basic data available, or make a per- • Payroll calculations
son more organized. They cannot fulfill needs if appropri- Health statistics • Population data
ate hardware and software are not chosen, and they are not a • Morbidity data
• Mortality data
one-time expense: funds are required for upgrades, training, Use • Health care coverage calculations
and support over time for both hardware and software. • Medicine consumption analysis
Conditions in an organization that support computeriza- Presentation • Graphs and charts
tion include— • Overhead transparencies or slide shows
for training
• Efficient existing manual procedures Communication • Fax
• other departments that have computerized success- • E-mail
fully • Mailing
50.4 InFoRMATIon MAnAGEMEnT
Box 50-1 Box 50-2
Key steps in the computerization process Illustrative phases in computerization
1. Identify the tasks or the system to be computerized Phase I: Convenience computing
with a detailed analysis of needs compared to cur- This phase includes tasks that could be done with a
rent systems. typewriter and calculator but are easier on the com-
2. Survey the environment and consider integrating puter. If the computer “goes down” (temporarily stops
with other systems to the extent feasible. (What working), the work can still be done. Examples are—
software and hardware are being used by other • Word processing
departments? Does an institutional computer pol- • Simple databases (for example, an address list)
icy exist? What equipment is already available?) • Simple budgets
3. Evaluate the staff situation (actual versus needed).
4. Select software before hardware. Phase II: Periodic analyses and special activities
5. Identify whether the software needed is available These tasks would be extremely difficult to do by hand
in the local language and to which original version but could be delayed for a few days or weeks if the
it is equivalent (non-English-language versions are computer were down. Examples are—
sometimes not as current as English versions). • Quantification exercises
6. Ensure the availability of supplies and maintenance. • Complex project budgets
• Survey analysis
7. Select the hardware and software suppliers that pro- Phase III: Essential daily activities
vide the most support.
8. Plan progressive implementation (one step at a These tasks involve large volumes of data handled daily
time) and involve current and future users in the or almost daily. If the computer went down, the work
design and implementation process. would be seriously impaired. Examples are—
• Inventory control
• Accounting
• Staff capable of, and interested in, operating computers • Pharmaceutical registration
• A reliable power supply
• Adequate funds to support maintenance, training, and
equipment upgrades
shared? Will a network be necessary? The key steps are listed
Conditions that can impede computerization include— in Box 50-1.
In computerization, users should walk before they try to
• Hardware or software not suited to the task run. Trying to do everything at once increases failure rates,
• not enough trained operators so organizations often computerize in phases (see Box 50-2).
• Lack of a maintenance plan This strategy enables computer operators to handle increas-
• Lack of reliable power (voltage surges ruin computers ingly demanding tasks, permits support systems for supplies
and databases) and repairs to develop, and allows security systems to be
• Inadequate supply of storage media, paper, or printer put in place to protect against electrical damage, computer
ink and toner viruses, theft, and other hazards.
• Unsuitable physical environment (exposure to dust, Perhaps most important, a phased approach to comput-
heat, or magnets, which can damage hardware and erization allows users to develop a clearer concept of what
software) computers can do, what kind of information they want
from the computerized system, and which modifications
Starting the computerization process they need to make in reporting and management systems to
obtain that information. Computerization must be planned
Begin with the basic questions: What will the computer be carefully so that implementation occurs smoothly, with a
used for? Who will use it? Where will it be used? What is the minimum of interruption and dislocation in the organiza-
budget for equipment, software, and maintenance? What tion’s work. Country Study 50-1 provides some examples of
special functions may be required? Will data need to be good and bad computerization experiences.
no reviews yet
Please Login to review.