JP2019185526A - Drug prescription support program, drug prescription support method, and an information processing apparatus - Google Patents

Abstract

To prevent taking medicine beyond the expiration date.SOLUTION: The drug prescription support program causes a computer to execute a drug prescription support program, including: when receiving a prescription, obtaining inventory information for prescription drugs, and when the inventory information includes the same type of drug in which a first drug that expires before the expiration of the prescription period and a second drug that does not expire before the expiration of the prescription period, performing a series of processing to output a piece of information that the medicine that should be taken first is included in the prescription medicine.SELECTED DRAWING: Figure 8

Description

  The present invention relates to a drug prescription support program, a drug prescription support method, and an information processing apparatus.

  Since pharmacies have ample stock so that there are no missing drugs, some drugs will expire without prescription. However, since pharmaceuticals are expensive, losses due to expiration are large. In order to prevent this, pharmacies are making various inventory management measures. However, since there are so many kinds of drugs, it is difficult to grasp the whole, and the expiration of the inventory continues to be a major issue for pharmacies.

  When using an infusion bag, if the expiration date of the solution expires before or during administration, a technology that recalculates the inventory replenishment schedule by presenting a message that the expiration date will expire during the administration period is known. It has been. If the expiration date of the remaining drug of the patient is still ahead, a technique has been proposed in which the number of the next use is the number obtained by subtracting the remaining amount from the number of drugs that need to be provided.

Special table 2006-507026 International Publication No. 2008/117544 JP 2003-118840 A

  However, the above technology does not take into account how the patient consumes the prescribed medicine, so some patients forget to take the medicine, etc. There is a problem that prescription drugs are greeted.

  Therefore, in one side, it aims at preventing taking the medicine beyond the expiration date.

  According to one aspect, upon receiving a prescription, the inventory information of the medicine to be prescribed is acquired, and the first kind medicine that expires before the expiration of the prescription period is obtained in the same kind of medicine in the inventory information. A prescription for a drug that causes the computer to output that the medicine to be taken is included in the prescription drug if it contains a second medicine that has not expired before the expiration of the prescription period Support programs are provided.

  It is possible to prevent a medicine that has expired from being taken.

It is a figure which shows the hardware structural example of information processing apparatus. It is a figure which shows the function structural example of the information processing apparatus in a present Example. It is a figure for demonstrating the item of an inventory time limit management table. It is a figure which shows the example of a registration screen. It is a figure which shows the example of data of an inventory time limit management table. It is a figure for demonstrating the item of prescription drug search conditions. It is a figure which shows the example of a search screen. It is a figure which shows the example of a search result display screen. It is a figure which shows the example of a state of the search result display screen just before an update. It is a figure which shows the example of a state of the search result display screen after an update. It is a figure which shows the example of an update screen. It is a flowchart figure (following) for demonstrating prescription drug search processing. It is a flowchart figure (following) for demonstrating prescription drug search processing. It is a flowchart figure (following) for demonstrating prescription drug search processing. It is a flowchart figure (continuation) for demonstrating prescription drug search processing. It is a figure for demonstrating the example of introduction.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. From the medical fee revision in 2002, the number of administration days was not restricted except for some cases. Specifically, administration for a period of 90 days or more is possible. Under such circumstances, there are various problems in inventory management of pharmaceuticals in pharmacies.

(1) It is necessary to hold inventory with a margin so as not to run out of goods (ie, out of stock).
Since it may be related to the patient's life, it is necessary to prevent the patient from prescribing the medicine due to the shortage. In addition, the symptoms of patients coming to the pharmacy and the date of visit cannot be predicted perfectly. For this reason, there is a tendency to have sufficient stock so that it can be handled in any case.

(2) If there is too much surplus inventory, some drugs will expire and expire.
Drug prices are high, so pharmacies lose a lot due to expiration. Various measures are taken for each pharmacy to reduce the loss.

(3) There are many types of pharmaceuticals. Therefore, it is difficult to grasp the remaining inventory.
There are a wide variety of types of packaging for pharmaceutical products. Even drugs with the same effect are tablets, powders, syrups, injections, etc., and the capacity and packaging differ depending on the package. Specifically, even in tablets, the capacity of one tablet is 5 mg or 10 mg, and packaging includes PTP (Press Through Pack) or bottling. Capacity differences and packaging differences are collectively referred to as “packaging differences”.

  Furthermore, since there are products of different manufacturers such as generic products (generic), there are simply many types. In addition, drugs may be divided according to prescription. In the case of dividing medicines, there are split tablets that divide one tablet by the middle line, and claims and syrups are moved to another container. Therefore, even for the same medicine, the state of the medicine in stock varies, and it is more difficult to grasp the amount of the stock.

  That is, as a first problem, it is difficult for the pharmacy side to accurately grasp the drug expiration date for each stock from the situation of (1) and (2) above. Even with the same product, the deadline varies depending on the purchase time, so it is necessary to be able to grasp the deadline for each medicine (box, bottle, ampoule, etc.).

  As a second problem, from the situation of (3) above, even if the deadline is grasped for each medicine, it is meaningless if the medicine cannot be identified. There are many types of medicines and stocks managed by pharmacies, and it is necessary to associate medicines with deadlines. In other words, it is preferable that it is possible to easily grasp when each box on which shelf is due.

  In the present embodiment, firstly, with respect to the first problem, the expiration date can be grasped for each product by registering the expiration date and making it searchable. Secondly, in the search for the product name, by displaying the time limit for each purchase, it is possible to select the products in order of close to the time limit. In addition, for the second problem, information for specifying a product at the time of registration can be set. As an example, registering information such as a storage location facilitates the identification of a product.

  The information processing apparatus that realizes the processing according to the present embodiment, which solves the first and second problems, has a hardware configuration as shown in FIG. FIG. 1 is a diagram illustrating a hardware configuration example of the information processing apparatus. In FIG. 1, an information processing apparatus 100 is an information processing apparatus controlled by a computer, and includes a CPU (Central Processing Unit) 11, a main storage device 12, an auxiliary storage device 13, an input device 14, and a display device. 15, a reading device 16, a communication I / F (interface) 17, and a drive device 18, which are connected to the bus B.

  The CPU 11 corresponds to a processor that controls the information processing apparatus 100 in accordance with a program stored in the main storage device 12. The main storage device 12 uses a RAM (Random Access Memory), a ROM (Read Only Memory) or the like, and is obtained by a program executed by the CPU 11, data necessary for processing by the CPU 11, and processing by the CPU 11. Store or temporarily store the data.

  The auxiliary storage device 13 uses an HDD (Hard Disk Drive) or the like, and stores data such as programs for executing various processes. A part of the program stored in the auxiliary storage device 13 is loaded into the main storage device 12 and executed by the CPU 11, whereby various processes are realized. The storage devices accessible by the main storage device 12, the auxiliary storage device 13, and other information processing devices 100 are collectively referred to as a storage unit 130.

  The input device 14 includes a mouse, a keyboard, and the like, and is used by a user such as a pharmacist to input various information necessary for processing by the information processing device 100. The display device 15 displays various information required under the control of the CPU 11. The input device 14 and the display device 15 may be a user interface such as an integrated touch panel.

  The reading device 16 may be a device such as a barcode reader. The communication I / F 17 performs communication through a wired or wireless network. Communication by the communication I / F 17 is not limited to wireless or wired.

  The drive device 18 performs an interface between the information processing device 100 and a storage medium 19 (for example, a CD-ROM (Compact Disc Read-Only Memory)) set in the drive device 18.

  A program that realizes processing performed by the information processing apparatus 100 is provided to the information processing apparatus 100 by a storage medium 19 such as a CD-ROM. The storage medium 19 stores a program that realizes various processes according to the present embodiment described later, and the program stored in the storage medium 19 is installed in the information processing apparatus 100 via the drive device 18. . The installed program can be executed by the information processing apparatus 100.

  The storage medium 19 for storing the program is not limited to a CD-ROM, but one or more non-transitory tangible media having a structure that can be read by a computer. If it is. As a computer-readable storage medium, in addition to a CD-ROM, a DVD (Digital Versatile Disk) disk, a portable recording medium such as a USB memory, or a semiconductor memory such as a flash memory may be used.

FIG. 2 is a diagram illustrating a functional configuration example of the information processing apparatus according to the present embodiment. In FIG. 2, the information processing apparatus 100 mainly includes a registration unit 40 and a prescription drug search unit 41.
The storage unit 130 stores an inventory expiration management table 51, a prescription drug table 53, a prescription drug search condition 3, and the like.

  The registration unit 40 is a processing unit that registers the received drug information 2 input by a user such as a pharmacist in the inventory expiration management table 51 every time a drug is stored in the pharmacy. The inbound medicine information 2 is registered as one record at least every expiration date. More specifically, in addition to the expiration date, each record is registered as one record for each combination of product name, capacity, standard unit, and the like.

  The prescription drug search unit 41 searches the inventory expiration date management table 51 according to the input of the prescription drug search condition 3, displays the search result 4 on the display device 15, and manages the inventory expiration date according to the input of the update information 5. It is a processing unit that updates the table 51. The prescription drug search condition 3 is stored in the storage unit 130. The prescription drug search unit 41 further includes an extraction unit 42, a category determination unit 44, a priority order determination unit 46, and a display unit 48.

  The extraction unit 42 searches the inventory expiration date management table 51 using the prescription drug search condition 3 stored in the storage unit 130, extracts a corresponding record, and creates the prescription drug table 53 in the storage unit 130. Part.

  The category determination unit 44 is a processing unit that determines a priority category for each record in the prescription drug table 53 based on the expiration date. As a priority category, each record is “X” indicating a drug that has already expired, “A” that may expire while the patient is taking, or “B” that is about to expire on the day of taking. being classified.

  The priority order determination unit 46 is a processing unit that determines the priority of the prescription order for each record in the prescription drug table 53 based on the priority category, the remaining inventory total, and the like.

  The display unit 48 is a processing unit that displays the search result 4 indicating the priority order on the display device 15 using the prescription drug table 53. The display unit 48 further includes an update unit 49. When the update unit 49 receives update information 5 for the search result 4 displayed on the display device 15 of the user, the update unit 49 updates the inventory expiration date management table 51.

  Each processing unit described above is realized by a process that a program installed in the information processing apparatus 100 causes the CPU 11 of the information processing apparatus 100 to execute.

  FIG. 3 is a diagram for explaining items in the inventory expiration management table. In FIG. 3, the inventory expiration date management table 51 includes a JAN code, serial number, YJ code, general name, product name, capacity, standard unit, expiration date, remaining inventory, storage location, information necessary for identification, generic product, number of alarm days. And have items such as registration date. A JAN code and a serial number for uniquely determining a medicine are set as a primary key.

  The JAN code indicates a product number that can be commonly used internationally. The JAN code is indicated by a barcode or the like on a box or the like in which medicines are packaged, and the information processing apparatus 100 indicates a code read using the reading device 16. The serial number is a number added to the JAN code, and indicates a serial number for identification for each management unit in the pharmacy. The serial number indicates, for example, a serial number for managing the received medicine for each expiration date, and is used as discrimination information other than the JAN code in this embodiment.

  The YJ code indicates a unique number (individual drug code) given to all the drug price listed items in Japan. The YJ code may also be indicated by a bar code or the like and read by the reading device 16. The generic name indicates the generic name of the drug. As an example, “carvedilol tablets” and the like are shown. The product name indicates the product name of the pharmaceutical product, and most of the information includes information indicating the capacity. As an example, an artist tablet 10 mg or the like is shown.

  The volume indicates a single dose including the type of administration. The standard unit indicates the amount and dosage form of one unit of drug. As an example, 10 mg for 1 tablet, 0.5 tablet for half tablet, ml or g for cream, etc. are shown.

  The expiration date indicates the time limit for taking the medicine indicated in the packaging unit. The remaining inventory indicates the amount held by the pharmacy. The storage location indicates information for specifying the storage location. The information necessary for identification indicates additional information for identifying the medicine managed by the record. The generic item indicates whether it is a generic item. “1” is indicated for generic products, and “0” is indicated otherwise.

  The number of alarm days indicates the number of days for determining that the expiration date is close, although it is not expired. As an example, a medicine with a high turnover rate is set short, and a medicine with a low turnover (when the selling interval is large) is set long. By setting the number of alarm days, it is possible to warn that a drug with a low turnover rate may expire before the next prescription. The registration date indicates the date when the record is registered. The user may set it, or the system date and time of the information processing apparatus 100 may be set in accordance with the input of the inbound medicine information 2.

  FIG. 4 is a diagram illustrating an example of a registration screen. A registration screen G60 illustrated in FIG. 4 is a screen that the registration unit 40 displays on the display device 15 in response to a registration screen display request made by the user's operation of the input device 14 or the like. The registration screen G60 has an input area 60a for inputting the inbound medicine information 2 and a registration button 60b.

  In the input area 60a, information on medicines to be received is input for each item name illustrated in FIG. The information input in the input area 60a corresponds to the inbound medicine information 2. The registration button 60b requests the registration unit 40 to register the stored medicine information 2 input in the input area 60a according to the user's selection. The registration unit 40 registers the received medicine information 2 in the inventory expiration management table 51.

  In this example, JAN code “4987081202775”, YJ code “2149032F1021”, generic name “Carvedilol tablet”, product name “Artist tablet 10 mg”, capacity “PTP 100T”, standard unit “10 mg 1 tablet”, expiration date “2018/2” / 15 ”, remaining inventory“ 10 ”, storage location“ 1st shelf 1 row 1 row ”, information necessary for specification“ purchase date 2015/8/3 seal available ”, generic product“ 0 ”, alarm days“ 14 ” "Etc. show examples set by the user.

  In the input area 60a, when inputting a general name, in addition to manual input, a product name corresponding to a JAN code or a YJ code may be automatically input. As an example, a table for managing product names in association with JAN codes or YJ codes is provided, and this can be realized by a mechanism for extracting product names in response to input of JAN codes or YJ codes.

  FIG. 5 is a diagram illustrating an example of data in the inventory expiration date management table. FIG. 5 shows a state in which one record indicating the set warehousing drug information 2 is registered in the inventory expiration date management table 51 every time the registration button 60b is pressed on the registration screen G60 of FIG.

  In the inventory expiration date management table 51, in the record of JAN code “4987081202775” and serial number “1”, the general name “Carvedilol tablet”, the product name “Artist tablet 10 mg”, the capacity “PTP 100T”, the standard unit “10 mg 1 tablet”, Expiration date “2018/2/15”, remaining inventory “10”, storage location “1st shelf 1 row 1 row”, information necessary for specification “purchase date 2015/8/3 seal”, generic product “0” ”, The number of alarm days“ 14 ”, and the like. This record corresponds to the example shown in FIG.

  Furthermore, when the user sets the warehousing drug information 2 on the setting screen G60 shown in FIG. 4, in the record of the JAN code “4987081202775” and the serial number “2”, the general name “Carvedilol tablet”, the product name “Artist tablet 10 mg”, Capacity “PTP 100T”, standard unit “10 mg 1 tablet”, expiration date “2018/7/30”, remaining inventory “100”, storage location “1st shelf 1 row 1 row”, information necessary for specification “purchase date 2015/10/3 (1) Sealed ”, generic item“ 0 ”, alarm days“ 14 ”, etc. are registered. The same applies to other records.

  FIG. 6 is a diagram for explaining items of prescription drug search conditions. In FIG. 6, prescription drug search condition 3 has items such as prescription date, quantity per day, number of administration days, selection items by pull-down of search information, standard unit, generic availability.

  The prescription date specifies the day on which the patient is prescribed. For daily quantity, specify the daily dosage. The quantity per day is specified as “1 tablet 3 times a day after breakfast, lunch and dinner”. In administration days, specify the number of days to prescribe. As the number of administration days, “14 tablets for 14 days” or the like is designated. The quantity per day and the number of administration days are referred to the calculation of the required quantity, and are also referred to the comparison with the inventory quantity for each expiration date.

  The selection items by the pull-down of the search information indicate items that can be selected by the user by displaying a list showing general names, product names, JAN codes, YJ codes, and the like. As an example of selection and input, a general name is selected and “Carvedilol tablet” is input, a product name is selected and “Artist lock” is input, a JAN code is selected, “4987081202775” is input, and a YJ code is selected. “2149032F1021” can be input.

  In the standard unit, the amount and dosage form of one unit of medicine are designated. It is possible to narrow down and search for medicines that meet the specified standard unit. If there is no input to the standard unit, no narrowing is performed. For example, when specifying the capacity of one tablet, 10 mg 1 tablet, half tablet “10 mg 0.5 tablet”, cream etc. “5 mg 1 container” or “5 ml 1 bottle”, etc. For powder, package / gram, etc., for liquid tablet, ml / tube, etc. are specified.

  Whether or not generic products are available is selected from a pull-down menu whether or not generic products are included in the search results. When generic product prescription is possible, search result 4 is not limited by generic item. When the generic product cannot be prescribed, the search is limited to records with the generic product value of “0” in the inventory time limit management table 51.

  FIG. 7 is a diagram illustrating an example of a search screen. A search screen G62 illustrated in FIG. 7 is a screen that the prescription drug search unit 41 displays on the display device 15 in response to a search screen display request made by the user's operation of the input device 14 or the like. The search screen G62 has an input area 62a for inputting prescription drug search conditions 3 and a search button 62b.

  In the input area 62a, information on medicines to be searched for each item name illustrated in FIG. 6 is input. The information input in the input area 62a corresponds to prescription drug search condition 3. The search button 62b makes a search request for the prescription drug search condition 3 input in the input area 62a to the prescription drug search unit 41 by the user's selection. The prescription drug search unit 41 searches for the prescription drug search condition 3 from the inventory expiration date management table 51.

  In this example, the prescription date “2018/2/3”, the quantity “3” per day, the number of administration days “14”, the generic name “carvedilol tablet”, and the generic product availability “possible” are set by the user. The standard unit (option) is not set. In addition, an example is shown in which the item of the general name is designated by the user and “carvedilol tablet” is set. When the user presses the search button 62b in this state, the search result 4 is displayed on the display device 15.

  FIG. 8 is a diagram illustrating an example of a search result display screen. The search result display screen G64 illustrated in FIG. 8 is a screen on which the display unit 48 displays the search result 4 on the display device 15 in response to pressing of the search button 62b of the search screen G62 in FIG. The search result display screen G64 has a display area 64a for displaying prescription information of medicines, a search result display area 64b including the search result 4, and an update button 64c.

  In the display area 64a, the prescription period and the required quantity are displayed. As the prescription period, a period calculated from the prescription date and the number of administration days set in the search screen G62 of FIG. 7 is displayed. As the necessary quantity, a quantity calculated from the quantity per day and the number of administration days set in the search screen G62 in FIG. 7 is displayed. In this example, the prescription period “2018/2/3 to 2018/2/16” and the required quantity “42” are shown.

  In the search result display area 64b, in addition to the search result 4, a display area in priority order, an input area for used quantity, a record correction button, and the like are added. The search result 4 includes a JAN code, a YJ code, a product name, a capacity, a standard unit, a remaining inventory, a storage location, information necessary for identification, a generic product, a usage amount, and the like.

  The priority order satisfies the required quantity according to the order of the expiration date from the record when the expiration date is within the prescription period among the records extracted from the inventory expiration date management table 51 using the prescription drug search condition 3. The order of prescription is shown. Further, when there is a record indicating the expiration date before the prescription period in the extracted record, a mark 64e indicating that prescription is not performed is indicated in priority order.

  In this example, since there is a record whose expiration date is within the prescription period, priority is given to the record until the total remaining inventory satisfies the required quantity “42”. Specifically, the expiry date is `` 2018/2/15 '' and `` 2018/2/16 '' because they are within the prescription period `` 2018/2/3-2018/2/16 '' Yes. Expiration dates of `` 2018/2/25 '' and `` 2018/7/30 '' are after the prescription period `` 2018/2/3-2018/2/16 '', but within the period based on the number of alarm days Therefore, the priority order is also shown in these two records.

  It is desirable to preferentially consume medicines that are due for use within the prescription period. Next, for medicines that are due for use within a certain period after the prescription period, the expiry date takes precedence over the previous medicine. It is desirable to consume. Therefore, the record of “2018/2/15” is the priority order “1”, the record of “2018/2/16” is the priority order “2”, the record of “2018/2/25” is the priority order “3”, And the record of “2018/7/30” is shown as priority “4”.

That means
The remaining inventory “10” in priority order 1 is insufficient (<42).
“30” (<42), which is the addition of the remaining inventory “20” of priority 2, is also insufficient.
“40” (<42) added to the remaining inventory “10” of priority 3 is also insufficient,
Add "2" from the remaining inventory "100" in priority order 4,
The required quantity “42” is satisfied.

  On the other hand, since the record of the expiration date “2018/2/1” indicates the pre-prescription period “2018/2/3 to 2018/2/16”, the mark 64e indicating that no prescription is performed is indicated in order of priority.

  The user refers to the search result display area 64b of the search result display screen G64, inputs the amount actually prescribed to the patient into the usage amount, and presses the update button 64c. The stock expiration date management table 51 is updated by the update unit 49 of the display unit 48 in response to pressing of the update button 64c.

  FIG. 9 is a diagram illustrating a state example of the search result display screen immediately before the update. FIG. 9 shows an example of a state in which the user inputs the usage amount of the search result display area 64b on the search result display screen G64.

  In this example, in accordance with the priority order, the user inputs all of the remaining inventory “10” in the usage quantity of the record in the priority order “1”, and the remaining inventory “20” in the usage quantity of the record in the priority order “2”. All are entered, and all of the remaining inventory “10” is entered in the used quantity of the record of priority “3”. At this point, the quantity “2” is further insufficient. Therefore, the user inputs “2” as the used quantity of the record having the priority “4”. Thereafter, when the user presses the update button 64c, the search result display screen G64 is updated as shown in FIG.

  FIG. 10 is a diagram illustrating a state example of the search result display screen after the update. FIG. 10 shows an example of a state where the user presses the update button 64c after inputting the usage amount of the search result display area 64b on the search result display screen G64.

  In this example, the result updated by the update unit 49 is displayed. The priority order is determined again. The remaining inventory quantities in the priority order “1”, “2”, and “3” displayed in FIG. 9 are all prescribed and the records are deleted. The record may be physically deleted from the inventory expiration date management table 51, or may be logically deleted by setting a flag indicating deletion or the like.

  Then, the priority order of the record of the priority order “4” displayed in FIG. 9 is changed to “1”, and the remaining inventory indicates “98” obtained by subtracting the prescribed amount “2” from “100”. .

  The user may want to correct the drug information displayed on the search result display screen G64. In such a case, the drug information can be corrected by pressing the correction button. As an example, a case where the correction button 64f is pressed will be described.

  FIG. 11 is a diagram illustrating an example of the update screen. An update screen G69 illustrated in FIG. 11 is a screen that the update unit 49 displays on the display device 15 in response to the user pressing the correction button 64f on the search result display screen G64 illustrated in FIG. The update screen G69 has an input area 69a for inputting drug information and an update button 69b. Since the input area 69a is the same as the input area 60a of FIG. 4, a detailed description thereof is omitted.

  In this update screen G69, an example will be described in which the user changes the number of alarm days. If the current date is March 30, 2018, the drug is a drug that can be used for the next three months based on the expiration date. On the other hand, in the case of this standard unit “20 mg 1 tablet”, if it is prescribed only once every six months, it is possible that the expiration date has passed on the next prescription day (around the end of September). In such a case, by changing the number of alarms to 180 (days), it is possible to set a priority as a medicine that is not expired at the time of search but has a near expiration date.

  The user changes the number of alarm days from “14” to “180” and presses the update button 69b. When the update button 69b is pressed, the update unit 49 updates the inventory expiration date management table 51.

  As described above, the expiration date and remaining inventory are managed for each purchase by the inventory expiration management table 51, and the priority order is determined for each purchase based on the expiration date and the remaining inventory. Therefore, it is possible to sell from a medicine with an early expiration date, and by referring to the search result display screen G64, it is possible to explain that the patient takes a medicine with an earlier expiration date. In addition, by setting the number of alarm days, it is possible to present information on medicines that are desired to be consumed early based on the sales trend of medicines in pharmacies.

  The prescription drug search process by the prescription drug search unit 41 in the above-described embodiment will be described with reference to FIGS. 12 to 15 are flowcharts for explaining prescription drug search processing.

  In FIG. 12, when the prescription drug search unit 41 displays the search screen G62 on the display device 15 in response to a search screen display request from the user (step S71), the extraction unit 42 displays a search button on the search screen G62 by the user. Prescription drug search condition 3 is acquired by pressing 62b (step S72).

  Prescription drug search condition 3 includes information such as prescription date, quantity per day, number of administration days, search information, standard unit, and availability of generic drugs. Although the standard unit can be omitted, if other information is insufficient, the display device 15 displays that there is insufficient information in the prescription drug search condition 3, and the process returns to step S71.

  The extraction unit 42 searches the inventory expiration date management table 51 using the acquired prescription drug search condition 3 (step S73). The retrieved record is stored in the prescription drug table 53. The search is performed with a front / middle / backward match. If the search has failed (NO in step S73), the extraction unit 42 displays a warning message on the display device 15 and returns to the search screen G62 (step S78).

  On the other hand, if the search is successful (YES in step S73), the extraction unit 42 narrows down the records stored in the prescription drug table 53 to the designated dosage form when the dosage form is designated in standard units (step S73). S74). When the dosage form is not designated, the process of step S74 is omitted.

  The extraction unit 42 refers to the prescription drug table 53 and determines whether one or more records have been extracted (step S75). If there is no record (NO in step S75), the extraction unit 42 displays a warning message on the display device 15 and returns to the search screen G62 (step S78).

  On the other hand, when one or more records are extracted (YES in step S75), the extraction unit 42 excludes a record that is not allowed to be subsequently generated from the prescription drug table 53 (step S76). Specifically, the extraction unit 42 deletes the record in which the generic product indicates “0” from the records in the prescription drug table 53.

  Then, the extraction unit 42 determines whether one or more records remain in the prescription drug table 53 (step S77). If no record remains (NO in step S77), the extraction unit 42 displays a warning message on the display device 15 and returns to the search screen G62 (step S78).

  On the other hand, when one or more records remain (YES in step S77), the extraction unit 42 acquires the YJ code of each record in the prescription drug table 53 (step S79). A list of acquired YJ codes is stored in the storage unit 130.

  Then, the extraction unit 42 searches the inventory expiration date management table using each YJ code, and includes a difference in packaging (step S80). As an example of the processing of step S80, when a record of “pharmaceutical A 10 mg 100 tablets” exists in the prescription drug table 53 and the inventory expiration date management table 51 is searched with the YJ code of the record, “pharmaceutical A 10 mg 500 tablets” Search including records. Even if the same medicine A is used, that is, even if the JAN code is different, it is possible to search including the packaging difference by searching with the YJ code.

  The extraction unit 42 replaces the prescription drug table 53 with the records extracted by the search with all the YJ codes. In the prescription drug table 53, a record including a packaging difference of the same medicine is stored. However, if the search information selected by pull-down of the search screen G62 is a JAN code, steps S79 and S80 are omitted.

  The extraction process by the extraction unit 42 ends, and the category determination process by the category determination unit 44 is performed. The category determination unit 44 repeatedly performs step S81 to step 86 in FIG. 13 for each record in the prescription drug table 53 to determine the category of all records.

  From FIG. 13, the category determination unit 44 determines whether or not the expiration date of the record selected from the prescription drug table 53 is before the prescription date (that is, it has already expired) (step S81). If the expiration date is not before the prescription date (NO in step S81), the category determination unit 44 proceeds to step S83. When the expiration date is before the prescription date of the prescription drug search condition 3 (YES in step S81), the category determination unit 44 sets “X” indicating “cannot be prescribed” in the priority category of the record ( The process proceeds to step S82) and step S83.

  The category determination unit 44 determines whether or not the expiration date of the record is before the date obtained by adding the number of administration days on the prescription date (that is, the expiration date may be expired) (step S83). If the expiration date is not earlier than the date obtained by adding the number of administration days on the prescription date (NO in step S83), the category determination unit 44 proceeds to step S85. When the expiration date is earlier than the date obtained by adding the number of administration days on the prescription date (YES in step S83), the category determination unit 44 indicates “possibility of expiration on the day of administration” in the priority category of the record. “A” is set (step S84), and the process proceeds to step S85.

  The category determination unit 44 adds the administration days to the prescription date and the last day of the prescription period is before the expiration date of the record, and the expiration date is the addition of the administration days and the alarm days. It is determined whether or not it is before the obtained near term date (that is, the term is about to expire) (step S85). If the determination condition that the last day of the prescription period is before the expiration date and the expiration date is before the expiration date is not satisfied (NO in step S85), the category determination unit 44 performs the next operation from the prescription drug table 53. Record is selected and step S81 to step S86 are repeated.

  On the other hand, when the determination condition in step S85 is satisfied (YES in step S85), the category determination unit 44 sets “B” indicating “expiration date is almost expired” in the priority category of the record (step S86). ). In the case of NO in step S85, or after the processing in step S86, when the priority category has been determined for all records in the prescription drug table 53, the category determination process by the category determination unit 44 ends. Then, priority order determination processing by the priority order determination unit 46 is performed. The priority order determination process corresponds to the process from step S87 to step S89 in FIG.

  As shown in FIG. 14, the priority order determination unit 46 determines the priority order of records with the priority category “A” in the prescription drug table 53 in the order of closest expiration (step S87). Specifically, the priority order may be determined by rearranging the records with the priority category “A” in order from the earliest expiration date. At this time, for records having the same expiration date, the priority order may be determined in the order of registration based on the registration date.

  Next, the priority order determination unit 46 determines the priority order with respect to the record whose priority category in the prescription drug table 53 is “B” in the order of the closest expiration date from the priority category “A” (Step) S88). Specifically, the priority order may be determined by rearranging records with the priority category “B” in the order from the earliest expiration date. At this time, for records with the same expiration date, the priority order may be determined in the order of the longest alarm days, and when the alarm days are the same, the priority order may be determined in the order of registration based on the registration date.

  Then, the priority order determination unit 46 determines the priority order for the records for which the priority order has not been set, using the consecutive numbers of “priority category = B” in the order of near expiration (step S89). Specifically, the priority order may be determined by rearranging records in which the priority order is not set in ascending order of the expiration date. At this time, for records having the same expiration date, the priority order may be determined in the order of registration based on the registration date. When the priority order is set for all the records in the prescription drug table 53, the priority order determination process by the priority order determination unit 46 is terminated, and the display process by the display unit 48 is performed.

  In FIG. 15, the display unit 48 performs a process of totaling the remaining inventory from the record of the prescription drug table 53 in descending order of priority, and calculates the prescription amount obtained by multiplying the quantity per day by the number of administration days. The priority order when it exceeds is specified (step S90).

  The display unit 48 determines whether the prescription amount has been secured (step S91). That is, it is determined whether the priority order is specified. When the prescription amount cannot be secured (NO in step S91), the display unit 48 displays a shortage message on the display device 15 (step S92), ends the display process by the display unit 48, and prescription drugs. The prescription drug search process by the search unit 41 is also terminated.

  On the other hand, when the prescription amount can be secured (YES in step S91), the display unit 48 sets the priority order lower than the priority order specified in step S90 to be hidden (step S93). As an example of the non-display setting method, a priority order value lower than the specified priority order may be deleted.

  Next, the display unit 48 sets the priority order of the records indicating the priority category “X” in the prescription drug table 53 to black, and sets the priority order to the priority order when the prescription amount is exceeded, The priority order is set to a predetermined highlight color (step S94). Further, the display unit 48 sets a part or all of the records of the same YJ code to the same background color, and displays the search result display screen G64 on the display device 15 (step S95).

  After displaying the search result display screen G64, the display unit 48 determines whether or not pressing of the update button 64c is detected (step S96). When pressing of the update button 64c is not detected (NO in step S96), the display unit 48 proceeds to step S98. On the other hand, when the pressing of the update button 64c is detected (YES in step S96), the update unit 49 updates the remaining stock on the display unit 48 based on the usage amount set by the user, and is the same as steps S90 to S95. Processing is performed to redisplay the search result display screen G64 (step S97). The priority order is changed by updating the remaining inventory, and the prescription drug table 53 is updated.

  The display unit 48 determines whether or not pressing of the correction button is detected (step S98). When pressing of the correction button is not detected (NO in step S98), the display unit 48 proceeds to step S98. On the other hand, when pressing of the correction button is detected (YES in step S98), in the display unit 48, the update unit 49 displays the update screen G69 on the display device 15, and updates the prescription drug table 53 with the acquired update information 5. (Step S99). In the display device 15, for example, the update screen G69 is closed and the search result display screen G64 is displayed.

  And the display part 48 judges whether it is complete | finished (step S100). The end may be determined by the presence / absence of a user operation to end the search result display screen G64. If not completed (NO in step S100), the display unit 48 returns to step S96 and repeats the same processing as described above.

  On the other hand, in the case of termination (YES in step S100), in the display unit 48, the update unit 49 updates the corresponding record in the inventory expiration date management table 51 based on the prescription drug table 53 (step S101). The display process by is completed. The prescription drug search process by the prescription drug search unit 41 is also terminated.

  The flow of work in the pharmacy when the information processing apparatus 100 according to this embodiment described above is introduced will be described. FIG. 16 is a diagram for explaining an introduction example. In FIG. 16, when the medicine 1 is delivered to the pharmacy, a user such as a pharmacist uses the input device 14 and the reading device 16 to input the stored medicine information 2 to the information processing apparatus 100 for each packaging. The input pharmacy information 2 is registered in the inventory expiration management table 51. After the warehousing drug information 2 is registered, the drug 1 is stored in the shelf 9.

  When the prescription 6 is received from the patient, the user displays a search screen G62 and inputs the prescription drug search condition 3 to the information processing apparatus 100 from the search screen G62. The information processing apparatus 100 displays a search result display screen G64 obtained by processing the search result 4 searched under the prescription drug search condition 3 based on the current date “2018/03/01”. In accordance with the priority order shown on the search result display screen G64, the user takes out the prescribed amount of the prescription drug 7 from the shelf 9 and sells it to the patient.

  The prescription 6 includes information such as “abc tablets 10 mg 1 tablet 3 tablets a day 180 days”, and the prescription drug search condition 3 is input to the information processing apparatus 100 based on such information. From the current date “2018/03/01” and the prescription period “180 days”, the prescription period is “2018/03/01” to “2018/09/01”.

  In this example, it is assumed that the expiration date of the medicine 7a taken out from the shelf 9 is “2018/04/10” and the expiration date of the medicine 7b is “2019/10/31”. Although the medicine 7a and the medicine 7b are the same medicine, the medicine 7a exceeds the expiration date within the prescription period. Drugs with the same generic name are the same drug. In such a case, the user explains to the patient to take the medicine 7a of “2018/04/10” whose expiration date is early before the medicine 7b.

  On the other hand, the user inputs the usage amount of the search result display screen G64 for the prescription amount of the prescription drug 7, and presses the update button 64c. In response to pressing of the update button 64c, the information processing apparatus 100 receives the update information 5 including the usage amount and displays the search result display screen G64 in which the remaining inventory and the priority order are updated.

  As described above, according to the present embodiment, the medicine information is managed for each expiration date, and based on the expiration date of the prescribed medicine, the medicine to be taken first is included among the same kind of medicines. By presenting the information, it is possible to prevent the prescription person from taking the medicine beyond the expiration date.

  As an example, as shown in FIG. 16, even when the prescription medicine 7 is the same medicine, when different expiration dates are mixed, the order of taking medicine 7 a and medicine 7 b can be appropriately communicated to the patient in the order of the expiration date. . Therefore, when the patient takes the prescription medicine 7 correctly, the patient can prevent the medicine from exceeding the expiration date.

  The present embodiment can be applied to inventory management of various commodities with expiration dates such as the expiration date as described above. Medicine is an example of such a product.

  In this embodiment, the expiration date is an example of the expiration date, the extraction unit 42 is an example of an acquisition unit, and the priority order determination unit 46 and the display unit 48 are examples of an output unit.

  The present invention is not limited to the specifically disclosed embodiments, and can be principally modified and changed without departing from the scope of the claims.

The following additional notes are further disclosed with respect to the embodiment including the above examples.
(Appendix 1)
When you receive a prescription, you will get inventory information for the drug you are prescribing,
If the same type of medicine in the inventory information includes a first medicine that expires before the expiration of the prescription period and a second medicine that expires before the expiration of the prescription period, A prescription support program for medicine that causes a computer to output that the medicine to be taken is included in the medicine to be prescribed.
(Appendix 2)
When there is a first medicine that may reach the expiration date within the prescription period with reference to the inventory information for each expiration date of the same type of medicine to be prescribed, the first medicine The medicine prescription support program according to supplementary note 1, which causes the computer to perform a process of giving a priority to the display device and displaying a list of medicines of the same type on a display device.
(Appendix 3)
When there is a second medicine whose expiration date is within a predetermined period after the prescription period, a process of giving the priority to the second medicine and displaying a list of the same kind of medicine on a display device The medicine prescription support program according to appendix 2, which causes the computer to execute
(Appendix 4)
The priority is given to the first medicine and the second medicine in the list, and the priority indicates that the earlier the expiration date, the higher the priority. Prescription support program for listed medicines.
(Appendix 5)
When an input of a usage amount is received for the medicine (2) for each expiration date of the list (64b) displayed on the display device (15), the medicine (2) for which the usage amount has been inputted is received. The medicine prescription support program according to appendix 4, characterized by causing the computer to perform a process of displaying the list (64b) in which the inventory quantity is subtracted and the priority is changed on the display device (15).
(Appendix 6)
When you receive a prescription, you will get inventory information for the prescription target drug,
If the same type of drug in the inventory information includes a first drug that expires before the expiration of the prescription period and a second drug that does not expire before the expiration of the prescription period, A prescription support method for a medicine that causes a computer to output that the medicine to be taken is included in the medicine to be prescribed.
(Appendix 7)
When receiving a prescription, an acquisition unit that acquires inventory information of a medicine to be prescribed,
If the same type of drug in the inventory information includes a first drug that expires before the expiration of the prescription period and a second drug that does not expire before the expiration of the prescription period, And an output unit that outputs that the medicine to be taken is included in the medicine to be prescribed.

2 Information on medicines received 3 Prescription drug search conditions 4 Search result 5 Update information 6 Prescription 7 Prescription drug 11 CPU
12 Main storage device 13 Auxiliary storage device 14 Input device 15 Display device 16 Reading device 17 Communication I / F
DESCRIPTION OF SYMBOLS 18 Drive apparatus 19 Storage medium 40 Registration part 41 Prescription drug search part 42 Extraction part 44 Category determination part 46 Priority order determination part 48 Display part 49 Update part 51 Inventory deadline management table 53 Prescription drug table 100 Information processing apparatus

Claims (6)

When you receive a prescription, you will get inventory information for the drug you are prescribing,
If the same type of medicine in the inventory information includes a first medicine that expires before the expiration of the prescription period and a second medicine that expires before the expiration of the prescription period, A prescription support program for medicine that causes a computer to output that the medicine to be taken is included in the medicine to be prescribed. When there is a first medicine that may reach the expiration date within the prescription period with reference to the inventory information for each expiration date of the same type of medicine to be prescribed, the first medicine The medicine prescription support program according to claim 1, wherein the computer is caused to perform a process of giving a priority to the display device and displaying a list of medicines of the same type on a display device. When there is a second medicine whose expiration date is within a predetermined period after the prescription period, a process of giving the priority to the second medicine and displaying a list of the same kind of medicine on a display device The medicine prescription support program according to claim 2, which causes the computer to perform the following.   The said priority is given with respect to the said 1st medicine and the said 2nd medicine in the said list | wrist, This priority shows that a priority is so high that the said expiration date is early. 3. A prescription support program for the medicine described in 3. When you receive a prescription, you will get inventory information for the drug you are prescribing,
If the same type of medicine in the inventory information includes a first medicine that expires before the expiration of the prescription period and a second medicine that expires before the expiration of the prescription period, A prescription support method for a medicine that causes a computer to output that the medicine to be taken is included in the medicine to be prescribed.
When receiving a prescription, an acquisition unit that acquires inventory information of a medicine to be prescribed,
If the same type of medicine in the inventory information includes a first medicine that expires before the expiration of the prescription period and a second medicine that expires before the expiration of the prescription period, And an output unit that outputs that the medicine to be taken is included in the medicine to be prescribed.

Images