JP2022098543A - Medical product warehousing service support system - Google Patents

Abstract

To allow for efficient warehousing service when warehousing a new medical product for which a storage place is not determined.SOLUTION: A terminal device (or a server device) comprises: a registration determination unit 12 which determines whether or not a storage place for a medical product to be warehoused is registered with a database of a storage place storage unit 21; a storage place candidate presentation unit 14 which selects and presents candidates for storage place on the basis of information in the database in which medical product information of the medical product to be warehoused, storage conditions of medical products, and storage places of the medical products are stored; and a storage place registration unit 16 which registers a storage place selected from the candidates with the database as a storage place for the medical product to be warehoused. When a new medical product for which a storage place is not determined is received, candidates for storage place are automatically presented and a user merely selects one of them to register the selected storage place with the database as the storage place for the medical product to be warehoused.SELECTED DRAWING: Figure 2

Description

The present invention relates to a drug warehousing business support system, and is particularly suitable for use in a system that supports a drug warehousing business.

Conventionally, a system for performing warehousing processing and warehousing processing based on drug ordering data and delivery data has been known (see, for example, Patent Documents 1 and 2).

The dispensing pharmacy support system described in Patent Document 1 is the minimum unit of sales such as a drug name, a drug code (a code given by the Ministry of Health, Labor and Welfare for each type of drug) and a product distribution code (JAN (Japanese Article Number) code). A drug master data storage unit that stores drug data associated with each drug), a warehousing processing unit that performs warehousing processing using the product distribution code attached to the drug, and a drug code, product distribution code, or An intermediate code associated with these codes (a code for each vendor given by the provider of the dispensing pharmacy support system) is used for issue processing, and a drug code, product distribution code, or intermediate code is used for inventory management. It has a management department.

In the storage / sales management system described in Patent Document 2, pharmaceutical products delivered to the pharmaceutical stock center in lot units are subjected to flexible warehousing / delivery processing, picking processing, sales processing, etc. regardless of whether they are in packaging units or subdivisions, and are dispensed. It is sold to general consumers through pharmacies. The server accepts the product data and lot number or expiration date data of the drug obtained by reading the delivered drug incidental code and lot number or the expiration date printing by the reader terminal, etc., as well as the corresponding drug. The warehousing data is associated with the shelf number of the storage shelf in which the goods are stored and registered in the inventory database.

Japanese Unexamined Patent Publication No. 2005-115878 Japanese Patent Application Laid-Open No. 2003-118840

According to the system described in Patent Documents 1 and 2, the code attached to the drug or the packaging box is read by a handy terminal or the like, and the information obtained by the code is used to perform the warehousing process and the warehousing process of the drug. Is possible. However, although the above-mentioned Patent Documents 1 and 2 refer to the warehousing process of the drug whose linking information with the storage position of the drug shelf is already registered in the database, the linking information is registered in the database. No mention is made of the process of warehousing new medicines.

An object of the present invention is to make it possible to streamline the warehousing operation when warehousing a new drug whose storage location is not determined.

In order to solve the above-mentioned problems, in the present invention, it is determined whether or not the storage location of the delivered drug, which is the target drug for warehousing, is registered in the database, and if it is determined that the storage location is not registered, the target for warehousing is determined. Based on the drug information of the drug, the information indicating the storage condition of the drug, and the information of the above database that stores the storage location of the drug, the candidate of the storage location of the drug to be stored is selected and presented. Then, the operation of selecting one of the presented candidates is accepted, and the selected storage location is registered in the database as the storage location of the drug to be stored.

According to the present invention configured as described above, when a new drug whose storage location is not determined is delivered, a candidate storage location is automatically presented, and the user can select one of them. All you have to do is select it. When the user performs an operation of selecting a storage location, the selected storage location is registered in the database as a storage location for the drug to be stored. In this way, when warehousing a new drug whose storage location has not been determined, the user only has to select one of the presented candidates, and the warehousing operation can be streamlined.

It is a figure which shows the configuration example of the drug warehousing business support system by this embodiment. It is a figure which shows the functional configuration example of the terminal apparatus or the server apparatus by this embodiment. It is a flowchart which shows the operation example of the terminal apparatus or the server apparatus by this embodiment.

Hereinafter, an embodiment of the present invention will be described with reference to the drawings. FIG. 1 is a diagram showing a configuration example of a drug warehousing business support system according to the present embodiment. As shown in FIG. 1A, for example, the drug warehousing business support system of the present embodiment is configured to include a terminal device 100 and a code reader 200. The terminal device 100 and the code reader 200 are connected via a wireless communication means such as Bluetooth (registered trademark) or Wi-Fi (registered trademark). Instead of wireless, the terminal device 100 and the code reader 200 may be connected by wire.

The terminal device 100 is, for example, a personal computer and is installed in a dispensing pharmacy. The code reader 200 reads a GS1 code (GS1 data bar, GS1 data bar synthetic symbol, etc.) attached to the package of the delivered drug. The terminal device 100 acquires the drug information recorded in the GS1 code read by the code reader 200, and executes a process related to the drug warehousing business (details will be described later). The drug information recorded in the GS1 code includes information such as the drug name, drug code, quantity, delivery quantity, shipping source, delivery destination, drug expiration date, serial number, etc. contained in the package. There is.

Further, the drug warehousing business support system of the present embodiment can be configured as shown in FIG. 1 (b). In the case of the example shown in FIG. 1 (b), the drug warehousing business support system includes a terminal device 100', a code reader 200, and a server device 300. The terminal device 100'and the server device 300 are connected via a communication network 500 such as a LAN (Local Area Network) or the Internet. The terminal device 100'transmits the drug information acquired through the reading of the GS1 code by the code reader 200 to the server device 300. The server device 300 executes a process related to the drug warehousing business by using the drug information transmitted from the terminal device 100'.

Further, instead of forming the terminal devices 100, 100'and the code reader 200 separately, a terminal device having a code reader function such as a tablet terminal may be used.

FIG. 2 is a diagram showing a functional configuration example of the terminal device 100 (or the server device 300 shown in FIG. 1B) shown in FIG. 1 (a). As shown in FIG. 2, the terminal device 100 (server device 300) of the present embodiment has a drug information acquisition unit 11, a registration determination unit 12, a storage location presentation unit 13, a storage location candidate presentation unit 14, and an operation as functional configurations. It has a reception unit 15 and a storage location registration unit 16. Further, the terminal device 100 (server device 300) of the present embodiment includes a storage location storage unit 21 and a storage condition storage unit 22 as storage media.

Each of the above functional blocks 11 to 16 can be configured by any of hardware, DSP (Digital Signal Processor), and software. For example, when configured by software, each of the above functional blocks 11 to 16 is actually configured to include a computer CPU, RAM, ROM, etc., and is a program stored in a storage medium such as RAM, ROM, hard disk, or semiconductor memory. Is realized by the operation of.

The storage location storage unit 21 stores a database that records the storage locations of each drug handled by the dispensing pharmacy. This database records, for example, the name (or drug code) of a drug and the information indicating the storage location in association with each other. The information in the database stored in the storage location storage unit 21 is appropriately updated by the storage location registration unit 16 described later.

Storage locations include medicine shelves, lockers, and other locations. The medicine rack has a plurality of storages, and individual medicines taken out from the package are stored in each storage. The locker has one or more storages, and is designed to store a package in which a plurality of individual medicines are put together in the storage. For example, the locker stores the delivered medicines as they are in the package, and the medicine shelf stores the individual medicines taken out from the package. Other locations are, for example, cardboard placed anywhere in the dispensing pharmacy. For example, medicines that cannot be stored in the medicine rack or the locker are temporarily stored in the cardboard.

When there is one or more drug shelves in the dispensing pharmacy, the storage location storage unit 21 stores information indicating which drug is stored in which storage of which drug shelf as a database. Further, when there is one or more lockers in the dispensing pharmacy, the storage location storage unit 21 stores information indicating which drug is stored in which storage of which locker as a database. Further, when there is one or more cardboard boxes in the dispensing pharmacy, the storage location storage unit 21 stores information indicating which drug is stored in the cardboard box at which position as a database.

The storage condition storage unit 22 stores information indicating the storage conditions of the drug in advance. The storage conditions for medicines include storage conditions specified for each medicine type, storage conditions for storage conditions, and storage conditions for operation specified to prevent mistakes when picking medicines from the medicine rack (at the time of delivery). The storage condition storage unit 22 stores, for example, the name (or drug code) of the drug and the information of the corresponding storage condition in association with each other for the drug corresponding to the storage conditions shown below. The storage condition information is information indicating the content of the condition or information specifying a medicine rack or locker that satisfies the condition. In the former case, depending on the contents of the storage conditions, definition table information or the like indicating which drug rack or locker meets the conditions is required separately.

The storage conditions specified for each drug type are as follows, for example.
・ Store psychotropic drugs in one place in a locked medicine rack or locker.
-Store narcotics and stimulants in secure locker shelves and lockers (including dedicated weight safes).
・ Store poisonous drugs in a special locked medicine shelf or locker.
・ Store powerful drugs separately from other drugs.

Further, the storage conditions regarding the storage state are as follows, for example.
-Pharmaceuticals that are required to be stored in a cold or dark place should be stored in a chemical shelf or locker (including a refrigerator) installed in a cold or dark place.

In addition, the storage conditions for operation specified to prevent misunderstandings are as follows, for example.
・ Do not store medicines with the same or similar names nearby.
Even if the medicines have the same name, different quantities may be stored in different storages. In this case, it is preferable not to store medicines with the same name but different amounts nearby in order to prevent misunderstandings. The same applies to drugs with similar names.

The drug information acquisition unit 11 acquires drug information regarding the delivered drug (hereinafter referred to as a drug subject to warehousing). That is, the drug information acquisition unit 11 acquires drug information of the delivered drug to be stocked by analyzing the GS1 code read by the code reader 200. The delivered medicines to be stored are inspected for whether or not they have been delivered as ordered, and then stored in the storage location registered in the storage location storage unit 21. However, when a new drug whose storage location is not registered in the database of the storage location storage unit 21 is delivered, a new storage location must be determined.

The registration determination unit 12 determines whether or not the storage location of the drug to be stored indicated by the drug information acquired by the drug information acquisition unit 11 is registered in the database of the storage location storage unit 21. For example, in the registration determination unit 12, information indicating a storage location is registered in the database of the storage location storage unit 21 in association with the name (or drug code) of the drug included in the drug information acquired by the drug information acquisition unit 11. Determine if it is.

The registration determination unit 12 may determine whether or not the storage location of the drug to be stored is registered in the database by the following method. That is, a database for inventory management is prepared separately from the database of the storage location storage unit 21, and when a drug is delivered, the number of delivered drugs is added to the number of stocks and registered in the inventory management database, while the drug is dispensed. When is used, the number of used items is subtracted from the number of items in stock and registered in the inventory management database. Then, the inventory quantity of the drug to be stored indicated by the drug information acquired by the drug information acquisition unit 11 is confirmed by the inventory management database, and if it is zero, the storage location of the drug to be stored is stored in the database of the storage location storage unit 21. It may be determined that the drug is not registered, and if it is not zero, it may be determined that the storage location of the drug to be stored is registered in the database. In this case, among the medicines whose inventory has become zero, the medicines that have not been ordered are listed as candidates for deleting information from the database of the storage location storage unit 21 and presented to the user. The user looks at the presented list and decides whether to delete the information from the database. For example, the user deletes information from the database of the storage location storage unit 21 for the medicines whose inventory quantity has exceeded the predetermined transitional measure date from the time when the stock quantity becomes zero.

When the storage location presentation unit 13 determines that the storage location of the drug to be stored is registered in the database of the storage location storage unit 21 by the registration determination unit 12, the storage location is set to the terminal device 100 (or the terminal device 100'). ) Is presented to the user by displaying it on the display. The storage location can be presented, for example, by displaying text information indicating the storage location. For example, in the case of a medicine shelf, the combination of the identification information of the medicine shelf and the identification information of the storage in the medicine shelf is displayed by text information.

The information that presents the storage location includes an in-house layout figure that shows the location of the drug rack, locker, and cardboard in the dispensing pharmacy, and one or more storages that the drug rack has and one or more storages that the locker has. The storage location of the medicine to be stored may be drawn in a manner that can be distinguished from others by using the storage layout figure showing the above. For example, it is possible to highlight the corresponding storage location and display the name of the drug in the storage location. Instead of the layout figure, an image acquired by photographing an actual medicine shelf, a locker, or a cardboard may be used.

When the storage location candidate presentation unit 14 determines that the storage location of the drug to be stored is not registered in the database of the storage location storage unit 21 by the registration determination unit 12, the storage target drug acquired by the drug information acquisition unit 11 Based on the drug information of the above, the information indicating the storage conditions of the drug stored in the storage condition storage unit 22, and the information of the database stored in the storage location storage unit 21, candidates for the storage location of the drug to be stored Is selected and presented.
At this time, the storage location candidate presentation unit 14 first determines whether or not the storage conditions related to the drug type or storage state stored in the storage condition storage unit 22 are applied to the drug to be stored, and when it is applied. The candidates are narrowed down to the storage locations according to the storage conditions. That is, the storage location candidate presentation unit 14 specifies a drug type based on drug information, and if there is a storage condition defined for the drug type, the storage location candidate presentation unit 14 selects a storage location that satisfies the storage condition as a candidate. Which drug type the drug indicated in the drug information corresponds to is specified, for example, based on a dictionary database prepared in advance. Alternatively, the drug information acquisition unit 11 may include the drug type information in the drug information acquired from the GS1 code.

In addition, the storage location candidate presentation unit 14 determines whether or not there is a condition regarding the storage state based on the drug information, and if there is a storage condition defined for the storage state, the storage location that observes the storage condition is selected as a candidate. do. Whether or not a specific storage state is required for a drug indicated by drug information is determined based on, for example, a dictionary database prepared in advance. Alternatively, the drug information acquisition unit 11 may include the storage state designation information in the drug information acquired from the GS1 code.

After narrowing down the storage location candidates according to the storage conditions related to the drug type or the storage state as described above, the storage location candidate presentation unit 14 is vacant based on the information in the database stored in the storage location storage unit 21. Search for existing storage locations and select vacant storage locations as candidates. At this time, the storage location candidate presentation unit 14 refers to the storage condition storage unit 22 to determine whether or not there is a storage condition related to the operation, and if there is a storage condition related to the operation, the storage location that observes the storage condition is set as a candidate. Select.

For example, the storage location candidate presentation unit 14 determines whether or not a drug having the same name or a similar name is already stored around the searched empty storage location. For example, in the case of a drug shelf having a plurality of storages arranged in m rows × n columns (m> 1, n> 1), the medicine shelves are stored in a maximum of eight storages adjacent to the storages searched for as empty. It is determined whether or not the drug in question has the same name or a similar name as the drug to be stocked. Then, when a drug having the same name or a similar name has been stored in at least one place, the storage place candidate presenting unit 14 excludes the searched storage from the candidates and searches for another storage.

Further, when selecting a storage place candidate, the storage place candidate presenting unit 14 selects a storage place that can store the medicines to be stored as a candidate according to the priority set in the order of the medicine shelf, the locker, and the cardboard. .. That is, the storage location candidate presentation unit 14 first searches for an empty storage that satisfies the storage conditions from the chemical shelves, and if one or more is found, selects it as a storage location candidate. When there is no empty storage that meets the storage conditions in the chemical shelf (including the case where the storage condition is not seen even if there is an empty storage), the storage location candidate presentation unit 14 may be used. Search the lockers for an empty storage that meets the storage conditions. If one or more are found, it is selected as a storage location candidate. If there is no empty storage in the locker, the storage location candidate presentation unit 14 selects corrugated cardboard as a storage location candidate.

In addition, the storage location candidate presentation unit 14 specifies the shape, form, and size of the drug to be stored based on the drug information acquired by the drug information acquisition unit 11 when selecting the storage location candidate. Based on the specified contents, a storage place that can store the medicines to be stored may be selected as a candidate. The shape of a pharmaceutical product indicates, for example, a distinction between a sheet shape, a bag shape, a bottle shape, and the like. The form of the drug indicates, for example, a distinction between a PTP sheet / rose (naked tablet) and the like. The shape, form and size of the drug are determined based on, for example, a dictionary database prepared in advance. Alternatively, the drug information acquisition unit 11 may include such information in the drug information acquired from the GS1 code.

The storage location candidate presenting unit 14 presents the storage location candidates selected as described above to the user by displaying them on the display of the terminal device 100 (or the terminal device 100'). Here, if a plurality of empty storage locations that satisfy the storage conditions are found, they are presented as candidates. The method of presenting the candidate for the storage place may be the same as the method of presenting the storage place performed by the storage place presentation unit 13. That is, it is possible to display the text information indicating the storage location. Alternatively, in the layout figure or the photographed image, one or more storage locations selected as candidates may be drawn in a manner distinguishable from the others.

The operation reception unit 15 accepts a user operation to select one from the candidates presented by the storage location candidate presentation unit 14. The storage location registration unit 16 registers the storage location selected by the user operation received by the operation reception unit 15 in the database of the storage location storage unit 21 as a storage location for the medicine to be stored. At the time of this registration, the storage location registration unit 16 associates with the storage location using the drug information acquired by the drug information acquisition unit 11.

The medicines stored in the locker may be later transferred to the medicine rack and stored. In addition, medicines stored in cardboard may be later transferred to a medicine shelf or locker for storage. In this case, the user operates the terminal device 100 (terminal device 100') to update the association between the drug information stored in the storage location storage unit 21 and the storage location. That is, the operation reception unit 15 accepts a user operation for changing the storage location of the drug. The storage location registration unit 16 changes and re-registers the storage location of the drug stored in the database of the storage location storage unit 21 according to the content of the user operation received by the operation reception unit 15.

FIG. 3 is a flowchart showing an operation example of the terminal device 100 (the same applies to the server device 300) configured as described above. First, the drug information acquisition unit 11 acquires drug information indicating the delivered drug to be stocked by analyzing the GS1 code read by the code reader 200 (step S1). Then, the registration determination unit 12 determines whether or not the storage location of the warehousing target drug indicated by the drug information acquired by the drug information acquisition unit 11 is registered in the database of the storage location storage unit 21 (step S2). ).

Here, when the registration determination unit 12 determines that the storage location of the drug to be stored is registered in the database of the storage location storage unit 21, the storage location presentation unit 13 uses the storage location on the display of the terminal device 100. It is presented to the user by displaying it (step S3). As a result, the processing of the flowchart shown in FIG. 3 is completed.

On the other hand, when the registration determination unit 12 determines that the storage location of the drug to be stored is not registered in the database of the storage location storage unit 21, the storage location candidate presentation unit 14 receives the warehousing acquired by the drug information acquisition unit 11. Storage location of the target drug based on the drug information of the target drug, the information indicating the storage condition of the drug stored in the storage condition storage unit 22, and the information of the database stored in the storage location storage unit 21. Candidates are selected and presented to the user (step S4).

Here, the operation reception unit 15 determines whether or not the user operation for selecting any of the candidates presented by the storage location candidate presentation unit 14 has been accepted. When the operation reception unit 15 accepts a user operation for selecting any candidate, the storage location registration unit 16 uses the storage location selected by the user operation as the storage location for the drug to be stored in the storage location storage unit 21. Register in the database (step S6). As a result, the processing of the flowchart shown in FIG. 3 is completed.

As described in detail above, in the present embodiment, it is determined whether or not the storage location of the drug to be stored is registered in the database of the storage location storage unit 21, and if it is determined that the storage location is not registered, the drug to be stored is not registered. Based on the drug information, the information indicating the storage conditions of the drug, and the information in the database of the storage location storage unit 21, candidates for the storage location of the drug to be stored are selected and presented. Then, the user operation of selecting one of the presented candidates is accepted, and the selected storage location is registered in the database as the storage location of the drug to be stored.

According to the present embodiment configured in this way, when a new drug whose storage location is not determined is delivered, a candidate for the storage location is automatically presented, and the user can select one of them. All you have to do is select it. When the user performs an operation of selecting a storage location, the selected storage location is registered in the database as a storage location for the drug to be stored. In this way, when warehousing a new drug whose storage location has not been determined, the user only has to select one of the presented candidates, and the warehousing operation can be streamlined.

In the above embodiment, when the registration determination unit 12 determines that the storage location of the drug to be stored is registered in the database of the storage location storage unit 21, the storage location presentation unit 13 presents the storage location to the user. Although the example of the above has been described, the following may be used. That is, when the registration determination unit 12 determines that the storage location of the drug to be stored is registered in the database, the storage location candidate presentation unit 14 determines the number of deliveries included in the drug information and the number of stocks of the drug to be stored. Based on the information indicating Present.

For example, the storage location candidate presentation unit 14 presents a locker as a storage location candidate when it is determined that the medicine to be stored cannot be stored in the storage of the medicine shelf. This is to prevent the same medicine from being distributed and stored in multiple storage locations on the medicine rack. If there is an empty storage next to the registered storage on the medicine shelf, that storage may be presented as a candidate.

Whether or not it is possible to add and store the medicines to be stored in the registered storage location is determined by the total quantity of the medicines delivered and in stock, which is the shape, form and size of the medicines to be stored and the storage location. It is possible to judge whether or not the maximum number of stored items, which is determined by the relationship with the size, is exceeded. This maximum number of storages may be stored in advance as a database for each storage location and drug.

In addition, the above embodiments are merely examples of the embodiment of the present invention, and the technical scope of the present invention should not be construed in a limited manner. That is, the present invention can be implemented in various forms without departing from its gist or its main features.

11 Drug information acquisition unit 12 Registration judgment unit 13 Storage location presentation unit 14 Storage location candidate presentation unit 15 Operation reception unit 16 Storage location registration unit 21 Storage location storage unit 22 Storage condition storage unit

Claims (7)

The Drug Information Acquisition Department, which acquires drug information related to the delivered drugs and the drugs subject to warehousing,
A registration determination unit that determines whether or not the storage location of the drug subject to warehousing indicated by the drug information acquired by the drug information acquisition unit is registered in the database, and a registration determination unit.
When the registration determination unit determines that the storage location of the drug to be stored is not registered in the database, the database stores the drug information, the information indicating the storage conditions of the drug, and the storage location of the drug. Based on the information, the storage location candidate presentation unit that selects and presents the storage location candidates for the above-mentioned medicines to be stored, and the storage location candidate presentation unit.
It is equipped with a storage location registration unit that accepts the operation of selecting one of the candidates presented by the storage location candidate presentation unit and registers the selected storage location as the storage location of the drug to be stored in the database. A drug warehousing business support system characterized by this. The storage conditions for the above drugs include the storage conditions specified for each drug type.
The storage location candidate presentation unit is characterized in that a drug type is specified based on the drug information, and if there are storage conditions specified for the drug type, a storage location that meets the storage conditions is selected as the candidate. The drug warehousing business support system according to claim 1. The storage conditions for the above drugs include storage conditions related to the storage condition.
The storage location candidate presentation unit determines whether or not there is a condition related to the storage condition based on the drug information, and if there is a storage condition specified for the storage condition, the storage location that observes the storage condition is selected as the candidate. The drug warehousing business support system according to claim 1 or 2, characterized in that. The storage conditions for the above-mentioned medicines include storage conditions for operation specified to prevent mistakes during picking.
The storage location candidate presenting unit determines whether or not there is a storage condition related to the operation, and if there is a storage condition related to the operation, the storage location candidate presenting unit selects a storage location that meets the storage condition as the candidate. The drug warehousing business support system according to any one of 3 to 3. The storage location candidate presentation unit specifies the shape, form, and size of the drug to be stored based on the drug information, and based on the specified content, the storage location where the drug to be stored can be stored is specified. The drug warehousing business support system according to any one of claims 1 to 4, characterized in that it is selected as a candidate. The drug information acquired by the drug information acquisition department includes identification information of the drug subject to warehousing and information on the number of deliveries.
When the registration determination unit determines that the storage location of the warehousing target drug is registered in the database, the storage location candidate presentation unit receives the delivery number information included in the drug information and the warehousing target drug. Based on the information indicating the number of stocks of The drug warehousing business support system according to claim 1, wherein the storage location is presented as the above candidate. The storage place includes a medicine shelf for storing individual medicines in a plurality of storages, a locker for storing a package in which a plurality of the individual medicines are put together, and other places, and includes the medicine shelf, the locker, and the above. Priority is set in the order of other places,
The drug warehousing business according to any one of claims 1 to 6, wherein the storage place candidate presenting unit selects a storage place capable of storing the warehousing target drug as the candidate in accordance with the priority order. Support system.

Images