Data reporting method and system based on model configuration, electronic equipment and storage medium

Abstract

The invention provides a data reporting method and system based on model configuration, electronic equipment and a storage medium, and relates to the field of computer software, and the method comprises the steps: configuring a physical data model, a quality control rule model and a value domain coding model based on a data reporting requirement; extracting original data, and mapping, converting and integrating the original data as required through a physical data model to generate an intermediate data set; verifying the intermediate data set through a quality control rule model and a value domain coding model, and generating a quality control result report according to a verification result; storing the verified intermediate data set and the quality control result report into a service database; processing the intermediate data set based on the quality control result report to generate a final data set; and based on the final data set, generating a file meeting the requirement and reporting the file. According to the method, configuration and closed loop of the data reporting process are realized in a model configuration mode, the data quality and the reporting efficiency are improved, and the practicability is relatively high.

Description

Technical Field

[0001] This application relates to the field of computer software, specifically to the field of medical information technology and data governance, and particularly to a data reporting method, system, electronic device, and storage medium based on model configuration. Background Technology

[0002] The national performance evaluation of tertiary public hospitals is an important mechanism for the state to comprehensively assess hospitals, and the quality of its data reporting directly affects the evaluation results. The reported data mainly originates from the patient record front page and must strictly adhere to the dynamically updated data interface standards and quality control rules issued by the National Health Commission. Currently, hospitals face two major challenges when preparing data for the national evaluation: 1. The contradiction between the dynamism of rules and the rigidity of the system. The data standards, value range encoding, and logical verification rules of the national civil service examination are adjusted almost every year. Traditional technical solutions usually use hard coding or configuration of a single rule table to implement verification. When the rules change, developers need to modify the code or scripts in multiple independent stages such as data extraction, cleaning, transformation, and verification. This results in slow response, heavy workload, and easy errors, and the system has poor flexibility and maintainability. 2. Fragmented processes and non-closed-loop management. Data goes through multiple isolated data processing and quality control steps from its source (business systems such as HIS) to final reporting. When a problem is discovered (such as an error in the original data), it is difficult to efficiently and automatically feed the problem back to the source and trigger a reprocessing of the entire process. This results in a long data correction cycle and makes it impossible to form a governance closed loop of "discovery-correction-re-verification". Summary of the Invention

[0003] To address the aforementioned deficiencies in existing technologies, this application provides a data reporting method, system, electronic device, and storage medium based on model configuration. By configuring the data reporting process through model configuration, it achieves configurability and closed-loop processing, improving data quality and reporting efficiency, and has strong practicality.

[0004] To achieve the above objectives, the present invention employs the following techniques: A data reporting method based on model configuration includes: S1000: Based on data reporting requirements, configure the physical data model, quality control rule model, and value range coding model; S2000: Extract raw data, and map, transform and integrate the raw data as needed through the physical data model to generate an intermediate data set; S3000 verifies the intermediate dataset using the quality control rule model and the value range coding model, and generates a quality control result report based on the verification results. S4000: Store the verified intermediate data set and quality control result report into the business database; S5000 processes intermediate data sets based on quality control result reports to generate the final data set; S6000: Based on the final data set, generate a file that meets the requirements and report it.

[0005] A data reporting system based on model configuration includes a model configuration module, a data processing module, a data verification module, a data storage module, a data processing module, and a data reporting module. The model configuration module is used to configure the physical data model, quality control rule model, and value range coding model based on data reporting requirements. The model processing module is used to extract raw data, and through the physical data model, it maps, transforms and integrates the raw data as needed to generate an intermediate data set; The data verification module is used to verify the intermediate data set through the quality control rule model and the value range coding model, and generate a quality control result report based on the verification results; The data storage module is used to store the verified intermediate data set and quality control result report into the business database; The data processing module is used to process intermediate data sets based on quality control result reports and generate the final data set; The data reporting module is used to generate and report compliant files based on the final data set.

[0006] An electronic device includes: at least one processor and a memory; wherein the memory stores computer-executable instructions; the at least one processor executes the computer-executable instructions stored in the memory, causing the at least one processor to perform the model-configuration-based data reporting method described above.

[0007] A computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, controls the device on which the computer-readable storage medium is located to perform the model-configuration-based data reporting method described above.

[0008] The beneficial effects of this invention are as follows: 1. By abstracting core logic such as data mapping, verification rules, and value range standards into configurable models, when the reporting standards are updated, the administrator only needs to update the corresponding model to automatically adapt to the new rules. This eliminates the dilemma of needing to modify code in multiple stages under the traditional method, improves the maintainability of the system and the response speed to changes in reporting standards, thereby improving reporting efficiency.

[0009] 2. By systematically integrating the data problem feedback, source correction, and automatic reprocessing processes, a complete closed loop is formed from data generation, verification, problem discovery, correction to re-verification. This changes the data governance model, enabling continuous improvement of data quality throughout the process, thereby enhancing data accuracy and reporting success rate, and thus improving data quality. Attached Figure Description

[0010] Figure 1 This is a schematic diagram illustrating the workflow of the data reporting method based on model configuration in an embodiment of this application.

[0011] Figure 2 This is a schematic diagram of the workflow of the data display model in an embodiment of this application.

[0012] Figure 3 This is a schematic diagram of the workflow for processing verification results in an embodiment of this application.

[0013] Figure 4 This is a schematic diagram of the workflow for revising problematic data according to an embodiment of this application.

[0014] Figure 5 This is a schematic diagram of the structure of a data reporting system based on model configuration according to an embodiment of this application. Detailed Implementation

[0015] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the implementation methods of the present invention will be described in detail below with reference to the accompanying drawings. However, the embodiments described in this invention are only some embodiments of the present invention, and not all embodiments.

[0016] like Figure 1 As shown, one aspect of this application provides a data reporting method based on model configuration, including the following steps: S1000. Based on data reporting requirements, configure a physical data model, a quality control rule model, and a value domain coding model. The physical data model is used to define the mapping relationship and conversion rules between source data fields and target reporting fields. The quality control rule model is used to define data integrity rules and business logic rules in a structured manner. Among them, data integrity rules include mandatory fields and conditional mandatory field constraints. Business logic rules include logical relationships and contradiction constraints between patient information, cost information, and diagnosis and treatment information. The value domain coding model is stored independently and used to maintain various codes and value domain dictionaries published by national standards.

[0017] S2000: Extract raw data, and map, transform and integrate the raw data as needed through a physical data model to generate an intermediate data set; raw data refers to the original medical record data in data sources such as the Hospital Information System (HIS), and mapping, transforming and integrating as needed means mapping, transforming and integrating according to the format and structure required for national examination reporting.

[0018] S3000 verifies the intermediate data set through the quality control rule model and the value range coding model, and generates a quality control result report based on the verification results; the quality control result report indicates the pass status and specific problems of each data point.

[0019] S4000: Store the verified intermediate data set and quality control result report into the business database.

[0020] S5000 processes intermediate data sets based on quality control result reports to generate the final data set.

[0021] S6000: Based on the final data set, generate a file that meets the requirements and submit it; the file that meets the requirements is the submission file that meets the requirements of the national examination platform.

[0022] Preferred, such as Figure 2 As shown, the following steps are executed simultaneously when S1000 is executed: S1100. Based on data reporting requirements, configure a data display model. The data display model is used to provide the front end with a visual interface that can be filtered by multiple dimensions such as time, department, and disease, for data browsing, verification, and location of problematic data.

[0023] Further preferred, such as Figure 2 As shown, S5000 includes the following steps: S5100 generates a visualization interface based on the quality control result report and intermediate data set through a data display model; the visualization interface here is a visualization interface that can be filtered by multiple dimensions such as time, department, and disease.

[0024] The S5200, based on a visual interface, processes intermediate data sets and generates the final data set; this design enables more accurate handling of data verification.

[0025] Preferred, such as Figure 3 As shown, S5200 includes: S5210. Display the quality control result report through a visual interface to determine if there is any data that failed verification: If so, then execute S5220.

[0026] If not, all the intermediate data that passed the verification will be integrated to generate the final data set.

[0027] S5220. Select problematic data from the intermediate dataset, revise the problematic data, and integrate the revised problematic data with the verified problematic data to generate the final dataset.

[0028] This design allows for precise and efficient revision of problematic data based on the verification results displayed on the visual interface, resulting in the final data that needs to be reported.

[0029] Preferred, such as Figure 4 As shown, S5220 includes the following steps: S5221. Display the data source of the problem data through a visual interface; the data source is the time when the problem data was generated, the type of disease, and the department to which it belongs.

[0030] S5222. Based on the data source, revise the original data corresponding to the problematic data; that is, based on the data source, reflect the verification situation to the corresponding clinical department, and the corresponding clinical department revises the errors in the problematic data from the level of the original data.

[0031] S5223. Starting from S2000, the revised original data is processed; that is, after the clinical department completes the revision, a "reprocessing" instruction for the batch of data will be triggered. After the system responds to the instruction, it will automatically re-execute the entire process from data extraction to quality control verification based on the latest configured model, and synchronize the updated results to the business database, forming a data processing closed loop that does not require manual intervention.

[0032] The following example, using the specific workflow of a hospital's national civil service examination data reporting, illustrates the working principle of this embodiment: System initialization and model configuration: Administrators configure the physical data model according to this year's national civil service examination data interface specifications, clarifying the mapping and conversion logic from the HIS medical record homepage table to hundreds of national civil service examination reporting fields; in the quality control rule model, rules are defined in a configuration manner, such as: "When the 'gender' field value is 'female,' the 'primary diagnosis code' field value cannot begin with a male reproductive system disease category code (such as a range in ICD-10)"; "Patient age and 'newborn birth weight' fields must meet the reasonable range"; in the value domain coding model, the latest dictionary tables, such as the "National Clinical Version of Surgical Operation Classification Codes" published by the state, are imported; when configuring the data display model, the fields, filtering conditions, and statistical charts to be displayed on the data confirmation page are defined.

[0033] Daily data processing and problem detection: Based on the physical data model, the system extracts and integrates data from the HIS daily at regular intervals. The integrated data is then validated using a pre-configured quality control rule model and value range coding model. For example, if a record shows a female patient's primary diagnosis as "benign prostatic hyperplasia," the record is marked as "logic verification failed," and the specific rule violation is noted in the report. The generated quality control result report, along with the intermediate data set, is stored in the business database. Quality control personnel can view the overall pass rate of all data to be reported that day through a visualization page generated by the data display model, and can drill down to view a specific list of abnormal data.

[0034] Closed-loop processing and rule update response: The quality control staff sends the issue of "female patient diagnosed with benign prostatic hyperplasia" to the medical records room through the system's embedded feedback process; the medical records room checks the original medical record, confirms that it is a coding entry error, and corrects it in the HIS; the medical records room selects the corrected data record in the system and clicks "reprocess". The system initiates a new processing task for the data, rerunning the entire process from extraction to verification of the case data, and re-evaluating whether there is any problematic data in the corrected data.

[0035] Suppose that a new "VTE Risk Assessment Result" reporting field is added to the national civil service exam the following year. The administrator only needs to perform the following operations in the model configuration center: a) add a mapping for this field in the physical data model; b) add an option dictionary for this field in the value domain coding model; c) selectively add relevant logical rules (such as "this field is mandatory for certain surgical patients") in the quality control rule model. After the configuration takes effect, the system can automatically process data containing this new field, without requiring developers to modify any backend or frontend code.

[0036] Data reporting: After all data has been verified, all verified intermediate data is integrated into the final data set. The administrator can use the reporting module to generate and submit an encrypted reporting file that meets the format requirements to the national assessment platform with one click.

[0037] like Figure 5 As shown, another aspect of the embodiments of this application includes a model configuration module, a data processing module, a data verification module, a data storage module, a data processing module, and a data reporting module; The model configuration module is used to configure the physical data model, quality control rule model, and value range coding model based on data reporting requirements. The model processing module is used to extract raw data, and through the physical data model, it maps, transforms and integrates the raw data as needed to generate an intermediate data set; The data verification module is used to verify the intermediate data set through the quality control rule model and the value range coding model, and generate a quality control result report based on the verification results; The data storage module is used to store the verified intermediate data set and quality control result report into the business database; The data processing module is used to process intermediate data sets based on quality control result reports and generate the final data set; The data reporting module is used to generate and report compliant files based on the final data set.

[0038] Preferred, such as Figure 5 As shown, the model configuration module is also used to configure the data display model based on data reporting requirements; Further preferred, such as Figure 5 As shown, the data processing module includes an interface generation submodule and a data processing submodule; The interface generation submodule is used to generate a visual interface based on the quality control result report and intermediate data set through a data display model. The data processing submodule is used to process intermediate data sets and generate the final data set based on a visual interface.

[0039] Preferred, such as Figure 5 As shown, the data processing submodule includes a verification and judgment unit and a data revision unit; The verification and judgment unit is used to display the quality control result report through a visual interface and determine whether there is any problematic data that fails verification. If the judgment is yes, it jumps to the data revision unit for execution. If the judgment is no, it integrates all intermediate data that has passed verification to generate the final data set.

[0040] The data revision unit is used to filter out problematic data from the intermediate dataset, revise the problematic data, and integrate the revised problematic data with the verified problematic data to generate the final dataset.

[0041] Preferred, such as Figure 5 As shown, the data revision unit includes a source display subunit, a data revision subunit, and a closed-loop processing subunit; The source display sub-unit is used to display the data source of the problem data through a visual interface; The data revision subunit is used to revise the original data corresponding to the problematic data based on the data source; The model processing module is also used to extract the original data after revision by the data revision subunit.

[0042] In another aspect of this application, an electronic device is provided, comprising: at least one processor and a memory; wherein the memory stores computer execution instructions; the at least one processor executes the computer execution instructions stored in the memory, causing the at least one processor to perform the model configuration-based data reporting method described in the preceding embodiments.

[0043] In another aspect of the embodiments of this application, a computer-readable storage medium is provided, on which a computer program is stored, wherein the computer program, when executed by a processor, controls the device where the storage medium is located to execute the data reporting method based on model configuration described in any of the preceding embodiments.

[0044] The above description is only a preferred embodiment of this application and is not intended to limit this application. Obviously, those skilled in the art can make various modifications and variations to this application without departing from the spirit and scope of this application.

Claims

1. A data reporting method based on model configuration, characterized in that, include: S1000: Based on data reporting requirements, configure the physical data model, quality control rule model, and value range coding model; S2000: Extract raw data, and map, transform and integrate the raw data as needed through the physical data model to generate an intermediate data set; S3000 verifies the intermediate dataset using the quality control rule model and the value range coding model, and generates a quality control result report based on the verification results. S4000: Store the verified intermediate data set and quality control result report into the business database; S5000 processes intermediate data sets based on quality control result reports to generate the final data set; S6000: Based on the final data set, generate a file that meets the requirements and report it.

2. The data reporting method based on model configuration according to claim 1, characterized in that, Execute the following steps simultaneously while executing S1000: S1100. Configure the data display model based on data reporting requirements; S5000 includes the following steps: S5100: Based on the quality control result report and intermediate data set, a visualization interface is generated through the data display model; S5200, based on a visual interface, processes intermediate data sets and generates the final data set.

3. The data reporting method based on model configuration according to claim 2, characterized in that, The S5200 includes: S5210. Display the quality control result report through a visual interface to determine if there is any data that failed verification: If so, then execute S5220; If not, all the intermediate data that passed the verification will be integrated to generate the final data set; S5220. Select problematic data from the intermediate dataset, revise the problematic data, and integrate the revised problematic data with the verified problematic data to generate the final dataset.

4. The data reporting method based on model configuration according to claim 1, characterized in that, S5220 includes the following steps: S5221. Display the data source of the problem data through a visual interface; S5222. Based on the data source, revise the original data corresponding to the problematic data; S5223. Starting from S2000, process the revised original data.

5. A data reporting system based on model configuration, characterized in that, It includes a model configuration module, a data processing module, a data verification module, a data storage module, a data processing module, and a data reporting module; The model configuration module is used to configure the physical data model, quality control rule model, and value range coding model based on data reporting requirements. The model processing module is used to extract raw data, and through the physical data model, it maps, transforms and integrates the raw data as needed to generate an intermediate data set; The data verification module is used to verify the intermediate data set through the quality control rule model and the value range coding model, and generate a quality control result report based on the verification results; The data storage module is used to store the verified intermediate data set and quality control result report into the business database; The data processing module is used to process intermediate data sets based on quality control result reports and generate the final data set; The data reporting module is used to generate and report compliant files based on the final data set.

6. The data reporting system based on model configuration according to claim 5, characterized in that, The model configuration module is also used to configure the data display model based on data reporting requirements; The data processing module includes an interface generation submodule and a data processing submodule; The interface generation submodule is used to generate a visual interface based on the quality control result report and intermediate data set through a data display model. The data processing submodule is used to process intermediate data sets and generate the final data set based on a visual interface.

7. The data reporting system based on model configuration according to claim 6, characterized in that, The data processing submodule includes a verification and judgment unit and a data revision unit; The verification and judgment unit is used to display the quality control result report through a visual interface and to determine whether there is any problematic data that fails verification. If the determination is yes, proceed to the data revision unit for execution; if the determination is no, integrate all the intermediate data that passed the verification to generate the final data set. The data revision unit is used to filter out problematic data from the intermediate dataset, revise the problematic data, and integrate the revised problematic data with the verified problematic data to generate the final dataset.

8. The data reporting system based on model configuration according to claim 7, characterized in that, The data revision unit includes a source display subunit, a data revision subunit, and a closed-loop processing subunit; The source display sub-unit is used to display the data source of the problem data through a visual interface; The data revision subunit is used to revise the original data corresponding to the problematic data based on the data source; The model processing module is also used to extract the original data after revision by the data revision subunit.

9. An electronic device, comprising: At least one processor and a memory; wherein the memory stores computer-executable instructions; characterized in that the at least one processor executes the computer-executable instructions stored in the memory, causing the at least one processor to perform the model-configuration-based data reporting method as described in any one of claims 1 to 4.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is run by the processor, it controls the device containing the computer-readable storage medium to perform the model-configured data reporting method as described in any one of claims 1 to 4.

Images