The decentralized pharmacy model brings with it the opportunity for pharmacists to be an integral part of the medical team. This includes following teams of healthcare provides, physicians, nurses, respiratory therapists, etc, on morning rounds. And like all good little pharmacists we like to be prepared with as much information as possible about the patient. Several methods for collecting data have been developed over the years, including the all time favorite; the 3×5 index card. The problem with this system is obvious; itâ€™s prone to human error. Taking information from one source and transcribing it somewhere else simply increases the chance for error. In addition, the information may be inaccurate as things can change rapidly with hospitalized patients, especially in areas like the ICU.
Like many other professions, pharmacists donâ€™t particularly like change. So when I offered to relieve them of their 3×5 index cards with a more high tech solution they were a little hesitant. It took some persuasion, but I was finally able to convince them that all the information they needed was readily available in electronic format. Unfortunately the information was scattered throughout several systems, requiring multiple clicks and views. The solution was to create a â€œrounds reportâ€ that would pull information from the various systems and display it in a single location.
Iâ€™m certainly not an expert with database design, but I can get around â€˜okâ€™. The report displayed below is the final version of the pediatric rounds report that was created. I also created one for ICU rounds. The information displayed in the report is pulled from various SQL tables on the back end of the pharmacy system in addition to a little visual basic used to grab the most recent lab values from the laboratory system. With a little encouragement I was even able to get the pharmacists to use the â€œNotesâ€ section in our pharmacy system to leave information for each other regarding the patient. Paired with a tablet PC, the report has given the pharmacist a giant, electronic, real-time index card. Sweet!