JP4118429B2 - Storage management device and system - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a storage management apparatus and system for managing medicines in schools and hospitals.
[0002]
[Prior art]
In recent years, there have been many incidents of exploiting useful chemicals as poisons. In order to prevent such misuse, it is necessary to manage who used what, what, and how much. As such a method, for example, it is conceivable to employ an automatic management system (Japanese Patent Laid-Open No. 5-51104) in which a storage having a large number of locations is provided and a weight detector is provided for each location.
[0003]
[Problems to be solved by the invention]
However, such a conventional system requires a weight detector at each location, which increases the cost.
In addition, it is necessary to make the system easy to use so as not to hinder original research.
[0004]
Accordingly, it is an object of the present invention to provide an inexpensive and simple system for a storage management apparatus and system capable of safety management of medicines and the like.
[0005]
[Means for Solving the Problems]
In order to achieve the above object, the storage management device of the present invention first comprises an electronic scale for weighing the object to be weighed, an input means for inputting identification information of a handler, and an item name of the object to be weighed. And the display means for displaying the measured value, the operation means for setting the item name of the object to be handled and the mode of entry / exit, and the item name of the object to be handled are set by the operation means. Is provided with an output port for outputting a signal for unlocking the lock at the location where the object is stored, and a time measuring means for measuring the date and time when the object is handled. An electronic lock of a storage is connected to the output port.
Now, when the identification information of the operator is input from the input means and the product name is set from the operation means, an unlock signal for unlocking the location of the storage corresponding to the product name is output from the output port, and The lock at the location of the product name is unlocked.
Next, when the weighing object is placed on an electronic balance and weighed and the mode of entry / exit is set, information on the operator, the date and time of handling, the mode of entry / exit, and the item name and measurement value of the item to be weighed are recorded. .
Therefore, it is possible to manage who used what, what, and how much.
Furthermore, it is assumed that when taking out the object to be weighed from the storage, in addition to a key to be operated when the object to be weighed is not returned to the storage, the taken-out object to be weighed is returned to the storage. And a key to be operated when performing. Therefore, inventory management becomes easy.
[0006]
In the present invention, the “object to be weighed” is generally a drug used in a laboratory or a hospital.
As the “input means for inputting identification information”, an ID card reader and a recitation number input device are generally used, but either of them may be used.
As the “display means and operation means”, it is preferable to use a touch screen in which both are integrated, but each may be a separate body.
“To place an object on the electronic balance and weigh it and set the mode of entry / exit” means that the operator puts chemicals etc. on the electronic balance by himself / herself. The provided system is not included in the scope of the present invention.
“Setting the product name” means that a single electronic scale can handle a large number of objects to be weighed. As a method for “setting the product name”, a pre-registered product name itself may be directly set, or a call number, a product number, or a storage location may be set.
There are two types of “entry / outgoing modes”: taking out the objects to be weighed from the storage and putting the objects to be weighed into the storage.
“Information is recorded” means not only that the information is stored in a storage medium such as a memory card or a floppy disk, but also that the information is stored in the memory or immediately after being stored in the memory. Means that it may be output.
“Information relating to” means that, for example, the product name may be recorded with other information such as product number and location.
[0007]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
This system manages the chemical | medical agent accommodated in the storage S of FIG. 1 with the storage management apparatus 1 of FIG.
The storage management device 1 includes an electronic balance 2, a card reader (input means) 3, a touch screen (display means, operation means) 4, and a stroke key part (operation means) 5 via an interface (not shown). (Fig. 1).
[0008]
The electronic balance 2 is for measuring the weight of the object (object to be weighed) A. The object A is generally a bottle (tare) B and a medicine M accommodated in the bottle B.
The card reader 3 reads the identification number of the handler from an ID card (not shown).
[0009]
The touch screen 4 has, for example, a liquid crystal display, and displays various messages in addition to the product name and the measured value (weight) as shown in FIGS. 3 to 5 and constitutes operation keys 4a to 4e. To do. That is, the touch screen 4 constitutes the display means of the present invention and the operation means for setting the product name and the manner of loading / unloading.
[0010]
As the mode setting keys for setting the mode of loading / unloading, there are four keys, a “shipping” key 4a, a “loading” key 4b, a “carrying out” key 4c and a “returning” key 4d shown in FIG. It is provided.
The “exit” key 4a is a key that is operated when the object A is not returned to the storage S when the object A is taken out from the storage S (hereinafter, this mode is referred to as “exit”). .
When the object A is taken out from the storage S and weighed, the “take-out” key 4c is assumed to return the object A to the storage S again (hereinafter referred to as “take-out”). It is a key to operate.
The “entry” key 4b is a key operated when the subject A is put into the storage S for the first time when the subject A is put into the storage S (this mode is hereinafter referred to as “entry”).
The “return” key 4d is used to return the object A previously taken out from the storage S to the location of the storage S when the object A is weighed and put into the storage S (hereinafter, this mode is referred to as “ "Return")).
When these mode setting keys 4 a to 4 d are touched, the CPU 11 reads the current date and time from the time measuring means 12.
[0011]
The CPU 11 of the microcomputer 10 in FIG. The time measuring means 12 measures the date and time when the object A was handled. Various registration information is stored in the RAM 13 of the microcomputer 10. The registration information includes, for example, the recitation number and handler name in FIG. 3 (a), the call number and drug name in FIG. 4 (a), and the RAM 13 has a number as shown in FIG. 1 (b). For each call number and product name, a location and a replenishment order weight, which will be described later, are stored in association with each other. The RAM 13 is provided with a storage unit for updating and storing the actual inventory quantity for each product name.
[0012]
A connector (mounting unit) 15 for connecting a memory card (storage medium) 20 is provided on the substrate of the microcomputer 10. The memory card 20 is provided with a history storage unit 21 for storing a loading / unloading history (FIG. 6).
[0013]
In the history storage unit 21, as shown in FIG. 6, in addition to the “date” and “time” at which the object A is handled, the “calling code”, “product number”, “weight” (measurement) of the object A Value, input value), “inventory quantity”, “location”, “handler number” (handler identification number) and “classification” (mode of entry / exit) of the storage S are recorded (stored).
[0014]
The history information is stored in CSV format.
That is, the history information is recorded (stored) in a text format in which items of each information are separated by commas, and a predetermined record (predetermined information) is separated by a line feed code. The history information is recorded in a new line for each loading / unloading mode, handler, and product name.
The history information is stored in a file for each day. That is, the CPU 11 automatically creates a new file in the history storage unit 21 of FIG. 1 every time the date read from the time measuring means 12 is changed, and writes the history information in the file.
[0015]
The microcomputer 10 is connected to an output port 16 for outputting an unlock signal and a lock signal. That is, when the product name of the object A to be handled is set by the touch screen 4, the CPU 11 reads the location corresponding to the product name from the RAM 13 and unlocks the lock Si at the location where the object A is stored. The signal is output via the output port 16.
On the other hand, when the “end” key 4 e in FIG. 4B is touched, the CPU 11 outputs a locking signal for locking the electronic lock Si at the unlocked location in FIG.
The output port 16 is connected to the electronic lock Si at each location of the storage S via the relay box 30.
[0016]
Next, the operation of this system will be described.
First, when the handler reads the ID card through the card reader 3 in FIG. 1, the handler is read from the RAM 13, and the handler confirmation screen in FIG. 3A is displayed on the touch screen 4. Thereafter, when a predetermined recitation number is input, the item name call screen of FIG. 3B is displayed on the touch screen 4. When a predetermined key is touched on this screen, the product name selection screen shown in FIG. 4A is displayed on the child window 4s. On this screen, by selecting a predetermined product name (medicine name) and touching the call number, the identification information of the operator is input and the product name is set. The above product name setting operation is the same regardless of the mode of entry / exit.
[0017]
The weighing screen shown in FIG. 4B is displayed on the touch screen 4 by the product name setting operation. At the same time, the CPU 11 in FIG. 1 reads the location number “01” in FIG. 1B corresponding to the product name “sodium chloride” from the RAM 13 and displays the location number “01” on the screen in FIG. 4B. At the same time, the location number “01” is output as an unlocking signal to the relay box 30 via the output port 16 of FIG. The relay box 30 unlocks the electronic lock S1 corresponding to the location number.
[0018]
Here, in this embodiment, since the location number corresponding to the product name is displayed on the touch screen 4 together with the product name, the operator does not need to remember the location, and there is no possibility of mistaken location.
[0019]
When performing “entry”, if the object A is a new article, the weight displayed on the label L of the bottle B in FIG. To enter the net weight. The input net weight is displayed as the weight as shown in the entry / exit mode selection screen in FIG. Thereafter, when the “entry” key 4b in FIG. 5A is touched, the CPU 11 reads the current date and time from the time measuring means 12, and the CPU 11 reads the past inventory weight from the RAM 13 and puts it in the inventory weight. Add new values to calculate new inventory weight. After this calculation, the CPU 11 updates and stores information on the stock quantity in the RAM 13. Thereafter, the CPU 11 displays the date, time, call code, product number (information on the product name), weight, unit, inventory quantity, unit, location, handler, and classification (incoming / outgoing mode: “incoming” in this case) shown in FIG. ) And line feed code information are stored in the history storage unit 21 of the memory card 20 in the CSV format. For example, in the case of the information on the first line in FIG. 6, 1998/10/7, 9: 56: 19,2, NaCl, 500, g, 2800, g, 01,100, warehousing and line feed code information are stored.
[0020]
After the operator touches the “entry” key 4b, the operator puts the object A into the location of the unlocked storage S, and then touches the “end” key 4e in FIG. 5A. When the handler touches the “end” key 4 e and the CPU 11 outputs a locking signal to the relay box 30 via the output port 16, the unlocked electronic lock Si is locked.
In addition, when the net weight is not known at the time of “entry”, the object A is weighed and then subjected to a well-known taring to enter.
[0021]
When performing “take-out”, after the operation of setting the product name, the object A in FIG. 2 having the product name is taken out from the unlocked location corresponding to the product name. After the removal, the handler places the object A on the electronic balance 2. That is, the medicine M is placed on the electronic balance 2 together with the bottle B. Thereby, the measured value (measured value at the time of taking-out) measured with the electronic balance 2 is displayed as a weight by the CPU 11 as shown in FIG. Thereafter, when the “take-out” key 4c in FIG. 5A is touched, the CPU 11 reads the current date and time from the time measuring means 12, and also shows the date, time, calling code, product number (information on the product name), weight shown in FIG. , Unit, stock quantity, unit, location, handler, classification (incoming / outgoing mode: “takeout” in this case) and line feed code are stored in the history storage unit 21 of the memory card 20 in CSV format.
[0022]
In the case of “take-out”, the stock quantity is not calculated, and the memory card 20 stores blank information as “stock quantity”, that is, information in a state where “,” and “,” are adjacent to each other. Remembered. For example, in the case of the information on the fourth line in FIG. 6, 1998/10/7, 11: 56: 55,1, NaCl, 300, g ,, g, 01,1234, export, and line feed code are stored.
When the operator touches the “end” key 4e after touching the “take-out” key 4c in FIG. 5A, the CPU 11 locks the electronic lock Si as in the case of “entry” described above. Make it.
[0023]
When performing “return”, the target object A to be returned is placed on the electronic balance 2 together with the bottle B after the product name setting operation. Thereby, the measured value (measured value at the time of return) measured with the electronic balance 2 is displayed as a weight by the CPU 11 as shown in FIG. Thereafter, when the “return” key 4d in FIG. 5A is touched, the CPU 11 reads the current date and time from the time measuring means 12, and calculates the inventory quantity represented by the following equation (1).
Stock quantity = (latest stock quantity)-((measured value when taking out)-(weighed value when returning)) ... (1)
After the calculation, the CPU 11 updates and stores the stock quantity information in the RAM 13 and stores the information from the date to the section shown in FIG. 6 in the history storage unit 21 of the memory card 20 in the CVS format.
[0024]
Here, the measured values at the time of take-out and return include the tare weight (the weight of bottle B), respectively, but it is necessary to know how many grams the tare weight is in the equation (1). Absent. Therefore, the operator does not need to be aware of the tare weight at all, that is, does not need to take out the medicine from the bottle B and weigh it, and is convenient.
[0025]
After the weighing, when the handler puts the object A into the location of the unlocked storage S, and then touches the “end” key 4e in FIG. The electronic lock Si is locked as in the case of.
[0026]
When performing “unloading”, after the product name setting operation, the object A with the product name is taken out from the location unlocked corresponding to the product name. After the take-out, the net weight described on the label L of the new (unused) object A or the like is entered using the numeric keypad (stroke key portion 5). Thereafter, when the “shipping” key 4a is touched, the CPU 11 reads the current date and time from the time measuring means 12, and calculates the stock quantity represented by the following equation (2).
Stock quantity = (latest stock quantity)-(measured value at the time of delivery)… (2)
After the calculation, the CPU 11 updates and stores the stock quantity information in the RAM 13 and stores the information from the date to the section shown in FIG. 6 in the history storage unit 21 of the memory card 20 in the CVS format. After the number operation, when the handler touches the “end” key 4e and the CPU 11 outputs a locking signal to the relay box 30 via the output port 16, the unlocked electronic lock Si is locked. .
[0027]
If the net weight is not known at the time of “exit”, the object A is weighed, and then a known taring is performed.
In addition, when it is troublesome to perform taring, only the empty bottle B may be “returned” after being taken out and used as “take out”.
[0028]
As described above, the history of entry / exit is recorded in the history storage unit 21 of the memory card 20. The history recorded in the memory card 20 can be displayed or printed in a state as shown in FIG. 6 by causing the personal computer (electronic computer) to read the memory card 20. In addition, the total for each handler can be calculated using commercially available spreadsheet software. Therefore, it is possible to easily manage who, what, what, and how many grams have been used (used) with a single electronic scale.
[0029]
In the present embodiment, as shown in FIG. 1 (b), and stores the replenishment orders weight W _L which is the lower limit of the amount of stock per product name in RAM 13. The CPU 11 compares the calculated current stock quantity W with the replenishment order weight W _L, and when W <W _L , the child window indicates that the remaining stock quantity has decreased as shown in FIG. Display in 4s.
[0030]
By the way, if the case of “take-out” to be “returned” later is handled as “ship-out” and the inventory amount is subtracted, the stock will run out every time it is taken out, making inventory management difficult. On the other hand, in the present embodiment, since “take-out” and “return” modes are provided, inventory management becomes easy.
[0031]
In the above embodiment, a plurality of electronic locks Sn are provided in the storage S of FIG. 1, but one electronic lock Sn may be provided. Further, the present invention does not limit the names (displays) of the keys 4a to 4e in FIG. Further, it is not always necessary to provide a “take-out” or “return” mode. Further, a printer may be provided in the storage management device itself of FIG. Further, the location corresponding to the product name may be displayed separately in correspondence with the detailed contents for each product name. Further, the product name may be set with a barcode reader or the like. Further, for a specific location, only a handler having a specific ID card set in advance may be unlocked.
[0032]
【The invention's effect】
As described above, according to the present invention, when the identification information and the product name are set, the predetermined location of the storage is unlocked, the object to be weighed is placed on the electronic scale, and the mode of entry / exit is set. Since the handler, the date and time, the mode of entry / exit, the product name, the measured value, and the like are stored, it is possible to manage who, what, what, and how many grams of goods are taken in and out.
In particular, since the management can be performed with a single electronic balance, the management can be performed with an inexpensive and simple apparatus.
By the way, if the amount of inventory is subtracted by using the “take-out” case of “returning” later as “shipping”, the stock will run out every time it is taken out, making inventory management difficult. In contrast, in the present invention, since “take-out” and “return” modes are provided, inventory management becomes easy.
[0033]
Further, if the location of the storage corresponding to the product name is displayed, the handler does not need to memorize the location for each product name, and there is no possibility of taking out medicines of other product names by mistake.
[0035]
In addition, when performing a new loading / unloading operation, the net weight can be entered by entering the number, while when taking out the bottle in use, the total weight including the tare can be measured with an electronic balance and taken out. This makes it possible to manage the operator without having to be aware of the tare weight at all, and it is convenient because there is no need to take out and measure the medicine from the bottle.
[Brief description of the drawings]
FIG. 1 is a schematic configuration diagram of a storage management system showing an embodiment of the present invention and a conceptual diagram showing a part of registration information.
FIG. 2 is a schematic perspective view of a storage management device.
FIG. 3 is a front view showing a display screen.
FIG. 4 is a front view showing another display screen.
FIG. 5 is a front view showing still another display screen.
FIG. 6 is a diagram showing a state in which the contents stored in the memory card are output by a computer.
[Explanation of symbols]
1: Storage management device 2: Electronic scale 3: Card reader (input means)
4: Touch screen (display means, operation means)
4a to 4e: Key 5: Stroke key part (operation means)
12: Timekeeping means 15: Connector 16: Output port 20: Memory card

Claims (7)

An electronic scale for weighing the object to be weighed;
An input means for inputting the identification information of the handler;
Display means for displaying the name of the item to be weighed and the measured weight value;
Operation means for setting the name of the item to be handled and the mode of entry and exit;
An output port that outputs a signal for unlocking a lock at a location where the object to be weighed is stored, when the name of the item to be weighed is set by the operation means,
A time measuring means for measuring the date and time when the object is handled,
When the identification information of the operator is input from the input means and the product name is set from the operation means, an unlocking signal for unlocking the storage location corresponding to the product name is output from the output port,
When the weighing object is placed on the electronic scale and weighed and the mode of entry / exit is set, it is now possible to record information about the handling person, the date and time of handling, the mode of entry / exit, and the item name and measurement value of the item to be weighed A storage management device ,
When taking out the object to be weighed from the storage, in addition to the key operated when the object to be weighed is not returned again to the storage, it is assumed that the taken-out object to be returned is returned to the storage A storage management device having a key to be operated. In claim 1,
A key that is operated when returning the weighing object taken out from the storage to the storage, in addition to a key operated when the weighing object is put into the storage for the first time when the weighing object is put into the storage. A storage management device. In claim 1 or 2 ,
A storage management device in which a key for outputting a signal for locking the lock at the unlocked location from the output port is provided in the operation means. In claim 1 , 2 or 3 ,
A storage management device that can display a location of a storage corresponding to a product name on the display means. In any one of Claims 1-4 ,
A storage management device that allows a net weight of an object to be weighed to be input from the operation means when performing an operation of entering or leaving the object to be weighed. In any one of Claims 1-5 ,
A storage management device that allows a total weight of the tared weight of the weighing object to be measured and taken out by the electronic balance when the weighing object is taken out from the storage. Storage management system comprising a storage management system of claims 1 to 6, and a vault which is unlocked by the unlocking signal.

Images