CN111145882B - Medical consumable dynamic supervision method and system based on multi-dimensional continuous drilling - Google Patents
Medical consumable dynamic supervision method and system based on multi-dimensional continuous drilling Download PDFInfo
- Publication number
- CN111145882B CN111145882B CN201911133444.1A CN201911133444A CN111145882B CN 111145882 B CN111145882 B CN 111145882B CN 201911133444 A CN201911133444 A CN 201911133444A CN 111145882 B CN111145882 B CN 111145882B
- Authority
- CN
- China
- Prior art keywords
- data
- time
- consumables
- medical
- real
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H40/00—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices
- G16H40/20—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- General Business, Economics & Management (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Biomedical Technology (AREA)
- Epidemiology (AREA)
- General Health & Medical Sciences (AREA)
- Medical Informatics (AREA)
- Primary Health Care (AREA)
- Public Health (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The invention provides a medical consumable dynamic supervision method and system based on multi-dimensional continuous drilling, belonging to the field of medical consumable supervision, wherein the method comprises the following steps: s10, configuring a standardized interface; s20, configuring a hierarchical collection mode of medical consumable data; s30, configuring a time collection mode of medical consumable data; s40, configuring a display mode of medical consumable data; s50, configuring query conditions of medical consumable data; s60, configuring a multi-dimensional continuous drilling mode of medical consumable data; s70, supervising the medical consumables according to the standardized interface, the level collection mode, the time collection mode, the display mode, the query condition and the multi-dimensional continuous drilling mode; the steps S10 to S60 are not in sequence. The invention has the advantages that: the medical consumables are subjected to multidimensional and dynamic supervision, and transparency, accuracy and integrity of supervision of the medical consumables are greatly improved.
Description
Technical Field
The invention relates to the field of medical consumable material supervision, in particular to a medical consumable material dynamic supervision method and system based on multi-dimensional continuous drilling.
Background
Medical consumables are accessory products which are frequently consumed and used in hospitals, safety and danger of patients are concerned, if medical consumables are not monitored in place, the medical consumables can not be supplied to the patients in time when the medical consumables are needed to be used by the patients or unqualified and unqualified medical consumables can be used by the patients, and illness states of the patients can be aggravated undoubtedly.
Since 2009, various medical improvement policies have been continuously issued, most of them require strict supervision on medical consumables of medical institutions.
However, traditionally, the supervision of medical consumables is only to perform single-dimensional supervision according to policy requirements, for example, to adapt to a 'double ten' system, only the usage index of high-value consumables is supervised, only the high-value consumable part rule and the medical staff who use the top ten of the money rank are supported to be directionally and dimensionally reflected, and the supervision of medical consumables involves circulation links including high-value consumables, ordinary consumables and low-value consumables, such as purchase plan, application, use and real-time inventory, so that the supervision of medical consumables is not in place, and many blind areas exist, and multidimensional and dynamic supervision cannot be performed.
Therefore, how to provide a dynamic supervision method for medical consumables based on multi-dimensional continuous drilling to realize multi-dimensional and dynamic supervision of medical consumables, and further improve the transparency, accuracy and integrity of supervision of medical consumables becomes a problem to be solved urgently.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a medical consumable dynamic supervision method and system based on multi-dimensional continuous drilling, so that multi-dimensional and dynamic supervision of medical consumables is realized, and further the transparency, accuracy and integrity of supervision of the medical consumables are improved.
In a first aspect, the invention provides a medical consumable dynamic monitoring method based on multi-dimensional continuous drilling, comprising the following steps:
step S10, configuring a standardized interface of the usage amount, the claiming amount, the planning amount and the real-time inventory amount of the medical consumables;
s20, configuring a hierarchical collection mode of medical consumable data;
s30, configuring a time collection mode of medical consumable data;
s40, configuring a display mode of medical consumable data;
s50, configuring query conditions of medical consumable data;
s60, configuring a multi-dimensional continuous drilling mode of medical consumable data;
s70, supervising the medical consumables according to the standardized interface, the level collection mode, the time collection mode, the display mode, the query condition and the multi-dimensional continuous drilling mode;
the steps S10 to S60 are not in sequence.
Further, the step S10 specifically includes:
configuring a standardized interface of the usage amount, the claim amount, the plan amount and the real-time inventory amount of the medical consumables, and obtaining the usage amount data, the claim amount data, the plan amount data and the real-time inventory amount data of the medical consumables through view interaction or SQL sentences;
in the usage data, high-value consumables are obtained by reading real-time data of a high-value consumable material core sales delivery list and an inventory delivery list of a secondary warehouse department of the logistics system; the common charging consumables are obtained by reading general consumption, charge verification and delivery bill real-time data and checking delivery bills of departments of a secondary warehouse of the logistics system; non-charging common consumables are obtained by reading general consumables, checking and selling out lists of departments of a secondary library of the logistics system; the low-value consumables are delivered to a delivery list, a transfer delivery list, a department low-value product withdrawal list and a low-value product in-use and in-store scrap list of departments through a primary warehouse of the reading logistics system;
in the application quantity data, high-value consumables are obtained by reading real-time data of application sheets of a secondary library department of the logistics system; acquiring general consumables by reading the real-time data of the general consumables of the logistics system department application form; low-value consumables are obtained by reading real-time low-value consumable claim data of a logistics system department claim form;
in the planned quantity data, high-value consumables are obtained by reading real-time data of a plan list of a secondary library department of a logistics system; the common consumables are obtained by reading real-time data of the plan of the common consumables of the department plan list of the logistics system; the low-value consumables are obtained by reading real-time data of a low-value item plan of a department plan sheet of the logistics system;
in the real-time inventory data, high-value consumable items are obtained by reading high-value real-time inventory data of a first-level warehouse and high-value real-time inventory data of a second-level warehouse of the logistics system; the common consumables are obtained by reading general consumption real-time inventory data of a first-level library and general consumption real-time inventory data of departments of a second-level library of the logistics system; the low-value consumables are obtained by reading low-value real-time inventory data and low-value management department inventory list data of a high-level library of the logistics system.
Further, the step S20 specifically includes: the hierarchical collection mode for configuring the medical consumable data at least comprises a whole hospital, types of departments, types of same departments to specific departments, medical groups of the same departments and specific medical groups; the attributes used for distinguishing the hierarchical relationship at least comprise departments, department types and medical groups; the department types at least comprise clinic, medical technology, medical assistance and administrative logistics;
the step S30 specifically includes: the time collection mode for configuring the medical consumable data at least comprises year, semiyear, quarter, month, week and day.
Further, the step S40 specifically includes:
the display mode for configuring the medical consumable data comprises an upper interface, a middle interface and a lower interface;
the upper interface is used for displaying query conditions; the middle interface is used for displaying a double-axis coordinate graph of the query result, the left longitudinal axis of the double-axis coordinate graph counts the quantity, the right longitudinal axis of the double-axis coordinate graph counts the amount, and the horizontal axis is displayed according to the selected counting time span; and the lower interface is used for displaying the medical consumable bill table information corresponding to the query result.
Further, the step S50 specifically includes:
configuring query conditions of medical consumable data, including usage amount, claimed amount, planned amount and query conditions of real-time inventory;
the query conditions of the usage amount at least comprise an article name, specification, model, main bar code, article classification, department, supplier, main doctor, counting start time, counting end time and counting time span;
the query conditions of the claim quantity at least comprise the name, specification, model, main bar code, whether to charge, article classification, department, supplier, statistical start time, statistical end time and statistical time span;
the query conditions of the planned quantity at least comprise article names, specifications, models, main bar codes, article classification, whether to pre-store in a warehouse or not, whether to charge, departments, suppliers, counting start time, counting end time and counting time span;
the query conditions of the real-time inventory at least comprise article names, specifications, models, main bar codes, whether to charge, article classification, whether to contain pre-warehousing, departments and suppliers;
the step S60 specifically includes: the multi-dimensional continuous drilling mode for configuring medical consumable data comprises the following steps: selecting an analysis data point to perform right mouse click on a drilling query condition on the basis of a data condition query result, drilling analysis and displaying an analysis result; and after the drilling query conditions selected at the previous time are eliminated, selecting analysis data points to perform right mouse button drilling analysis and displaying an analysis result, namely multidimensional continuous data drilling analysis.
In a second aspect, the invention provides a medical consumable dynamic monitoring system based on multi-dimensional continuous drilling, which comprises the following modules:
standardized interface configuration module: a standardized interface for configuring the usage amount, the application amount, the plan amount and the real-time inventory amount of the medical consumables;
a hierarchical collection mode configuration module: a hierarchical collection mode for configuring medical consumable data;
a time collection mode configuration module: a time collection mode for configuring medical consumable data;
a display mode configuration module: the display mode is used for configuring medical consumable data;
the query condition configuration module: query conditions for configuring medical consumable data;
a drilling mode configuration module: a multi-dimensional continuous drilling mode for configuring medical consumable data;
a supervision module: and the system is used for supervising the medical consumables according to the standardized interface, the level collection mode, the time collection mode, the display mode, the query condition and the multi-dimensional continuous drilling mode.
Further, the standardized interface configuration module specifically includes:
configuring a standardized interface of the usage amount, the claiming amount, the planning amount and the real-time inventory amount of the medical consumables, and acquiring the usage amount data, the claiming amount data, the planning amount data and the real-time inventory amount data of the medical consumables through view interaction or SQL statements;
in the usage data, high-value consumables are obtained by reading real-time data of a high-value consumable material core sales delivery list and an inventory delivery list of a secondary warehouse department of the logistics system; the common charging consumables are obtained by reading general consumption, charge verification and delivery bill real-time data and checking delivery bills of departments of a secondary warehouse of the logistics system; non-charging common consumables are obtained by reading general consumables, inventory, check, sell and delivery lists of departments of a secondary warehouse of the logistics system; the low-value consumables are delivered to a delivery list, a transfer delivery list, a department low-value product withdrawal list and a low-value product in-use and in-store scrap list of departments through a primary warehouse of the reading logistics system;
in the application quantity data, high-value consumables are obtained by reading real-time data of application sheets of a secondary library department of the logistics system; acquiring general consumables by reading the real-time data of the general consumables of the logistics system department application form; the low-value consumables are obtained by reading low-value product application real-time data of a logistics system department application form;
in the planned quantity data, high-value consumables are obtained by reading real-time data of a plan list of a secondary library department of a logistics system; the common consumables are obtained by reading real-time data of the plan of the common consumables of the department plan list of the logistics system; low-value consumables are obtained by reading real-time data of a low-value consumable plan of a logistics system department plan list;
in the real-time inventory data, high-value consumables are obtained by reading high-value real-time inventory data of a first-level warehouse and high-value real-time inventory data of a second-level warehouse of the logistics system; the common consumables are obtained by reading general consumption real-time inventory data of a first-level library and general consumption real-time inventory data of departments of a second-level library of the logistics system; the low-value consumables are obtained by reading low-value real-time inventory data and low-value management department inventory list data of a high-level library of the logistics system.
Further, the hierarchical aggregation mode configuration module specifically includes: the layer-level collection mode for configuring the medical consumable data at least comprises a whole hospital, types of departments, types of same departments, specific departments, groups of medical treatment and specific medical treatment groups of the same departments; the attributes used for distinguishing the hierarchical relationship at least comprise departments, department types and medical groups; the department types at least comprise clinical, medical and technical, medical assistance and administrative logistics;
the time collection mode configuration module specifically comprises: the time collection mode for configuring the medical consumable data at least comprises year, semiyear, quarter, month, week and day.
Further, the display mode configuration module specifically includes:
the display mode for configuring the medical consumable data comprises an upper interface, a middle interface and a lower interface;
the upper interface is used for displaying query conditions; the middle interface is used for displaying a double-axis coordinate graph of the query result, the left longitudinal axis of the double-axis coordinate graph counts the quantity, the right longitudinal axis of the double-axis coordinate graph counts the amount, and the horizontal axis is displayed according to the selected counting time span; and the lower interface is used for displaying the medical consumable bill table information corresponding to the query result.
Further, the query condition configuration module specifically includes:
configuring query conditions of medical consumable data, including query conditions of usage amount, claim amount, plan amount and real-time inventory amount;
the query conditions of the usage amount at least comprise an article name, specification, model, main bar code, article classification, department, supplier, main doctor, counting start time, counting end time and counting time span;
the query conditions of the claim quantity at least comprise the name, specification, model, main bar code, whether to charge, article classification, department, supplier, statistical start time, statistical end time and statistical time span;
the query conditions of the planned amount at least comprise article names, specifications, models, main bar codes, article classification, whether to pre-store in a warehouse or not, whether to charge, departments, suppliers, counting start time, counting end time and counting time span;
the query conditions of the real-time inventory at least comprise article names, specifications, models, main bar codes, whether to charge, article classification, whether to contain pre-warehousing, departments and suppliers;
the drilling mode configuration module specifically comprises: the multi-dimensional continuous drilling mode for configuring medical consumable data comprises the following steps: selecting an analysis data point to perform right mouse click on the analysis data point to drill a query condition on the basis of the data condition query result, drilling and analyzing and displaying the analysis result; and after the drilling query conditions selected at the previous time are eliminated, selecting analysis data points to perform right mouse button drilling analysis and displaying analysis results, namely multidimensional continuous data drilling analysis.
The invention has the advantages that:
medical consumables are supervised by configuring the standardized interface, the level collection mode, the time collection mode, the display mode, the query condition and the multidimensional continuous drilling mode, multidimensional and dynamic supervision on the medical consumables is realized, and the transparency of supervision on the medical consumables is further improved.
The invention realizes the summary and detail data of medical consumables from the collection dimensions of hospital, departments of various types, departments of the same type, specific departments, medical groups in departments and the like, realizes the condition matching display of medical consumable data from the query dimensions of item names, specifications, models, main codes, item classification, departments, suppliers, main doctors, counting start time, counting end time, counting time span and the like, realizes the multi-angle multi-dimensional continuous drilling query of department, departments, high-value consumables in the hospital, common consumables, low-value consumables usage, plan quantity, claim quantity and real-time inventory dynamic supervision graphs, and supports the traceability to check the detail information, thereby being beneficial to analyzing the reasons of fluctuation abnormity, and having the following advantages compared with the prior art:
1. the analysis indexes can meet the requirements of policy supervision and can also cover the requirements of internal control of hospital medical consumable management. 2. The data display mode is rich and dynamic, multiple modes such as graphs and tables are supported under the same theme, and data utilization can be realized in dynamic modes such as hierarchy, time, multidimensional query conditions and multidimensional drilling analysis conditions. 3. The data analysis dimension is rich, if there are N supervision indexes and there are M inquiry dimensions for each supervision index, the analysis dimension of the medical consumable supervision data will have N × M! The utility value of medical consumable supervision data is greatly improved. 4. The system data query and analysis operation is convenient and fast, and can be rapidly mastered in a short time.
Drawings
The invention will be further described with reference to the following examples and figures.
FIG. 1 is a flow chart of the implementation of the dynamic supervision method for medical consumables based on multi-dimensional continuous drilling according to the present invention.
Fig. 2 is a flowchart of a specific application scenario of the present invention.
Detailed Description
Referring to fig. 1 to 2, a preferred embodiment of a medical consumable dynamic supervision method based on multi-dimensional continuous drilling according to the present invention includes the following steps:
step S10, configuring a standardized interface of the usage amount, the claiming amount, the planning amount and the real-time inventory amount of the medical consumables;
s20, configuring a hierarchical collection mode of medical consumable data;
s30, configuring a time collection mode of medical consumable data;
s40, configuring a display mode of medical consumable data;
s50, configuring query conditions of medical consumable data;
s60, configuring a multi-dimensional continuous drilling mode of medical consumable data;
s70, supervising the medical consumables according to the standardized interface, the level collection mode, the time collection mode, the display mode, the query condition and the multi-dimensional continuous drilling mode;
the steps S10 to S60 are not in sequence.
The step S10 specifically includes:
configuring a standardized interface of the usage amount, the claim amount, the plan amount and the real-time inventory amount of the medical consumables, and obtaining the usage amount data, the claim amount data, the plan amount data and the real-time inventory amount data of the medical consumables through view interaction or SQL sentences;
in the usage data, high-value consumables are obtained by reading real-time data of a high-value consumable material check delivery list and an inventory delivery list of a secondary warehouse of the logistics system; the general expenses of charging are obtained by reading the general expenses of the departments of the second-level warehouse of the logistics system, the real-time data of the bill of delivery of the charge and the check bill of delivery of the warehouse; non-charging common consumables are obtained by reading general consumables, checking and selling out lists of departments of a secondary library of the logistics system; the low-value consumables are delivered to a delivery list, a transfer delivery list, a department low-value product withdrawal list and a low-value product in-use and in-store scrap list of departments through a primary warehouse of the reading logistics system;
in the claim quantity data, high-value consumables are obtained by reading real-time data of claim statements of secondary library departments of the logistics system; the common consumables are obtained by reading real-time data of common consumables application of a logistics system department application form; low-value consumables are obtained by reading real-time low-value consumable claim data of a logistics system department claim form;
in the planned quantity data, high-value consumables are obtained by reading real-time data of a plan list of a secondary library department of a logistics system; the common consumables are obtained by reading real-time data of the plan of the common consumables of the department plan list of the logistics system; low-value consumables are obtained by reading real-time data of a low-value consumable plan of a logistics system department plan list;
in the real-time inventory data, high-value consumables are obtained by reading high-value real-time inventory data of a first-level warehouse and high-value real-time inventory data (including pre-warehousing real-time inventory data) of a second-level warehouse of the logistics system; common consumables are obtained by reading common consumption real-time inventory data of a primary library and common consumption real-time inventory data of departments of a secondary library of the logistics system; the low-value consumables are obtained by reading low-value real-time inventory data and low-value management department inventory list data of a high-level library of the logistics system.
The step S20 is specifically: the hierarchical collection mode for configuring the medical consumable data at least comprises a whole hospital, types of departments, types of same departments to specific departments, and medical groups and specific medical groups of the same departments; the attributes used for distinguishing the hierarchical relationship at least comprise departments, department types and medical groups; the department types at least comprise clinical, medical and technical, medical and auxiliary and administrative logistics. The summary and detail data of the medical consumables are displayed in a hierarchical collection mode from a whole hospital, each department type to a specific department, each medical group of the same department, each medical group and the like.
The step S30 specifically includes: the time collection mode for configuring the medical consumable data at least comprises year, semiyear, quarter, month, week and day.
The step S40 is specifically:
the display mode for configuring the medical consumable data comprises an upper interface, a middle interface and a lower interface;
the upper interface is used for displaying query conditions; the middle interface is used for displaying a double-axis coordinate graph of the query result, the left longitudinal axis of the double-axis coordinate graph counts the quantity, the right longitudinal axis of the double-axis coordinate graph counts the amount, the horizontal axis is displayed according to the selected counting time span, and the double-axis coordinate graph is mainly represented by a line graph and a column graph; and the lower interface is used for displaying the medical consumable bill table information corresponding to the query result. Default statistics show monthly data for the last half year of each department.
The step S50 is specifically:
configuring query conditions of medical consumable data, including usage amount, claimed amount, planned amount and query conditions of real-time inventory;
the query conditions of the usage amount at least comprise article names, specifications, models, main bar codes, article classifications, departments, suppliers, main doctors, counting starting time, counting ending time and counting time span;
the query conditions of the claim quantity at least comprise the name, specification, model, main bar code, whether to charge, article classification, department, supplier, counting start time, counting end time and counting time span;
the query conditions of the planned quantity at least comprise article names, specifications, models, main bar codes, article classification, whether to pre-store in a warehouse or not, whether to charge, departments, suppliers, counting start time, counting end time and counting time span;
the query conditions of the real-time inventory at least comprise article names, specifications, models, main codes, whether charging is required, article classification (pull-down dictionary selection), whether pre-warehousing exists, departments and suppliers;
the step S60 specifically includes: the multi-dimensional continuous drilling mode for configuring medical consumable data comprises the following steps: selecting an analysis data point (graph and table) to perform right mouse button selection and drill a query condition on the basis of the data condition query result, drilling and analyzing and displaying the analysis result; and after the drilling query condition selected at the previous time is removed, selecting an analysis data point to perform right-click mouse drilling analysis and displaying an analysis result, namely multidimensional continuous data drilling analysis.
The invention relates to a better embodiment of a medical consumable dynamic supervision system based on multi-dimensional continuous drilling, which comprises the following modules:
a standardized interface configuration module: a standardized interface for configuring the usage amount, the application amount, the plan amount and the real-time inventory amount of the medical consumables;
a hierarchical collection mode configuration module: a hierarchical collection mode for configuring medical consumable data;
a time collection mode configuration module: a time collection mode for configuring medical consumable data;
a display mode configuration module: the display mode is used for configuring medical consumable data;
the query condition configuration module: query conditions for configuring medical consumable data;
a drilling mode configuration module: a multi-dimensional continuous drilling mode for configuring medical consumable data;
a supervision module: and the system is used for supervising the medical consumables according to the standardized interface, the level collection mode, the time collection mode, the display mode, the query condition and the multi-dimensional continuous drilling mode.
The standardized interface configuration module is specifically as follows:
configuring a standardized interface of the usage amount, the claiming amount, the planning amount and the real-time inventory amount of the medical consumables, and acquiring the usage amount data, the claiming amount data, the planning amount data and the real-time inventory amount data of the medical consumables through view interaction or SQL statements;
in the usage data, high-value consumables are obtained by reading real-time data of a high-value consumable material core sales delivery list and an inventory delivery list of a secondary warehouse department of the logistics system; the common charging consumables are obtained by reading general consumption, charge verification and delivery bill real-time data and checking delivery bills of departments of a secondary warehouse of the logistics system; non-charging common consumables are obtained by reading general consumables, inventory, check, sell and delivery lists of departments of a secondary warehouse of the logistics system; the low-value consumables are delivered to a delivery list, a transfer delivery list, a department low-value product withdrawal list and a low-value product in-use and in-store scrap list of departments through a primary warehouse of the reading logistics system;
in the application quantity data, high-value consumables are obtained by reading real-time data of application sheets of a secondary library department of the logistics system; the common consumables are obtained by reading real-time data of common consumables application of a logistics system department application form; the low-value consumables are obtained by reading low-value product application real-time data of a logistics system department application form;
in the plan quantity data, high-value consumables are obtained by reading real-time data of plan lists of secondary-level library departments of the logistics system; the method comprises the steps that common consumables are obtained by reading real-time data of common consumable plans of a logistics system department plan list; low-value consumables are obtained by reading real-time data of a low-value consumable plan of a logistics system department plan list;
in the real-time inventory data, high-value consumables are obtained by reading high-value real-time inventory data of a primary warehouse of the logistics system and high-value real-time inventory data (including pre-warehouse real-time inventory data) of departments of a secondary warehouse; the general consumables are obtained by reading general consumption real-time inventory data of a first-level library and general consumption real-time inventory data of departments of a second-level library of the logistics system; the low-value consumables are obtained by reading low-value real-time inventory data and low-value management department inventory list data of a high-level library of the logistics system.
The hierarchical collection mode configuration module specifically comprises: the hierarchical collection mode for configuring the medical consumable material data at least comprises a whole hospital, types of departments, types of same departments, specific departments, groups of medical treatment and specific medical treatment groups of the same departments; the attributes used for distinguishing the hierarchical relationship at least comprise departments, department types and medical groups; the department types at least comprise clinical, medical and technical, medical and auxiliary and administrative logistics. The summary and detail data of the medical consumables are compared and displayed from the dimensions of hierarchical collection from a hospital, each department type, the same department type to a specific department, each medical group of the same department, the specific medical group and the like in a hierarchical collection mode.
The time collection mode configuration module specifically comprises: the time collection mode for configuring the medical consumable data at least comprises year, semiyear, quarter, month, week and day.
The display mode configuration module specifically comprises:
the display mode for configuring the medical consumable data comprises an upper interface, a middle interface and a lower interface;
the upper interface is used for displaying query conditions; the middle interface is used for displaying a double-axis coordinate graph of the query result, the left longitudinal axis of the double-axis coordinate graph counts the quantity, the right longitudinal axis of the double-axis coordinate graph counts the amount, the horizontal axis is displayed according to the selected counting time span, and the double-axis coordinate graph is mainly represented by a line graph and a column graph; and the lower interface is used for displaying the medical consumable bill table information corresponding to the query result. Default statistics show monthly data for the last half year of each department.
The query condition configuration module specifically comprises:
configuring query conditions of medical consumable data, including query conditions of usage amount, claim amount, plan amount and real-time inventory amount;
the query conditions of the usage amount at least comprise an article name, specification, model, main bar code, article classification, department, supplier, main doctor, counting start time, counting end time and counting time span;
the query conditions of the claim quantity at least comprise the name, specification, model, main bar code, whether to charge, article classification, department, supplier, statistical start time, statistical end time and statistical time span;
the query conditions of the planned amount at least comprise article names, specifications, models, main bar codes, article classification, whether to pre-store in a warehouse or not, whether to charge, departments, suppliers, counting start time, counting end time and counting time span;
the query conditions of the real-time inventory at least comprise article names, specifications, models, main bar codes, whether to charge, article classification (pull-down dictionary selection), whether to contain pre-warehousing, departments and suppliers;
the drilling mode configuration module specifically comprises: the multi-dimensional continuous drilling mode for configuring the medical consumable data comprises the following steps: on the basis of the data condition query result, selecting an analysis data point (a graph and a table) to perform right mouse button selection and drill a query condition, drilling and analyzing and displaying an analysis result; and after the drilling query condition selected last time is eliminated, selecting an analysis data point to perform right-click mouse drilling analysis and displaying an analysis result, namely multidimensional continuous data drilling analysis.
The specific scene of applying the invention comprises the following steps:
1. selecting a supervision analysis angle:
and selecting to analyze the monitoring angle of the use amount, the claim amount, the plan amount or the real-time inventory.
2. Selecting a supervision analysis subject:
and (4) selecting high-value consumables, common consumables or low-value consumables to supervise the theme analysis.
3. Selecting a supervision time collection mode:
year, half year, quarter, month, week or day is selected for regulatory data analysis.
4. Selecting a supervision level collection mode:
and selecting to carry out supervision data analysis on the whole hospital, each department type, the departments of the same type, a specific department, a medical group of the same department or a specific medical group.
5. Selecting a supervision matching query condition:
and (4) checking and filling specific query conditions of the data which need to be further collected, and displaying the data matched according to the query conditions by the system.
6. Selecting a drilling analysis query condition:
and according to the analysis dimension, selecting a data point which needs to be further drilled and analyzed on the basis of the query condition matching display result, selecting a drilling analysis condition by a right mouse button, and displaying the data according to the drilling analysis condition matching data by the system. And if further drilling analysis is needed, selecting data points needing further drilling analysis on the basis of the drilling analysis condition matching display result, selecting the rest drilling analysis conditions by a right mouse button, and displaying the data according to the continuous drilling analysis condition matching data.
In summary, the invention has the advantages that:
medical consumables are supervised by configuring the standardized interface, the level collection mode, the time collection mode, the display mode, the query condition and the multidimensional continuous drilling mode, multidimensional and dynamic supervision on the medical consumables is realized, and the transparency of supervision on the medical consumables is further improved.
The invention realizes the summary and detail data of medical consumables from the collection dimensions of hospital, departments of various types, departments of the same type, specific departments, medical groups in departments and the like, realizes the condition matching display of medical consumable data from the query dimensions of item names, specifications, models, main codes, item classification, departments, suppliers, main doctors, counting start time, counting end time, counting time span and the like, realizes the multi-angle multi-dimensional continuous drilling query of department, departments, high-value consumables in the hospital, common consumables, low-value consumables usage, plan quantity, claim quantity and real-time inventory dynamic supervision graphs, and supports the traceability to check the detail information, thereby being beneficial to analyzing the reasons of fluctuation abnormity, and having the following advantages compared with the prior art:
1. the analysis index can meet the policy supervision requirement and can also cover the internal control requirement of hospital medical consumable management. 2. The data display mode is rich and dynamic, multiple modes such as graphs and tables are supported to display under the same theme, and data utilization can be achieved in dynamic modes such as levels, time, multidimensional query conditions and multidimensional drilling analysis conditions. 3. The dimension of data analysis is rich, if there are N supervision indexes and there are M inquiry dimensions for each supervision index, the dimension of analysis of the supervision data of medical consumables will have N × M! The utility value of medical consumable supervision data is greatly improved. 4. The system data query and analysis operation is convenient and fast, and can be rapidly mastered in a short time.
Although specific embodiments of the invention have been described above, it will be understood by those skilled in the art that the specific embodiments described are illustrative only and are not limiting upon the scope of the invention, and that equivalent modifications and variations can be made by those skilled in the art without departing from the spirit of the invention, which is to be limited only by the appended claims.
Claims (4)
1. A medical consumable dynamic supervision method based on multi-dimensional continuous drilling is characterized by comprising the following steps: the method comprises the following steps:
step S10, configuring a standardized interface of the usage amount, the claiming amount, the planning amount and the real-time inventory amount of the medical consumables;
s20, configuring a hierarchical collection mode of medical consumable data;
s30, configuring time collection modes of medical consumable data, wherein the time collection modes at least comprise year, semiyear, quarter, month, week and day;
s40, configuring a display mode of medical consumable data;
s50, configuring query conditions of medical consumable data;
s60, configuring a multi-dimensional continuous drilling mode of medical consumable data;
s70, supervising the medical consumables according to the standardized interface, the level collection mode, the time collection mode, the display mode, the query condition and the multi-dimensional continuous drilling mode;
the step S10 specifically includes:
configuring a standardized interface of the usage amount, the claiming amount, the planning amount and the real-time inventory amount of the medical consumables, and obtaining the usage amount data, the claiming amount data, the planning amount data and the real-time inventory amount data of the medical consumables through view interaction or SQL statements;
in the usage data, the high-value consumables are obtained by reading real-time data of the high-value consumables of the secondary warehouse department of the logistics system for checking and selling the delivery list and checking the delivery list; the general expenses of charging are obtained by reading the general expenses of the departments of the second-level warehouse of the logistics system, the real-time data of the bill of delivery of the charge and the check bill of delivery of the warehouse; non-charging common consumables are obtained by reading general consumables, checking and selling out lists of departments of a secondary warehouse of the logistics system; the low-value consumables are obtained by reading a delivery list, a transfer delivery list, a department low-value product withdrawal list and a low-value product in-use and in-store scrap list from the logistics system to departments;
in the application quantity data, high-value consumables are obtained by reading real-time data of application sheets of a secondary library department of the logistics system; acquiring general consumables by reading general consumables application real-time data of a logistics system department application form; the low-value consumables are obtained by reading low-value product application real-time data of a logistics system department application form;
in the planned quantity data, high-value consumables are obtained by reading real-time data of a plan list of a secondary library department of a logistics system; the method comprises the steps that ordinary consumables are obtained by reading real-time data of ordinary consumable plans of a logistics system department plan list; the low-value consumables are obtained by reading real-time data of a low-value item plan of a department plan sheet of the logistics system;
in the real-time inventory data, high-value consumables are obtained by reading high-value real-time inventory data of a first-level warehouse and high-value real-time inventory data of a second-level warehouse of the logistics system; the common consumables are obtained by reading general consumption real-time inventory data of a first-level library and general consumption real-time inventory data of departments of a second-level library of the logistics system; the low-value consumables are obtained by reading low-value real-time inventory data and low-value management department inventory list data of a high-level library of the logistics system;
the step S20 is specifically: the hierarchical collection mode for configuring the medical consumable data at least comprises a whole hospital, types of departments, types of same departments to specific departments, and medical groups and specific medical groups of the same departments; the attributes used for distinguishing the hierarchical relationship at least comprise departments, department types and medical groups; the department types at least comprise clinic, medical technology, medical assistance and administrative logistics;
the step S40 is specifically: the display mode for configuring the medical consumable data comprises an upper interface, a middle interface and a lower interface;
the upper interface is used for displaying query conditions; the middle interface is used for displaying a double-axis coordinate graph of the query result, the left longitudinal axis of the double-axis coordinate graph counts the quantity, the right longitudinal axis of the double-axis coordinate graph counts the amount, and the horizontal axis of the double-axis coordinate graph is displayed according to the selected counting time span; the lower interface is used for displaying the medical consumable bill table information corresponding to the query result;
the step S60 specifically includes: the multi-dimensional continuous drilling mode for configuring medical consumable data comprises the following steps: selecting an analysis data point to perform right mouse click on the analysis data point to drill a query condition on the basis of the data condition query result, drilling and analyzing and displaying the analysis result; after the drilling query conditions selected at the previous time are removed, selecting an analysis data point to perform right mouse button drilling analysis and displaying an analysis result, namely multidimensional continuous data drilling analysis;
the steps S10 to S60 are not in sequence.
2. The method for dynamically supervising medical consumables based on multi-dimensional continuous drilling according to claim 1, wherein the method comprises the following steps: the step S50 specifically includes:
configuring query conditions of medical consumable data, including query conditions of usage amount, claim amount, plan amount and real-time inventory amount;
the query conditions of the usage amount at least comprise an article name, specification, model, main bar code, article classification, department, supplier, main doctor, counting start time, counting end time and counting time span;
the query conditions of the claim quantity at least comprise the name, specification, model, main bar code, whether to charge, article classification, department, supplier, counting start time, counting end time and counting time span;
the query conditions of the planned quantity at least comprise the name, specification, model, main bar code, article classification, whether to pre-store in a warehouse or not, whether to charge, department, supplier, starting time of statistics, ending time of statistics and time span of statistics;
the query conditions of the real-time inventory at least comprise article names, specifications, models, main bar codes, whether charging is carried out, article classification, whether pre-warehousing is carried out, departments and suppliers.
3. The utility model provides a medical consumptive material dynamic supervisory systems based on multidimension is bored in succession, its characterized in that: the system comprises the following modules:
standardized interface configuration module: the standardized interface is used for configuring the usage amount, the claiming amount, the planning amount and the real-time inventory amount of the medical consumables;
a hierarchical collection mode configuration module: a hierarchical collection mode for configuring medical consumable data;
a time collection mode configuration module: the time collection mode for configuring the medical consumable data at least comprises year, semiyear, quarter, month, week and day;
a display mode configuration module: the display mode is used for configuring medical consumable data;
the query condition configuration module: query conditions for configuring medical consumable data;
a drilling mode configuration module: a multi-dimensional continuous drilling mode for configuring medical consumable data;
a supervision module: the system is used for supervising the medical consumables according to the standardized interface, the level collection mode, the time collection mode, the display mode, the query condition and the multi-dimensional continuous drilling mode;
the standardized interface configuration module is specifically as follows:
configuring a standardized interface of the usage amount, the claiming amount, the planning amount and the real-time inventory amount of the medical consumables, and obtaining the usage amount data, the claiming amount data, the planning amount data and the real-time inventory amount data of the medical consumables through view interaction or SQL statements;
in the usage data, the high-value consumables are obtained by reading real-time data of the high-value consumables of the secondary warehouse department of the logistics system for checking and selling the delivery list and checking the delivery list; the common charging consumables are obtained by reading general consumption, charge verification and delivery bill real-time data and checking delivery bills of departments of a secondary warehouse of the logistics system; non-charging common consumables are obtained by reading general consumables, inventory, check, and sales orders of departments of a secondary warehouse of the logistics system; the low-value consumables are obtained by reading a delivery list, a transfer delivery list, a department low-value product withdrawal list and a low-value product in-use and in-store scrap list from a high-level warehouse of the logistics system to a department;
in the application quantity data, high-value consumables are obtained by reading real-time data of application sheets of a secondary library department of the logistics system; acquiring general consumables by reading general consumables application real-time data of a logistics system department application form; low-value consumables are obtained by reading real-time low-value consumable claim data of a logistics system department claim form;
in the plan quantity data, high-value consumables are obtained by reading real-time data of plan lists of secondary-level library departments of the logistics system; the method comprises the steps that ordinary consumables are obtained by reading plan real-time data of ordinary consumables of a department plan list of a logistics system; the low-value consumables are obtained by reading real-time data of a low-value item plan of a department plan sheet of the logistics system;
in the real-time inventory data, high-value consumables are obtained by reading high-value real-time inventory data of a first-level warehouse and high-value real-time inventory data of a second-level warehouse of the logistics system; the common consumables are obtained by reading general consumption real-time inventory data of a first-level library and general consumption real-time inventory data of departments of a second-level library of the logistics system; the low-value consumables are obtained by reading low-value real-time inventory data and low-value management department inventory list data of a logistics system first-level library;
the hierarchical collection mode configuration module specifically comprises: the hierarchical collection mode for configuring the medical consumable data at least comprises a whole hospital, types of departments, types of same departments to specific departments, and medical groups and specific medical groups of the same departments; the attributes used for distinguishing the hierarchical relationship at least comprise departments, department types and medical groups; the department types at least comprise clinic, medical technology, medical assistance and administrative logistics;
the display mode configuration module specifically comprises: the display mode for configuring the medical consumable data comprises an upper interface, a middle interface and a lower interface;
the upper interface is used for displaying query conditions; the middle interface is used for displaying a double-axis coordinate graph of the query result, the left longitudinal axis of the double-axis coordinate graph counts the quantity, the right longitudinal axis of the double-axis coordinate graph counts the amount, and the horizontal axis of the double-axis coordinate graph is displayed according to the selected counting time span; the lower interface is used for displaying the medical consumable bill table information corresponding to the query result
The drilling mode configuration module specifically comprises: the multi-dimensional continuous drilling mode for configuring the medical consumable data comprises the following steps: selecting an analysis data point to perform right mouse click on the analysis data point to drill a query condition on the basis of the data condition query result, drilling and analyzing and displaying the analysis result; and after the drilling query condition selected at the previous time is removed, selecting an analysis data point to perform right-click mouse drilling analysis and displaying an analysis result, namely multidimensional continuous data drilling analysis.
4. The system of claim 3, wherein the system comprises: the query condition configuration module specifically comprises:
configuring query conditions of medical consumable data, including query conditions of usage amount, claim amount, plan amount and real-time inventory amount;
the query conditions of the usage amount at least comprise an article name, specification, model, main bar code, article classification, department, supplier, main doctor, counting start time, counting end time and counting time span;
the query conditions of the claim quantity at least comprise the name, specification, model, main bar code, whether to charge, article classification, department, supplier, statistical start time, statistical end time and statistical time span;
the query conditions of the planned amount at least comprise the name, specification, model, main bar code, article classification, whether to pre-store in a warehouse or not, whether to charge, department, supplier, statistical start time, statistical end time and statistical time span;
the query conditions of the real-time inventory at least comprise article names, specifications, models, main bar codes, whether to charge, article classification, whether to contain pre-warehousing, departments and suppliers.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911133444.1A CN111145882B (en) | 2019-11-19 | 2019-11-19 | Medical consumable dynamic supervision method and system based on multi-dimensional continuous drilling |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911133444.1A CN111145882B (en) | 2019-11-19 | 2019-11-19 | Medical consumable dynamic supervision method and system based on multi-dimensional continuous drilling |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111145882A CN111145882A (en) | 2020-05-12 |
| CN111145882B true CN111145882B (en) | 2022-12-13 |
Family
ID=70517094
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911133444.1A Active CN111145882B (en) | 2019-11-19 | 2019-11-19 | Medical consumable dynamic supervision method and system based on multi-dimensional continuous drilling |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111145882B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105871611A (en) * | 2016-03-31 | 2016-08-17 | 浪潮通信信息系统有限公司 | Network management system supervision platform and supervision method |
| CN106296518A (en) * | 2015-06-11 | 2017-01-04 | 谭维华 | Intelligent medical treatment thin cloud linked system |
| CN107958698A (en) * | 2016-10-17 | 2018-04-24 | 广州思来医疗投资咨询有限公司 | A kind of medical consumable management system |
| CN108417260A (en) * | 2018-01-26 | 2018-08-17 | 中冶华天工程技术有限公司 | Hospital bed, wisdom hospital bed management system and management method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10878458B2 (en) * | 2016-07-21 | 2020-12-29 | Under Armour, Inc. | Associating taste with consumable records |
-
2019
- 2019-11-19 CN CN201911133444.1A patent/CN111145882B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106296518A (en) * | 2015-06-11 | 2017-01-04 | 谭维华 | Intelligent medical treatment thin cloud linked system |
| CN105871611A (en) * | 2016-03-31 | 2016-08-17 | 浪潮通信信息系统有限公司 | Network management system supervision platform and supervision method |
| CN107958698A (en) * | 2016-10-17 | 2018-04-24 | 广州思来医疗投资咨询有限公司 | A kind of medical consumable management system |
| CN108417260A (en) * | 2018-01-26 | 2018-08-17 | 中冶华天工程技术有限公司 | Hospital bed, wisdom hospital bed management system and management method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111145882A (en) | 2020-05-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20210012904A1 (en) | Systems and methods for electronic health records | |
| US20200364404A1 (en) | Artificial intelligence (ai) based document processor | |
| US20150317337A1 (en) | Systems and Methods for Identifying and Driving Actionable Insights from Data | |
| US20120130736A1 (en) | Systems and methods involving physician payment data | |
| Su et al. | A cost-benefit decision model: analysis, comparison amd selection of data management | |
| US11119762B1 (en) | Reusable analytics for providing custom insights | |
| US20120253997A1 (en) | Method for multi-dimensional accounting of business transactions and system therefor | |
| JP2010508587A (en) | System and method for detecting anomalies in market data | |
| Martin | Data quality in process mining | |
| Gandhi et al. | Evaluating an oncology systemic therapy computerized physician order entry system using international guidelines | |
| Dewland et al. | Notes on operations: Patron driven acquisitions: determining the metrics for success | |
| Aljumaili | Data quality assessment: Applied in maintenance | |
| Li | Data quality and data cleaning in database applications | |
| US7992126B2 (en) | Apparatus and method for quantitatively measuring the balance within a balanced scorecard | |
| US7912809B2 (en) | Data management system for manufacturing enterprise and related methods | |
| CN111145882B (en) | Medical consumable dynamic supervision method and system based on multi-dimensional continuous drilling | |
| Bargui et al. | A decision making ontology building process for analytical requirements elicitation | |
| Gupta et al. | A Review of Data Warehousing and Business Intelligence in different perspective | |
| Nabelsi et al. | Detecting constraints in supply chain reengineering projects: case study of data and process integration in a hospital pharmacy | |
| Bedny | Application of systemic-structural activity theory to the design of BOTs and AI software | |
| Muraina et al. | Healthcare business intelligence: The case of university’s health center | |
| Rennhackkamp et al. | Applying Business Intelligence and Analytics to Clinical Costing Data | |
| US20220284405A1 (en) | Maintenance information management system, maintenance information management device, maintenance information management method, and program | |
| US11151653B1 (en) | Method and system for managing data | |
| Mathew et al. | A conceptual data modelling methodology for asset management data warehousing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |