JP2016224555A - Receipt analysis system, receipt analysis method, and computer program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To lighten the load of a medical institution etc., by enable receipt analysis making good use of increase/decrease point memorandum data in CSV form.SOLUTION: A receipt analysis system 10 comprises: increase/decrease point memorandum data acquisition means 110; receipt unit data acquisition part 130 of acquiring receipt identification information from data; first character string setting means of setting a character string, extracted from "demand contents" of data and "contents after correction/evaluation" column as an object character string to be retrieved; second character string setting means of setting a character string including a character string having an item name extracted from the object character string to be retrieved and a character string related to an amount as an object character string to be retrieved; amount-related information acquisition means of acquiring amount-related information by extracting the character string associated with the amount from the object character string to be retrieved, and setting the character string having the amount-related character string removed as an object character string to be retrieved; item name information acquisition means of acquiring an item name from the object character string to be retrieved; and information storage means 160 of storing the receipt identification information, item name, and amount-related information so as to be associated with each other in a storage device 190.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a receipt analysis system, a receipt analysis method, and a computer program.

  Medical institutions such as hospitals and clinics and dispensing pharmacies create a receipt and submit it to an examination payment organization such as the Social Insurance Medical Fee Payment Fund or the National Health Insurance Association Federation in order to request medical fees (for insurance). doing. The examination and payment institution examines the submitted receipt, and if there is no deficiency in the contents of the receipt, it pays a medical fee to a medical institution or the like. On the other hand, if the contents of the receipt are incomplete, the examination / payment institution performs processing such as return or assessment according to the contents of the incompleteness, and sends a return breakdown or an increase / decrease report to the medical institution. Notify the reason and the amount after the review.

  In the case of a return, if a medical institution submits a receipt with the deficiencies corrected to the examination and payment institution and requests a reexamination, the examination and payment institution will reexamine and if there is no deficiency, the medical fee will be paid. Although it is possible to receive a full payment in the case of an assessment, the medical institution etc. will not be able to recover the cost despite actually performing medical treatment or medication, It becomes a management problem.

  In Patent Document 1, based on a provisional receipt that has not yet been submitted to the examination and payment institution, a process for predicting medical fees, analyzing improvement measures for reducing medical fees that may not be paid, etc. Also, based on the provisional receipt and this receipt submitted to the examination and payment institution, by comparing these, etc., the actual situation of the improvement situation against the provisional receipt deficiency is visualized and the effect is analyzed as a monetary amount A receipt analyzer is disclosed.

JP 2013-168037 A

  By the way, in medical institutions, etc., check the receipt and the increase / decrease point correspondence sheet for the purpose of informing doctors etc. of the inadequate medical practice and medication and reflecting them in future medical practice and medication. Scrutinize the contents of the assessment. However, since the work of matching the receipt with the increase / decrease point report is performed manually, there is a problem that the burden on the medical institution or the like is very large. In addition, the contents of the increase / decrease point report are provided by the examination and payment institution as CSV (Comma Separated Value) format data, but it is very difficult to extract necessary data from such increase / decrease point report data. Therefore, the increase / decrease point report data is not currently used.

  The present invention has been made in view of the above-described background, and allows a receipt analysis using the increase / decrease point report data and can reduce the burden on medical institutions, etc., a receipt analysis system, a receipt analysis method, and a computer The purpose is to provide a program.

  In order to achieve the above-mentioned object, a receipt analysis system according to the present invention includes an increase / decrease point report data acquisition means for acquiring CSV format increase / decrease point report data, and a receptor for identifying a receipt from the increase / decrease point report data. A receipt identification information obtaining unit for obtaining receipt identification information, a first character string that is extracted in a “billing content” column of the increase / decrease point correspondence data, and the extracted character string is set as a search target character string. A character string that represents an item name related to medical practice and a character string that represents information related to the amount of money from the search target character string set by the charge time character string setting means and the first charge time character string setting means A second character string setting unit that extracts a character string including a money amount related character string and sets the extracted character string as a search target character string; and a search pair set by the second character string setting unit. Extract the billing amount related character string from the character string, obtain the billing amount related information, which is information related to the amount, and use the character string from which the billing amount related character string is removed as the search target character string. Billing time amount related information acquisition means to be set, and billing time item name information acquisition means for acquiring the charging time item name information which is information of the item name from the search target character string set by the charging time amount related information acquisition means And a first post-assessment character string setting unit that extracts a character string stored in the “contents after correction / assessment” column of the increase / decrease point report data, and sets the extracted character string as a search target character string; From the search target character string set by the first post-assessment character string setting means, a character string including the character string representing the item name and the post-assessment amount related character string that is a character string representing information related to the amount of money Extracted and extracted A second post-assessment character string setting unit that sets a character string as a search target character string, and the post-assessment amount-related character string is extracted from the search target character string set by the second post-assessment character string setting unit. And a post-assessment amount related information acquisition means for setting a character string obtained by removing the post-assessment amount related character string as a search target character string, and a post-assessment amount related information From the search target character string set by the information acquisition means, the post-assessment item name information acquisition means for acquiring the post-assessment item name information that is the information of the item name, the receipt identification information, the item name information at the time of claim, And an information storage unit that associates the billing amount related information, the post-assessment item name information, and the post-assessment amount related information with each other and stores them in a storage device.

  According to such a system, it is possible to acquire item name information related to medical practice and information related to the amount of money from the increase / decrease point report data and store it in a storage device such as a computer. The information obtained in this way can be analyzed using a computer, etc., for example, by receiving the contents of the receipt and the contents of the point increase / decrease report side by side, or by summarizing them as a table or a graph, using the data of the point increase / decrease point report. Is possible. In addition, since the manual operation of matching the receipt with the increase / decrease point report is not required, the burden on the medical institution or the like can be greatly reduced.

  In the system described above, the billing amount related information acquisition unit and the post-assessment amount related information acquisition unit each include a continuous group of character strings including “yen /” in the search target character string. Extracts a continuous group of characters including "Yen /", converts the character string before "Yen /" into a numerical value and obtains it as unit price information, and also includes a continuous group of characters including "Yen /" Unit price information acquisition means for setting a character string from which the character string is removed as a search target character string, and a continuous group of character strings composed of [numbers] “×” [numbers] at the end of the search target character string If it is included, extract a group of consecutive strings consisting of [numbers] “x” [numbers], convert the string before “x” into a numerical value, and obtain it as point information. And the character string after “x” is converted into a numerical value and the count information Point / number information acquisition means for setting a character string obtained by removing a group of consecutive character strings composed of [numbers] “×” [numbers] as a search target character string, and the search target character string If a group of consecutive characters composed of [numbers] and [unit characters] is included at the end of, extract a group of consecutive characters composed of [numbers] and [unit characters] The character string that constitutes [Number] is converted into a numerical value and obtained as quantity information, and the character string that constitutes [Unit Character] is obtained as unit name information, and is composed of [Number] and [Unit Character]. And a quantity / unit name information acquisition unit that sets a character string obtained by removing a group of consecutive character strings as a search target character string.

  In the above-described system, at least the second post-assessment character string setting unit includes “check” when the search target character string includes a continuous group of character strings including “check”. It can be set as the structure which has the 1st character string removal means which removes a group of continuous character strings.

  In the above-described system, the second billing character string setting unit and the second post-assessment character string setting unit each include a case where a character string starting with “(calculation date)” is included in the search target character string. Can be configured to have a second character string removing means for removing a character string starting with “(calculation date)”.

  In the above-described system, the claim item name information acquisition unit and the post-assessment item name information acquisition unit use the search target character string as a search character string, respectively, from a master in which information on a plurality of the item names is stored. When there is an item name that matches and is found, the item name can be acquired as the item name information at the time of billing or the item name information after the assessment.

  In the system described above, when the claim item name information acquisition unit and the post-assessment item name information acquisition unit respectively search from the master using the search target character string as a search character string, and there is no matching item name The search character string is divided into a group of consecutive character strings, the character string from which the first character string is removed is set as the search character string, and the search character string is searched from the master and matched. If there is an item name to be acquired, the item name is acquired as the request item name information or the post-assessment item name information, and a character string other than the search character string in the search target character string is obtained as product name standard size information. It can be set as the structure acquired as.

  In the system described above, when the information in the “record type” column of the increase / decrease point report data is 1, the receipt identification information acquisition unit includes information in the “medical department code” column of the header of the increase / decrease point report data. Can be obtained as at least one of the receipt identification information.

  In the above-described system, when the receipt identification information acquisition unit can acquire information from the “medical record number etc.” column of the increase / decrease point report data, the information of the column is acquired as at least one of the receipt identification information. It can be set as the structure to do.

  In the above-described system, the information storage unit is configured such that the information in the “record type” column of the increase / decrease point report data is 5 and the information in the “record type” column of the immediately preceding row is not 5. The receipt identification information, the billing item name information, the billing amount related information, the post-assessment item name information, and the post-assessment amount related information can be stored in the storage device.

  In order to achieve the above-described object, the method of analyzing a receipt according to the present invention includes a step in which a computer includes an increase / decrease point report data acquisition step of acquiring CSV format increase / decrease point report data, and the increase / decrease point report data. From this, a receipt identification information acquisition step for acquiring a receipt identification information for identifying a receipt, and a character string stored in the “Billing Content” column of the increase / decrease point report data are extracted, and the extracted character string is searched. A character string representing an item name related to medical practice from the first character string setting step set in the target character string, the search target character string set in the first character string setting step, and information related to the amount of money A character string including a charge amount related character string representing a charge amount is extracted, and the extracted character string is set as a search target character string. And extracting the charge amount related character string from the search target character string set in the second charge time character string setting step to obtain the charge amount related information which is information related to the amount of money. The charge amount related information acquisition step for setting the character string from which the time amount related character string is removed as the search target character string, and the item name information from the search target character string set in the charge amount related information acquisition step. Item name information acquisition step at the time of acquiring a certain item name information at the time of request, and a character string stored in the “contents after correction / assessment” column of the increase / decrease point report data is extracted and the extracted character string is searched From the first post-assessment character string setting step to be set in the target character string and the search target character string set in the first post-assessment character string setting step, the character string representing the item name and the information related to the amount of money A second character string setting step of extracting a character string including a post-assessment amount-related character string that is a character string representing the character string, and setting the extracted character string as a search target character string; and the second post-assessment character The post-assessment amount related character string is extracted from the search target character string set in the column setting step to obtain post-assessment amount related information, which is information related to the amount, and the post-assessment amount related character string is removed. Obtain post-assessment item name information, which is information of the item name, from the post-assessment amount related information acquisition step for setting a character string as a search target character string and the search target character string set in the post-assessment amount related information acquisition step A post-assessment item name information acquisition step, the receipt identification information, the billing item name information, the billing amount related information, the post-assessment item name information, and the post-assessment amount related information. And an information storage step for storing the information in a storage device in a linked manner.

  According to such a method, it is possible to acquire item name information related to medical practice or information related to the amount of money from the increase / decrease point report data and store it in the storage device of the computer. Information obtained in this way can be output using a computer, for example, by arranging the contents of a receipt and the contents of an increase / decrease point report side by side, or as a table or graph. It becomes possible. In addition, since the manual operation of matching the receipt with the increase / decrease point report is not required, the burden on the medical institution or the like can be greatly reduced.

  In order to achieve the above-described object, the computer program of the present invention causes a computer to receive a receipt from the increase / decrease point report data acquisition means for acquiring the increase / decrease point report data in CSV format and the increase / decrease point report data. Receipt identification information acquisition means for acquiring receipt identification information for identification, and a character string stored in the “Billing contents” column of the increase / decrease point report data is extracted, and the extracted character string is used as a search target character string. A first character string setting means for setting, a character string representing an item name related to medical practice, and a character string representing information related to the amount of money, from the character string to be searched set by the first character string setting means. A second charge time character string setting means for extracting a character string including the charge time related character string and setting the extracted character string as a search target character string; and the second charge time character string Characters obtained by extracting the billing amount related character string from the search target character string set by the determination means, obtaining billing amount related information that is information related to the amount, and removing the billing amount related character string Charge-time item related information acquisition means for setting a column as a search target character string, and charge-time item name information that is information on the item name is acquired from the search target character string set by the charge-time amount related information acquisition unit Item name information acquisition means at the time of request, and first assessment that extracts the character string stored in the “contents after correction / assessment” column of the increase / decrease point report data and sets the extracted character string as a search target character string A post-assessment amount related character which is a character string representing the item name and information related to the amount of money, from the search target character string set by the post character string setting unit and the post-assessment character string setting unit Statements containing columns A second post-assessment character string setting unit that extracts a column and sets the extracted character string as a search target character string, and the post-assessment amount from the search target character string set by the second post-assessment character string setting unit Acquire post-assessment amount related information that extracts the related character string, obtains post-assessment amount related information that is information related to the amount, and sets the character string from which the post-assessment amount related character string is removed as the search target character string A post-assessment item name information obtaining unit that obtains post-assessment item name information that is information of the item name, from the search target character string set by the post-assessment amount related information obtaining unit, the receipt identification information, The charge item name information, the charge amount related information, the post-assessment item name information, and the post-assessment amount related information are associated with each other and stored in a storage device. The

  According to such a program, it is possible to acquire item name information related to medical practice and information related to the amount of money from the increase / decrease point report data and store it in the storage device of the computer. Information obtained in this way can be output using a computer, for example, by arranging the contents of a receipt and the contents of an increase / decrease point report side by side, or as a table or graph. It becomes possible. In addition, since the manual operation of matching the receipt with the increase / decrease point report is not required, the burden on the medical institution or the like can be greatly reduced.

  According to the present invention, a receipt analysis using the increase / decrease point report data is possible, and the burden on a medical institution or the like can be reduced.

It is a block diagram of a receipt analysis system. It is a figure explaining a receipt unit table. It is a figure explaining a location unit table. It is a figure explaining an item unit table. It is a figure which shows an example of the increase / decrease point communication data. It is a figure explaining the file name of increase / decrease point report data. It is a figure explaining the file structure of the increase / decrease point report data, (a) shows a header, (b) shows the detail part of a data record. It is a block diagram of an item unit data acquisition means. It is a figure explaining an item name master, (a) shows a medicine master, (b) shows a medical practice master, and (c) shows a specific equipment master. It is a figure which shows an example of a selection screen. It is a figure which shows an example of the form which put out the content of the receipt, and the content of the increase / decrease point report in order. It is a flowchart explaining operation | movement of a receipt analysis system. It is a flowchart explaining operation | movement of a receipt analysis system. It is a flowchart explaining operation | movement of a receipt analysis system. It is a flowchart explaining the operation | movement of item unit data acquisition. It is a flowchart explaining the operation | movement of item unit data acquisition. It is a flowchart explaining the operation | movement of item name information acquisition. It is a flowchart explaining the operation | movement of item name information acquisition.

  Next, an embodiment of the present invention will be described. As shown in FIG. 1, a receipt analysis system 10 mainly includes a billing / assessment information management device 100, a receipt management device 200 that issues and manages a receipt, and a receipt analysis device 300 that analyzes a receipt. Has been. The billing / assessment information management apparatus 100, the receipt management apparatus 200, and the receipt analysis apparatus 300 are connected to each other so that data communication is possible. The billing / assessment information management device 100, the receipt management device 200, and the receipt analysis device 300 are each composed of a computer having a CPU (Central Processing Unit), a RAM (Random Access Memory), a ROM (Read Only Memory), a storage device, and the like. Each means is realized by reading a computer program stored in a ROM or a storage device in advance into the RAM and executing it.

  The receipt management apparatus 200 is a known apparatus that issues a receipt, accumulates receipt data, and the like. The receipt management device 200 includes a storage device 290. The storage device 290 identifies receipt data, for example, medical record number information, information for identifying a patient such as a patient code and a patient's name, information for identifying a doctor such as a doctor code, and a clinical department such as a medical department code Information on the ward code, information on the contents of the medical practice performed by the doctor, information on the amount of medical treatment remuneration for the medical practice performed, and the like are stored.

The billing / assessment information management device 100 extracts and acquires information from the CSV format increase / decrease point report data provided by the examination and payment institution, and stores the acquired information in a table stored in the storage device 190. Then, the data is stored in the storage device 190. The table includes a receipt unit table, a location unit table, and an item unit table.
As shown in FIG. 2, the receipt unit table is a table in which receipt identification information for identifying a receipt is stored. Specifically, in the receipt unit table, for example, “medical chart number”, “medical department code”, and the like are stored as receipt identification information.

  As shown in FIG. 3, the location unit table shows the contents when a medical fee is requested for a group of medical activities that are the basis for calculating the medical fee in one reception, and after the assessment by the examination paying institution. This is a table for storing information of contents when the contents are different. Specifically, in the location unit table, for example, “reason code” indicating the reason for the assessment (reason for increase / decrease), “number of times of claim”, “number of times of claim”, “number of points after assessment”, “number of times after assessment” Etc. are stored. When there are a plurality of assessment locations in one receipt, a plurality of records in the location unit table are created for each assessment location for one receipt (one record in the receipt unit table).

  As shown in FIG. 4, the item unit table is a table in which information on the contents of the assessment part, the contents when the medical fee is requested and the contents after the assessment by the examination paying institution is stored. This item unit table includes, for example, item names related to medical practices (hereinafter simply referred to as “item names”) such as drug names and medical practice names at the time of billing and after assessment, unit prices at the time of billing and after assessment, Information such as unit name, quantity, number of points, number of times is stored. When a plurality of item names are included in one assessment location, a plurality of item unit table records are created for each item name for one assessment location (one record in the location unit table).

  Returning to FIG. 1, the billing / assessment information management apparatus 100 acquires information from the increase / decrease point report data and stores it in each table. Therefore, the increase / decrease point report data acquisition unit 110, the record type information acquisition unit 120, As an example of a receipt identification information acquisition unit, a receipt unit data acquisition unit 130, a location unit data generation unit 140, an item unit data acquisition unit 150, and an information storage unit 160 are mainly provided.

  The increase / decrease point report data acquisition unit 110 is a unit that acquires CSV format increase / decrease point report data. The increase / decrease point report data acquisition unit 110 may be configured to acquire the increase / decrease point report data through a network such as the Internet, or read the increase / decrease point report data stored in a storage medium such as a CD or a DVD. The structure which acquires may be sufficient. Further, the configuration may be such that the increase / decrease point report data stored in advance in the storage device 190 is read from the storage device 190 and acquired.

  FIG. 5 shows an example of CSV format increase / decrease point report data. The file name, file structure, etc. of the increase / decrease point report data are determined in advance by the examination / payment institution (for example, “online billing system operation procedure manual” attached printable form / CSV creation target file <medical institution (medical / DPC)> February 2015 edition, p.15-17,51-56, [online], May 7, 2014, Social Insurance Medical Fee Payment Fund / Prefectural National Health Insurance Organization Federation, Search on May 14, 2015], Internet <URL: http://www.ssk.or.jp/rezept/iryokikan/download/files/claimsys28_11.pdf>).

  As shown in FIG. 6, the increase / decrease point report data has a file name of “RIzognabbcdddddddGYYMM.csv” or “RDzognabbcdddddddGYYMM.csv”. “RI” means a medical subsystem ID, and “RD” means a DPC (Diagnosis Procedure Combination) subsystem ID. “A” means an examination payment organization code, which is 1 for the social insurance medical fee payment fund and 2 for the National Health Insurance Association. “Bb” means a prefecture number from 01 to 47, and “ddddddd” means a 7-digit medical institution code. “G” means the era (4 in the case of Heisei), and “YYMM” means the processing date. For example, if “GYYMM” = “42606”, it means June 2014.

  As shown in FIG. 5 and FIG. 7, the increase / decrease point report data includes the header of “record type” at the beginning of each row (row), the title part of the data record with “record type” of 2, and “ And a data record detail section whose record type is any one of 3 to 6. The header of record type 1 has columns from item number 1 to item number 9, for example, item number 7 is a “clinical department code” column in which a clinical department code is stored. The detail sections of the record types 3 to 6 have columns from item number 1 to item number 30, for example, item number 19 is a “medical record number etc.” column in which a medical record number or the like is stored. Item No. 26 is a “Billing Content” column in which a character string including an item name when the medical institution requests a medical fee is stored. Item No. 28 is an item after the assessment by the examination paying institution. It is a “Content after correction / assessment” column that stores a character string including the item name. The title part of record type 2 has columns from item number 1 to item number 30 as in the detail part, and each column after item number 2 has item number 2 to item number 30 in FIG. The item names corresponding to the previous item names are sequentially stored as character strings.

  Returning to FIG. 1, the record type information acquisition unit 120 is a unit that acquires “record type” from the increase / decrease point report data. Here, each of the record type information acquisition unit 120, the receipt unit data acquisition unit 130, the location unit data generation unit 140, the item unit data acquisition unit 150, the information storage unit 160, and the like can access the storage device 190 and store it. Data can be exchanged via the device 190. The receipt unit data acquisition unit 130, the location unit data generation unit 140, the item unit data acquisition unit 150, and the information storage unit 160 execute processing based on the “record type” acquired by the record type information acquisition unit 120. The record type information acquisition unit 120 ends the processing of the current row when the processing in the receipt unit data acquisition unit 130, the location unit data generation unit 140, the item unit data acquisition unit 150, and the information storage unit 160 is completed. Then, the “record type” of the next row is acquired. That is, the billing / assessment information management apparatus 100 is configured to read the rows of the increase / decrease point report data in order from the top and sequentially process the rows one by one.

The record type information acquisition unit 120 performs the following conditions (1) in addition to the case where normal processing in the receipt unit data acquisition unit 130, the location unit data generation unit 140, the item unit data acquisition unit 150, and the information storage unit 160 is completed. ) To (4), the current row processing is terminated and the “row type” of the next row is acquired.
(1) The “record type” of the increase / decrease point report data is 2.
(2) The first billing character string setting unit 151, which will be described later, cannot extract the character string from the “billed content”, and the first post-assessment character string setting unit 152 determines the character string from the “corrected / assessed content”. Cannot be extracted (when both “request contents” and “contents after amendment / assessment” are blank).
(3) When information cannot be acquired from “location 1” (item number 20) in the detail portion of the data record (when “location 1” is blank).
(4) When the first billing character string setting means 151 has a character string extracted from “contents of billing” at the head of “subject to public benefit payment” or “paid amount (first) character string”.

  The receipt unit data acquisition means 130 is means for obtaining receipt identification information, that is, receipt unit data that is information stored in the receipt unit table, from the increase / decrease point report data. Specifically, when the information in the “record type” column of the increase / decrease point report data is 1, the receipt unit data acquisition unit 130 acquires the information in the “clinical department code” column of the header of the increase / decrease point report data. . In addition, the receipt unit data acquisition unit 130 includes the information of the column when information can be acquired from the “chart number etc.” in the detail part of the increase / decrease point report data (when the “chart number etc.” is not blank). Get information to be stored in the receipt unit table. More specifically, the receipt unit data acquisition means 130 determines the “prefecture”, “medical institution code”, “billing date”, “examination / payment institution” shown in FIG. And “file type” is acquired, and “exclusion / exclusion classification”, “medical chart number, etc.”, information specifying the clinical department, “name” of the patient, insurer number, etc. are acquired from the detail part of the data record.

  2 to 4, the left column indicates the names of the fields of each table, and the right column mainly indicates the acquisition source of the information of each field. Here, the “billing date” is obtained by converting the year / month (GYYMM) expressed in the era to the year / month (yyyyMM) expressed in the Western calendar. The “file type” is acquired as 1 when the first two characters of the file name are “RI” and as 2 when “RD”. Further, “in / out category” is acquired as 1 when the character string stored in the “category” column of the detail section includes “on” and as 2 when “out” is included. The “doctor code”, “ward code”, and “patient code” are acquired by searching the data stored in the storage device 290 of the receipt management device 200 from information such as the acquired medical record number.

  The receipt unit data acquisition unit 130 generates “registration key” and “receipt serial number” as information for associating the receipt unit table, the location unit table, and the item unit table when acquiring the receipt unit data. “Registration key” is a key unique to one point increase / decrease report data (one file), “prefecture” (bb), “medical institution code” (ddddddd), “billing date” (yyyyMM), A 17-digit code “bbdddddddyyyyMMa1” or “bbdddddddyyyyMMa2” is generated from “examination / payment institution” (a) and “file type” (1 or 2). The “receipt serial number” is a unique serial number set for each record (one receipt) in the receipt unit table within the same registration key.

  The item unit data acquisition unit 150 is a unit that acquires item unit data that is information stored in the item unit table. As shown in FIG. 8, the item unit data obtaining unit 150 includes a first billing character string setting unit 151, a first post-assessment character string setting unit 152, a second billing character string setting unit 153, and a second billing character string setting unit 153. The post-assessment character string setting unit 154, the billing amount related information acquisition unit 155, the post-assessment amount related information acquisition unit 156, the billing item name information acquisition unit 157, and the post-assessment item name information acquisition unit 158 are mainly provided. Prepare for.

  The first billing character string setting means 151 stores, for example, “flumazenil intravenous solution 0.2 mg“ chemifa ”_2 mL_1 tube shown in FIG. 5 stored in the“ Billing Details ”column of the detail part of the increase / decrease point report data. ”Or“ Silase IV 2 mg_1 tube_117 × 1 ”,“ Urine sediment (microscopy) _27 × 3 ”(_ means a space, and so on) This is a means for setting the extracted character string as the search target character string, and the first post-assessment character string setting means 152 is the “post-correction / assessment content” column (“invoice content” in the detail part of the increase / decrease point report data. ”Column 2), for example, extract a character string such as“ Silace IV 2 mg_1 tube_35 × 1 ”or“ Urine sediment (microscopy) _27 × 2 ”. Set the extracted character string as the search target character string It is means to do. The first billing character string setting unit 151 and the first post-assessment character string setting unit 152 may be a single functional unit. If the character string cannot be extracted (if the column is blank), the first billing character string setting unit 151 and the first post-assessment character string setting unit 152 send information to that effect to the record type information acquisition unit 120. Output. In addition, the first billing character string setting means 151, when there is a character string extracted from “contents of billing” at the beginning of “Character Benefit Benefit Target” or “paid amount (first) character string”, information to that effect Is output to the record type information acquisition means 120.

  The second billing character string setting unit 153 is a character string representing a character string representing an item name and information related to the amount of money, from the search target character string set by the first billing character string setting unit 151. This is means for extracting a character string including a money amount related character string and setting the extracted character string as a search target character string. Further, the second post-assessment character string setting unit 154 is a character string representing an item name and information related to the amount of money from the search target character string set by the first post-assessment character string setting unit 152. This is a means for extracting a character string including a post-assessment amount related character string and setting the extracted character string as a search target character string. The second billing character string setting unit 153 and the second post-assessment character string setting unit 154 may be a single functional unit.

  More specifically, the second billing character string setting unit 153 and the second post-assessment character string setting unit 154 each represent a character string representing the item name and information related to the amount of money by removing the specific character string. Extracts a character string including a character string. Therefore, the second billing character string setting unit 153 and the second post-assessment character string setting unit 154 include a first character string removing unit 161 and a second character string removing unit 162, respectively.

  The first character string removing unit 161 includes a group of consecutive character strings including “inspection” such as “inspection inspection”, “overall inspection”, “match inspection”, etc. at the beginning of the search target character string. Is included, a continuous group of character strings including “check” is removed. Thus, for example, when the character string extracted from “contents after correction / assessment” is “overview check_Pariet lock 10 mg_1 lock_14 × 56”, the second after-assessment character string setting means 154 performs “overview check”. “Pariet lock 10 mg — 1 tablet — 14 × 56” is set in the search target character string. The second billing character string setting unit 153 and the second post-assessment character string setting unit 154 include information about a group of consecutive character strings including “check” at the beginning of the search target character string. ("Inspection at request" or "Inspection after appraisal" in Fig. 4), for example, "Inspection inspection" is set to 1, "General inspection" is set to 2, and "Inspection inspection" Get the case as 3.

  Here, the “continuous group of character strings” refers to a series of character strings that do not include spaces. For example, the extracted character string is the above-mentioned “Overview check_Pariet lock 10 mg_1 tablet_14 × 56”. If there is, “inspection check”, “Pariet tablet 10 mg”, “1 tablet” and “14 × 56” correspond to a group of consecutive character strings. In the present invention, the character string includes the case of one character.

  When the search target character string includes a character string starting with “(calculation date”), the second character string removing unit 162 removes the character string starting with “(calculation date). If the character string extracted from “After correction / assessment” is “visiting psychotherapy (less than 30 minutes) — 330 × 2 — (calculation date) — 1 day: 1 time — 15 days: 1 time” The setting unit 154 sets “visit psychotherapy (less than 30 minutes) — 330 × 2”, which is obtained by removing the character string after “(calculation date)”, as the search target character string.

  The billing amount related information acquisition unit 155 extracts a billing amount related character string from the search target character string set by the second billing time character string setting unit 153, and the billing amount related information is information related to the amount. And a character string from which a charge-related money-related character string is removed is set as a search target character string. Also, the post-assessment amount related information acquisition unit 156 extracts the post-assessment amount related character string from the search target character string set by the second post-assessment character string setting unit 154, and the post-assessment amount related information is the amount related information. It is a means for acquiring the related information and setting the character string from which the post-assessment amount related character string is removed as the search target character string. The billing amount related information acquisition unit 155 and the post-assessment amount related information acquisition unit 156 may be a single functional unit. The billing amount related information acquisition unit 155 and the post-assessment amount related information acquisition unit 156 each include a unit price information acquisition unit 171, a score / count information acquisition unit 172, and a quantity / unit name information acquisition unit 173.

  When the search target character string includes a continuous group of character strings including “Yen /” such as “175 Yen / book”, the unit price information obtaining unit 171 determines that “Yen / A continuous group of character strings including "" is extracted, and the character string before "Yen /" is converted into a numerical value to obtain unit price information ("unit price at billing" or "unit price after assessment" in FIG. 4). Then, the unit price information acquisition unit 171 sets a character string obtained by removing a continuous group of character strings including “yen /” as a search target character string. Thus, for example, the search target character string is “stomach / duodenal catheter Margensonde E-7 (2.5-4.5) _nutrition catheter (for nasal / general) _175 yen / book_1_18 × 5” In this case, the unit price information acquisition means 171 converts “175” before “yen /” into a numerical value and acquires it as unit price information, and removes “175 yen / line”, “stomach / duodenal catheter” Margensonde E-7 (2.5-4.5) _nutrition catheter (for nasal / general) _one_18 × 5 ”is set as a new search target character string.

  The score / count information acquisition unit 172 includes a continuous group of character strings composed of [numbers] “×” [numbers] such as “18 × 5” at the end of the search target character string. In the case where the character string is “number” “×” [number], a continuous group of character strings is extracted, the character string before “×” is converted into a numerical value, and score information (FIG. 4) is obtained. "Number of points at the time of request" or "number of points after assessment"), and the character string after "x" is converted into a numerical value and obtained as count information ("number of times at the time of billing" or "number of times after assessment") . The score / count information acquisition unit 172 sets a character string obtained by removing a continuous group of character strings composed of [numbers] “×” [numbers] as a search target character string. Thus, for example, when the search target character string is “stomach / duodenal catheter Margensonde E-7 (2.5-4.5) _nutrition catheter (for nasal / general) _1_18 × 5” The score / count information acquisition means 172 converts “18” before “×” into a numerical value and acquires it as point information, and also converts “5” after “×” into a numerical value as the number information. Get as. And the score / count information acquisition means 172 removes “18 × 5”, “stomach / duodenal catheter Margensonde E-7 (2.5-4.5) _nutrition catheter (nasal / general) _1 "is set as a new search target character string.

  The quantity / unit name information acquisition means 173 includes a continuous group of character strings composed of [numbers] [unit characters] such as “one” at the end of the search target character string. If the number of characters in the sequence is extracted, a series of character strings composed of [numbers] and [unit characters] are extracted, and the character strings that constitute [numbers] are converted into numerical values to obtain quantity information ("charged quantity in FIG. 4"). Or “quantity after assessment”), and a character string constituting [unit character] is obtained as unit name information (“unit name upon request” or “unit name after assessment”). Here, the unit name information is acquired from a master table in which information of a plurality of unit characters such as a book, a tube, a bag, mL, a tube, a bottle, and a lock stored in advance in the storage device 190 is stored. Then, the quantity / unit name information acquisition unit 173 sets a character string obtained by removing a continuous group of character strings composed of [numbers] and [unit characters] as a search target character string. Thus, for example, if the search target character string is “stomach / duodenal catheter Margensonde E-7 (2.5-4.5) _nutrition catheter (nasal / general) _1”, The unit name information acquisition means 173 converts “1” out of “1” into a numerical value and acquires it as quantity information, and acquires “book” as unit name information from the master table. And the quantity / unit name information acquisition means 173 removes “one”, “stomach / duodenal catheter Margensonde E-7 (2.5-4.5) _nutrition catheter (for nasal / general) "" Is set as a new search target character string. The unit name information may be acquired as a code from a master table that is stored in advance in the storage device 190 and associates the unit character with its code.

  The billing item name information acquisition unit 157 uses the search target character string set by the billing amount related information acquisition unit 155 to request item name information (invoiced item name information in FIG. )). Further, the post-assessment item name information acquisition means 158 uses the post-assessment item name information (“post-assessment item name”) from the search target character string set by the post-assessment amount related information acquisition means 156. ). The billing item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 may be a single functional unit. Although details will be described later, the item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 are search targets set by the amount-of-charge related information acquisition unit 155 and the post-assessment amount-related information acquisition unit 156, respectively. By retrieving from the item name master storing the information of a plurality of item names using the character string as a search character string, the item name information at the time of billing or the item name information after assessment is acquired.

  The item name master is stored in the storage device 190, and includes a pharmaceutical product master, a medical practice master, and a specific equipment master as shown in FIGS. Each master can be created from, for example, a master (basic master) relating to a medical insurance claim provided by the Ministry of Health, Labor and Welfare (for example, see http://www.iryohoken.go.jp/shinryohoshu/searchMenu/). The medicine master is configured as a table in which item names (medicine names), codes, unit names, amounts, and the like are associated. The medical practice master is configured as a table in which item names (medical practice names), codes, scores, entrance / exit application classifications, DPC application classifications, and the like are associated with each other. The specific equipment master is configured as a table in which item names (specific equipment names), codes, unit names, amounts, separate table numbers, and the like are associated with each other. In addition, since there may be a case where a plurality of records having the same item name are registered in the basic master described above, the item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 have unit units as described later. Uses the name, application / exclusion classification, DPC application classification, and separate table number to obtain the item name information at the time of request and the item name information after the assessment.

  The item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 retrieve from the item name master using the search target character string as a search character string, and if there is a matching item name, Obtained as item name information at the time of request or item name information after assessment. At this time, the requesting item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 acquire the corresponding codes as the “requesting code” or “post-assessment code” in FIG. In addition, the billing item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 acquire the corresponding amount or point information. Thereby, for example, when the search target character string set by the billing amount related information acquisition unit 155 is “Pariet lock 10 mg”, the charge item name information acquisition unit 157 searches for “Pariet lock 10 mg”. If there is a matching item name (see FIG. 9A), the item name “Pariet lock 10 mg” is acquired as “item name at request”. At this time, the billing item name information acquisition unit 157 acquires the code “610412202” corresponding to the acquired item name as the “billing time code”, and also acquires the corresponding amount or point information “132.6”.

  On the other hand, the item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 search from the item name master using the search target character string as a search character string, and if there is no matching item name, the search character string A character string obtained by dividing the column into a group of consecutive character strings and removing the first character string is set as a new search character string. Then, the new search character string is searched from the item name master, and if there is a matching item name, the item name is acquired as request item name information or post-assessment item name information. At this time, the billing item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 also acquire the corresponding code, the amount of money, or the score information as described above. Further, the billing item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 are the search characters among the search target character strings set by the billing amount related information acquisition unit 155 and the post-assessment amount related information acquisition unit 156. A character string other than a column (a character string representing an item name) is acquired as product name standard size information (“invoiced product name standard size” or “post-assessment product surface standard size”). The request item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 divide the search character string and set a new search character string until the request item name information and post-assessment item name information can be acquired. , The process of searching the set search character string from the item name master is repeatedly executed.

  Thus, for example, the search character string is “stomach / duodenal catheter Margensonde E-7 (2.5-4.5) _nutrition catheter (for nasal / general)” and matches the item name master When there is no name, the item name information acquisition means 157 at the time of requesting the character string “nutrition catheter” from which the first character string “stomach / duodenal catheter Margensonde E-7 (2.5-4.5)” is removed. (Nasal / general) "is set as a new search character string. Then, the search character string “nutrition catheter (for nasal / general)” is searched from the item name master, and when there is a matching item name (see FIG. 9C), the item name “nutrition catheter” (For nasal / general use) ”is acquired as“ item name at the time of billing ”. At this time, the billing item name information acquisition means 157 also acquires the corresponding code “733220000” and the amount or point information “180”. Furthermore, the item name information acquisition unit 157 at the time of billing includes a search target character string “stomach / duodenal catheter Margensonde E-7 (2.5-4.5) _nutrition catheter (set by the billing amount related information acquisition unit 155) Character string “stomach / duodenal catheter Margensonde E-7 (2.5-4.5)” other than the search character string “nutrition catheter (for nasal / general)” Is acquired as “Product name standard size when billing”.

  The billing item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 first search the medicine master and execute the above-described item name information acquisition process. If there is an item name that matches the medicine master, the code “C” is acquired as the “code category upon request” or “code category after assessment” in FIG. When there is no item name that matches the medicine master, the medical practice master is searched and the item name information acquisition process is executed. If there is an item name that matches the medical practice master, the code “F” is acquired as the “code category upon request” or “code category after assessment”. When there is no item name that matches the medical practice master, the specific device master is searched and the item name information acquisition process is executed. If there is an item name that matches the specific equipment master, the code “D” is acquired as the “code category upon request” or “code category after assessment”.

Here, acquisition of item name information at the time of billing and item name information after assessment (acquisition of item name and code) when a plurality of records having the same item name are registered in the item name master will be described.
When there is one item name that matches the medicine master, the requesting item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 acquire the matching item name and the corresponding code. On the other hand, when there are a plurality of item names that match the drug master, the request item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 include the unit name acquired by the quantity / unit name information acquisition unit 173 and the drug name. Search for records with the same master unit name. When there is one record with the same unit name, the item name and code of the record are acquired. On the other hand, if there is no record with the same unit name, the item name and code of the first record are acquired from among a plurality of records having the same item name. When there are a plurality of records with matching unit names, the item name and code of the first matching record are acquired.

  When there is one item name that matches the medical practice master, the requesting item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 acquire the matching item name and the corresponding code. On the other hand, when there are a plurality of item names that match the medical practice master, the item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 at the time of claim are the “in / out classification” acquired by the receipt unit data acquisition unit 130. The record that matches the entry / exit application classification of the medical practice master is searched. Specifically, when the “in / out category” is 1, it matches when the in / out category is 0 or 1. When the “in / out category” is 2, the in / out category is 0 or 2. Sometimes matches. Then, when there is one record whose “exclusion / exclusion category” matches the entry / exclusion application category, the item name and code of the record are acquired. On the other hand, when there is no record in which the “in / out category” and the in-and-out application category match, the item name and code of the first record are acquired from among a plurality of records having the same item name. In addition, when there are a plurality of records in which the “exclusion / exclusion category” and the entry / exclusion application category match, the request item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 have the same DPC application category. Search for records. Specifically, when the DPC application category of the facility set in advance by the user is “volume” (or when the DPC application category of the facility is “not set”), the DPC application category of the medical practice master If the DPC application category of the facility is “specific”, it matches when the DPC application category of the medical practice master is 2, and the DPC application category of the facility is “ If it is “specialized”, it matches when the DPC application category of the medical practice master is 4, and if the DPC application category of the facility is “Other”, it matches when the DPC application category of the medical practice master is 3 Then. When there is one record in which the DPC application category of the facility and the DPC application category of the medical practice master match, the item name and code of the record are acquired. On the other hand, if there is no record in which the DPC application category of the facility matches the DPC application category of the medical practice master, the first record of the plurality of records in which the “exclusion / exclusion category” and the entry / exclusion category match. Get item name and code. If there are a plurality of records in which the DPC application classification of the facility and the DPC application classification of the medical practice master match, the item name and code of the first matching record are acquired.

  When there is one item name that matches the specific equipment master, the requesting item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 acquire the matching item name and the corresponding code. On the other hand, when there are a plurality of item names that match the specified device master, the request item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 receive the “medical treatment” acquired by the location unit data generation unit 140 as described later. A record in which the “identification” (see FIG. 3) matches the separate table number of the medical practice master is searched. Specifically, when “medical treatment identification” is 14, the table numbers match when the number is 1, and when “medical treatment identification” is 60, 70, 31, 32, 33, 40, 50, or 54, the separate table Assume that the numbers match when the number is 2. Then, when there is one record whose “medical care identification” and the attached table number match, the item name and code of the record are acquired. On the other hand, when there is no record in which the “medical care identification” and the separate table number match, the item name and code of the first record are acquired from among a plurality of records having the same item name. Further, when there are a plurality of records in which the “medical care identification” and the attached table number match, the request item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 include the quantity / unit name information acquisition unit 173. Search for a record in which the acquired unit name matches the unit name of the medicine master. When there is one record with the same unit name, the item name and code of the record are acquired. On the other hand, when there is no record with the matching unit name, the item name and code of the first record are acquired from among the plurality of records with the same “medical care identification” and the separate table number. When there are a plurality of records with matching unit names, the item name and code of the first matching record are acquired.

  The item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 perform a search in the order of the pharmaceutical product master, the medical practice master, and the specific device master, and there is no item name that matches the specific device master to be searched last, If the search character string cannot be divided into a group of consecutive character strings, the search target character string set by the billing amount related information acquisition unit 155 or the post-assessment amount related information acquisition unit 156 is set to the item name information at the time of billing or the assessment. Acquired as post item name information. At this time, the dummy code “999999999” is acquired as “code upon request” or “code after assessment”, and the code “*” is acquired as “code category upon request” or “code category after assessment”.

  In addition to the above, the item unit data acquisition unit 150 acquires “assessment type” and “changed part” in FIG. 4 as item unit data. Specifically, if the item name is not extracted from “Billing Content” and the item name is extracted from “Content after Correction / Assessment”, the code “2” (addition) is acquired as “Assessment Type”. , Code “0” (other than change) is acquired as “change location”. Also, if the item name is extracted from “contents charged” and the item name is not extracted from “contents after correction / assessment”, the code “3” (deleted) is acquired as the “assessment type” and the code “0” Is acquired as “changed part”. In addition, if the item name is extracted from both “Invoice Content” and “Content after Correction / Assessment”, and there is a difference in the item name, the code “1” (change) is acquired as the “assessment type” and the code “1” (item) is acquired as “changed part”. Also, if the item name is extracted from both “Billing Content” and “Content after Correction / Assessment”, and the item name is the same but the quantity is different, the code “1” is acquired as “Assessment Type” Then, the code “2” (quantity) is acquired as “changed part”. In addition, if the item name is extracted from both “Billing content” and “Content after amendment / assessment” and the item name and quantity are the same, but the number of times is different, the code “1” is set to “assessment type”. And the code “3” (number of times) is acquired as “changed part”. In addition, if the item name is extracted from both “Invoice Content” and “Content after Amendment / Assessment” and the item name, quantity, and number of times are the same, the code “0” (no assessment) is assigned to “Assessment Type”. And the code “0” is acquired as “changed part”.

  Further, the item unit data acquisition means 150 generates “item serial number”, “amount when billing”, “amount after assessment” and “amount of increase / decrease 2” in FIG. The “item sequence number” is a unique sequence number set for each record in the item unit table within the same registration key, receipt sequence number, and location sequence number described later. “Billing amount” is generated by calculation based on “Billing amount”, “Number of billing times” and the amount or points information obtained from the item name master, and “Amount after assessment” is “Quantity after assessment”, Generated by calculation from “number of times after assessment” and information on the amount or points acquired from the item name master. Further, the “increase / decrease amount 2” is generated by subtracting the “prior amount” from the “post-assessment amount”.

  As shown in FIG. 1, the location unit data generation unit 140 is a unit that generates location unit data that is information stored in the location unit table. Specifically, the location unit data generation means 140 acquires “medical treatment identification” in FIG. 3 from “location 1” in the detail part of the increase / decrease point report data when the receipt unit data is acquired, and the receipt unit data "Registration key" and "receipt serial number" are acquired from, and "reason code", "number of times of request", "number of times of request", "number of points after assessment" and "number of times after assessment" are obtained from the item unit data. . Further, the location unit data generation means 140 generates “location serial number”, “amount when billing”, “amount after assessment”, and “increase / decrease amount 1”. The “location serial number” is a unique serial number set for each record in the location unit table within the same registration key / receipt serial number. “Amount at time of claim” is generated by calculation from “number of times of request” and “number of times of request”, and “Amount after assessment” is generated by calculation from “number of points after assessment” and “number of times after assessment”. Further, “increase / decrease amount 1” is generated by subtracting “amount upon request” from “amount after assessment”.

  The information storage means 160 includes receipt identification information such as “medical department code” and medical chart number, item name information at the time of billing (“item name at the time of billing”), “unit price at billing”, “number of billing points”, “billing time” Information related to the billing amount such as “Time Count”, “Quantity at Billing”, “Unit Name at Billing”, Item Name Information after Assessment (“Item Name after Assessment”), “Unit Price After Assessment” and “Point After Assessment” ”,“ Number of times after assessment ”,“ quantity after assessment ”,“ name of unit after assessment ”, and the like. More specifically, the information storage unit 160 receives a response when the information in the “record type” column of the increase / decrease point report data is 5 and the information in the “record type” column of the immediately preceding row is not 5. The unit data, location unit data, and item unit data are stored in the storage device 190 by storing them in the corresponding fields of the receipt unit table, location unit table, and item unit table. At this time, the information storage unit 160 registers the system date and time in the “registration date and time” of the receipt unit table. Here, the registration date and time “yyyyMMddhhmmss” in FIG. 2 means yyyy year MM month dd day hh hour mm minute ss second.

  As shown in FIG. 1, the receipt analysis apparatus 300 includes data relating to the assessment contents stored in the storage device 190 of the billing / assessment information management apparatus 100 and receipt data stored in the storage apparatus 290 of the receipt management apparatus 200. Based on this, it is a device that performs a receipt analysis. As an example, the receipt analysis apparatus 300 mainly includes a selection screen display unit 310 and an analysis result output unit 320.

  The selection screen display means 310 is a means for displaying a selection screen for selecting an analysis condition for a receipt on the display 400 as an example of a display device. Specifically, the selection screen display unit 310 displays a selection screen 410 as shown in FIG. In the selection screen 410, “item name” and “code” are arranged in the center, and on the right side, a check indicating that an assessment has been made for a predetermined billing date such as “(Heisei 26) June 06” A table 411 in which the amount of increase / decrease such as “-1,640” is arranged is displayed in the box C1. Also, on the left side of the table 411, a condition narrowing column 412 in which check boxes and radio buttons for further narrowing down the analysis conditions for the receipt are displayed.

  In the condition narrowing down column 412, “company insurance” (social insurance), “national insurance” (national health insurance), “hospital”, “outpatient”, “DPC”, “target data”, “reason code” (reason for increase / decrease) The analysis conditions can be further narrowed down by checking or unchecking the check box C2 such as. In addition, the billing date displayed in the table 411 can be changed by entering an appropriate number in the “period” input field C3. Further, when the “amount” radio button B2 in the “display item” column is pressed, the increase / decrease amount can be displayed on the right side of the check box C1 of the table 411, and when the “number of places” radio button B2 is pressed, the table 411 is displayed. The number of assessment points can be displayed on the right side of the check box C1 instead of the increase / decrease amount. In addition, when the radio button B3 of “clinical department”, “clinical identification”, “doctor”, and “ward” is pressed, the clinical department, clinical identification, doctor or ward is selected in the drop-down list D1 above the radio button B3. A plurality of check boxes C4 are displayed, and by checking or unchecking them, it is possible to narrow down clinical departments, medical identifications, doctors or wards. Further, by inputting an arbitrary item name into the search box 413 arranged on the table 411 and pressing the search button B4, only the matching item names can be displayed on the table 411.

  The analysis result output unit 320 is a unit that outputs the result of the receipt analysis by searching the information stored in the storage devices 190 and 290 based on the analysis condition of the receipt selected on the selection screen 410. Specifically, the analysis result output unit 320 displays a check box C1 of “June 26, 2014” for the “flumazenil intravenous solution 0.2 mg“ chemifa ”2 mL” on the selection screen 410, for example. When the receipt print button B1 is pressed, the item name is changed and added for “flumazenil intravenous solution 0.2 mg“ Chemifa ”2 mL” from the receptacle unit table, the location unit table and the item unit table stored in the storage device 190. Alternatively, a record that has been deleted or whose quantity or number of times has been changed is searched and the corresponding one is extracted. Further, the analysis result output means 320 extracts the receipt data corresponding to the record in which the item name is changed from the storage device 290. Based on the receipt data and the information of the record in which the item name is changed, the analysis result output means 320 then displays the contents of the receipt (item name and quantity at the time of requesting medical fees, unit name, points, number of times) Etc.) and the contents of the increase / decrease point communication form (item name, quantity, unit name, score, number of times, etc. after assessment by the examination and payment organization) are arranged and output as a receipt form 420 as shown in FIG. The output of the analysis result may be performed, for example, by displaying the form 420 on the display 400 or by printing the form 420 by a printer connected to the receipt analysis apparatus 300 (receipt analysis system 10). it can.

  The form 420 displays the contents of the receipt submitted to the examination and payment institution above the description of “Information from the increase / decrease report”. The contents of the increase / decrease point report (information acquired from the increase / decrease point report data) are displayed in the analysis content column 421 below the description. The analysis content column 421 mainly includes a billing content column 422 and an after-assessment content column 423. In the billing content column 422, the item name, quantity, and unit name at the time of medical fee claim obtained from the increase / decrease point report data are displayed, and the reason for the increase / decrease point is displayed before the item name to be assessed. The reason code, for example, “C” is displayed. The post-assessment content column 423 arranged below the billing content column 422 displays the item name, quantity, and unit name after assessment by the examination / payment institution obtained from the increase / decrease point report data. In the example shown in FIG. 11, it is displayed that the item “flumazenil intravenous injection 0.2 mg“ Chemifa ”2 mL” at the time of claim has been deleted as a result of the assessment. The analysis result output means 320 is a receipt in which such a form 420 is evaluated in “June 2014” for “flumazenil intravenous solution 0.2 mg“ Chemifa ”2 mL”. Within the range selected in (4), all are output as a form 420.

  In this way, since the contents of the receipt and the contents of the increase / decrease point report can be output side by side on one form 420, it is possible to easily check the receipt and the increase / decrease point report. Moreover, since only the received assessment is output, it is possible to reduce the burden on the medical institution when checking the receipt and the increase / decrease point report.

  Next, the operation (receipt analysis method) of the receipt analysis system 10 configured as described above, specifically, the operation of acquiring and storing information from the increase / decrease point report data will be described with reference to a flowchart. In the flowcharts of FIGS. 12 to 14, the processes from the start to the end are repeatedly executed by the number of rows of the increase / decrease point report data.

Prior to acquiring information from the increase / decrease point report data, the increase / decrease point report data acquisition unit 110 acquires the CSV format increase / decrease point report data acquisition unit 110 from the network, the storage medium, the storage device 190, or the like ( Increase / decrease point report data acquisition step).
As shown in FIG. 12, the record type information acquisition unit 120 acquires “record type” from the acquired increase / decrease point contact data (S111). If the record type is not “2” (S121, No), the process proceeds to step S131. If the record type is “2” (S121, Yes), the current row processing is terminated (see FIG. 14).

  In step S131, when the record type is “3” or “5” (Yes) and the receipt unit data has been acquired (S132, Yes), the location unit data generation unit 140 receives the receipt unit data. The location unit data is generated from the item unit data (S133). On the other hand, if the record type is not “3” or “5” in step S131 (No), and if no unit-of-receipt data is acquired in step S132 (No), the process proceeds to step S141.

  If the record type is “5” in step S141 (Yes), the information storage unit 160 determines whether the record type of the immediately preceding row was “5” (S142). If the record type of the immediately preceding row is not “5” (S142, No), the information storage unit 160 stores the receipt unit data, location unit data, and item unit data for one receipt into the receipt unit table, location By storing in the fields of the unit table and the item unit table, it is stored in the storage device 190 (S143) (information storage step). Thereafter, the information storage means 160 clears the information (acquired data) stored in the information storage area of the RAM in order to be able to acquire the next receipt data (S144). On the other hand, if the record type is not “5” in step S141 (No) and if the record type of the immediately preceding row is “5” (Yes) in step S142, the process proceeds to step S151 in FIG.

  In step S151, when the record type is “3” (Yes), the record type information acquisition unit 120 determines whether “location 1” is blank (S152). If “Place 1” is not blank (S152, No), the process proceeds to step S161. If “Place 1” is blank (S152, Yes), the current row processing is terminated. On the other hand, if the record type is not “3” in step S151 (No), the process proceeds to step S161.

  In step S161, when the record type is “4” (Yes), the record type information acquisition unit 120 sets “public utility benefit” at the beginning of the character string extracted from the “billing content” by the first billing character string setting unit 151. It is determined whether there is a character string of “subject” or “payment amount (first)” (S162). ), The process proceeds to step S171, and if the “claimed contents” has “subject of public benefit” or “paid amount (No.)” (S162, Yes), the current row processing is terminated. If the record type is not “4” (No), the process proceeds to step S171.

  In step S171, when the record type is “1” (Yes), the receipt unit data acquisition unit 130 acquires the “clinical department code” (S172) (receipt identification information acquisition step). On the other hand, if the record type is not “1” in step S171 (No), the process proceeds to step S181 in FIG.

  In step S181, when the record type is “3” (Yes), the receipt unit data acquisition unit 130 determines whether “the medical record number etc.” is blank (S182). If the “medical record number etc.” is not blank (S182, No), the receipt unit data acquisition unit 130 acquires receipt unit data (S183) (receipt identification information acquisition step). On the other hand, if the record type is not “3” in Step S181 (No), and if “Record Number etc.” is blank (Yes) in Step S182, the process proceeds to Step S191.

  In step S191, when the record type is “3” or “4” (Yes), the first billing character string setting unit 151 extracts the character string from “billing content” and sets the character string after the first assessment. The means 152 extracts a character string from the “contents after correction / assessment”. At this time, if both “billing content” and “content after correction / assessment” are blank (if no character string could be extracted from either) (S192, Yes), the current row processing is terminated. If the record type is not “3” or “4” in step S191 (No), the current row processing is also terminated. On the other hand, when a character string can be extracted from at least one of “charged contents” and “contents after correction / assessment” (S192, No), the item-unit data acquisition unit 150 acquires item-unit data (S200).

  As shown in FIG. 15, in step S200, firstly, the first billing character string setting means 151 and the first post-assessment character string setting means 152 are the characters extracted from the “billed contents” and the “corrected / assessed contents”. A column is set as a search target character string (S210) (first character string setting step upon request, first character string setting step after assessment).

  Next, the second billing character string setting unit 153 and the second post-assessment character string setting unit 154 extract a character string including the character string representing the item name and the money amount related character string from the search target character string. The extracted character string is set as a search target character string (second character string setting step at the time of second billing / character string setting step after the second assessment).

  Specifically, when the first character string removing unit 161 can extract a continuous group of character strings including “inspection” from the beginning of the search target character string (S221, Yes), a general inspection according to the contents Information ("inspection at billing" or "inspection after assessment") is acquired (S223), and a character string other than the extracted character string is set as a search target character string (S225). On the other hand, if it is not possible to extract a continuous group of character strings including “check” from the beginning of the search target character string in step S221 (No), the process proceeds to step S231.

  When the character string starting with “(calculation date)” can be extracted from the search target character string (S231, Yes), the second character string removing unit 162 sets a character string other than the extracted character string as the search target character string. On the other hand, if it is not possible to extract a character string starting with “(calculation date)” from the search target character string in step S231 (No), the process proceeds to step S241 in FIG.

  Next, the billing amount related information acquisition unit 155 and the post-assessment amount related information acquisition unit 156 extract a monetary amount related character string representing a unit price, points, number of times, quantity, unit name, etc. from the search target character string. The related information is acquired, and the character string from which the money amount related character string is removed is set as a search target character string (billing amount related information acquisition step / assessed amount related information acquisition step after assessment).

  Specifically, when the unit price information acquisition unit 171 can extract a continuous group of character strings including “yen /” from the search target character string (Yes in S241), the character string before “yen /” is extracted. Unit price information is acquired by converting it into a numerical value (S243), and a character string other than the extracted character string is set as a search target character string (S245). On the other hand, if it is not possible to extract a continuous group of character strings including “Yen /” from the search target character string in step S241 (No), the process proceeds to step S251.

  If the score / count information acquisition unit 172 can extract a continuous group of character strings composed of [number] “×” [number] from the end of the search target character string (S251, Yes), the “×” The previous character string is converted into a numerical value to obtain score information (S253), and the character string after “x” is converted into a numerical value to obtain the number of times information (S254). Then, the score / number of times information acquisition unit 172 sets a character string other than the extracted character string as a search target character string (S255). On the other hand, if it is not possible to extract a continuous group of character strings composed of [number] “×” [number] from the end of the search target character string in step S251 (S251, No), the process proceeds to step S261.

  When the quantity / unit name information acquisition unit 173 can extract a continuous group of character strings composed of [numbers] [unit characters] from the end of the search target character string (S261, Yes), the [number] is configured. The character string to be converted is converted into a numerical value to obtain quantity information (S263), and the unit name information is obtained from the character string constituting [unit character] (S264). Then, the quantity / unit name information acquisition unit 173 sets a character string other than the extracted character string as a search target character string (S265). On the other hand, in step S261, when a continuous group of character strings composed of [numbers] [unit characters] cannot be extracted from the end of the search target character string (S261, No), the process proceeds to step S300.

  Next, the item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 acquire item name information from the search target character string (S300) (request item name information acquisition step / post-assessment item name) Information acquisition step).

  Specifically, as shown in FIG. 17, in step S300, the billing item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 acquire the billing amount related information acquisition unit 155 and the post-assessment amount related information. The search target character string set by the means 156 is set as a search character string (S311), and the item name master is searched (S312). If there is a matching item name (S313, Yes), the item name is acquired as item name information, and the corresponding code is acquired (S314), and the current row processing is terminated.

  On the other hand, if there is no matching item name in step S313 (No), the billing item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 divide the search character string into a group of consecutive character strings. (S321). If the character string can be divided (S322, Yes), a character string other than the first character string is set as a new search character string (S323). After that, the billing item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158 search for a new search character string from the item name master (S324). If there is a matching item name (S325, Yes), the item name is acquired as item name information, the corresponding code is acquired, and the billing amount related information acquisition means 155 or the post-assessment amount related information. Among the search target character strings set by the acquisition unit 156, a character string other than the search character string is acquired as product name standard size information (S326), and the current row processing is terminated. On the other hand, if there is no matching item name in step S325 (No), the process proceeds to step S321, and the subsequent processing is executed.

  In step S322, when the search character string cannot be divided into a group of consecutive character strings (No), the request item name information acquisition unit 157 and the post-assessment item name information acquisition unit 158, as shown in FIG. Is changed (S331). Specifically, the search target master is changed from the medicine master to the medical practice master, or from the medical practice master to the specific equipment master. If the master can be changed (S332, Yes), the process proceeds to step S311 in FIG. 17, and the subsequent processing is executed. On the other hand, in step S332, when the item name master is the specific equipment master and cannot be changed to another master (No), the search set by the billing amount related information acquisition unit 155 or the post-assessment amount related information acquisition unit 156 The target character string is acquired as item name information, and a dummy code is acquired (S333), and the current row processing is terminated.

  According to the present embodiment described above, item name information and information related to the amount of money can be acquired from the CSV format increase / decrease point report data and stored in the storage device 190. And, as shown in FIG. 11, for example, the contents of the receipt (contents at the time of request) and the contents of the increase / decrease point report (contents after the assessment) can be output side by side as shown in FIG. Receipt analysis using point correspondence data is possible. In addition, since the manual operation of matching the receipt with the increase / decrease point report is not required, the burden on the medical institution or the like can be greatly reduced.

  Although one embodiment of the present invention has been described above, the present invention is not limited to the above embodiment. About a concrete structure, it can change suitably in the range which does not deviate from the meaning of invention as follows.

  In the above embodiment, as shown in FIG. 11, an example in which information acquired from the increase / decrease point report data (contents of the increase / decrease point report) is output along with the contents of the receipt has been shown. The method of using the acquired information is not limited to this. For example, the information acquired from the increase / decrease point report data may be output after being collected in a table format, or may be output after being collected in a graph format.

  In the embodiment, the second character string setting unit 153 and the second post-assessment character string setting unit 154 both include the first character string removing unit 161 that removes a continuous group of character strings including “check”. Although it had, it is not limited to this. For example, if a continuous group of character strings including “inspection” are set only after the assessment, only the second assessed character string setting means may have the first character string removal means. . The same can be applied to the other means as long as the specific character string is set only at one time of the request and after the assessment.

  The information stored in each table, each item name master, etc. shown in the above embodiment is an example, and is not limited to that in the above embodiment. That is, the information (item name) stored in each table, each item name master, and the like is more than the item in the above embodiment as long as the information necessary for receipt analysis and item name information acquisition is included. There may be a thing with many, and a thing with few items may be sufficient. Moreover, in the said embodiment, although the table consisted of the receipt unit table, the location unit table, and the item unit table, it is not limited to this, For example, you may manage by one table. Moreover, in the said embodiment, although the item name master consisted of the pharmaceutical master, the medical treatment master, and the specific equipment master, it is not limited to this, For example, you may be comprised from one master table.

  In the said embodiment, although the example which applied this invention as medical use was shown, it is not limited to this. That is, the present invention can be applied, for example, for dispensing pharmacies or for dental use.

DESCRIPTION OF SYMBOLS 10 Receipt analysis system 100 Claim / assessment information management apparatus 110 Increase / decrease point report data acquisition means 120 Record type information acquisition means 130 Receptacle unit data acquisition means 140 Location unit data generation means 150 Item unit data acquisition means 160 Information storage means 190 Storage device 200 Receipt Management Device 300 Receipt Analysis Device 151 First Charging Character String Setting Unit 152 First Assessed Character String Setting Unit 153 Second Billing Time Character String Setting Unit 154 Second Post-Assessment Character String Setting Unit 155 Billing Amount Related Information Acquisition means 156 Post-assessment amount related information acquisition means 157 Requested item name information acquisition means 158 Post-assessment item name information acquisition means 161 First character string removal means 162 Second character string removal means 171 Unit price information acquisition means 172 Score / count information Acquisition means 173 Quantity / unit name Information acquisition means

Claims (11)

Increase / decrease point report data acquisition means for acquiring the increase / decrease point report data in CSV format;
A receipt identification information acquisition means for acquiring a receipt identification information for identifying a receipt from the increase / decrease point contact data;
A first character string setting unit for extracting the character string stored in the “billing content” column of the increase / decrease point report data, and setting the extracted character string as a search target character string;
Characters including a character string representing an item name related to a medical practice and a charge-related money amount related character string representing information related to an amount of money from a search target character string set by the first charge time character string setting unit A second billing character string setting means for extracting a column and setting the extracted character string as a search target character string;
The charge amount related character string is extracted from the search target character string set by the second charge time character string setting means, and the charge amount related information that is information related to the amount is acquired. Billing amount related information acquisition means for setting a character string from which a related character string is removed as a search target character string,
A billing item name information acquisition unit for acquiring billing item name information, which is information of the item name, from a search target character string set by the billing amount related information acquisition unit;
A first post-assessment character string setting unit that extracts a character string stored in the “contents after correction / assessment” column of the increase / decrease point report data, and sets the extracted character string as a search target character string;
From the search target character string set by the first post-assessment character string setting means, a character string including the character string representing the item name and the post-assessment amount related character string that is a character string representing information related to the amount of money A second post-assessment character string setting means for extracting and setting the extracted character string as a search target character string;
The post-assessment amount related character string is extracted from the search target character string set by the second post-assessment character string setting means to obtain post-assessment amount related information, which is information related to the amount, and the post-assessment amount A post-assessment amount related information acquisition means for setting a character string from which a related character string is removed as a search target character string;
From the search target character string set by the post-assessment amount related information acquisition unit, the post-assessment item name information acquisition unit that acquires post-assessment item name information that is information of the item name,
Information storage means for associating the receipt identification information, the billing item name information, the billing amount related information, the post-assessment item name information, and the post-assessment amount related information in a storage device; A receipt analysis system comprising: The billing amount related information acquisition unit and the post-assessment amount related information acquisition unit are respectively:
When the search target character string includes a continuous group of character strings including “Yen /”, a continuous group of character strings including “Yen /” is extracted, and the character string before “Yen /” is extracted. Unit price information acquisition means for converting a character string into a numerical value and acquiring it as unit price information, and setting a character string from which a group of consecutive character strings including “yen /” is removed as a search target character string;
When a series of character strings composed of [numbers] “×” [numbers] is included at the end of the search target character string, a sequence composed of [numbers] “×” [numbers] The character string before “×” is converted into a numerical value and acquired as point information, and the character string after “×” is converted into a numerical value and acquired as number information. In addition, a score / number of times information acquisition means for setting a character string obtained by removing a continuous group of character strings composed of [number] “×” [number] as a search target character string,
When a group of consecutive characters composed of [numbers] and [unit characters] is included at the end of the search target character string, a group of consecutive characters composed of [numbers] and [unit characters] Extracts the column, converts the character string constituting [Numeric] into a numerical value and obtains it as quantity information, obtains the character string constituting [Unit character] as unit name information, and [Numeric] [Unit] 2. The receipt analysis system according to claim 1, further comprising: a quantity / unit name information acquisition unit configured to set a character string obtained by removing a continuous group of character strings formed of “characters” as a search target character string. .   At least the second post-assessment character string setting means, when the search target character string includes a continuous group of character strings including “check” at the beginning of the search target character string, The receipt analysis system according to claim 1, further comprising a first character string removing unit that removes the string.   The second billing time character string setting means and the second post-assessment character string setting means respectively determine "(calculation) when the search target character string includes a character string beginning with" (calculation date) ". The receipt analysis system according to any one of claims 1 to 3, further comprising a second character string removing unit that removes a character string starting with "day".   The claim-time item name information acquisition unit and the post-assessment item name information acquisition unit respectively search from the master in which information of a plurality of the item names is stored using the search target character string as a search character string, and match 5. The receipt analysis according to claim 1, wherein when there is an item name, the item name is acquired as the item name information at the time of claim or the item name information after the assessment. system.   The claim-time item name information acquisition unit and the post-assessment item name information acquisition unit respectively search from the master using the search target character string as a search character string, and when there is no matching item name, the search A character string obtained by dividing the character string into a group of consecutive character strings and removing the first character string is set as a search character string, the search character string is searched from the master, and there is a matching item name. In this case, the item name is acquired as the item name information at the time of billing or the item name information after the assessment, and a character string other than the search character string among the search target character strings is acquired as product name standard size information. The receipt analysis system according to claim 5, wherein:   When the information in the “record type” column of the increase / decrease point report data is 1, the receipt identification information acquisition unit uses the information of the “clinical department code” column in the header of the increase / decrease point report data as the receipt identification information. It acquires as at least one of these, The receipt analysis system of any one of Claims 1-6 characterized by the above-mentioned.   When the receipt identification information acquisition means can acquire information from the “medical record number etc.” column of the increase / decrease point report data, the information of the column is acquired as at least one of the receipt identification information. The receipt analysis system according to any one of claims 1 to 7.   The information storage means receives the receipt identification information when the information in the “record type” column of the increase / decrease point report data is 5 and the information in the “record type” column of the immediately preceding row is not 5. 9. The claim item information, the billing amount related information, the post-assessment item name information, and the post-assessment amount related information are stored in the storage device. 2. Receptacle analysis system according to item 1. The means provided in the computer is
Increase / decrease point report data acquisition step for acquiring CSV format increase / decrease point report data;
A receipt identification information obtaining step for obtaining a receipt identification information for identifying a receipt from the increase / decrease point contact data;
A first billing character string setting step of extracting a character string stored in a “billing content” column of the increase / decrease point correspondence data, and setting the extracted character string as a search target character string;
Characters including a character string representing an item name related to a medical practice and a charge amount related character string that is a character string representing information related to the amount of money from the search target character string set in the first charge time character string setting step A second billing character string setting step of extracting a column and setting the extracted character string as a search target character string;
The charge amount related character string is extracted from the search target character string set in the second charge time character string setting step, and the charge amount related information that is information related to the amount is acquired. A billing amount related information acquisition step for setting a character string from which a related character string is removed as a search target character string,
A billing item name information acquisition step for acquiring billing item name information, which is information of the item name, from a search target character string set in the billing amount related information acquisition step;
A first post-assessment character string setting step of extracting a character string stored in the “contents after correction / assessment” column of the increase / decrease point report data, and setting the extracted character string as a search target character string;
From the search target character string set in the first post-assessment character string setting step, a character string including a character string representing the item name and a post-assessment amount related character string that is a character string representing information related to the amount of money A second post-assessment character string setting step for extracting and setting the extracted character string as a search target character string;
The post-assessment amount related character string is extracted from the search target character string set in the second post-assessment character string setting step to obtain post-assessment amount related information that is information related to the amount, and the post-assessment amount A post-assessment amount related information acquisition step for setting a character string from which a related character string is removed as a search target character string,
From the search target character string set in the post-assessment amount related information acquisition step, the post-assessment item name information acquisition step for acquiring post-assessment item name information that is information of the item name,
An information storage step of associating the receipt identification information, the billing item name information, the billing amount related information, the post-assessment item name information, and the post-assessment amount related information in a storage device; A method for analyzing a receipt, comprising: Computer
Increase / decrease point report data acquisition means for acquiring the increase / decrease point report data in CSV format;
A receipt identification information acquisition means for acquiring a receipt identification information for identifying a receipt from the increase / decrease point contact data;
A first character string setting unit for extracting the character string stored in the “billing content” column of the increase / decrease point report data, and setting the extracted character string as a search target character string;
Characters including a character string representing an item name related to a medical practice and a charge-related money amount related character string representing information related to an amount of money from a search target character string set by the first charge time character string setting unit A second billing character string setting means for extracting a column and setting the extracted character string as a search target character string;
The charge amount related character string is extracted from the search target character string set by the second charge time character string setting means, and the charge amount related information that is information related to the amount is acquired. Billing amount related information acquisition means for setting a character string from which a related character string is removed as a search target character string,
A billing item name information acquisition unit for acquiring billing item name information, which is information of the item name, from a search target character string set by the billing amount related information acquisition unit;
A first post-assessment character string setting unit that extracts a character string stored in the “contents after correction / assessment” column of the increase / decrease point report data, and sets the extracted character string as a search target character string;
From the search target character string set by the first post-assessment character string setting means, a character string including the character string representing the item name and the post-assessment amount related character string that is a character string representing information related to the amount of money A second post-assessment character string setting means for extracting and setting the extracted character string as a search target character string;
The post-assessment amount related character string is extracted from the search target character string set by the second post-assessment character string setting means to obtain post-assessment amount related information, which is information related to the amount, and the post-assessment amount A post-assessment amount related information acquisition means for setting a character string from which a related character string is removed as a search target character string;
From the search target character string set by the post-assessment amount related information acquisition unit, the post-assessment item name information acquisition unit that acquires post-assessment item name information that is information of the item name,
Functions as information storage means for associating and storing the receipt identification information, the billing item name information, the billing amount related information, the post-assessment item name information, and the post-assessment amount related information A computer program characterized by causing

Images