A processing method for drug use index statistical information system

Abstract

The present invention discloses a processing method for a drug use index statistical information system, and relates to the technical field of drug use index statistics. The main points of the technical solution are: the statistical attributes of the drug-based extension code are uniformly maintained in a background database, wherein the statistical attributes of the drug-based extension code in the background are respectively maintained by product name associated attributes, preparation specification code associated attributes, packaging specification code associated attributes, local extension code associated attributes, and production enterprise associated attributes according to attribute characteristics; the drug application end associates the drug prescription with the drug-based extension code; when performing statistics on each indicator, the local extension code attribute value associated with the prescription is obtained, and the corresponding indicator can be calculated after multiplying it by the cumulative number of prescriptions. The present invention can be used in the fields of hospital indicator statistics, government regulatory departments performing indicator statistics on all hospital prescriptions obtained, big data analysis, etc., and has the characteristics of rapid maintenance, consistent statistical results, simple procedures, etc.

Description

Technical Field

[0001] The present invention relates to the technical field of drug use index statistics, and more specifically, to a method for processing a drug use index statistics information system. Background Art

[0002] The statistics of drug use indicators are an important part of hospital pharmacy management, involving a wide range of areas, many indicators, and the drug use indicators are in a process of continuous and rapid increase. The statistical indicators required by the existing policies include: the use rate of antimicrobial drugs in the statistics of antimicrobial drug indicators (statistics of inpatients and outpatients separately), the per capita amount of antimicrobial drug use, the use rate of antimicrobial injections, the intensity of antimicrobial use, the amount of antimicrobial drug classification, the double ten statistics of antimicrobial drugs, the use statistics of carbapenems and tigecycline antimicrobial drugs, the proportion of restricted antimicrobial drugs, and the proportion of special use antimicrobial drugs; others include the use rate of basic drugs, the proportion of basic drug procurement varieties, the use rate of intravenous infusion (outpatients, emergency, inpatients), the use rate of antitumor drugs, the proportion of antitumor drug use amount, the use rate of proton pump inhibitors, the proportion of proton pump inhibitor use amount, the use amount of key monitored drugs, the use amount of national centralized procurement drugs and the percentage of completion of tasks, the use of national centralized negotiations, and the use of Chinese medicine injections. In this context, it is difficult to carry out the above work without relying on information systems. Therefore, many companies have developed professional information systems such as pharmaceutical management information systems, pharmaceutical management indicator statistical information systems, and rational drug use management information systems. Some HIS manufacturers directly count the above indicators in the hospital HIS system.

[0003] Another use case for drug use index statistics is government regulatory departments, especially health administrative departments, which collect statistics on drug use indexes for the whole society. Government regulatory departments can easily obtain hospital medical order data. However, due to the inconsistency of basic attribute data of drug data uploaded by various hospitals, the large amount of data obtained by government regulatory departments is difficult to count, so that these data cannot be fully used.

[0004] The basis of drug usage index statistics is the setting of drug statistical attributes. In existing software, the setting of statistical attributes is basically done by users. This method leads to a significant increase in user workload, and the maintenance results are not necessarily standard, resulting in large differences in statistical results. Some software also have statistical attribute knowledge bases, but due to the lack of unified drug coding, these statistical attribute knowledge bases are not necessarily comprehensive. When the drug correspondence is wrong, the statistical attributes will also be wrong, resulting in incorrect statistical results, or the drug specification description in the knowledge base is inconsistent with the hospital specification description, and the attribute values ​​in some knowledge bases are inconsistent with the attribute values ​​that should be adopted according to the actual specifications used by the hospital, resulting in statistical errors.

[0005] Therefore, the present invention aims to design and provide a processing method for a medication index statistical information system to solve the above-mentioned problems. Summary of the invention

[0006] The purpose of the present invention is to solve the above problems and provide a processing method for a drug use index statistical information system.

[0007] The above technical purpose of the present invention is achieved through the following technical solutions: A method for processing a drug use index statistical information system, comprising the following steps:

[0008] S1. In the background of the drug use index statistical information system, each statistical attribute data is uniformly maintained for each drug-based extension code to form a drug statistical attribute knowledge base;

[0009] S2. At the application end of the medication index statistical information system, each prescribed drug is matched with a drug-based extended code;

[0010] S3. Install the drug statistical attribute knowledge base in the application-side database of the drug use index statistical information system, and use the drug statistical attribute knowledge base to mark each attribute of each medical order to obtain attribute marking data, and then multiply the attribute marking data by the medical order quantity, and add up the same attributes of all medical orders to obtain the index statistical results.

[0011] Furthermore, when maintaining each statistical attribute data for each drug-based extension code in step S1, the specific method is as follows:

[0012] S101. Attribute data directly related to the drug product name is directly maintained in the product name attribute data table, and attribute data in the drug-based extension code is directly obtained from the product name attribute data table;

[0013] S102. Attribute data directly related to drug preparation specifications are directly maintained in the preparation specification attribute data table, and attribute data in the drug-based extension code is directly obtained from the preparation specification attribute data table;

[0014] S103. Attribute data directly related to drug packaging specifications are directly maintained in the packaging specification attribute data table, and attribute data in the drug-based extension code is directly obtained from the packaging specification attribute data table;

[0015] S104. Attribute data directly related to drug prescription specifications are directly maintained in the prescription specification attribute data table, and attribute data in the drug-based extension code is directly obtained from the prescription specification attribute data table;

[0016] S105. The attribute data directly related to the drug manufacturer is directly maintained in the manufacturer attribute data table, and the attribute data in the drug-based extension code is directly obtained from the manufacturer attribute data table.

[0017] Furthermore, in step S2, the specific method for matching each type of prescribed drug with the drug-based extension code is as follows:

[0018] The drug order data is matched automatically or manually through the interface through one or more data combinations including drug approval number, product name, drug base code, drug specification, and manufacturer data, and after matching once, the same drug order data does not need to be matched again.

[0019] Furthermore, the method for marking each attribute of each medical advice in step S3 is:

[0020] S301, adding various statistical information fields to the medical order data table, and marking the values ​​of the statistical information fields in the medical order with the attribute data corresponding to the drug-based extension code;

[0021] S302. When performing indicator statistics, the number of medical orders of the specified medical order data is multiplied by the medical order attribute value to obtain a statistical indicator of a medical order, and the statistical indicator values ​​of all medical orders are accumulated to obtain the attribute statistical indicators of all medical orders.

[0022] Furthermore, the indicator statistics in step S3 and S301 and S302 also include the following method:

[0023] S303, statistics of the number of medical orders of a certain attribute: the number of medical orders for each drug is accumulated to obtain the statistical results of the indicators whose attributes corresponding to the Boolean data in the attribute value of the local extended code are true; wherein, the attribute statistical indicators whose attribute values ​​are 1 / 0 are also counted by the above method;

[0024] S304, Boolean data or index statistics with attribute values ​​of 1 / 0 using patients as statistical units: as long as the same patient contains data with attribute values ​​of true or 1, the attribute index of the patient is marked as 1; the cumulative value of the attribute index of all patients is the statistical result of the index;

[0025] S305, Boolean data or index statistics with attribute values ​​of 1 / 0 using date as statistical unit: as long as the same date contains data with attribute values ​​of true or 1, the attribute index of the date is marked as 1; the cumulative value of the attribute index of all patients is the statistical result of the index;

[0026] S306. Boolean data or index statistics with attribute values ​​of 1 / 0 using patients and dates as statistical units: if the same patient and the same date contain data with attribute values ​​of true or 1, the attribute index of the patient and date is marked as 1; the cumulative value of the attribute index of all patients and dates is the statistical result of the index;

[0027] S307, the index statistics of the attribute with the amount as the statistical unit and the attribute type as Boolean or the attribute value as 1 / 0: the amount of all the medical orders for each drug is accumulated, and the accumulated amount of the medical orders of these drugs is marked according to the attribute value of each local extension code, and the accumulated value of the amount marked with the same attribute is used as the statistical result of this index;

[0028] S308. Statistics of indicators whose attribute values ​​are not Boolean or 1 / 0: the cumulative value of the multiplication of the usage of each drug and the attribute value is used as the statistical result of the indicator; or the cumulative value of the usage of each drug and the attribute value are multiplied as the statistical result of the indicator.

[0029] Furthermore, it also includes: when department indicators or personnel indicators of various indicators need to be counted, adding filtering items by department or by person as statistical conditions.

[0030] Furthermore, it also includes: when it is necessary to calculate the per capita indicators of various indicators, the cumulative value of each indicator is divided by the total number of patients for calculation;

[0031] When the average index for each day or a certain period of time needs to be counted, the cumulative value of each index is divided by the total number of days in the statistical period or the specified time length for calculation;

[0032] When it is necessary to calculate the percentage of an indicator, the cumulative value of each statistical indicator is divided by the total value of the statistical item for calculation.

[0033] Furthermore, the system program of the medication index statistical information system is implemented by a programming language such as Fox, Foxpro, Pacical, C language, C++, Delphi, .Net, JAVA, Phython or WebService combined with XML.

[0034] Furthermore, the programs or databases involved in the medication index statistical information system use a U disk or hard disk to copy data and decompress it for installation for users, or are directly installed for users by users activating a remote installation program; the database is upgraded by copying the upgrade package with a U disk or hard disk and decompressing and upgrading it within the user, or it is upgraded for users remotely by users; the programs run by users of the medication index statistical information system are independent applications or are mounted in the user's HIS system, pharmacy management system, rational medication management system or OA system for operation.

[0035] The core of the technical solution of the present invention is to add basic data of drug statistical attributes to the drug-based extended code table to form a drug statistical attribute knowledge base. At the application end, as long as the user's drug corresponds to the drug-based extended code, the attribute data in the drug statistical attribute knowledge base can be used to perform statistics on various indicators of the medical order.

[0036] In summary, the present invention has the following beneficial effects:

[0037] 1. Through the method of the present invention, the statistical attributes set by the drug statistical attribute knowledge base can avoid users from maintaining various statistical attributes for each drug, thus saving the workload of users;

[0038] 2. Through the method of the present invention, each user uses a unified statistical attribute knowledge base, which can avoid the difference in maintenance of the same attribute of the same drug by different users, thereby avoiding errors in statistical data, and the statistical results between different users are comparable;

[0039] 3. By using the method of the present invention, when maintaining a drug statistical attribute knowledge base, according to different basic data associated with different attributes, the product name associated attributes, preparation specification associated attributes, packaging specification associated attributes, and manufacturer associated attributes are maintained respectively. According to the product name, preparation specification, packaging specification, prescription specification, manufacturer, etc. associated with the drug-based extension code, all attribute values ​​are further associated with the drug-based extension code attribute data table. On the one hand, the workload of knowledge base maintenance can be reduced. On the other hand, the newly added drug-based extension code data is directly maintained in the new data through the attribute value of the associated data, avoiding omissions caused by untimely maintenance of the local extension code attributes.

[0040] 4. Through the method of the present invention, in the design of statistical software, according to different field types of different attributes or limited ranges of attribute values, two methods of adding attribute values ​​in medical orders and adding attribute values ​​in the total amount of medical orders can be used to calculate statistical results. According to different indicator types, multiple unified controls can be designed during design to reduce the amount of program design. At the same time, different indicators can adopt different methods to take into account the speed of data statistics. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Figure 1 is a flow chart of maintaining a knowledge base of statistical attributes of local extension codes in an embodiment of the present invention;

[0042] Figure 2 is one of the user statistical index calculation formulas in the embodiment of the present invention;

[0043] Figure 3 This is the second user statistical index calculation formula in the embodiment of the present invention. DETAILED DESCRIPTION

[0044] In order to make the purpose, technical scheme and advantages of the present invention clearer, the present invention is further described in detail below in conjunction with the embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention. The name of the present invention and the drug name in the embodiments refer to the product name of the drug, that is, the identification of the drug name used in drug management, circulation, and use. In some cases, it is also called the generic name of the drug. This difference in name does not limit the present invention. The drug specifications in the embodiments are sometimes called packaging specifications, product specifications, etc., and the present invention separates them into preparation specifications, which are sometimes called minimum specifications. The differences in these specification names do not limit the present invention.

[0045] The present invention provides an information processing method for a drug use index statistical system based on a drug-based extended code, comprising the following steps:

[0046] S1. Maintain each statistical attribute data for each drug-based extension code in the background to form a drug statistical attribute knowledge base (such as Figure 1 shown);

[0047] S101. Attribute data directly related to the drug product name is directly maintained in the product name attribute data table, and attribute data in the drug-based extension code is directly obtained from the product name attribute data table;

[0048] S102. Attribute data directly related to drug preparation specifications are directly maintained in the preparation specification attribute data table, and attribute data in the drug-based extension code is directly obtained from the preparation specification attribute data table;

[0049] S103. Attribute data directly related to drug packaging specifications are directly maintained in the packaging specification attribute data table, and attribute data in the drug-based extension code is directly obtained from the packaging specification attribute data table;

[0050] S104. Attribute data directly related to drug prescription specifications are directly maintained in the prescription specification attribute data table, and attribute data in the drug-based extension code is directly obtained from the prescription specification attribute data table;

[0051] S105. The attribute data directly related to the drug manufacturer is directly maintained in the manufacturer attribute data table, and the attribute data in the drug-based extension code is directly obtained from the manufacturer attribute data table.

[0052] S2. The application end matches each type of medical prescription drug with the drug base extension code. The matching method includes: automatically or manually matching the drug medical prescription with one or more data combinations of drug approval number, product name, drug base code, drug specification, and manufacturer data, and matching the drug medical prescription data after matching once, and the same drug medical prescription data does not need to be matched again;

[0053] S3. Install the drug statistical attribute knowledge base in the application database, use the drug statistical attribute knowledge base to mark each attribute of each medical order, multiply the attribute marking data by the medical order quantity and add up the same attributes of all medical orders to obtain the indicator statistical results (such as Figure 2 and Figure 3 shown).

[0054] S301, adding various statistical information fields to the medical order data table, and marking the values ​​of the statistical information fields in the medical order with the attribute data corresponding to the drug-based extension code;

[0055] S302. When performing indicator statistics, the number of medical orders of the specified medical order data is multiplied by the medical order attribute value to obtain a statistical indicator of a medical order, and the statistical indicator values ​​of all medical orders are accumulated to obtain the attribute statistical indicators of all medical orders.

[0056] S303, statistics of the number of medical orders of a certain attribute: the number of medical orders for each drug is accumulated to obtain the statistical results of the indicators whose attributes corresponding to the Boolean data in the attribute value of the local extended code are true; wherein, the attribute statistical indicators whose attribute values ​​are 1 / 0 are also counted by the above method;

[0057] S304, Boolean data or index statistics with attribute values ​​of 1 / 0 using patients as statistical units: as long as the same patient contains data with attribute values ​​of true or 1, the attribute index of the patient is marked as 1; the cumulative value of the attribute index of all patients is the statistical result of the index;

[0058] S305, Boolean data or index statistics with attribute values ​​of 1 / 0 using date as statistical unit: as long as the same date contains data with attribute values ​​of true or 1, the attribute index of the date is marked as 1; the cumulative value of the attribute index of all patients is the statistical result of the index;

[0059] S306. Boolean data or index statistics with attribute values ​​of 1 / 0 using patients and dates as statistical units: if the same patient and the same date contain data with attribute values ​​of true or 1, the attribute index of the patient and date is marked as 1; the cumulative value of the attribute index of all patients and dates is the statistical result of the index;

[0060] S307, the index statistics of the attribute with the amount as the statistical unit and the attribute type as Boolean or the attribute value as 1 / 0: the amount of all the medical orders for each drug is accumulated, and the accumulated amount of the medical orders of these drugs is marked according to the attribute value of each local extension code, and the accumulated value of the amount marked with the same attribute is used as the statistical result of this index;

[0061] S308. Statistics of indicators whose attribute values ​​are not Boolean or 1 / 0: the cumulative value of the multiplication of the usage of each drug and the attribute value is used as the statistical result of the indicator; or the cumulative value of the usage of each drug and the attribute value are multiplied as the statistical result of the indicator.

[0062] When it is necessary to count departmental indicators or personnel indicators of various indicators, the above statistical conditions need to add filtering items by department or by person.

[0063] When it is necessary to calculate the per capita indicators of various indicators, the cumulative value of each indicator needs to be divided by the total number of patients for calculation; when it is necessary to calculate the average indicators for each day or a certain period of time, the cumulative value of each indicator needs to be divided by the total number of days in the statistical time or the specified length of time for calculation; when it is necessary to calculate the percentage of the indicator, the cumulative value of each statistical indicator needs to be divided by the total value of the statistical item for calculation.

[0064] Example 1: Background each drug local extension code maintains statistical attribute example:

[0065] 1. Establish the drug-based extended code attribute table

[0066] The fields of the drug-based extended code attribute table include at least the base extended code, product name, product name code, preparation specification, preparation specification code, packaging specification, packaging specification code, prescription specification, prescription specification code, company name, approval number, various attributes and other fields.

[0067] 2. Product name associated attribute maintenance example

[0068] Create a "product name associated attribute data table" with fields including at least product name code, product name, and various attributes. The data in the product name field includes all product names that have ever been on the market.

[0069] The attributes associated with the product names include: toxicity, anesthesia, essence 1, essence 2, radiation, termination of pregnancy, antibiotics, antibiotic grade, stimulants, carbapenems, tigecycline, vancomycin and norvancomycin, anti-tumor, anti-cold, contrast agents, systemic hormones, Chinese herbal medicines, injections, proton pump inhibitors, enteral nutrition and parenteral nutrition, vitamins and trace elements, and national key monitoring, etc.

[0070] According to the authoritative data of various attributes, the attribute value of each drug is maintained as true / false (false can be empty), or the allowed value is set as 1 / 0 according to the field attribute, where the attribute is true when the value is 1 (0 can be empty).

[0071] By associating the product name or product name code in the "local extension code attribute data table" with the "product name associated attribute data table", the corresponding attribute data in the "local extension code attribute data table" automatically obtains the corresponding attribute value.

[0072] 3. Example of maintaining attributes associated with preparation specifications

[0073] Establish a "preparation specification associated attribute data table" with fields including at least preparation specification code, product name, preparation specification, and various attributes. The data in the preparation specification field includes all product names and preparation specifications that have ever been on the market.

[0074] Attributes associated with drug product specifications include: solvent, large infusion, high warning, dosage unit DDD, etc.

[0075] According to the authoritative information of various attributes, the attribute value of each drug preparation specification is maintained as a specific value, such as the dosage unit DDD; or the attribute value of the drug preparation specification is maintained as true / false (false can be empty), or the allowed value is set to 1 / 0 according to the field attribute, where the attribute is true when the value is 1 (0 can be empty).

[0076] By associating the preparation specification code in the "original extension code attribute data table" with the "preparation specification associated attribute data table", the corresponding attribute data in the "original extension code attribute data table" automatically obtains the corresponding attribute value.

[0077] 4. Example of maintaining prescription specification related attributes

[0078] Establish a "prescription specification associated attribute data table" with fields including at least prescription specification code, product name, prescription specification, and various attributes. The data in the prescription specification field includes all product names and prescription specifications that have ever been on the market.

[0079] Attributes associated with prescription strengths include: fluid volume, sodium content, potassium content, calcium content, magnesium content, calories, non-egg calories, etc.

[0080] According to the authoritative data of various attributes, the attribute value of each drug prescription specification is maintained as a specific value; or maintained as true / false (false can be empty), or the allowed value is set to 1 / 0 according to the field attribute, where the attribute is true when the value is 1 (0 can be empty).

[0081] By associating the prescription specification code in the "original extension code attribute data table" with the "prescription specification associated attribute data table", the corresponding attribute data in the "original extension code attribute data table" automatically obtains the corresponding attribute value.

[0082] 5. Example of maintaining packaging specification related attributes

[0083] Establish a "packaging specification associated attribute data table" with fields including at least packaging specification code, product name, packaging specification, and various attributes. The data in the packaging specification field includes all product names and packaging specifications that have ever been on the market.

[0084] Attributes associated with packaging specifications include: basic drugs, national negotiated drugs, medical insurance, over-the-counter drugs, etc.

[0085] According to the authoritative data of various attributes, the attribute value of each drug packaging specification is maintained as true / false (false can be empty), or the allowed value is set as 1 / 0 according to the field attribute, where the attribute is true when the value is 1 (0 can be empty).

[0086] By associating the packaging specification code in the "original extension code attribute data table" with the "packaging specification associated attribute data table", the corresponding attribute data in the "original extension code attribute data table" automatically obtains the corresponding attribute value.

[0087] 6. Example of maintaining enterprise name related attributes

[0088] Establish a "corporate name associated attribute data table" with at least the corporate name and various attributes. The data in the corporate name field includes all the corporate names that have ever been listed.

[0089] Attributes associated with company names include: domestic, imported, joint venture, state-owned enterprise, central enterprise, listed, etc.

[0090] According to the authoritative data of various attributes, the attribute value of the enterprise name is maintained as true / false (false can be empty), or the allowed value is set as 1 / 0 according to the field attribute, where the attribute is true when the value is 1 (0 can be empty).

[0091] By associating the enterprise name in the "local extension code attribute data table" with the "enterprise name associated attribute data table", the corresponding attribute data in the local extension code attribute data table automatically obtains the corresponding attribute value.

[0092] 7. Maintenance example of approval document number associated attributes

[0093] Establish an "approval document number associated attribute data table" with at least approval document number and various attributes. The data in the approval document number field includes all approval document numbers that have ever been put on the market.

[0094] Attributes associated with approval numbers include: traditional Chinese medicine, chemical drugs, biological products, etc.

[0095] According to the approval number authorization rules, approval numbers containing H are chemical drugs, approval numbers containing S are biological products, and approval numbers containing Z are traditional Chinese medicines. The cases that do not contain the above letters need to be maintained according to the specific situation, and the attribute value of the approval number is maintained as true / false (false can be empty), or the allowed value is set to 1 / 0 according to the field attribute, where the attribute is true when the value is 1 (0 can be empty).

[0096] By associating the approval document number in the "local extension code attribute data table" with the "approval document number associated attribute data table", the corresponding attribute data in the local extension code attribute data table automatically obtains the corresponding attribute value.

[0097] 8. Attribute data maintenance example specific to the attribute data table of this extension code:

[0098] The proprietary attribute data of the "Binary Extension Code Attribute Data Table" includes: national centralized procurement drugs, etc.

[0099] The "local extension code attribute data table" is copied to the user server.

[0100] Example 2: Hospital drug use index statistics example 1 (such as Figure 2 shown):

[0101] All hospital drugs correspond to drug-based extension codes: one or more data combinations such as drug approval number, product name, drug-based code, drug specifications, and manufacturer are matched with drug orders automatically or manually on the interface. After matching once, the same drug order data does not need to be matched again. Hospital drug correspondence refers to the correspondence between the unique code of hospital drugs and the drug-based extension code.

[0102] This embodiment adopts the method of assigning values ​​to the attributes of medical orders and performing statistics on a daily or real-time basis.

[0103] When assigning values ​​to the attributes of medical orders every day, it is agreed that at a fixed time every day (generally at night when the server is relatively idle), all the data on the execution of medical orders in the hospital on that day will be imported into the medication indicator statistical information system through the interface to generate a medical order table (including the drug-based extension code).

[0104] After the import is completed, according to the drug base code in the medical order table, the program adds data to the attributes of each medical order data one by one from the "base extended code attribute data table".

[0105] Statistics are generally collected for indicators within a period of time. Depending on the attribute field type and statistical content, there are the following statistical methods:

[0106] 1. The field type is Boolean data or the attribute value is limited to 1 / 0 (taking the case where the attribute value is 1 / 0 as an example)

[0107] (1) Calculation of single attribute using total amount

[0108] Filter all medical order table data within the statistical time period and with an indicator attribute value of 1, and add up the amount of each medical order to obtain the total amount used for a single attribute.

[0109] For example, the total amount of narcotic drugs used during the statistical period, filter all medical order data with the statistical time period and anesthesia attribute = 1, and the total amount in the filtered data is the total amount of narcotic drugs used during the statistical period.

[0110] (2) Calculation of amount using multiple attributes

[0111] Filter all medical order table data in the statistical time period and with multiple statistical indicator attribute values ​​= 1, and add up the amount of each medical order to obtain the total amount used for a single attribute.

[0112] For example, the total amount of antibiotic injections used during the statistical period, filter all medical order data with the statistical time period, antibiotic attribute = 1, and injection attribute = 1, and the total amount in the filtered data is the total amount of antibiotic injections used during the statistical period.

[0113] (3) Statistics on the usage rate of a certain attribute

[0114] A. When the denominator of the utilization rate is the number of medical orders,

[0115] The usage rate of a certain attribute = ∑ attribute value / ∑ number of medical orders.

[0116] B. When the denominator of the utilization rate is prescription

[0117] Create a prescription number attribute table with prescription number as the unique value, and add all prescription numbers in the medical order to the table. In the medical order table, for each prescription number, as long as there is one medical order data with an attribute value of 1, the attribute value corresponding to the prescription number is 1. When the attribute values ​​of all medical order data in the prescription are 0, the attribute value corresponding to the prescription number is 0.

[0118] The usage rate of a certain attribute = ∑ attribute value / ∑ number of prescription numbers.

[0119] C. When the denominator of the utilization rate is the number of patients

[0120] Create a patient ID number attribute table with the patient ID number as the unique value, and add all patient ID numbers in the medical order to the table. In the medical order table, for each patient ID number, as long as there is one medical order data with an attribute value of 1, the attribute value corresponding to the patient ID number is 1. When the attribute values ​​of all medical order data in the patient ID are 0, the attribute value corresponding to the patient ID number is 0.

[0121] Attribute usage rate = ∑ attribute value / ∑ number of patient ID numbers

[0122] 2. Statistical indicators whose attribute values ​​are not Boolean and whose attribute values ​​are not 1 / 0

[0123] Statistical indicators whose attribute values ​​are not Boolean and are not 1 / 0 are generally related to the dosage of the drug; the cumulative value of multiplying the dosage of each drug by the attribute value is the statistical result of the indicator.

[0124] The following is an introduction based on the statistics of antimicrobial drugs DDDs (combined attributes):

[0125] Filter all the medical order table data in the statistical time period, where the attribute value of the antimicrobial drug is 1;

[0126] Antimicrobial drug DDDs = ∑ [amount per doctor's order (in dosage units) × dosage unit DDD].

[0127] 3. Add other conditions to the indicator statistics

[0128] The following is an example of the intensity of antibiotic use:

[0129] Intensity of antibiotic use = (∑antimicrobial drugs DDDs / ∑patient hospitalization days) × 100;

[0130] Among them, the DDDs of antimicrobial drugs are calculated according to the method in the previous example.

[0131] 4. Statistics of department indicators, department indicators or doctor indicators

[0132] Create a corresponding attribute table with department, division or doctor as the unique value, add all departments or departments or doctors in the medical order to the table, and add the corresponding statistical results to the data of each department or department or doctor in the above-mentioned medical order screening conditions.

[0133] Example 3: Hospital drug use index statistics example 2 (such as Figure 3 shown):

[0134] All hospital drugs correspond to drug-based extension codes: one or more data combinations such as drug approval number, product name, drug-based code, drug specifications, and manufacturer are matched with drug orders automatically or manually on the interface. After matching once, the same drug order data does not need to be matched again. Hospital drug correspondence refers to the correspondence between the unique code of hospital drugs and the drug-based extension code.

[0135] This embodiment adopts a method of first calculating the total number, total dosage, and total amount of each medical order within the statistical time period, and then calculating the index value.

[0136] Create a summary table of medical orders based on the unique code of each drug in the medical order table, and add the total number of medical orders, total dosage, and total amount of each drug in the medical order table to the medical order summary table. Add each attribute value in the "local extended code attribute data table" to the medical order summary table.

[0137] 1. The field type is Boolean data or the attribute value is limited to 1 / 0 (taking the case where the attribute value is 1 / 0 as an example)

[0138] (1) Calculation of single attribute using total amount

[0139] The indicator attribute value = 1 in the medical order summary table is filtered, and the total amount in the filtered data is the total amount of the corresponding indicator in the statistical period.

[0140] (2) Calculation of amount using multiple attributes

[0141] For all medical order table data in the medical order summary table where multiple statistical indicator attribute values ​​= 1, the total amount used for a single attribute can be obtained by adding up the amount of each medical order.

[0142] (3) When the denominator of the utilization rate is the number of medical orders, the statistical summary of the utilization rate of a certain attribute is used to calculate the total number of medical orders, and the indicator attribute value = 1 in the medical order summary table is filtered out. The utilization rate of a certain attribute = ∑ (the total number of medical orders with attribute value = 1) / ∑ the total number of medical orders.

[0143] 2. Statistical indicators whose attribute values ​​are not Boolean or 1 / 0

[0144] The following is an introduction based on the statistics of antimicrobial drugs DDDs (combined attributes):

[0145] Filter the data with antimicrobial drug attribute value = 1 in the doctor's order summary table

[0146] Antimicrobial drug DDDs = ∑ [total dosage prescribed by doctor (in dosage units) × dosage unit DDD].

[0147] The various statistical methods in the above-mentioned embodiments of the present invention can also be used for statistical examples of medication indicators using hospital medical order data obtained by government administrative supervision and management departments.

[0148] This specific embodiment is merely an explanation of the present invention and is not a limitation of the present invention. After reading this specification, those skilled in the art may make non-creative modifications to the present embodiment as needed. However, as long as they are within the scope of the claims of the present invention, they are protected by the patent law.

Claims

1. A method for processing a drug use index statistical information system, characterized by: The following steps are involved: S1. In the background of the drug use index statistical information system, each statistical attribute data is uniformly maintained for each drug-based extension code to form a drug statistical attribute knowledge base; When maintaining each statistical attribute data for each drug-based extension code in step S1, the specific method is as follows: S101. Attribute data directly related to the drug product name is directly maintained in the product name attribute data table, and attribute data in the drug-based extension code is directly obtained from the product name attribute data table; S102. Attribute data directly related to drug preparation specifications are directly maintained in the preparation specification attribute data table, and attribute data in the drug-based extension code is directly obtained from the preparation specification attribute data table; S103. Attribute data directly related to drug packaging specifications are directly maintained in the packaging specification attribute data table, and attribute data in the drug-based extension code is directly obtained from the packaging specification attribute data table; S104. Attribute data directly related to drug prescription specifications are directly maintained in the prescription specification attribute data table, and attribute data in the drug-based extension code is directly obtained from the prescription specification attribute data table; S105. The attribute data directly related to the drug manufacturer is directly maintained in the manufacturer attribute data table, and the attribute data in the drug-based extension code is directly obtained from the manufacturer attribute data table; S2. At the application end of the medication index statistical information system, each prescribed drug is matched with a drug-based extended code; The specific method of matching each prescribed drug with the drug-based extension code in step S2 is: The drug order data is matched automatically or manually through the interface through one or more data combinations of drug approval number, product name, drug base code, drug specification, and manufacturer data, and the same drug order data does not need to be matched again after matching once; S3, installing the drug statistical attribute knowledge base in the application-side database of the drug use index statistical information system, and using the drug statistical attribute knowledge base to mark each attribute of each medical order to obtain attribute marking data, and then multiplying the attribute marking data by the medical order quantity, and summing up the same attributes of all medical orders to obtain the index statistical results; The method for marking each attribute of each medical advice in step S3 is: S301, adding various statistical information fields to the medical order data table, and marking the values ​​of the statistical information fields in the medical order with the attribute data corresponding to the drug-based extension code; S302. When performing indicator statistics, the number of medical orders of the specified medical order data is multiplied by the medical order attribute value to obtain a statistical indicator of a medical order, and the statistical indicator values ​​of all medical orders are accumulated to obtain the attribute statistical indicators of all medical orders.

2. The method for processing a drug use index statistical information system according to claim 1, characterized in that: The indicator statistics in step S3 also include the following methods: S303, statistics of the number of medical orders of a certain attribute: the number of medical orders for each drug is accumulated to obtain the statistical results of the indicators whose attributes corresponding to the Boolean data in the attribute value of the local extension code are true; wherein, the attribute statistical indicators whose attribute values ​​are 1 / 0 are also counted by the above method; S304, Boolean data or index statistics with attribute values ​​of 1 / 0 using patients as statistical units: as long as the same patient contains data with attribute values ​​of true or 1, the attribute index of the patient is marked as 1; the cumulative value of the attribute index of all patients is the statistical result of the index; S305, Boolean data or index statistics with attribute values ​​of 1 / 0 using date as statistical unit: as long as the same date contains data with attribute values ​​of true or 1, the attribute index of the date is marked as 1; the cumulative value of the attribute index of all patients is the statistical result of the index; S306. Boolean data or index statistics with attribute values ​​of 1 / 0 using patients and dates as statistical units: if the same patient and the same date contain data with attribute values ​​of true or 1, the attribute index of the patient and date is marked as 1; the cumulative value of the attribute index of all patients and dates is the statistical result of the index; S307, the index statistics of the attribute with the amount as the statistical unit and the attribute type as Boolean or the attribute value as 1 / 0: the amount of all the medical orders for each drug is accumulated, and the accumulated amount of the medical orders of these drugs is marked according to the attribute value of each local extension code, and the accumulated value of the amount marked with the same attribute is used as the statistical result of this index; S308. Statistics of indicators whose attribute values ​​are not Boolean or 1 / 0: the cumulative value of the multiplication of the usage of each drug and the attribute value is used as the statistical result of the indicator; or the cumulative value of the usage of each drug and the attribute value are multiplied as the statistical result of the indicator.

3. A method for processing a drug use index statistical information system according to any one of claims 1 to 2, characterized in that: Also includes: When department indicators or personnel indicators of various indicators need to be counted, add filter items by department or by person as statistical conditions.

4. A method for processing a drug use index statistical information system according to any one of claims 1 to 2, characterized in that: Also includes: When the per capita indicators of various indicators need to be counted, the cumulative value of each indicator is divided by the total number of patients for calculation; When the average index for each day or a certain period of time needs to be counted, the cumulative value of each index is divided by the total number of days in the statistical period or the specified time length for calculation; When it is necessary to calculate the percentage of an indicator, the cumulative value of each statistical indicator is divided by the total value of the statistical item for calculation.

5. A method for processing a drug use index statistical information system according to any one of claims 1 to 2, characterized in that: The system program of the drug use index statistical information system is composed of Fox, Foxpro, Pacific, C language, C++, Delphi, Net, JAVA, Phython programming language or WebService Incorporating XML accomplish.

6. The method for processing a drug use index statistical information system according to claim 5, characterized in that: The programs or databases involved in the medication index statistical information system use a U disk or hard disk to copy data and decompress it for installation for users, or the users activate a remote installation program to directly install the programs for users; the database is upgraded by copying the upgrade package to a U disk or hard disk and decompressing and upgrading it within the user, or the user activates a remote upgrade for the user; the programs run by users of the medication index statistical information system are independent applications or are mounted on the user's HIS system, pharmacy management system, rational medication management system or OA system for operation.

Images