Development of a Pharmaceutical Product Management System

Abstract

We developed a total management system of hospital preparations to manage the preparation of raw materials, hospital preparations and the use of patient information for hospital preparations generally in Aichi Medical University Hospital and built a safe means of preparing the hospital preparations and an appropriate use regime. We used an object-relational database management system. The main functions are the management of raw materials of hospital preparations and hospital preparation stock, checking preparations and management of information of hospital preparations. In administration of hospital preparation stock, when raw materials of hospital preparations are stocked, we record in the system the batch number of raw materials for hospital preparations to secure their traceability. When the system is started up, the information of hospital preparations is shown on the display before a deadline that makes possible the administration of all hospital preparations in terms of validity in the hospital. In preparing an evaluation, we made a preparation master of hospital preparations and then raw materials of hospital preparations were authenticated and the weight checked to make it possible to prepare hospital preparations by only a pharmacist. It was effective in reducing the working hours for preparation and recording information. Moreover, the information of patient＇s administration ensures that informed consent is obtained where necessary and reports on clinical use results are collected. The clinical use results report recorded in the system make it possible to administer hospital preparations validly, safely, and with awareness of the side effects.