KR101057022B1 - System and method for managing drug inventory - Google Patents

Abstract

PURPOSE: A hospital stock management method and system thereof are provided to control an exhaustion of articles according to expiration date, to suitably manage the expiration date of stocks, and to handle a stock management of the articles according to a prescription. CONSTITUTION: A linkage unit(210) receives one or more consumed articles according to each prescription and an exhaustion amount from a terminal. The linkage unit stores received information in a prescription DB(data base)(310) and receives a prescription identification number. An article management unit(220) extracts the exhaustion amount and exhaustion articles from the prescription DB. The article management unit deducts the stock of an extracted exhaustion articles as the exhaustion amount of the exhaustion articles.

Description

System and method for managing drug inventory

The present invention relates to a method and system for inventory management of a hospital article, and more particularly, to a method and a system capable of enterprise-wide management of the inventory and exhausted articles of the hospital article used in the hospital.

As medical technology develops, hospital organizations are becoming very large. Medical staff, nursing staff, drug workers, medical technicians, administrative staff, technical staff, and technical staff are in charge of medical work, medical support, education and research, office management, technical work, and technical assistance. It is organically interoperating to provide services. In such a large organization, a computer system for improving work efficiency is urgently needed.

An example of a computer system used in a hospital or the like is an order delivery system (OCS). It has the function of inputting, modifying and canceling the prescription information about the patient in an efficient and accurate online form, and inquiring and outputting it according to the user's needs. It is evaluated. However, even in the prescription delivery system, a single prescription requires a variety of items and drugs, and different procedures and treatments require different amounts of items and drugs. These items are used in various tissues. There is a limit to inventory management of drugs. In addition, it is very important to manage the expiration date of the goods and drugs in the procedure and treatment, the lack of a method and system for efficiently managing them in a large inventory has been pointed out as a problem.

Accordingly, the present invention has been made to solve the above problems, an object of the present invention is to provide a method and system for inventory management of hospital goods that can handle inventory management of the goods according to the prescription.

In addition, another object of the present invention is to provide a method and system for managing hospital inventory inventory that can properly manage the expiration date of the inventory and control the exhaustion of the article according to the expiration date.

According to a feature of the present invention for achieving the object as described above, the present invention, (a) the interlocking unit receiving at least one or more exhausted articles and exhausted amount according to each prescription from the terminal and storing in the prescription database, ( b) receiving the prescription identification number from the terminal by the interlocking unit, (c) the article management unit extracts the exhausted article and the exhausted amount included in the prescription of the input prescription identification number in the prescription database, and extracted from the article database Subtracting the amount of inventory of each exhausted product by the amount of exhaustion of the exhausted article; (d) the goods management unit transmits a purchase request signal to the purchasing unit with respect to the exhausted article stored in the goods database whose inventory is less than the predetermined inventory; And (e) an invoice management unit collecting the purchase request signals to each of the exhausted articles. And a step of generating a bill.

According to the present invention, the prescription includes a test prescription and an action prescription, wherein the test prescription includes a required amount of the reagent as at least one or more reagent names and an exhausted amount required for the test as the exhausted article, and the action prescription is an exhausted article. At least one article name and exhausted amount required for the procedure include the required amount of the article.

In the present invention, the step (b) includes a step of receiving, from the terminal, the prescription identification number received in at least one form of a barcode, QR code, image, string.

In the present invention, the step (b) includes the step of receiving the linkage identification number from the prescription delivery system linkage.

In the present invention, the article database stores the expiration date for each of the exhausted article, step (d), (d-1) the expiration date of the exhausted article stored in the article database of the goods management unit is limited from the current date And generating a warning message regarding the exhausted article included within the time.

In the present invention, the step (c), the article management unit extracts the exhausted article and the exhausted amount included in the prescription of the input prescription identification number in the prescription database, the validity period of each exhausted article extracted from the article database And subtracting the inventory of the exhausted article included within the limit time from the current date by the exhausted quantity of the exhausted article, and transmitting a usage command to the terminal for the exhausted article.

In the present invention, in the step (c), the article management unit extracts the exhausted article and the exhausted amount included in the prescription of the inputted prescription identification number from the prescription database, and each of the exhausted article extracted from the article database validity period In the order of the least effective period, the inventory amount of the exhausted article is deducted by the exhausted amount of the exhausted article, and the instruction for use of the exhausted article and the exhausted article are arranged in the order of the validity period. Transmitting the information.

In the present invention, step (e) includes a step of generating a tax invoice when each invoiced item is prepaid by collecting the respective purchase request signals on the date specified by the bill management unit.

In the present invention, the step (e), the bill management unit collects each purchase request signal and includes recording the use of the exhausted article in the acceptance database when the exhausted article is a consumable item.

The present invention, the linkage unit for receiving at least one or more exhausted articles and the amount of exhaustion according to each prescription from the terminal to store in the prescription database, receiving the prescription identification number from the terminal, the prescription of the prescription ID number received in the prescription database Extracting the exhausted goods and the exhausted amount included in the product, subtracting the inventory of each extracted exhausted goods from the goods database by the exhausted amount of the exhausted goods, and out of the exhausted goods stored in the goods database, the inventory is less than the preset appropriate inventory An article management unit which transmits a purchase request signal to the purchase unit with respect to the exhausted article, and a bill management unit which collects each purchase request signal and generates a bill for each exhausted article.

According to the hospital goods inventory management method and system according to the present invention as described above has the following effects.

The present invention can provide a hospital article inventory management method and system that can handle inventory management of the article according to the prescription.

In addition, the present invention can provide a hospital article inventory management method and system that can properly manage the expiration date of the inventory items and control the exhaustion of the goods according to the expiration date.

1 is a view showing the configuration of a hospital goods inventory management system according to the present invention.
2 is a block diagram showing the configuration of a hospital goods inventory management system according to the present invention.
3 is a flow chart showing a hospital article inventory management method according to the present invention.
4 is a view showing a screen in which prescriptions and exhausted articles are registered according to the hospital article inventory management method according to the present invention.
5 is a view showing the expiration date and automatic order history in the hospital article inventory management method according to the present invention.

Hereinafter, a hospital article inventory management method and system thereof according to an embodiment of the present invention will be described in detail with reference to the accompanying drawings. Advantages and features of the present invention and methods for achieving them will be apparent with reference to the embodiments described below in detail with the accompanying drawings.

However, the present invention is not limited to the embodiments disclosed below, but can be implemented in various forms, and only the embodiments are to make the disclosure of the present invention complete, and common knowledge in the art to which the present invention belongs. It is provided to fully inform the person having the scope of the invention, which is defined only by the scope of the claims.

Like reference numerals refer to like elements throughout.

1 is a view showing the configuration of a hospital goods inventory management system according to the present invention.

The terminal 101 that accepts a user's input is implemented as an electronic terminal including a general personal computer, a notebook computer, a smartphone, and the like, and is connected to the inventory management system 200 through the network N. Inventory management system 200 may be linked to a conventional prescription delivery system 400 (OCS).

Inventory management system 200 according to the present invention is a server-side system is connected to the terminal 101 or the prescription delivery system 400 through the network (N), interlocking unit 210, goods management unit 220, purchase unit 230, the bill management unit 240 may be included. Each component constituting the inventory management system 200 may be implemented as a separate hardware system, or may be implemented as each software module included in one hardware system. In addition, the inventory management system 200 according to the present invention is a prescription database 310 for defining at least one or more exhausted articles required for each prescription for the at least one prescription and the amount of exhaustion of each exhausted article required for the prescription, and It includes an article database 320 for storing all the exhausted goods and their inventory, they may be implemented in a conventional database system (DBMS), or may be implemented as a data structure stored in a conventional storage medium. In the present invention, the exhausted article means a hospital article, which means a medicine, a reagent, and all other articles exhausted at the time of treatment, examination, or prescription in a hospital.

2 is a block diagram showing the configuration of a hospital goods inventory management system according to the present invention.

Inventory management system 200 according to the present invention receives the information from the terminal 101 or the prescription delivery system 400, the interlocking unit 210 to interlock with, and the information about the prescription received by the linking unit 210, The goods management unit 220 that manages the inventory of the exhausted goods stored in the goods database 320, when the inventory of the exhausted goods is less than the appropriate inventory, the purchase unit 230 and the request by the purchasing unit 230 to make a purchase request automatically It includes a bill management unit 240 for managing the purchase history. A function performing step of each component will be described with reference to FIG. 3.

First, the manager registers a new article through the manager terminal 101. For example, if you input "1000 sap set y type (50ea) 1000", "1000cc container of nutritional supplement", the interlocking unit receives it and registers it as an item of the name, standard, quantity (in stock) of the exhausted article in the goods database. In addition, it is possible to register a large amount in the form of Excel, etc. (S310) In addition, the exhausted article includes the expiration date information to manage the expiration date. In addition, the manager may record how much exhausted article is exhausted for a certain prescription through the manager terminal 101. For example, the prescription may include a test prescription necessary for medical treatment, such as a test, and an action prescription required for medical treatment or a procedure, and as shown in FIG. 4, a prescription identification number "LB0002", a name "abo / typing", 10 ml of each of the anti-a, anti-b and anti-d products are registered to exhaust 0.054 vial, and the prescription identification number "A0019284" and the name "non-feeding supplement" Dosage and type can be registered to exhaust the "one 3-way cord line 25cm", "one sap set y type (50ea)", "one nutrient 1000cc" as necessary items for "prescription". The interlocking unit 210 receives and records and stores the prescription in a prescription database or a prescription table (S320). Afterwards, the medical staff prescribes the prescription and then the prescription identification number such as "LB0002" or "A0019284" through the medical staff terminal 101. If the input, (S330) the article management unit receives this and the prescription database 31 Search for the prescription stored in 0) and extract the exhausted article and the exhausted amount included in the prescription, and subtract the exhausted amount of the exhausted article from the inventory of each exhausted article extracted from the article database 320. (S340 When the prescription identification number is input in the medical staff terminal 101, a character string may be directly input, but may be input to identify each prescription in the form of a barcode, QR code, or an image. The interlock unit 210 may be directly received from the medical staff terminal 101, but may be received from the prescription delivery system 400 received a prescription identification number from the medical staff terminal 101.

In order to manage the expiration date for each of the exhausted goods, the goods management unit 220 may generate a warning message regarding the exhausted goods whose expiration date is included within a limited time from the current date among the exhausted goods in which the current inventory amount remains. (S350, S355) Since the expiration date of a hospital item may vary depending on the type and storage condition of the hospital item, each time limit can be set differently. It is appropriate to warn them that they will run out quickly if they remain less than three months before the expiration date. As shown in Figure 5, the validity period can be confirmed by displaying the item name and inventory amount of the stock remaining within three months. It is advantageous for the convenience of management to manage the exhausted goods in the order of First Input First Out, but in some cases, the receipt of the exhausted goods may not proceed in the order of the expiration date. 220 may reflect this and generate an order to use the exhausted article according to the expiration date. For example, when the inventory of the exhausted goods is subtracted, the amount of inventory of the exhausted goods whose expiration date is included within the limit time from the current date is depleted by the exhausted amount, and the terminal receives a usage instruction regarding the exhausted goods. By transmitting, it is possible to induce the use of the exhausted article which is shortly valid. Preferably, after the goods management unit 220 sorts the exhausted articles in order of expiration date, the amount of inventory of the exhausted articles with the least expiration date is deducted, and in addition to the command to use the exhausted articles, the exhausted articles are valid. Status information arranged in order can be transmitted, and exhausted goods can be directly referred to by the user. The state information includes an expiration date of the exhausted article, location information of the exhausted article, and the like.

In addition, the article management unit 220 may identify those in which the inventory amount is less than the preset appropriate inventory among the exhausted goods recorded in the article database 320, it can automatically generate a purchase request signal for these. (S360, S365) As shown in FIG. 5, each exhausted article may have a different amount of appropriate inventory, but in the case of "3-way cord line", if less than 75, 10 pieces are ordered to each other. In the case of less than 30, 100 pieces are set, and the "sap set" is set to order 100 pieces if less than 50. When the amount of inventory is exhausted, a purchase request is automatically generated and the purchase unit 230 is ordered. Delivered. In this way, the purchase request is included in the purchase order, and the medical support or material department can confirm it and procure exhausted goods.

The purchase request signal automatically generated by the article management unit 220 is collected by the invoice management unit 240, and generates a bill for the exhausted goods requested for purchase. (S370) If the exhausted goods are prepaid goods The tax invoice can be generated, and if it is a consumable item, its usage information is recorded and settled later with the supplier.

Those skilled in the art will appreciate that the present invention can be embodied in other specific forms without changing the technical spirit or essential features of the present invention. It is therefore to be understood that the above-described embodiments are illustrative in all aspects and not restrictive. The scope of the present invention is indicated by the scope of the following claims rather than the detailed description, and all changes or modifications derived from the meaning and scope of the claims and the equivalent concept are included in the scope of the present invention. Should be interpreted.

N: network 101: terminal
200: inventory management system
210: linking unit 220: article management unit
230: purchase unit 240: bill management unit
310: prescription database 320: product database
400: Prescription Delivery System

Claims (10)

(a) the interlocking unit receiving at least one or more exhausted articles and the exhausted amount according to each prescription from the terminal and storing them in the prescription database;
(b) the interworking unit receiving the prescription identification number from the terminal;
(c) the article management unit extracts the exhausted article and the exhausted amount included in the prescription of the inputted prescription identification number from the prescription database, and subtracts the stock of each exhausted article extracted from the article database by the exhausted amount of the exhausted article; Making;
(d) transmitting a purchase request signal to the purchasing unit for the exhausted goods stored in the goods database in which the inventory amount is less than the preset appropriate stock quantity stored in the goods database; And
(e) a bill management unit collecting the respective purchase request signals to generate a bill for each exhausted article;
The prescription includes a prescription and conduct prescription,
The test prescription includes at least one reagent name and a required amount of the reagent as the exhausted amount required for the test as the exhausted article,
Wherein said act prescription includes at least one article name required for the procedure as an exhausted article and a required amount of said article as an exhausted amount. delete The method of claim 1,
In step (b),
Receiving a prescription identification number received in at least one form of a barcode, QR code, image, character string from the terminal unit; Hospital product inventory management method comprising a. The method of claim 1,
In step (b),
Receiving linking unit receives a prescription identification number from the prescription delivery system; Hospital goods inventory management method comprising a. The method of claim 1,
The article database stores an expiration date for each exhausted article,
In step (d),
(d-1) the goods management unit generating a warning message for the out of expiration items stored in the goods database in the expiration date is included within the limit time from the current date; hospital goods inventory management method further comprising. The method of claim 5,
In step (c),
The article management unit extracts the exhausted article and the exhausted amount included in the prescription of the inputted prescription identification number from the prescription database, and the exhausted article of which the expiration date is included within the limited time from the current date among the exhausted articles extracted from the article database. And subtracting the inventory amount of the exhausted product by the exhausted amount of the exhausted article and transmitting a usage command to the terminal for the exhausted exhausted article. The method of claim 5,
In step (c),
The article management unit extracts the exhausted article and the exhausted amount included in the prescription of the inputted prescription identification number from the prescription database, and sorts the extracted exhausted articles in the order database in the order of the expiration date and has the least valid period remaining. And subtracting the stock of the exhausted article by the exhausted amount of the exhausted article, and transmitting a usage instruction about the exhausted exhausted article and status information of the exhausted article in order of validity period to the terminal. How to Manage Goods Inventory. The method of claim 1,
In step (e),
And a bill invoice management unit collecting each purchase request signal on a designated date and generating a tax invoice if each exhausted article is a prepaid product. The method of claim 7, wherein
In step (e),
And a bill management unit collecting each purchase request signal and recording the use of the corresponding exhausted article in the acceptance database when the exhausted article is provisional product. An interlocking unit for receiving at least one exhausted article and exhausted amount according to each prescription from the terminal, storing the at least one exhausted article and the amount of exhaustion in the prescription database, and receiving a prescription identification number from the terminal;
Extracting the exhausted article and the exhausted amount included in the prescription of the inputted prescription identification number from the prescription database, subtracting the inventory amount of each extracted exhausted article from the article database by the exhausted amount of the exhausted article, and stored in the article database A goods management unit which transmits a purchase request signal to a purchasing unit regarding the exhausted goods in which the stocks of the exhausted goods are less than the preset proper stock quantity; And
And a bill management unit for collecting the purchase request signals and generating bills for the exhausted articles.
The prescription includes a prescription and conduct prescription,
The test prescription includes at least one reagent name and a required amount of the reagent as the exhausted amount required for the test as the exhausted article,
Wherein said act prescription includes at least one article name required for a procedure as an exhausted article and a required amount of said article as an exhausted amount.

Images