Pharmacy System Data Storage: The Case for a Standard | Print |  E-mail

Author Photo

by Brad Ordener

With each passing year healthcare and other industries are becoming more and more reliant on technology. Pharmacy is one industry that is particularly dependent on new innovations to keep up with increasing demand. As this reliance on technology increases some unique problems are emerging that are slowing progress and making it difficult for pharmacy owners to change pharmacy systems. The technological landscape in pharmacy could be improved significantly with the adoption of a data storage standard as a part of the foundation for developing new technologies and industry practices.



The History

Technology in pharmacy has always been a mix of various innovations and proprietary software and hardware. We have seen many important improvements that make our lives easier. We have seen the emergence of online claims billing, e-fax, digital hard copy images, digital signature logs, e-prescribing, etc. Some of tools have developed nicely while others haven't. One of the differences between technologies that have had successful deployment across pharmacy and those that haven't is the creation of standards. For example, we have NCPDP to thank for creating a universal standard so we can bill insurances for our patients regardless of the software system, location, drug etc. Now, we are seeing the emergence of universal standards for e-prescribing and even the beginning of a standard for billing MTM and other clinical services.


Despite the successful application of standards in these and other areas, one place where we don't have a standard is in the way that we store the data  accessed by pharmacy management systems, including patient, prescriber, and drug data. Wouldn't it be wonderful if every pharmacy system stored this data in the exact same way? Let's explore the implications of this for a moment. A benefit of a universal standard is the capability for multiple systems to interpret and make changes to the same data. Imagine implementing a new pharmacy system on a trial basis for a few hours or a few days and switching effortlessly back and forth until you find the system that is right for you. Consider the competition and ultimately, innovation that this type of standard could drive. Another possible application for this may be a transition period in which an owner could use his or her new pharmacy system during portions of the day that are less busy. When the going gets tough the old system can be used until things calm down. As long as the old system and hardware are available they can be used when necessary until the new system has been mastered.


A Few of the Benefits

Off-site backups could be streamlined as well. When data is stored in a standard format the off-site storage solution can know what the data will look like and how to interpret the data it receives. This allows the source to send less information. Imagine that the database is a series of bookcases filled with trays. In this analogy the book case is a data set (e.g. one patient) and the trays are individual fields (e.g. patient name). The information sent in the initial backup only needs to consist of the data and which bookcase and tray it fits in. This is significantly less information to transmit compared to making a mirror copy of the drive that is being backed up. Once the database is copied the first time it's even faster. Changes since the last back-up can be flagged and only that information would be sent to update the off-site copy of the database. This significantly reduces the amount of time required to perform a backup. And keep in mind, if you aren't backing up your data you aren't protecting your most valuable asset.


There are other benefits. With a standardized database structure we could more effectively encrypt and protect data. This is particularly critical when you consider that there has been an increasing amount of talk about, and some use of, public databases in pharmacy. Many states have started tracking and sharing information on controlled substances to help identify abuse and diversion. Many of us have heard about and supported efforts to create electronic health records by making patient charts and profiles accessible via a national database for all healthcare providers. If a data storage standard exists as these systems are created, the aggregation and sharing of this data will not only be more secure, but it will be effortless for our industry as well. The list of potential benefits goes on and on.


Encouraging Competition

And how would a standard contribute to pharmacy system innovation? Simply put, if it were easy to change from system to system within a matter of minutes or hours pharmacy owners could more easily find and buy the best system for their needs. Without standards, changing pharmacy systems is difficult. Even if there is a better system out there we can't or won't use it. Vendors are well aware of this fact and are slow to invest in their products because of it. These technical barriers can be advantageous to vendors who aren't innovating at the cost of pharmacists and patients. When a new technology emerges companies often add it to their product but rarely do it well. Too many pharmacy systems contain poorly integrated and executed pieces of technology. For example, when e-prescribing came to the forefront of new technology in pharmacy most, if not all, developers added support to their software suite. Many of these companies' products still don't offer full functionality several years later. In a world where it is easy to switch systems because of data storage standards, pharmacists could readily move to the system with the best e-prescribing tools, or whatever the newest and most important feature may be. This is true for digital record keeping and other items as well. This industry is in need of more fierce competition to drive product development and a data storage standard is a great way to make it happen.


Moving to Standards

The creation of a standard like this would present some technical challenges for the users and developers. Many pharmacies are operating outdated versions of pharmacy systems. Because of resistance from pharmacy owners, most vendors continue to support these old versions of their systems despite threats to stop. Pharmacies that operate these older systems might experience more challenges moving to standardized databases than those that upgrade regularly, but the benefits would be worth the extra effort. Vendors already create data migration tools for each new version of their software. In order for a pharmacy to move from a several-version-old system to a current system using standardized databases they would most likely need to take a step-wise upgrade approach from their outdated system to the new version.


As far as development goes, the developer would have to create a data migration tool in order to fill in the new database. On top of this developers would have to modify or create a system to use the new standard. The logical approach for vendors is to only create a data migration tool to work with their current system however it is certainly possible to create several migration tools for the vendor's various software versions. I can't neglect to mention that someone would need to create a data storage standard first. The standard I envision is essentially an all-inclusive collection of all the types of data pharmacies store that has been consolidated and formatted for use by any pharmacy system. The database itself would need cross platform support to allow use by Linux, Unix, and Windows based systems. There are competing database solutions currently available that have this capability.


What can we do? Someone in our industry must take the lead. This type of standard is not very difficult to create. Each company would have to dedicate some additional resources to convert to it's use yet that isn't necessarily a major barrier. The difficult aspect of a project like this is convincing the industry to participate. Perhaps a good first step we can take is presenting this idea to our national associations and politicians. Whatever the catalyst, data storage standards will be an important piece of future technology in pharmacy.

Brad Ordener is a student pharmacist in his final year at Midwestern University College of Pharmacy in Glendale, Ariz.  He has experience in community and hospital pharmacy as well as a background in computers. He has been involved in pharmacy system testing, troubleshooting and implementation during his short time in the field of pharmacy.  Brad can be reached at brordener@gmail.com.

 

Exclusive Pharmacy Technology Content

Pharmacy System Data Storage: The Case for a Standard

Author Photo

by Brad Ordener

With each passing year healthcare and other industries are becoming more and more reliant on technology. Pharmacy is one industry that is particularly dependent on new innovations to keep up with increasing demand. As this reliance on technology increases some unique problems are emerging that are slowing progress and making it difficult for pharmacy owners to change pharmacy systems. The technological landscape in pharmacy could be improved significantly with ...

Read more...
Pharmacy Training On Demand
jay_lalkiya_1.jpgIn this interview, pharmacist Jay Lalkiya talks about how he's using a tool called myPharmacyTrainer to educate his staff at Apalachin Pharmacy about how to improve store operations and how best to interact with customers. This tool offers 22 modules that recreate scenarios commonly encountered by pharmacy staff and employs an interactive, audio/visual educational approach.

Read more...
Technology Perspectives: Pharmacy and Healthcare Reform

ctpodcast_image.jpgIn this podcast, McKesson Pharmacy Systems President Stanton McComb covers a range of topics surrounding pharmacy, technology, and the current drive for healthcare reform. He offers his take on what new roles pharmacy may play as a result, the growing role of clinical care in pharmacy, and what’s on the horizon for technology for the pharmacy and for the patient. Also part of the discussion: What MTM means for retail pharmacy right now and what it ...

Read more...
The 90% Nightmare

jeremy_manchester.jpgFor the last twelve months, many independent pharmacies have struggled over the decision of whether to register their pharmacy under the 90% Rule, or invest in an IIAS certified point-of-sale.  For one reason or another, many pharmacies opted for the 90% Rule.  It seemed like a logical choice.  No expensive point-of-sale, no major changes, just a little complicated paperwork and it is back to business as usual.  For some, this has worked out.  For others, FSA card declines have ...

Read more...
Boost Front-End Sales with Proper Merchandise Placement

dick_bradley.jpgPharmacies already have OTC items in their stores, and with a little planning and proper placement, those standard items can turn into added sales at the POS.

Read more...
Some More Thoughts on Paperless Pharmacy

integra_logo.jpgThis letter from Integra CEO Kevin Welch is in response to the article written by Kapali Eswaran in the September/October 2009 issue of ComputerTalk regarding "What to Look for in a Paperless System."

Read more...
Perspectives on E-Prescribing: Pharmacist and Physician

ken_lalime.jpgAn Interview with the Connecticut State Medical Society-IPA Executive Director, Ken Lalime.

Listen to the podcast now

Sponsored by Emdeon

E-Prescribing: An Update

erx_logo.jpg

In this interview, eRx Network's VP of Clinical Services, Rick Sage, talks to ComputerTalk senior editor Will Lockwood about where he sees ePrescribing right now and the role companies like eRx play as adoption increases.

&...

Read more...
Strategies for Managing Prescription Pricing and Patients’ Prescription Costs

justin_wilson_head_shot.jpgAn Interview with Valu-Med Pharmacy’s Justin Wilson

Listen to the podcast now

Sponsored by Emdeon

Read more...
Technology and the Pharmacy School Curriculum

amypeak08.jpgkent_van_tyle.jpgThe mobile technology initiative in Butler University's College of Pharmacy and Health Sciences started four years ago with the introduction of laptops for all pharmacy students. A year later laptops were replaced with tablet PCs, which allow students to draw structures, write equations, and ...

Read more...
A New Online Resource for Ownership Transition

bob_graul.jpgLong-time independent pharmacist Bob Graul has made some big changes and taken a new direction recently. In this interview with ComputerTalk senior editor Will Lockwood, Graul talks about the process of selling his pharmacies and how this motivated him to get involved in his current project: www.RxOwnership.com, a Web site designed to facilitate independent pharmacy ownership transition.


Read more...
Reorganizing the Pharmacy: Learning from a Distribution Model

tcgrx_logo.jpg Duane Chudy, president of TCG, has a long history in pharmacy automation. Beginning with a career at Baxter nearly 25 years ago, Duane pioneered the launch of automated tablet packaging and has since designed and implemented revolutionary new products for a number of pharmacy markets. In this interview with ComputerTalk's Will Lockwood, he offers his insight into how his newest technology venture is bringing an new ...

Read more...
Operating Systems: The Developer’s Perspective

hcc_logo.jpg In this interview with ComputerTalk's Will Lockwood, HCC VP of Sales Larry Stephenson discusses some of the choices software vendors face when choosing development tools and how these choices influence the end product, from what the user sees to what's under the hood.

Read more...
A Nice Side Benefit of IIAS: Easier Giving

QS/1 user Richard Stryker, of Bayshore Pharmacy in Atlantic Highlands, N.J., anticipates that his IIAS-compliant POS system is going to help his customers help others. Here's how he tells this story.

Read more...
Meeting the FSA Challenge with flexTRAX

Brad Jones and Brandon ShueyYou're probably aware that as of January 1, 2009 there will be new rules for pharmacies processing payments for items eligible for FSA/HRA spending.  If you have a point-of-sale (POS) system, you'll need to make sure it is IIAS compliant and that your system has been certified. If you don't have POS, then you may be looking for another solution.  In this interview, Retail Management Solutions President Brad Jones and KeyCentrix ...

Read more...
Automating Front-End Tasks with POS

ECRS's Peter CatoeManaging a pharmacy's front-end can be a time-consuming and complex task. But there are ways to make life easier. In this interview with ComputerTalk's Maggie Lockwood, ECRS President Peter Catoe talks about how the company's Supplier Gateway can connect its Catapult point-of-sale (POS) system with supplier ordering systems to reduce the time spent on ordering, pricing, and other activities.

Read more...
Better Marketing: You Can Start Now

dave_williams.jpg

By Dave Williams

In an increasingly competitive marketplace, many pharmacies are looking to cultivate greater customer affinity with a branded loyalty program. One misconception among many retailers is that these programs have to be complicated. Nothing could be further from the truth. By simply instituting a loyalty program where customers perceive some added value, store visit frequency and average basket size should increase by at least 1% to 2%. Such a sales increase ...

Read more...
Summer Roundup: Technology Support Services on Call

daa_logo.jpg

onclicktechsupport.jpgIn this interview with ComputerTalk's Will Lockwood, DAA VP for business development Abrar Kazmi talks about the company's new OnClickTech Support offering, which offers remote PC support. This is a joint venture with Team 9 Global Serivces, and is something a little different for ...

Read more...
Summer Roundup: Introducing McKesson EnterpriseRx

stanton_mccomb_2008.jpg McKesson Pharmacy Systems' (MPS) president Stanton McComb took time during the most recent McKesson Trade Show in Las Vegas to answer a series of questions from ComputerTalk's Will Lockwood about what the centrally-hosted EnterpriseRx pharmacy management product, already deployed in the chain setting, offers for independent pharmacy.

Read more...
Summer Roundup: Automation and the Successful Pharmacy

doug_kaleugher1.jpgPharmacist Doug Kaleugher opened Med-Fast Pharmacy 1990. Since then the business has expanded to 22 pharmacies in western Pennsylvania, with a mix of standard prescription services, retail, long-term care, and compounding. In this interview with ComputerTalk's Will Lockwood, Kaleugher talks about the big role dispensing automation has played Med-Fast's growth. He also offers strategies for introducing automation into your pharmacy and his take on the benefits of some of the newest dispensing technology out there.

Read more...
Summer Roundup: Investing Wisely in Workflow

Dave Burke in the Innovation Exhibit at the Cardinal RBCDave Burke R.Ph, M.B.A., pictured at left in blue, owner of Dave’s Pharmacy in Marysville, Ohio, took some time out at the recent Cardinal RBC to talk with ComputerTalk's Will Lockwood about his decision to a install a workflow management system and the benefits he has seen. Dave’s Pharmacy fills an average of 400 prescriptions per day, with peaks on some ...

Read more...
Summer Roundup: How to Tighten Up Your Inventory
jonathan_rider.jpgJonathan Rider, owner of Rider Pharmacy in Fairmont, W.Va., is a firm believer in perpetual inventory. He took a few minutes at the Cardinal RBC in Orlando, Fla., to talk to ComputerTalk’s Will Lockwood about Cardinal Inventory Management (CIM), how he uses Kirby Lester counting technology to speed through the daily counts that are the basis for this inventory tracking method, and the financial and operational improvements he’s seen.
Read more...
Pharmacy Facing New Compliance Challenges

joeross_2.jpgJoe Ross, director of business services at McKesson Pharmacy Systems, talks in this interview with ComputerTalk senior editor Will Lockwood about existing and anticipated regulations that are changing what drug sales pharmacists are required to log. State and Federal regulations that require tracking the sale of non-prescription methamphetamine precursors have contributed to a demonstrable reduction in the illegal use of these drugs. More regulation may be in store, since the FDA is currently considering a behind-the-counter class of ...

Read more...
Five Questions: The Buzz Around E-Prescribing

heath_reynolds.jpg Here is an overview of the big questions about e-prescribing that pharmacists were asking Speed Script’s Heath Reynolds during the 109th NCPA meeting in October. Reynolds, director of business development, talks here of the nuts and bolts of taking e-prescribing from theory to practice.

Read more...
Outbound Messaging: Expanding Your Phone’s Potential Workflow Role
The benefits of automating phone communications are no longer just at the front end of the prescription-filling proces. Pharmacists are now putting their phones to work managing outbound calls that help with such tasks as will-call management and opt-in automatic refill programs.
Read more...
Workflow and the LTC Pharmacy

Pharmacies serving the long-term care market are likely to have special workflow requirements. Read on for vendors' views on the key elements to maximize LTC safety and efficiency.

Read more...
What's New: The Latest Workflow Features

Workflow technology is constantly evolving. Here are some details on the latest enhancements that vendors have added to their offerings.

Read more...
Beyond Claims Adjudication: Why to Expect More from Your Switching Service

Marc CohenComputerTalk senior editor Will Lockwood caught up recently with Marc Cohen, senior director of marketing for RelayHealth, to talk about what's happening in the world of claims processing and switching services. It turns out that there are some interesting new additions being made that build on the transactional expertise and connectivity that are the core elements of these services.

Read more...
Differentiating Independent Pharmacy: Natural Health, Loyalty Programs, and a Real Web Presence

In this interview with ComputerTalk senior editor Will Lockwood, PharmacistsOnLine CEO David Knaggs offers his views on how independent pharmacists can improve their competitiveness by turning their attention to tested marketing tools and to product lines that have not traditionally been a big part their business.

Read more...
Pharmacy Viewpoint: McKessons Stanton McComb

McKesson Pharmacy Systems President Stanton McCombMcKesson Pharmacy Systems (MPS) President Stanton McComb sat down with ComputerTalk senior editor Will Lockwood at the McKesson Pharmacy Strategies Conference and Trade Show in Boston in July to talk about recent changes at MPS resulting from the Per-Se Technologies acquisition, the newest technology that MPS is offering, and the changes he sees ahead for retail pharmacy practice.

Read more...
Five Questions On: Trends in Technology for the Consultant Pharmacist

carla_and_spiro.jpg

In this interview with ComputerTalk's Maggie Lockwood, the American Society of Consultant Pharmacist’s Carla Sexton, R.Ph., CGP, assistant director, policy and advocacy, along with consultant and ASCP board member Shelly Spiro, R.Ph., FASCP, talk about the ways evolving technologies, from web-based interfaces to the LTC e-prescribing pilot, are impacting the consultant pharmacist.

Read more...
Parata RDS On Tour

Parata Mobile unit's visit to ComputerTalk Parata brought its RDS robotics directly to ComputerTalk recently, courtesy of its new mobile unit. The concept was developed over the past year as a way to reach out to busy community pharmacists.


Read more...
Trends in Dispensing Automation

tomrhoads_contents.jpg In this interview with ComputerTalk's senior editor, Will Lockwood, Parata's executive VP of sales and marketing, Tom Rhoads, pictured at left, discusses the results and lessons of two recent surveys on dispensing automation that covered independent, chain, and institutional pharmacies. Read on for his take on the trends revealed, pharmacists' attitude toward their industry and their future, and the tools that can help make sure that investment in automation pays dividends.

Read more...
Farmacia En Internet