JP2024030145A - Inventory management ordering system and program - Google Patents

Abstract

An object of the present invention is to provide an inventory management ordering system that can manage the inventory of medical materials needed by a medical institution and optimize the amount of medical materials ordered. [Solution] An inventory management ordering system 3 includes a material prediction unit 10 that predicts the inventory of medical materials managed at a medical institution by predicting the types and quantities of medical materials used at the medical institution; A dispensing unit 11 that statistically predicts the type and amount of medical materials to be dispensed, a dispensing reservation unit 12 that reserves medical materials to be dispensed for a treatment booked at a medical institution, and a dispensing unit 12 that statistically predicts the type and amount of medical materials to be dispensed. By doing so, if it is determined that the amount of medical materials in stock at a medical institution is insufficient when the scheduled treatment is performed, the medical materials will be delivered to the medical institution by the time the scheduled treatment is performed. , and an ordering unit 13 that orders an amount of medical materials to supplement the medical materials determined to be in short supply. [Selection diagram] Figure 1

Description

The present invention relates to an inventory management ordering system and program.

Dental clinics regularly place orders for dental materials from dental stores. There are about 150 to 200 types of dental materials (including drugs, medical instruments, etc.) that are handled on a daily basis in dental clinics. Previously, medical personnel (including medical staff such as dentists and dental hygienists) visually checked which dental materials were stored on which shelves, and barcodes attached to dental materials were used to visually confirm which dental materials were stored on which shelves. They managed the inventory of dental materials by reading them with a reader. However, while busy with their clinical work, medical professionals must check the inventory status of a large number of dental materials and place orders for dental materials that will be in short supply for the next treatment. For ordering dental materials, filling in an ordering notebook or faxing an ordering form was used. Medical workers have to visually check the inventory of dental materials, order quantities, etc., and these tasks place a burden on the medical workers.

In order to save labor in dental clinics, order management systems for dental materials are provided. It was thought that by using an order management system, medical professionals would be able to keep track of the inventory of dental materials and reduce the effort involved in ordering dental materials.

Patent Document 1 discloses a WEB order management system for dental laboratories, which includes a user terminal device for ordering dental laboratories, a processing base terminal device for accepting orders for processing dental laboratories, and a server device. ing.

JP2019-021075A

However, even if the order management system disclosed in Patent Document 1 is used, if the person in charge of ordering makes a mistake or if a medical worker who is inexperienced with ordering performs the ordering process, surplus inventory may occur or necessary for processing. The company was unable to resolve the issue of improper inventory management, such as shortages of dental materials. For example, it is a time-consuming task to perform dispensing of dental materials used by medical personnel each time. Here, the dispensing of dental materials means, for example, that the dental materials in stock on the shelves of a dental clinic have been opened and are ready for use. If a box contains a dozen new dental materials, when the box is opened and the dental materials can be taken out one by one, one box has been dispensed. However, not all of the discharged dental material is used in one treatment. The dispensed dental material may also be used in other procedures. Therefore, in this specification, dispensing and use are used with different meanings.

Conventional order management systems have a mechanism that automatically places an order when the number of dental materials in stock at a dental clinic falls below a certain amount. However, the fixed quantity compared to the inventory quantity was determined by the experience and intuition of skilled ordering personnel. For this reason, medical professionals other than the person in charge of ordering need to know whether the quantity of dental materials ordered through the order management system is appropriate, whether a certain amount is appropriate, or whether the order itself is necessary. I didn't know what it was. These issues are the same for medical institutions that provide medical services other than dental clinics, so there has been a need to optimize the amount and timing of orders for medical materials used at each medical institution.

The present invention has been made in view of this situation, and an object of the present invention is to optimize the order amount and order timing of medical materials to be dispensed at medical institutions.

The inventory management ordering system according to the present invention includes a material prediction unit that predicts the inventory of medical materials managed in a medical institution by predicting the types and quantities of medical materials used in the medical institution, and a material prediction unit. A dispensing unit that predicts the type and amount of medical materials to be dispensed at a medical institution based on the predicted type and amount of medical materials; A dispensing reservation section that reserves medical materials to be dispensed for the procedure scheduled for the procedure, and the amount of medical materials in the medical institution's inventory at the time the reserved procedure is performed by using the medical materials reserved for dispensing. an ordering department that orders an amount of medical materials to make up for the medical materials determined to be in short supply so that the medical materials arrive at the medical institution by the time the scheduled treatment is performed when it is determined that there is a shortage of medical materials. .

According to the present invention, the amount and timing of orders for medical materials dispensed at medical institutions can be optimized.
Problems, configurations, and effects other than those described above will be made clear by the following description of the embodiments.

1 is a block diagram showing an example of the overall configuration of an order management system according to an embodiment of the present invention. It is a diagram showing an example of each piece of information transmitted from the medical record system to the inventory management ordering system according to an embodiment of the present invention. FIG. 3 is a diagram illustrating a configuration example of each master according to an embodiment of the present invention. It is a figure showing an example of history data concerning one embodiment of the present invention. FIG. 3 is a diagram showing an example of a list and a table according to an embodiment of the present invention. It is a figure showing the example of composition of the functional block which performs learning processing and prediction processing of the material prediction part concerning one embodiment of the present invention. It is a figure showing an example of learning data concerning one embodiment of the present invention. FIG. 1 is a block diagram showing an example of the hardware configuration of a computer according to an embodiment of the present invention. It is a flowchart showing an example of payout processing according to one embodiment of the present invention. FIG. 2 is a flowchart illustrating an example of a process in which a medical worker confirms predicted materials to be used and amounts to be used, according to an embodiment of the present invention. FIG. It is a flowchart showing an example of payout registration processing according to an embodiment of the present invention. 2 is a flowchart illustrating an example of payout reservation processing according to an embodiment of the present invention. 3 is a flowchart illustrating an example of order processing according to an embodiment of the present invention. 3 is a flowchart showing a detailed example of order registration processing according to an embodiment of the present invention. It is a flowchart which shows an example of arrival processing concerning one embodiment of the present invention. FIG. 3 is a diagram showing an example of order history data and a treatment-material correspondence table for explaining analysis processing according to an embodiment of the present invention.

DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, embodiments for carrying out the present invention will be described with reference to the accompanying drawings. In this specification and the drawings, components having substantially the same functions or configurations are designated by the same reference numerals and redundant explanations will be omitted.

[One embodiment]
FIG. 1 is a block diagram showing an example of the overall configuration of an order management system 1 according to an embodiment. The order management system 1 includes a medical record system 2, an inventory management order system 3, and an order system 4.

The medical record system 2 is a system used by medical personnel to examine patients. The medical record system 2 is installed, for example, in a server at a dental clinic, and various information can be input and output through a PC (Personal Computer) or a tablet terminal at the dental clinic. For this reason, a plurality of medical record systems 2 are connected to the inventory management ordering system 3. However, the medical record system 2 is installed on a cloud server by the business that provides the order management system 1 to each company, and various information is input and output through the dental clinic's PC or tablet terminal that accesses the cloud server. good. A dental clinic is an example of a medical institution that specializes in dental procedures.

A medical record registration screen (not shown), which is a user interface of the medical record system 2, is displayed on a PC or tablet terminal used by a medical worker at a dental clinic. The medical worker registers the details of the treatment for each patient and the type and quantity of dental materials used in the treatment through the medical record registration screen. The registered various information is stored in the medical record system 2 as medical record information 22 (see FIG. 2, which will be described later). In dental clinics, various types of materials, medicines, medical devices, etc. are collectively referred to as "dental materials." Dental materials are an example of medical materials used in dental procedures.

Furthermore, the medical staff operates the medical record system 2 to register the patient's symptoms and treatment details. The details of the treatment are made clear by the medical record information 22, which includes information such as the type and amount of dental materials required for the treatment. Further, through the medical record system 2, the medical worker inputs the patient's own information (patient information 21), information on the patient's medical reservation, and information on the details of the planned treatment (reservation information 23). Patient information 21, medical record information 22, and reservation information 23 are transmitted from medical record system 2 to inventory management ordering system 3 at the time of registration in medical record system 2.

The order receiving system 4 is a system used by a material trading company that handles dental materials. When the ordering system 4 receives the ordering information for dental materials ordered from the inventory management ordering system 3, the ordering system 4 collects the dental materials from stores and manufacturers based on the ordering information and performs processing to deliver them to the dental clinic.

The inventory management ordering system 3 determines the inventory of dental materials for each dental clinic, the type and number of dental materials to be used in future treatments, etc. based on the patient information 21, medical record information 22, and reservation information 23 received from the medical record system 2. Manage. Then, the inventory management ordering system 3 automatically orders the ordering system 4 with ordering information in which the type and quantity of necessary dental materials are recorded, based on the type and number of dental materials predicted to be in short supply due to future treatment. This inventory management ordering system 3 is a system installed in a cloud server by a business that makes the ordering management system 1 available to each company. In the following description, the user of the business who manages the inventory management ordering system 3 will be referred to as a "system administrator." This inventory management ordering system 3 includes functional blocks such as a material prediction section 10 and a database 40 containing various data and lists. The database 40 manages the types and quantities of dental materials in stock for each dental clinic.

The material prediction unit 10 predicts the inventory of dental materials managed at the dental clinic by predicting the type and amount of dental materials used at the dental clinic. Therefore, the material prediction unit 10 has a function of predicting the inventory amount of dental materials for each clinic by learning various data read from the database 40 using AI (Artificial Intelligence). The material prediction unit 10 determines the type of dental material to be dispensed and used in the next scheduled treatment based on patient information 21, medical record information 22, and reservation information 23 received from the medical record system 2 when predicting the inventory amount. and predict the amount.

Further, the material prediction unit 10 predicts the type and amount of dental material to be used in the next scheduled treatment based on the type and amount of dental material used in treatments actually performed in the past. In this way, the material prediction unit 10 manages the inventory of dental materials at each dental clinic. Therefore, the dispensing unit 11 and the dispensing reservation unit 12 can perform dispensing processing and dispensing reservation processing based on the inventory amount of dental materials predicted by the material prediction unit 10.

The database 40 also includes master information such as a clinic master 31, trading company master 32, material master 33, and material price list 34, historical data such as dispensing history data 41, ordering history data 42, arrival history data 43, and a used material list. 44, a list of materials to be used 45, a material delivery schedule 46, and a treatment-material correspondence table 47, as well as list information and table information.

Here, data transmitted from the medical record system 2 to the inventory management ordering system 3 will be explained with reference to FIG. 2.
FIG. 2 is a diagram showing an example of each piece of information transmitted from the medical record system 2 to the inventory management ordering system 3. Here, a configuration example of the patient information 21, medical record information 22, and reservation information 23 will be explained.

Patient information 21 records patient information. This patient information 21 includes items such as patient ID, clinic ID, patient name, date of birth, and gender.
In the patient ID field, unique identification information assigned to each patient by the medical record system 2 is stored as a patient ID.
In the clinic ID field, unique identification information assigned to each dental clinic by the inventory management ordering system 3 is stored as a clinic ID. The clinic ID in the patient information 21 is used by the inventory management ordering system 3 to identify which clinic the patient belongs to.
The patient name field stores the patient's name.
The date of birth item stores the patient's date of birth.
The gender item stores the patient's gender.

In the medical record information 22, the contents written in the medical record are recorded for each patient. This medical record information 22 is composed of items such as patient ID, clinic ID, treatment date, site, disease name, and treatment.
The patient ID item is as already explained, so the explanation will be omitted.
The clinic ID item is as already explained. The hospital ID of the medical record information 22 is used by the inventory management ordering system 3 to identify which hospital's patient's medical record belongs.
The treatment date field stores the treatment date on which the patient was treated.
The site item stores the site where the treatment was performed.
The disease name item stores the patient's disease name.
The treatment item stores the treatment in the treatment.

The reservation information 23 records the details of the treatment scheduled for the next reservation. This reservation information 23 includes items such as patient ID, clinic ID, next scheduled date and time, time frame, treatment area, doctor in charge, and hygienist in charge.
The patient ID item is as already explained, so the explanation will be omitted.
The clinic ID item is as already explained. The clinic ID of the reservation information 23 is used by the inventory management ordering system 3 to identify which clinic the patient's reservation information belongs to.
The next scheduled date and time field stores the scheduled date and time of the next visit for which treatment is reserved.
In the frame time item, the time (minutes) required for the reserved treatment is stored as the frame time.
The treatment site item stores the treatment site of the reserved treatment.
In the attending physician item, the dentist in charge of the reserved treatment is stored as the attending physician.
In the field of hygienist in charge, the dental hygienist in charge of the reserved treatment is stored as the hygienist in charge.

In this way, the reservation information 23 includes information regarding the next scheduled treatment, but does not include information on the type and amount of dental materials used in the treatment. However, by receiving patient information 21 and medical record information 22, the inventory management ordering system 3 predicts the type and amount of dental materials that will be used in the next scheduled treatment, and automatically saves dental materials that are in short supply at the dental clinic. Order.

Next, each master registered in advance by the system administrator of the inventory management ordering system 3 will be explained with reference to FIG.
FIG. 3 is a diagram showing an example of the configuration of each master. Here, configuration examples of the clinic master 31, trading company master 32, material master 33, and material price list 34 will be explained.

The clinic master 31 is master information in which dental clinic information is registered. The clinic master 31 includes items such as a clinic ID, dental clinic name, address, and telephone number.
Since the clinic ID item has already been explained, its explanation will be omitted.
The dental clinic name field stores the dental clinic name.
The address item stores the address of the dental clinic.
The phone number field stores the phone number of the dental clinic.

The trading company master 32 is master information in which information on material trading companies is registered. The trading company master 32 is composed of items such as trading company ID, trading company name, address, and telephone number.
In the trading company ID field, unique identification information assigned to each material trading company is stored as a trading company ID.
The trading company name field stores the trading company name of the materials trading company.
The address field stores the address of the material trading company.
The telephone number field stores the telephone number of the material trading company.

The material master 33 is master information in which information on dental materials is registered. The material master 33 is composed of items such as material ID, material name, manufacturer, category, and order unit.
The material ID item stores unique identification information assigned to each dental material as a material ID. A JAN (Japanese Article Number) code or the like is used as the material ID.
The material name item stores the material name of the dental material.
The manufacturer item stores the manufacturer name of the dental material.
The category item stores the category of dental materials.
The order unit field stores the order unit of dental materials. As for the ordering unit, there are forms such as individual pieces (one piece at a time) and boxes (one box at a time), depending on how the dental materials are delivered.

The material price list 34 is a table in which the prices of dental materials are registered. The material price list 34 is composed of the following items: hospital ID, trading company ID, material ID, and price.
A clinic ID is stored in the clinic ID item.
The trading company ID field stores the trading company ID.
In the material ID field, dental materials ordered from the material trading company specified by the trading company ID are stored as material IDs. The material ID may be the same information as the material ID of the material master 33.
The price item stores the order price of dental materials ordered from the material trading company.

The prices of dental materials ordered by materials trading companies from stores may vary from dental clinic to dental clinic even if the materials are the same. Therefore, the material price list 34 stores the prices of ordered materials for each dental clinic.

Next, the contents of each functional unit of the inventory management ordering system 3 will be explained with reference to the block diagram in FIG. 1 and the data configuration diagrams in FIGS. 4 and 5. FIG. 4 shows an example of historical data, and FIG. 5 shows an example of a list and a table.

<Functional explanation of the dispensing section>
The dispensing unit 11 predicts the type and amount of dental material to be dispensed at the dental clinic based on the type and amount of dental material predicted by the material prediction unit 10. At this time, the dispensing unit 11 determines the type and amount of dental materials based on the details of the treatment obtained from the medical record system 2 that manages medical record information created for each patient for the treatment performed at the dental clinic. Predict. Then, the dispensing unit 11 records in the dispensing history data 41 that the dental materials whose inventory is managed at the dental clinic have been dispensed for treatment. Further, the dispensing unit 11 records dental materials dispensed and used in the medical practice in the used material list 44 .

FIG. 4 shows an example of payout history data 41. The dispensing history data 41 includes items such as clinic ID, dispensing date and time, dispensing material ID, dispensing quantity, dispensing unit, and dispensing confirmer ID.
In the clinic ID field, unique identification information assigned to each dental clinic is stored as a clinic ID.
The date and time when the dental material specified by the dispensing material ID was dispensed is stored in the dispensing date and time item as the dispensing date and time.
In the dispensing material ID field, unique identification information assigned to each dispensing dental material is stored as a dispensing material ID. The dispensing material ID may be the same information as the material ID of the material master 33.

The dispensed quantity item stores the dispensed quantity of dental materials.
The dispensing unit item stores the dispensing unit of the dispensing dental material. The dispensing unit may be one piece, one bottle, or a box containing a plurality of pieces.
In the dispensing confirmer ID field, unique identification information assigned to each medical worker who confirmed the dispensed dental material is stored as a dispensing confirmer ID. Although not shown, the medical record system 2 is also provided with a medical worker master in which unique identification information assigned to each dental clinic is stored as a medical worker ID. The same information as the medical worker ID is used.

FIG. 5 shows an example of the used material list 44. The used material list 44 includes the following items: hospital ID, used date and time, used material ID, used quantity, used unit, and dispensing flag. As described above, "use" as opposed to "dispensing" means that a medical worker uses the dispensing dental materials in an actual treatment. For example, if a box containing 12 dental materials is dispensed and 2 dental materials are used from the box, the number of dispensed items is 1 and the quantity used is 2. Further, even if one medicine bottle is dispensed, the same medicine from the dispensed medicine bottle may be used for treatment of multiple patients. The medical record information 22 describes the quantity of dental materials dispensed and the quantity of used dental materials.

Since the clinic ID item has already been explained, the explanation thereof will be omitted.
In the used date and time field, the date and time when the dental material became used is stored as the used date and time.
The used material ID item stores unique identification information assigned to each dental material used as the used material ID. The used material ID may be the same information as the material ID of the material master 33.

The used quantity item stores the used quantity of used dental materials.
The usage unit item stores the usage unit of the used dental material. The unit of use is 1 piece, 1 bottle, or 1 bag.
In the dispensing flag item, whether the dispensing dental material is "dispensing completed" or "dispensing incomplete" is stored as a dispensing flag. After a predetermined unit of dental material has been dispensed, if all of this dental material has been used, the dispensing flag becomes "dispensed".
On the other hand, if the dental materials have been dispensed but unused dental materials remain, the dispensing flag becomes "dispensing incomplete". Note that if dental materials whose quality has not yet expired remain after being dispensed, the dispensing flag will be set to "Dispensing incomplete," but if the quality of unused dental materials has expired, the dispensing flag will be set to "Dispensing incomplete.""Completed". In addition, in order for the dispensing unit 11 to determine whether the quality period of the dental material has expired, for example, data on the expiration date for each manufacturing lot of the material and the number of usable days (such as 30 days) for each material are required. It is desirable to add it to the material master 33.

<Functional explanation of payout reservation section>
Next, returning to FIG. 1, the functions of the payout reservation section 12 of the inventory management ordering system 3 will be explained.
The dispensing reservation unit 12 reserves dental materials to be dispensed in a treatment reserved at a dental clinic based on the type and amount of dental materials predicted by the dispensing unit 11. At this time, the dispensing reservation unit 12 reserves dental materials based on the treatment reservation details obtained from the medical record system 2. Therefore, based on the treatment reservation information 23, the dispensing reservation unit 12 pre-reserves dental materials that are expected to be disbursed in the reserved treatment. Reserving the predicted dispensing of dental materials for the reserved treatment in this manner is called a "dispensing reservation." Then, the dispensing reservation unit 12 writes information about the dispensing reservation in the list of materials to be used 45.

FIG. 5 shows an example of the list of materials to be used 45. The list of materials scheduled to be used 45 is a list of materials scheduled to be used for each dental clinic based on the patient's medical reservation. This list of materials to be used 45 includes items such as hospital ID, scheduled date and time of use, material ID to be used, quantity to be used, and unit of use.

Since the clinic ID item has already been explained, its explanation will be omitted.
The scheduled use date and time field stores the scheduled date and time when the dental material will be used as the scheduled use date and time. The scheduled date and time of use is the date and time of a medical appointment.
In the planned-to-use material ID item, unique identification information assigned to each dental material to be used is stored as the planned-to-use material ID. The material ID to be used may be the same information as the material ID of the material master 33.
The planned usage quantity item stores the usage quantity of the dental material scheduled to be used.
The scheduled usage unit item stores the usage unit of the dental material scheduled to be used.

<Functional explanation of ordering department>
Next, returning to FIG. 1, the functions of the ordering section 13 of the inventory management ordering system 3 will be explained.
If the ordering unit 13 determines that the amount of dental materials in stock at the dental clinic will be insufficient when the reserved treatment is performed due to the use of the dental materials reserved for dispensing by the dispensing reservation unit 12, Order dental materials in an amount to compensate for the dental materials determined to be in short supply so that the dental materials arrive at the dental clinic by the time the scheduled treatment is performed.
Therefore, the ordering unit 13 has a function of ordering the required amount of dental materials to the order receiving system 4 based on the reserved dental materials that have been paid out and the inventory of dental materials at the dental clinic. Then, the ordering unit 13 writes information regarding the ordered dental materials into the ordering history data 42.

FIG. 4 shows an example of order history data 42. The order history data 42 records the history of orders placed with material trading companies. This order history data 42 is composed of the following items: clinic ID, order date and time, order material ID, order quantity and order unit, order confirmation person ID, order store ID, order unit price, and expected arrival date and time.

Since the clinic ID item has already been explained, its explanation will be omitted.
In the ordering date and time field, the date and time when the ordering unit 13 placed an order for dental materials from the order receiving system 4 is stored as the ordering date and time.
In the ordered material ID field, unique identification information assigned to each dental material ordered by the ordering unit 13 is stored as an ordered material ID. The ordered material ID may be the same information as the material ID of the material master 33.

The order quantity item and order unit item store the order quantity and order unit of dental materials ordered by the ordering unit 13.
In the order confirmation person ID field, unique identification information assigned to each medical worker who has confirmed the order details of dental materials ordered by the ordering unit 13 is stored as the order confirmation person ID.
In the ordering store ID field, unique identification information assigned to each store to which the ordering unit 13 has placed an order is stored as the ordering store ID. A certain number of ordered materials are often handled by different stores at different prices. For this reason, it is necessary to specify which store has ordered the dental materials ordered by the ordering section 13, so an ordering store ID is provided.

The order unit price item stores the order unit price [yen] of dental materials ordered by the ordering unit 13.
The expected arrival date and time field stores the expected arrival date and time of dental materials ordered by the ordering unit 13.

The material ordering information sent from the inventory management ordering system 3 to the ordering system 4 includes information on each item shown in the ordering history data 42. The order receiving system 4 then orders dental materials from the manufacturer based on the received material ordering information and delivers the dental materials to the dental clinic.

FIG. 5 shows an example of the material delivery schedule 46. The material delivery date table 46 includes items such as a clinic ID, material ID, store ID, and delivery date.
Since the clinic ID item has already been explained, its explanation will be omitted.
The material ID item stores unique identification information assigned to each dental material as a material ID. The material ID may be the same information as the material ID of the material master 33.
In the store ID field, unique identification information assigned to each store that manages the order receiving system 4 is stored as a store ID. The store ID may be the same as the ordering store ID.
The delivery date field stores the delivery date by which the store that has received the order for dental materials can deliver the dental materials to the dental clinic. The delivery date stored in the delivery date field is generally a guideline for the number of days required to deliver dental materials.

<Functional explanation of the receiving section>
Next, returning to FIG. 1, the functions of the receiving section 14 of the inventory management ordering system 3 will be explained.
The receiving unit 14 records arrival information for each product in the arrival history data 43 when the dental materials ordered by the material trading company arrive at the dental clinic from the store. Therefore, after the dental materials ordered by the ordering unit 13 arrive at the dental clinic, information on the received dental materials is transmitted from the medical record system 2 to the inventory management ordering system 3.
In addition to the medical record system 2, fax, e-mail, etc. may be used as a method for transmitting the information on the received dental materials to the inventory management ordering system 3. Then, the receiving unit 14 records information on the dental materials that have arrived at the dental clinic in the arrival history data 43.

FIG. 4 shows an example of arrival history data 43. The arrival history data 43 includes the following items: clinic ID, arrival date and time, arrival material ID, arrival quantity, arrival unit, arrival confirmation person ID, and arrival store ID.
Since the clinic ID item has already been explained, its explanation will be omitted.
The arrival date and time field stores the arrival date and time of the materials received from the store to the material trading company.
In the incoming material ID field, unique identification information assigned to each dental material (referred to as "incoming material") that is delivered to the material trading company is stored as an incoming material ID. The incoming material ID may be the same information as the material ID of the material master 33.

The received quantity item stores the received quantity of dental materials delivered to the material trading company.
The arrival unit item stores the arrival unit (unit, book, gram, etc.) of dental materials delivered to the material trading company.
In the arrival confirmation person ID field, unique identification information assigned to each person in charge of the material trading company who confirmed the dental materials arriving at the material trading company is stored as the arrival confirmation person ID.
The receiving store ID field stores unique identification information assigned to each store that receives dental materials as the receiving store ID. The receiving store ID may be the same as the ordering store ID.

<Explanation of treatment-material correspondence table>
The treatment-material correspondence table 47 shown in FIGS. 1 and 5 is a table in which information on treatments, which are the contents of treatments performed at a dental clinic, and materials necessary for the treatments are managed.

FIG. 5 shows an example of the treatment-material correspondence table 47. The treatment-material correspondence table 47 includes items such as hospital ID, treatment, treatment unit, material ID, material usage amount, and material usage unit.
Since the clinic ID item has already been explained, its explanation will be omitted.
The treatment item stores the name of the treatment performed on the patient at the dental clinic.
The treatment unit item stores the unit of the amount of dental material used when a treatment is performed at a dental clinic. For example, when one dental material is used for one tooth to be treated, "per tooth" is stored in the treatment unit item.

The material ID item stores unique identification information assigned to each dental material as a material ID. The material ID may be the same information as the material ID of the material master 33.
The material usage item stores the amount of material used in one treatment.
The material usage unit item stores the usage unit of the material used in one treatment.

<Explanation of the processing of the material prediction section>
Next, an example in which the material prediction unit 10 performs learning processing and prediction processing will be described.
FIG. 6 is a diagram illustrating a configuration example of functional blocks that perform learning processing and prediction processing of the material prediction unit 10. Each data, list, etc. shown in FIG. 1 is collectively referred to as a database 40. The database 40 includes data including the type and quantity of dental materials dispensed and used in the treatment.

By using the material prediction unit 10 as AI and performing machine learning, the functions of each unit of the dispensing unit 11, dispensing reservation unit 12, and ordering unit 13 shown in FIG. 1 are updated. Focusing on the machine learning process of the material prediction unit 10, the material prediction unit 10 includes a model definition unit 51, a learning unit 52, and a prediction unit 53.

The system administrator of the inventory management ordering system 3 defines a material prediction model, which is an example of a machine learning model, in the model definition unit 51 in advance. The material prediction model is a machine learning model used to obtain prediction results for the inventory amount of dental materials. The material prediction model is a neural network in which a plurality of nodes are arranged for each of a plurality of layers, and the nodes of each layer are connected to the nodes of the adjacent layer.

The learning unit 52 causes the material prediction model to learn changes in the inventory amount of dental materials by combining the frame called "material prediction model" with the learning data 50. Parameters such as weights and biases used by the learning unit 52 for learning are defined in the material prediction model.

Therefore, the learning unit 52 uses the types and amounts of dental materials in stock at the dental clinic and the types and amounts of dental materials used for each treatment performed at the dental clinic as learning data 50 to define a model. The material prediction model read out from the unit 51 is trained to generate a "trained material prediction model."

Therefore, the learning unit 52 uses the material prediction model defined in the model definition unit 51 and the learning data 50 accumulated in the database 40 to adjust the optimal parameters of the material prediction model and change the network configuration. . The process in which the learning unit 52 adjusts the parameters of the material prediction model and changes the network configuration is called "learning." The learning unit 52 learns a model using techniques such as RNN (Recurrent Neural Network) and LSTM (Long Short Term Memory), which are types of deep learning, for example. The material prediction model learned by the learning unit 52 and whose parameters have been optimized is referred to as the above-mentioned "learned material prediction model." The learning unit 52 then stores the generated learned material prediction model in the model definition unit 51.

The prediction unit 53 predicts the type and amount of dental material using the learned material prediction model read from the model definition unit 51 when the material prediction unit 10 is called by the dispensing unit 11 and the dispensing reservation unit 12. Then, the prediction unit 53 inputs various data read from the database 40 into the learned material prediction model, and obtains the predicted inventory amount of dental materials for each dental clinic from the learned material prediction model. The prediction unit 53 outputs the inventory amount of dental materials etc. predicted using the learned material prediction model to the caller's dispensing unit 11 and dispensing reservation unit 12.

Here, the processing of the material prediction unit 10 will be explained separately into initial processing, learning processing, and prediction processing.
<Initial processing>
At the initial stage of learning by the learning unit 52, the material prediction model defined by the system administrator of the inventory management ordering system 3 is stored in the model definition unit 51. The configuration, weights, etc. of the material prediction model defined in the model definition unit 51 at the initial stage of learning are not optimized. Therefore, before the learning process, that is, as an initial process, it is necessary to accumulate actual data in the database 40. The database 40 stores, for example, data collected from hundreds to thousands of dental clinics (see FIG. 2).

<Learning process>
When a sufficient amount of data is accumulated in the database 40, the learning process is started. The learning unit 52 reads a large amount of learning data 50 from the database 40 and inputs the data to the material prediction model read out from the model definition unit 51. The learning unit 52 uses the learning data 50 to adjust the parameters of the material prediction model so that the data output by the material prediction model matches the actual data.

Here, a configuration example of the learning data 50 will be described with reference to FIG. 7.
FIG. 7 is a diagram showing an example of the learning data 50.
The learning data 50 includes items such as hospital ID, gender, age, site, disease name, treatment details, and materials used. The learning unit 52 creates learning data 50 using data read from the database 40 during learning. This learning data 50 is created for each treatment for a patient.

Since the clinic ID item has already been explained, its explanation will be omitted.
The gender item stores the patient's gender.
The age item stores the patient's age.
The region item stores the patient's treatment region.
The disease name item stores the patient's disease name.
The treatment content item stores the treatment content. The treatment content item also stores information indicating a first visit and information indicating symptoms, but does not store information indicating a re-examination.
The material used item stores the material used. The materials used include the type and quantity of dental materials used.

Although not shown in FIG. 7, the learning data 50 also stores information such as the number of treatments, date and time of treatment, quantity of dental materials to be dispensed, unit of dispensing, reservation information 23, and the like.

Returning to FIG. 6, the explanation of the learning process will be continued.
As described above, the learning unit 52 uses the learning data 50 acquired from the database 40 to learn the material prediction model. Here, the learning unit 52 does not use all of the learning data 50 for the learning process, but uses 80% of the randomly divided learning data 50 as training data and the remaining 20% of the data as evaluation data.
The learning unit 52 then uses the training data to perform a learning process on the material prediction model so that the output of the material prediction model matches the content of the training data. At this time, the parameters of the material prediction model are adjusted according to the training data.

<Evaluation processing>
When the learning unit 52 finishes learning the material prediction model, it performs an evaluation process to evaluate the learned material prediction model. Evaluation data is used in the evaluation process. The learning unit 52 then evaluates the behavior of the material prediction model whose parameters have been adjusted using the training data, using the evaluation data acquired from the database 40. For example, if the number of dental materials actually dispensed for a certain procedure is 2, as shown in the evaluation data, the number of dental materials predicted by the data output from the material prediction model is If there are two, it is a material prediction model that makes correct predictions.

The learning unit 52 needs to prevent the material prediction model being trained from falling into overfitting that is optimized only for specific training data, and to evaluate whether the output is appropriate even with data other than the training data. . Therefore, the learning unit 52 performs a learning process using training data and an evaluation process using evaluation data on the material prediction model multiple times. At this time, different training data and evaluation data are used in each learning process and evaluation process.

For example, No. Assume that there are 10 pieces of data from 1 to 10. In the first learning process, data of "No. 1, 3, 4, 6, 7, 8, 9, 10" is used as training data, and in the evaluation process, the remaining data of "No. 2, 5" is used for evaluation. Used as data. In the second learning process, data of "No. 2, 3, 4, 5, 7, 8, 10" is used as training data, and in the evaluation process, the remaining data of "No. 1, 6" is used as evaluation data. used. In this way, different training data and evaluation data are used each time in the learning process and the evaluation process.

A material prediction model that has been subjected to multiple learning and evaluation processes is used as a learned material prediction model whose parameters have been adjusted using a large amount of data. By using the trained material prediction model in the prediction unit 53, the model definition unit 51 has a trained material prediction model that can make correct predictions without the need for a system administrator to individually adjust the parameters of the material prediction model. will be saved in

<Prediction processing>
The prediction unit 53 reads out the learned material prediction model from the model definition unit 51 in accordance with the processing of the payout unit 11 or the payout reservation unit 12. The prediction unit 53 then inputs the data read from the database 40 into the learned material prediction model to obtain output data. This output data is returned to the dispensing unit 11 or dispensing reservation unit 12 which is the calling source of the material prediction unit 10.

In the prediction process, the dispensing unit 11 calculates the type and type of dental materials to be dispensed at the dental clinic for each dental material using a learned material prediction model that has learned the dispensing date and time, dispensing quantity, and usage quantity of the actually dispensed dental materials. Predict the amount. Further, the dispensing reservation unit 12 can reserve dental materials to be dispensed in a treatment booked at a dental clinic, using a learned material prediction model that has learned the quantity of dental materials actually used.

The learning process and evaluation process described above are executed at arbitrary timing. For example, the learning process and the evaluation process may be executed every week or every month. By repeatedly executing the learning process and the evaluation process, the learning unit 52 can learn the material prediction model based on the latest data at the time of execution. Moreover, the prediction unit 53 can improve the accuracy of prediction processing of various data by using a learned material prediction model learned based on the latest data.

Furthermore, by using data collected from a large number of dental clinics as the learning data 50, the material prediction unit 10 obtains a learned material prediction model that can output general values for the type and amount of dental materials for a certain treatment. be able to.

However, in a particular dental clinic, the amount of dental materials in stock predicted by the learned material prediction model may deviate from the actual amount in stock. In such dental clinics, if a trained material prediction model that can output general values is used, there is a risk that the amount of dental materials ordered will be excessive or insufficient. Therefore, the material prediction unit 10 may predict the inventory amount of dental materials at a specific dental clinic using a learned material prediction model obtained by learning a material prediction model dedicated to the specific dental clinic.

Further, when a new dental material that has not been ordered before is used, data on this dental material is not stored in the database 40. Therefore, when the order history data 42 and the like for new dental materials at each dental clinic have been sufficiently accumulated, the learning section 52 of the material prediction section 10 uses the material prediction model read out from the model definition section 51 to Performs learning and evaluation processing for dental materials. As a result, even if the dental material is new, the prediction unit 53 can order the learned material prediction model read from the model definition unit 51 at the appropriate timing and in the appropriate quantity.

<Example of computer hardware configuration>
Next, the hardware configuration of the computer 100 that constitutes the inventory management ordering system 3 will be explained.
FIG. 8 is a block diagram showing an example of the hardware configuration of the computer 100. The computer 100 is an example of hardware used as a computer that can operate as the inventory management ordering system 3 according to the present embodiment. The inventory management ordering system 3 according to the present embodiment realizes an inventory management ordering method performed by the functional blocks shown in FIG. 1 in cooperation with each other by the computer 100 (computer) executing a program.

The computer 100 includes a CPU (Central Processing Unit) 101, a ROM (Read Only Memory) 102, and a RAM (Random Access Memory) 103, each connected to a bus 104. Further, the computer 100 includes a display device 105, an input device 106, a nonvolatile storage 107, and a network interface 108.

CPU 101 reads software program codes that implement each function according to the present embodiment from ROM 102, loads them into RAM 103, and executes them. Variables, parameters, etc. generated during the calculation process of the CPU 101 are temporarily written to the RAM 103, and these variables, parameters, etc. are read out by the CPU 101 as appropriate. However, instead of the CPU 101, an MPU (Micro Processing Unit) may be used, or the CPU 101 and a GPU (Graphics Processing Unit) may be used together. The functions of each block such as the material prediction section 10 and the dispensing section 11 of the inventory management ordering system 3 are realized by the CPU 101.

The display device 105 is, for example, a liquid crystal display monitor, and displays the results of processing performed by the computer 100 to the system administrator of the inventory management ordering system 3. For example, a keyboard, a mouse, etc. are used as the input device 106, and the system administrator can input predetermined operations and give instructions.

As the non-volatile storage 107, for example, an HDD (Hard Disk Drive), an SSD (Solid State Drive), a flexible disk, an optical disk, a magneto-optical disk, a CD-ROM, a CD-R, a magnetic tape, or a non-volatile memory is used. It will be done. In this non-volatile storage 107, in addition to an OS (Operating System) and various parameters, programs for making the computer 100 function are recorded. The ROM 102 and the non-volatile storage 107 record programs, data, etc. necessary for the operation of the CPU 101, and serve as an example of a computer-readable non-transitory storage medium that stores programs to be executed by the computer 100. used. A database 40 for each data, master, etc. of the inventory management ordering system 3 is configured in a non-volatile storage 107.

For example, a NIC (Network Interface Card) is used as the network interface 108, and various data can be sent and received between devices via a LAN (Local Area Network), dedicated line, etc. connected to the terminal of the NIC. It is possible. The inventory management ordering system 3 can communicate with the medical record system 2 and the ordering system 4 through the network interface 108 .

Next, examples of processing of each part of the inventory management ordering system 3 will be explained with reference to flowcharts shown in FIGS. 9 to 15.

<Example of payout process>
FIG. 9 is a flowchart showing an example of payout processing. In the dispensing process, the dispensing unit 11 cooperates with the medical record information 22, and based on the treatment details described in the medical record and registered in the medical record system 2, the dispensing unit 11 disposes of dental materials used in the treatment (hereinafter referred to as "materials used"). ) and its usage amount, and the process of dispensing the materials to be used.

First, a medical worker inputs the details of the patient's treatment through the medical record system 2 (S1). The treatment details input into the medical record system 2 are transmitted as medical record information 22 to the inventory management ordering system 3. Further, patient information 21 is also transmitted from the medical record system 2 to the inventory management ordering system 3.

The material prediction unit 10 of the inventory management ordering system 3 calculates the dental materials used in the treatment of the patient (hereinafter referred to as "materials used") based on the patient information 21 and medical record information 22 received from the medical record system 2. , and the usage amount of dental materials (S2). At this time, the material prediction unit 10 uses the treatment-material correspondence table 47 shown in FIG. 5 in a complementary manner to predict the materials to be used and the amount to be used. Then, the material prediction unit 10 transmits the predicted materials to be used and amounts to be used to the medical record system 2 in order to have a medical professional confirm whether the predicted materials to be used and amounts to be used are correct.

The medical worker confirms the predicted materials to be used and the amount to be used, which the medical record system 2 has received from the inventory management ordering system 3 (S3). In the confirmation process of step S3, if the predicted amount of dental materials to be dispensed at the dental clinic predicted by the material prediction unit 10 and the actual usage amount of the dental materials dispensed at the dental clinic are different, the actual usage of the dental materials is determined. A process is performed to correct the predicted amount of dental material in accordance with the amount. Here, the confirmation process in step S3 will be explained with reference to FIG. 10.

FIG. 10 is a flowchart illustrating an example of a process in which a medical worker confirms the predicted materials and amounts to be used.

First, the medical record system 2 notifies the medical staff of the materials and amount to be used predicted by the material prediction unit 10 (S11). This notification is performed by the medical record system 2 displaying the materials used and the amounts used on the monitor of the PC in the dental clinic. The medical worker checks the notified materials to be used and the amount to be used, and determines whether the materials to be used and the amount to be used predicted by the dispensing unit 11 are correct (S12).

If the medical worker determines that the material and amount to be used predicted by the material prediction unit 10 are correct (YES in S12), the process proceeds to step S14. In this case, information determined to be correct by the medical staff is transmitted from the medical record system 2 to the inventory management ordering system 3.

When the medical worker determines that the predicted materials to be used and the amount to be used are incorrect (NO in S12), the medical worker corrects the predicted materials to be used and the amount to be used (S13). In this case, the information corrected by the medical worker is transmitted from the medical record system 2 to the inventory management ordering system 3.

After YES in step S12 or after step S13, the medical record system 2 causes the material prediction unit 10 to learn the correct materials and usage amounts (S14). At this time, the learning unit 52 in FIG. 6 reads out the data on the materials used and usage amount determined to be correct or the corrected data on the materials used and usage amount from the database 40 as the learning data 50, and uses the material prediction model. Re-learn. Then, the inventory management ordering system 3 returns the process to step S4 in FIG.

Next, the dispensing unit 11 registers the used materials and usage amounts in the used material list 44 shown in FIG. 5 (S4). Here, the initial value of the dispensing flag of the used material list 44 is "dispensing incomplete". In other words, unless all of the discharged dental materials are used up, the dispensing flag remains "dispensing incomplete". When all the dispensed dental materials are used up, the dispensing flag becomes "dispensed".

Next, the dispensing unit 11 performs a dispensing registration process for each used material based on the used material list 44 (S5), and ends this process. In the dispensing registration process of step S5, when the dispensing unit 11 determines that the cumulative amount of used dental materials is equal to or exceeds the dispensing unit amount of dental materials, the dispensing unit 11 registers in the database that the dental materials have been disbursed. Record at 40. Here, the payout registration process in step S5 will be explained with reference to FIG. 11.

FIG. 11 is a flowchart illustrating an example of payout registration processing.
First, the dispensing unit 11 determines whether the dispensing unit amount and the usage unit amount of the material to be dispensed (denoted as "the material" in the figure) are equal (S21). For example, even if the dispensing unit of dental materials is one dozen, the unit may be different, such as the amount used at one time being one bag. Further, when the dispensing unit is "1 box", it is also assumed that the usage unit is "1/12 box". Therefore, these amounts are respectively referred to as a "payout unit amount" and a "use unit amount." For dental materials whose dispensing unit amount and usage unit amount are different, the dispensing unit 11 refers to the medical record information 22 and performs dispensing processing as appropriate in consideration of the number of times the dental material has been used.

For example, if a dental material (cement, etc.) dispensed at a dental clinic has been used for 3 days, and it is discovered that another cement has been dispensed, the period of use of the dispensing dental material will be 3 days. It can also be seen that it is a day. Therefore, when the dental material is used for a certain period or a certain number of times, the dispensing dental material is completely used and dispensing processing is performed as if it had been used up.

If the dispensing unit amount and the usage unit amount of the material are equal (YES in S21), the dispensing unit 11 advances the process to step S24. In this case, the dispensing unit 11 updates the dispensing flag item in the used material list 44 to "dispensed".

On the other hand, if the dispensing unit amount and the used unit amount of the material are different (NO in S21), the dispensing unit 11 refers to the used material list 44 and calculates the cumulative usage amount of the material that has not yet been disbursed. It is determined whether the payout unit amount has been exceeded (S22). For example, the dispensing unit 11 determines whether the cumulative amount used this time exceeds 12 bags, which is the dispensing unit.

If it is determined in step S22 that the cumulative usage amount of the material does not exceed the payout unit amount (NO in S22), this process ends. At this time, the process of step S5 in FIG. 9 also ends.

When it is determined in step S22 that the cumulative usage amount of the material exceeds the dispensing unit amount (YES in S22), the dispensing unit 11 sets the dispensing flag of the material in the used material list 44 to "dispensed". Change (S23). Further, the dispensing unit 11 performs another dispensing of the material in excess of the dispensing unit amount, and sets the dispensing flag of the dispensing material to "dispensing incomplete".

If YES in step S21 or after step S23, the dispensing unit 11 registers the dispensing history of the material in the dispensing history data 41 shown in FIG. 4 (S24), and ends this process. At this time, the process of step S5 in FIG. 9 also ends.

Note that the processes in steps S2 and S3 shown in FIG. sometimes skipped.

<Example of payout reservation processing>
FIG. 12 is a flowchart showing an example of payout reservation processing. The dispensing reservation process is a process in which the dispensing reservation unit 12 cooperates with the reservation information 23 to predict the dental materials and usage amount to be used in the reserved treatment. The dispensing reservation unit 12 reserves dental materials based on treatment reservation information 23 obtained from the dental clinic and patient information 21 of the patient receiving the treatment. When the dispensing reservation unit 12 reserves dental materials, if there is a shortage of dental materials for the next scheduled treatment, the ordering unit 13 automatically orders the dental materials.

First, a medical worker inputs the details of a patient's reservation through the medical record system 2 (S31). The reservation details input into the medical record system 2 are sent to the inventory management ordering system 3 as reservation information 23. Then, the material prediction unit 10 of the inventory management ordering system 3 receives the reservation information 23.

Next, the material prediction unit 10 uses the learned material prediction model to determine the materials to be used and the amount of dental materials to be used in the next treatment, based on the patient information 21 and the scheduled treatment contents extracted from the reservation information 23. is predicted (S32). Then, the dispensing reservation unit 12 registers the predicted usage material and usage amount in each item of the usage schedule material ID, usage schedule quantity, and usage schedule unit of the usage schedule material list 45 (S33), and ends this process. .

The dispensing reservation unit 12 automatically performs dispensing reservation processing when a treatment reservation is made, and predicts the materials and amount to be used for the next reserved treatment. The ordering unit 13 can place an order in advance if the materials and amounts necessary for the next treatment are not in stock at the dental clinic. Next, the processing of the ordering unit 13 will be explained.

<Example of order processing>
FIG. 13 is a flowchart showing an example of order processing. The ordering process is a process that predicts the shortage of materials used at the dental clinic based on the amount of inventory at the dental clinic and the amount scheduled for future use, and automatically orders the materials that are predicted to be out of stock. . The ordering unit 13 aggregates the inventory of dental materials managed at the dental clinic every predetermined period, and orders the dental materials reserved by the dispensing reservation unit 12 when it is determined that the inventory of dental materials is insufficient. .

First, a medical worker sets a period and aggregation unit time for inventory prediction through the medical record system 2 (S41). The period and aggregation unit time for inventory prediction set in the medical record system 2 are transmitted to the inventory management ordering system 3, and the material prediction unit 10 receives the period and aggregation unit time for inventory prediction. For example, the period for inventory prediction is set to "2022/07/01 to 2022/07/03", and the aggregation unit time is set to 24 hours (one day). In this way, when 24 hours (one day) is set as the aggregation unit time, inventory is predicted for each day.

Next, the ordering unit 13 totals the inventory amount of each material used at each set point in time (S42). At this time, the ordering unit 13 refers to the dispensing history data 41 shown in FIG. 4, the ordering history data 42, the arrival history data 43, the used material list 44 shown in FIG. The amount of stock and shortage of materials used at each point in time (July 1st, 2nd, and 3rd) will be tallied.

Next, the ordering unit 13 notifies the medical record system 2 of the inventory amount of each material used at each set point in time (S43). This notification is sent from the medical record system 2 to the medical personnel. The ordering unit 13 then performs an ordering registration process (S44), and ends this process.

FIG. 14 is a flowchart showing a detailed example of the order registration process in step S44.
First, the medical worker uses the medical record system 2 to determine whether or not to order the dental materials notified from the ordering unit 13 (S51), and inputs the determination result into the medical record system 2. If the medical worker determines not to process the order for the dental materials notified by the ordering unit 13 (NO in S51), this process ends. At this time, the process of step S44 in FIG. 13 also ends. Information indicating that the ordering process for dental materials will not be performed is transmitted from the medical record system 2 to the inventory management ordering system 3, and the ordering process by the ordering unit 13 is canceled.

On the other hand, when the medical worker determines to process the order for the dental materials notified by the ordering unit 13 (YES in S51), information regarding ordering permission is transmitted from the medical record system 2 to the inventory management ordering system 3. Then, the ordering unit 13 specifies the dental materials to be ordered and the quantity to be ordered (S52).

The dental materials specified to be ordered by the ordering unit 13 and the order quantity are transmitted to the medical record system 2. Note that the specified dental materials and order quantity may be confirmed by a medical professional before ordering, or may be automatically ordered by the ordering unit 13 without prior confirmation by a medical professional. . If an order is automatically placed without prior confirmation by a medical professional, for example, the automatically ordered content is transmitted to the medical record system 2 every three days, and the medical staff confirms the ordered content. When the medical worker finishes confirming the order details, information indicating that the order details have been confirmed is transmitted to the inventory management ordering system 3. Then, the ID of the medical worker who confirmed the order is written in the order confirmer ID of the order history data 42.

Next, the ordering unit 13 transmits material ordering information to the ordering system 4 of the material trading company (S53). The ordering unit 13 then registers the ordered dental materials and the order quantity in the ordering history data 42 (S54), and ends this process. At this time, the process of step S44 in FIG. 13 also ends.

In this way, the ordering unit 13 can automatically perform ordering processing according to the ordering unit. For example, when a tube containing dental material with a short shelf life is dispensed, a process is immediately performed to order the next tube. Also, if the toner for a printer is something that can be used continuously for about a month after opening, the process of ordering the next bottle will be performed after a predetermined period of about two weeks has passed. . Furthermore, the ordering unit 13 can change the frequency of ordering depending on the quality deadline and inventory amount of dental materials. Furthermore, the ordering unit 13 can also order a larger amount of a specific material used in frequently reserved treatments.

FIG. 15 is a flowchart illustrating an example of arrival processing. The arrival process is a process for recording that the dental materials ordered by the ordering unit 13 have been delivered to the dental clinic.

First, the receiving unit 14 creates a list of unarrived materials (not shown) based on the order history data 42 and the arrival history data 43 (S61). The unarrived materials list is a list of dental materials that have been ordered but have not yet arrived at the dental clinic. For example, if the number of dental materials written in the order history data 42 is less than the number written in the arrival history data 43, the difference in the number of dental materials is written in the unarrived materials list.

When the ordered dental materials are received, the system administrator inputs the number of the received dental materials based on the unarrived materials list (S62). The receiving unit 14 then registers the quantity of dental materials received in the receiving history data 43 (S63), and ends this process.

<Procedure-Correction processing of material correspondence table>
Next, the processing of the totaling unit 15 shown in FIG. 1 will be explained.
The aggregation unit 15 aggregates the types and amounts of dental materials acquired from dental clinics and the types and amounts of dental materials to be dispensed at dental clinics predicted by the dispensing unit 11, and approximates the expected usage amount of dental materials. Correct based on actual usage amount. Therefore, the tallying unit 15 tallies the number of treatments and the amount of dental materials dispensed corresponding to the treatment based on the medical record information 22 received from the medical record system 2 and the dispensing history data 41 of the database 40. Then, the aggregation unit 15 statistically corrects the value of the amount of material used for a certain period recorded in the treatment-material correspondence table 47 in the following steps (a) to (e).

(a) The treatment-material correspondence table 47 records the material used (e.g. material B) and the expected amount used (information on the material usage amount item) when a certain treatment (e.g. treatment A) is carried out. There is.
(b) Based on the medical record information 22, the totaling unit 15 totals the number of times (for example, N times) that treatment A has been performed in a certain period (for example, period P).
(c) Based on the order history data 42, the totaling unit 15 totals the total ordered amount (for example, M) of material B during the period P in which the number of implementations of treatment A was totaled.
(d) The aggregation unit 15 enters the number of times that treatment A was performed (e.g. N times) and the total order amount of material B in period P (e.g. M) into the following formula (1), and calculates the number of times treatment A is performed. The actual approximate usage amount of material B during the implemented period P is calculated.
Actual approximate usage = M ÷ N…(1)
Although formula (1) is described in a simplified manner, in reality, the aggregation unit 15 calculates the usage amount of dental materials by also considering the "treatment unit".
(e) The aggregation unit 15 updates (corrects) the estimated usage amount (material usage item) in the treatment-material correspondence table 47 with the actual approximate usage amount calculated using equation (1). As a result, the estimated usage amount in the treatment-material correspondence table 47 is corrected based on the actual data.

<Analysis processing>
Next, the processing of the analysis section 16 shown in FIG. 1 will be explained with reference to FIG. 16.
The analysis unit 16 provides the dental clinic with an analysis result of the price of dental materials ordered for each dental clinic or the amount of dental materials used. For example, the analysis unit 16 analyzes dental material usage data collected from the medical record system 2 of each dental clinic and accumulated in the database 40. The analysis unit 16 then compares the management costs of each dental clinic and analyzes the usage trends of dental materials. Therefore, the analysis unit 16 can notify the medical record system 2 of the analysis results and advise the appropriate amount of dental materials to be used at the dental clinic.

FIG. 16 is a diagram showing an example of order history data 42 and treatment-material correspondence table 47 for explaining analysis processing.
The analysis unit 16 refers to the order history data 42 and analyzes the purchase price of dental materials for each dental clinic. The analysis unit 16 can provide the dental clinic with information as to whether the purchase price of the dental material is higher or lower than the market price.

As shown in FIG. 16, it is assumed that the same dental material identified by the same ordered material ID is ordered for four dental clinics with clinic IDs "1" to "4". Here, the average order price per transaction for a certain dental material (ordered material ID = 12345678) is 121.8 yen, the median price is 122.5 yen, the lowest price is 117 yen, and the highest price is 125 yen. Suppose there is. It can be seen that a certain dental clinic (clinic ID = 4) purchases dental materials (ordered material ID = 12345678) at a lower price (117 yen) than other dental clinics (clinic ID = 1 to 3). . Therefore, the analysis unit 16 can also present the difference in market prices of dental materials to medical professionals by referring to the order history data 42. Furthermore, the reason why the dental clinic (clinic ID=4) is able to purchase dental materials at a low price is because the number of orders is large compared to other dental clinics. It is also possible to advise other dental clinics.

Furthermore, the analysis unit 16 can refer to the treatment-material correspondence table 47 to analyze the materials used when a medical worker performs a certain treatment. For example, in one dental clinic (clinic ID = 1), dental material with material ID = 12345678 is often used during treatment A, and in other dental clinics, dental material with material ID = 12345000 is often used. I understand. Therefore, by referring to the order history data 42 and the treatment-material correspondence table 47, the analysis unit 16 presents information such as whether the amount of dental materials used at the dental clinic is too large or too small compared to other dental clinics. You can also.

In addition, the inventory management ordering system 3 orders dental materials from an ordering system 4 used by each material trading company. Therefore, the inventory management ordering system 3 can grasp the dental materials handled by each material trading company, select the material trading company most suitable for the dental clinic, and place an order.

Note that the dispensing unit 11 can also add information on the medical worker who was in charge of the treatment to the used material list 44. Therefore, the analysis unit 16 can also analyze the amount of materials used by each medical worker.

Furthermore, the medical record information 22 can be linked to business records for each medical worker. For this reason, the analysis unit 16 analyzes how each medical worker uses dental materials, and provides appropriate amounts of dental materials for each medical worker who determines that they are using too many dental materials. It is also possible to give advice on how to use it.

The inventory management ordering system 3 according to the embodiment described above can utilize the medical record information 22 received from the medical record system 2 to manage the inventory of dental materials using the learned material prediction model. At this time, the dispensing process of the dental materials at each dental clinic is automatically performed, so that the effort required for dispensing the dental materials at each dental clinic is reduced. In addition, the inventory management ordering system 3 uses the reservation information 23 received from the medical record system 2 to predict the type and amount of dental materials that will be needed in the future, and automatically orders the required amount of dental materials. Therefore, the dental clinic can secure an appropriate inventory of dental materials.

In addition, the inventory management ordering system 3 manages and understands the appropriate type and amount of dental materials for each treatment by collecting a large amount of medical record information 22. For this reason, it can be seen that an excessive amount of dental materials is being used in some dental clinics. Furthermore, by linking the medical record information 22, dispensing history data 41, and used material list 44, the inventory management ordering system 3 can also determine how dental materials are used for each medical worker. For this reason, the inventory management ordering system 3 can notify the medical staff through the medical record system 2 of the dental material usage status, appropriate usage amount, etc., and alert them.

Furthermore, in the embodiments described above, the dental material that is dispensed or used in dental treatment at a dental clinic has been described. However, inventory management of dental materials used in various medical practices and medical assistance activities by doctors other than dentists, pharmacists, nurses, physical therapists, judo therapists, nursing care staff, etc. It may also be applied to order processing. Furthermore, the order management system 1 and the inventory management order system 3 according to the present embodiment can be used not only in dental clinics but also in general hospitals with various medical departments.

Note that the inventory management ordering system 3 described above can predict dental materials even without using the medical record system 2. For example, assume that a dental clinic uses an inventory management system that manages inventory information on dental materials. In this case, the dispensing unit 11 predicts the type and amount of dental materials based on changes in inventory information acquired from the inventory management system. The delivery reservation unit 12 can also reserve dental materials based on changes in inventory information acquired from the inventory management system.

Note that the present invention is not limited to the embodiments described above, and it goes without saying that various other applications and modifications can be made without departing from the gist of the present invention as set forth in the claims.
For example, in the embodiments described above, the configuration of the system is explained in detail and specifically in order to explain the present invention in an easy-to-understand manner, and the system is not necessarily limited to having all the configurations described. Furthermore, it is also possible to add, delete, or replace some of the configurations of this embodiment with other configurations.
Further, the control lines and information lines are shown to be necessary for explanation purposes, and not all control lines and information lines are necessarily shown in the product. In reality, almost all components may be considered to be interconnected.

1... Order management system, 2... Medical record system, 3... Inventory management ordering system, 4... Order receiving system, 10... Material prediction department, 11... Dispatch department, 12... Dispatch reservation department, 13... Ordering department, 14... Receiving department , 15... Tabulation unit, 16... Analysis unit, 21... Patient information, 22... Medical record information, 23... Reservation information, 40... Database, 41... Dispensing history data, 42... Order history data, 43... Arrival history data, 44... Used material list, 45...List of materials scheduled to be used, 46...Material delivery schedule, 47...Treatment-material correspondence table, 50...Learning data, 51...Model definition section, 52...Learning section, 53...Prediction section

Claims (12)

a material prediction unit that predicts the inventory of the medical materials managed at the medical institution by predicting the types and quantities of the medical materials used at the medical institution;
a dispensing unit that predicts the type and amount of the medical material to be dispensed at the medical institution based on the type and amount of the medical material predicted by the material prediction unit;
a dispensing reservation unit that reserves the medical materials to be dispensed in a treatment reserved at the medical institution based on the type and amount of the medical materials predicted by the material prediction unit;
When it is determined that the amount of the medical materials in the inventory of the medical institution is insufficient when the reserved treatment is performed due to the use of the medical materials reserved for dispensing, the reserved treatment is performed. an ordering unit that orders an amount of the medical materials to compensate for the medical materials determined to be in short supply so that the medical materials arrive at the medical institutions by the time the medical institutions receive the medical materials. When the predicted amount of the medical material to be dispensed at the medical institution and the actual usage amount of the medical material dispensed at the medical institution are different, the dispensing unit adjusts the amount of the medical material to match the actual usage amount of the medical material. The inventory management ordering system according to claim 1, wherein the predicted quantity of the medical material is corrected. comprising a database for managing the types and quantities of the medical materials in stock for each medical institution;
The dispensing unit records in the database that the medical material has been dispensed when it is determined that the cumulative value of the usage amount of the medical material is equal to or exceeds the dispensing unit amount of the medical material. The inventory management ordering system described in Section 2. The inventory management ordering system according to claim 3, wherein the dispensing reservation unit reserves the medical materials based on treatment reservation information acquired from the medical institution and patient information of the patient receiving the treatment. The ordering unit aggregates the inventory of the medical materials managed by the medical institution every predetermined period, and when it is determined that the inventory of the medical materials is insufficient, the ordering unit collects the inventory of the medical materials managed by the medical institution, and when it is determined that the inventory of the medical materials is insufficient, the ordering unit stores the medical supplies reserved by the dispensing reservation unit. The inventory management ordering system according to claim 4, which orders materials. The dispensing unit determines the type and amount of the medical material based on the implementation details of the treatment acquired from a medical record system that manages medical record information created for each patient for the treatment performed at the medical institution. predict,
The inventory management ordering system according to claim 5, wherein the dispensing reservation unit reserves the medical materials based on reservation details of the treatment acquired from the medical record system. The dispensing unit predicts the type and amount of the medical material based on changes in the inventory information obtained from an inventory management system that manages inventory information of the medical materials used in the medical institution,
The inventory management ordering system according to claim 5, wherein the dispensing reservation unit reserves the medical materials based on a change in the inventory information acquired from the inventory management system. a model definition unit in which a material prediction model for predicting the inventory amount of the medical materials is defined;
The type and amount of the medical material in stock at the medical institution and the type and amount of the medical material used for each medical treatment performed at the medical institution in the past are read from the model definition unit as learning data. a learning unit that causes the material prediction model to learn and stores the learned material prediction model in the model definition unit;
The learned material prediction model is read from the model definition unit in accordance with the processing of the dispensing unit or the dispensing reservation unit, and the inventory amount of the medical material predicted using the learned material prediction model is sent to the dispensing unit. or a prediction unit that outputs to the payout reservation unit. The dispensing unit determines the type of medical materials to be dispensed at the medical institution for each medical material based on the learned material prediction model that has learned the dispensing date and time, dispensing quantity, and usage quantity of the medical materials actually dispensed. and predict the amount;
According to claim 8, the dispensing reservation unit reserves the medical materials to be disbursed in a treatment reserved at the medical institution, based on the learned material prediction model that has learned the usage quantity of the medical materials actually used. Inventory management ordering system described. The type and amount of the medical material acquired from the medical institution and the type and amount of the medical material to be dispensed at the medical institution predicted by the dispensing unit are aggregated, and the expected usage amount of the medical material is approximated. The inventory management ordering system according to claim 8, further comprising a totaling unit that corrects the amount based on the actual usage amount. The inventory management ordering system according to claim 8, further comprising an analysis unit that provides the medical institution with an analysis result of analyzing the price of the medical materials ordered for each medical institution or the usage amount of the medical materials. A step of predicting the inventory of the medical materials managed at the medical institution by predicting the types and quantities of the medical materials used at the medical institution;
A step of statistically predicting the type and amount of medical materials to be dispensed at the medical institution based on the predicted type and amount of the medical materials;
a step of reserving the medical materials to be dispensed in a treatment booked at the medical institution based on the predicted type and amount of the medical materials;
When it is determined that the amount of the medical materials in the inventory of the medical institution is insufficient when the reserved treatment is performed due to the use of the medical materials reserved for dispensing, the reserved treatment is performed. A program for causing a computer to execute a procedure for ordering an amount of the medical materials to compensate for the medical materials determined to be in short supply so that the medical materials arrive at the medical institutions by the time of delivery.

Images