CN108389621A - Medical record database quality determining method and system - Google Patents
Medical record database quality determining method and system Download PDFInfo
- Publication number
- CN108389621A CN108389621A CN201810127119.3A CN201810127119A CN108389621A CN 108389621 A CN108389621 A CN 108389621A CN 201810127119 A CN201810127119 A CN 201810127119A CN 108389621 A CN108389621 A CN 108389621A
- Authority
- CN
- China
- Prior art keywords
- data
- field
- code
- court
- hospital
- 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.)
- Granted
Links
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
- G16H50/00—ICT specially adapted for medical diagnosis, medical simulation or medical data mining; ICT specially adapted for detecting, monitoring or modelling epidemics or pandemics
-
- 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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
- G06F40/157—Transformation using dictionaries or tables
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Medical Informatics (AREA)
- Software Systems (AREA)
- Public Health (AREA)
- Primary Health Care (AREA)
- Biomedical Technology (AREA)
- Quality & Reliability (AREA)
- Epidemiology (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Pathology (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The embodiment of the invention discloses a kind of Medical record database quality determining methods, specifically include following steps:Import data to database;The data of importing are detected.Also disclose a kind of Medical record database quality detecting system.It can detect the wrong data of first page of illness case and data lack of standardization, obtain testing result and problem is detailed.The superiority and inferiority for also reflecting the court's Medical record database quality allows hospital to recognize the Medical record database of the court there are one intuitive.
Description
Technical field
The present invention relates to medical big data detection technique field, specifically a kind of Medical record database quality testing side
Method and system.
Background technology
Since self-defence planning commission requires each hospital to report Medical record database, Medical record database quality is just greatly closed
Note, and Medical record database has following three at present:Medical record database is checked by manual type by hospital, this
Mode inefficiency and be difficult know comprehensively identify wrong data and data lack of standardization;The existing technical conditions of hospital cannot be right
The Medical record database of the court can not learn the distribution situation of the court's wrong data there are one whole understanding;Between hospital that
This is not exchanged mutually, and medical record data are in information island, can not reflect the level of the court's data in China.
Invention content
A kind of Medical record database quality determining method and system are provided in the embodiment of the present invention, to solve the prior art
In verification Medical record database efficiency it is low, can not have to the distribution situation of the court's wrong data it is whole understanding, medical record data without
The horizontal problem of method reflection in China.
In order to solve the above-mentioned technical problem, the embodiment of the invention discloses following technical solutions:
First aspect present invention provides a kind of Medical record database quality determining method, and this approach includes the following steps:
Import data to database;
The data of importing are detected.
With reference to first aspect, it imports data to database in the first possible realization method in first aspect and specifically wraps
Include following steps:
File is converted to unified format by the file that acquisition hospital reports;
The file converted is stored according to certain classifying rules in corresponding catalogue;
It is that the hospital generates database, and the information of data file is imported into corresponding table according to the data file of importing
In;
The interim table of the hospital is created, and the information of data file is imported into corresponding interim table.
With reference to first aspect, in second of possible realization method of first aspect, the classifying rules includes:Per class
The catalogue in the hospital each year is stored under hospital's catalogue, and the catalogue in each season, each season are stored under each year catalogue
The data file and dictionary table catalogue in hospital's season are stored under catalogue, and each dictionary list file mesh is stored under dictionary table catalogue
It records, each dictionary list file is stored under each dictionary table file directory.
With reference to first aspect, in first aspect in the third possible realization method, after importing data to database
It is further comprising the steps of:
Data are standardized;
Field after standardization is pre-processed.
With reference to first aspect, described that place is standardized to data in the 4th kind of possible realization method of first aspect
Reason includes:Field is mapped by standardizing dictionary, specifically includes following steps:
Preceding 232 fields are obtained from the field mapping table of the corresponding database of hospital;
Preceding 232 fields of acquisition are matched with 232 fields of standard, capitalization is converted in matching;
If the data after matching are imported into standard form table by successful match;If there is unmatched field,
Then the field is imported into field mapping table and terminates the subsequent quality inspection flow of the hospital.
With reference to first aspect, in the 5th kind of possible realization method of first aspect, 232 fields of the standard include
Defend system 4-1 232 fields of standard.
With reference to first aspect, in the 6th kind of possible realization method of first aspect, described pair standardization after field into
Row pretreatment includes being standardized to code and carrying out standardization processing to format.
With reference to first aspect, in the 7th kind of possible realization method of first aspect, code is standardized
Method specifically includes:According to the mapping relations of code table by the court's code conversion of respective field be standard code;
The method for carrying out standardization processing to format specifically includes:Obtain the data format of 232 fields in database;Root
The field that the field of nvarchar data type is converted to respective type according to data format is set as if convert failed
It is empty.
With reference to first aspect, in the 8th kind of possible realization method of first aspect, the standard code and the court's code
For one-to-many relationship, specially:The court's code is empty or multiple values, and corresponding standard code is to determine to be worth;
The data format includes string, double, datetime, int.
With reference to first aspect, in the 9th kind of possible realization method of first aspect, by the court's code of respective field
It also needs to read the court's code table when being converted to standard code;When reading the court's code table, according to comma automatically by the court's code
It is grouped.
With reference to first aspect, in the tenth kind of possible realization method of first aspect, packet is detected to the data of importing
Include Data Detection and quality testing.
With reference to first aspect, in a kind of the tenth possible realization method of first aspect, the Data Detection is specifically wrapped
Include following steps:
Diagnostic message is detached from first page of illness case mark data into individual table with operation and operation information;
Data in update diagnostic message, operation and operation information, medical record attribute list are prepared as later stage statistics and use;
Count each moon record number;
The court's disease dictionary table and operation and operation dictionary table are matched with normal dictionary table, statistical match rate.
With reference to first aspect, in the 12nd kind of possible realization method of first aspect, the quality testing includes root
Medical record database field is detected according to quality inspection rule, and testing result is preserved in the database, is specifically included following
Step:
Traverse all quality inspection rules;
According to first page of illness case content involved in each single item quality inspection rule, first page of illness case content is extracted from tables of data
Out;
According to quality inspection rule, judge whether first page of illness case content is legal.
With reference to first aspect, in the 13rd kind of possible realization method of first aspect, according to quality inspection rule to medical record head
Page data field be detected the standard of the integrality, detection data that specifically include detection data, detection data normalization;
The detection integrality includes detecting the percentage of head rice filled in of Medical record database, including detection required field is complete
Property, detect non-required field integrality and detection combination field integrality;
The examination criteria includes the utilization rate for detecting each code, standard diagnosis and treatment subject register and discharge section office of the court
Code matches situation, the court's disease dictionary table version match situation and the court's operation and operation dictionary table version match situation;
The inspection criterion includes detecting single field specification, detection conjunction code field logic, detection combination word
Section expense logic, detection combination field time logic.
With reference to first aspect, in the 14th kind of possible realization method of first aspect, the testing result includes inspection
Survey result report and problem detail list;
The quality measurements are reported as whole quality measurements, including the indices of quality inspection rule, phase
Answer Problem-chain;The problem link, which may link to, is connected to corresponding problem detail list;
The problem detail list is distributed according to quality inspection result items, and each problem detail list includes that a result items record
The problem of data;Problem detail list is stored according to patient's identification number, date of birth, admission time and problem field;Patient's identification number goes out
Phase birthday and admission time are used for positioning Medical record database, and problem field is the data of problem field.
Second aspect of the present invention provides a kind of Medical record database quality detecting system, which includes that data import mould
Hospital data is converted to unified format, database is imported into according to classifying rules by block;With,
Detection module carries out Data Detection and quality testing to case of hospital homepage data.
In conjunction with second aspect, in second aspect in the first possible realization method, the system further includes standardization
Module, for being standardized to the data of importing according to standardization dictionary, including code standardization and format specification;
Also content data file is identified, if identifying nonstandard file, stops the quality inspection of the first page of illness case of the hospital;
With,
Data statistic analysis module, it is for statistical analysis to data according to quality inspection rule, it analyzes in certain period and owns
The overall condition of case of hospital homepage data show that quality measurements are reported, and provides corresponding problem detail list.
The Medical record database quality detecting system of second aspect of the present invention can realize first aspect and first party
Method in each realization method in face, and obtain identical effect.
By above technical scheme as it can be seen that the present invention can detect the wrong data of first page of illness case and data lack of standardization, obtain
It is detailed to testing result and problem.
According to testing result with problem detail, it can reflect the superiority and inferiority of the court's Medical record database quality, allow
There are one intuitive understanding for Medical record database of the hospital to the court.
Description of the drawings
Fig. 1 is Medical record database quality determining method flow diagram of the present invention;
Fig. 2 is the method flow schematic diagram that the embodiment of the present invention imports data to database;
Fig. 3 is the method flow schematic diagram that the embodiment of the present invention is standardized data;
Fig. 4 is the method flow schematic diagram of Data Detection of the embodiment of the present invention;
Fig. 5 is the method flow schematic diagram of quality testing of the embodiment of the present invention;
Fig. 6 is Medical record database quality detecting system structural schematic diagram of the present invention.
Specific implementation mode
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, for those of ordinary skill in the art
Speech, without creative efforts, other drawings may also be obtained based on these drawings.
As shown in Figure 1, Medical record database quality determining method, specifically includes following steps:
S1, database is imported data to;
S2, data are standardized;
S3, the field after standardization is pre-processed;
S4, the data of importing are detected.
As shown in Fig. 2, importing data to database in S1 specifically includes following steps:
File is converted to unified format by the file that S11, acquisition hospital report;File format includes .xls .xlsx,
.csv, data file is uniformly converted to .xlsx formats by tetra- kinds of .dbf by third party's tool.
S12, the file converted is stored according to certain classifying rules in corresponding catalogue;Classifying rules includes:
Hospital's classified catalogue is divided into single hospital, trusts hospital associate, Civilian Hospital association, association of Tianjin Hospital.
S13, it is that the hospital generates database, and the information of data file is imported into accordingly according to the data file of importing
Table in;
S14, the interim table for creating the hospital, and the information of data file is imported into corresponding interim table.Totally six
Dictionary table, including:《The court's first page of illness case code table》、《The court's first page of illness case dictionary table-medical institutions' diagnosis and treatment subject register》、
《The court's first page of illness case dictionary table-classification of diseases and code (ICD-10)》、《The court's first page of illness case dictionary table-surgical procedure classification
With code (ICD-9-CM3)》、《The court's first page of illness case dictionary table-Morphological Coding》、《The court's first page of illness case dictionary table-operation point
Grade》.
Classifying rules in S12 includes:The catalogue in the hospital each year, each year mesh are stored under per class hospital catalogue
The catalogue in each season is stored under record, and the data file and dictionary table catalogue in hospital's season, word are stored under each season catalogue
The record of allusion quotation entry is lower to store each dictionary table file directory, and each dictionary list file is stored under each dictionary table file directory.
As shown in figure 3, in S2 to data be standardized including:Field is mapped by standardizing dictionary,
Specifically include following steps:
S21, preceding 232 fields are obtained from the field mapping table of the corresponding database of hospital.
S22, preceding 232 fields of acquisition are matched with 232 fields of standard, capitalization is converted in matching.
S23, judge whether successful match;If successful match executes S24;Otherwise, S25 is executed.
S24, the data after matching are imported into standard form table.
S25, the field is imported into field mapping table and terminates the subsequent quality inspection flow of the hospital.Simply by the presence of not
The field matched as matches unsuccessful.
232 fields of standard include defending system 4-1 232 fields of standard.
It includes being standardized to code and being advised to format to carry out pretreatment to the field after standardization in S3
Generalized processing.
The method that code is standardized is specifically included:According to the mapping relations of code table by the sheet of respective field
Institute's code conversion is standard code.It also needs to read the court's code when being standard code by the court's code conversion of respective field
Table;When reading the court's code table, the court's code is grouped automatically according to comma.As table 1 shows standard code example.
Corresponding field | Standard code title | Standard code |
YLFKFS | Basic Medical Insurance for Urban Employees | 1 |
YLFKFS | Basic medical security for urban residents | 2 |
YLFKFS | Novel rural cooperative medical service | 3 |
YLFKFS | Poverty relief | 4 |
YLFKFS | Commercial medical insurance | 5 |
YLFKFS | Full public expense | 6 |
YLFKFS | Entirely at one's own expense | 7 |
YLFKFS | Other social insurances | 8 |
YLFKFS | Other | 9 |
XB | Unknown gender | 0 |
XB | Male | 1 |
XB | Women | 2 |
XB | Unaccounted gender | 9 |
1 standard code sample table of table
The method for carrying out standardization processing to format specifically includes:Obtain the data format of 232 fields in database;Root
The field that the field of nvarchar data type is converted to respective type according to data format is set as if convert failed
It is empty.
Standard code is one-to-many relationship with the court's code, specially:The court's code is empty or multiple values, corresponding mark
Quasi- code is to determine to be worth;
Data format includes string, double, datetime, int.
The data of importing are detected including Data Detection and quality testing in S4.
As shown in figure 4, Data Detection specifically includes following steps:
S411, diagnostic message is detached from first page of illness case mark data into individual table with operation and operation information;
Data in S412, update diagnostic message, operation and operation information, medical record attribute list, being prepared as later stage statistics makes
With;
S413, statistics each moon record number;
S414, the court's disease dictionary table and operation and operation dictionary table are matched with normal dictionary table, statistical match
Rate.
As shown in figure 5, quality testing includes being detected to Medical record database field according to quality inspection rule, and will detection
As a result it preserves in the database, specifically includes following steps:
All quality inspection rules of S421, traversal;
S422, according to first page of illness case content involved in each single item quality inspection rule, by first page of illness case content from tables of data
In extract;
S423, according to quality inspection rule, judge whether first page of illness case content legal.
The integrality for specifically including detection data, testing number are detected to Medical record database field according to quality inspection rule
According to standard, detection data normalization.
Detection integrality includes the percentage of head rice for detecting Medical record database and filling in, including detection required field integrality, inspection
Survey non-required field integrality and detection combination field integrality.Required field totally 29, including:USERNAME,YLFKFS,
ZYCS,BAH,XM,XB,CSRQ,NL,GJ,ZY,HY,RYTJ,RYSJ,RYSJS,RYKB,RYBF,CYSJ,CYSJS,CYKB,
CYBF,SJZYTS,MZZD,JBBM,ZYZD,JBDM,RYBQ,L YFS,SFZZYJH,ZFY;In addition to required field, remaining field
For non-required field, combined field predominantly diagnoses three (disease name, ICD-10 codings, the state of an illness of being admitted to hospital) and operation three
(operation and action name, ICD-9-CM-3 codings, operation and date of operation).
Examination criteria includes the utilization rate for detecting each code, standard diagnosis and treatment subject register and discharge section office of the court code
It performs the operation with situation, the court's disease dictionary table version match situation and the court and operates dictionary table version match situation.Predominantly 17
The utilization rate of a each code of code table, standard diagnosis and treatment subject register and discharge section office of the court code matches situation, the court's disease word
Allusion quotation table version match situation and the court's operation and operation dictionary table version match situation.17 code tables include:Medical payer
Formula, gender, occupational group, marriage, approach of being admitted to hospital, the state of an illness of being admitted to hospital, drug allergy, Died Patients postmortem, blood group, RhD blood groups, disease
Case quality, rank of performing the operation, operative incision grade, operative incision healing classification, anesthesia method, from school's formula, if having discharge 31
It is hospitalized and plans again in it.
Inspection criterion includes detecting single field specification, detection conjunction code field logic, detection combination field expense
Logic, detection combination field time logic.
Testing result includes test results report and problem detail list.
Quality measurements are reported as whole quality measurements, including the indices of quality inspection rule, corresponding problem
Chain;The problem link, which may link to, is connected to corresponding problem detail list.
The problem of problem detail list is distributed according to quality inspection result items, and each problem detail list includes a result items record
Data;Problem detail list is stored according to patient's identification number, date of birth, admission time and problem field;Patient's identification number, date of birth
It is used for positioning Medical record database with admission time, problem field is the data of problem field, and user is facilitated quickly to position and repair
Change Medical record database.
As shown in fig. 6, Medical record database quality detecting system, including data import modul, hospital data is converted to
Unified format, database is imported into according to classifying rules;With detection module, to case of hospital homepage data progress Data Detection
And quality testing;With, standardized module, for being standardized to the data of importing according to standardization dictionary, including generation
Code standardization and format specification;Also content data file is identified, if identifying nonstandard file, stops the doctor
The quality inspection of the first page of illness case of institute;With data statistic analysis module is for statistical analysis to data according to quality inspection rule, analyzes
The overall condition of all case of hospital homepage data in certain period show that quality measurements are reported, and provides and ask accordingly
Inscribe detail list.
The above is only the specific implementation mode of the present invention, is made skilled artisans appreciate that or realizing this hair
It is bright.Various modifications to these embodiments will be apparent to one skilled in the art, as defined herein
General Principle can be realized in other embodiments without departing from the spirit or scope of the present invention.Therefore, of the invention
It is not intended to be limited to the embodiments shown herein, and is to fit to and the principles and novel features disclosed herein phase one
The widest range caused.
Claims (17)
1. Medical record database quality determining method, characterized in that specifically include following steps:
Import data to database;
The data of importing are detected.
2. according to the method described in claim 1, it is characterized in that, import data to database and specifically include following steps:
File is converted to unified format by the file that acquisition hospital reports;
The file converted is stored according to certain classifying rules in corresponding catalogue;
It is that the hospital generates database, and the information of data file is imported into corresponding table according to the data file of importing;
The interim table of the hospital is created, and the information of data file is imported into corresponding interim table.
3. according to the method described in claim 2, it is characterized in that, the classifying rules includes:It is stored under per class hospital catalogue
The catalogue in the hospital each year stores the catalogue in each season under each year catalogue, hospital is stored under each season catalogue
The data file and dictionary table catalogue in the season store each dictionary table file directory, each dictionary table text under dictionary table catalogue
Each dictionary list file is stored under part catalogue.
4. according to the method described in claim 1, it is characterized in that, it is further comprising the steps of after importing data to database:
Data are standardized;
Field after standardization is pre-processed.
5. according to the method described in claim 4, it is characterized in that,
It is described to data be standardized including:Field is mapped by standardizing dictionary, specifically includes following step
Suddenly:
Preceding 232 fields are obtained from the field mapping table of the corresponding database of hospital;
Preceding 232 fields of acquisition are matched with 232 fields of standard, capitalization is converted in matching;
If the data after matching are imported into standard form table by successful match;If there is unmatched field, then will
The field imported into field mapping table and terminates the subsequent quality inspection flow of the hospital.
6. according to the method described in claim 5, it is characterized in that, 232 fields of the standard include defending system 4-1 standards 232
A field.
7. according to the method described in claim 4, it is characterized in that, described pair standardization after field carry out pretreatment include to generation
Code is standardized and carries out standardization processing to format.
8. according to the method described in claim 7, it is characterized in that, the method that code is standardized is specifically included:Root
According to code table mapping relations by the court's code conversion of respective field be standard code;
The method for carrying out standardization processing to format specifically includes:Obtain the data format of 232 fields in database;According to number
The field that the field of nvarchar data type is converted to respective type according to format is set as empty if convert failed.
9. according to the method described in claim 8, it is characterized in that, the standard code and the court's code are one-to-many relationship,
Specially:The court's code is empty or multiple values, and corresponding standard code is to determine to be worth;
The data format includes string, double, datetime, int.
10. according to the method described in claim 8, it is characterized in that, by the court's code conversion of respective field be standard code
When also need read the court's code table;When reading the court's code table, the court's code is grouped automatically according to comma.
11. according to the method described in claim 1, it is characterized in that, the data of importing are detected including Data Detection and matter
Amount detection.
12. according to the method for claim 11, characterized in that the Data Detection specifically includes following steps:
Diagnostic message is detached from first page of illness case mark data into individual table with operation and operation information;
Data in update diagnostic message, operation and operation information, medical record attribute list are prepared as later stage statistics and use;
Count each moon record number;
The court's disease dictionary table and operation and operation dictionary table are matched with normal dictionary table, statistical match rate.
13. according to the method for claim 11, characterized in that the quality testing includes according to quality inspection rule to medical record
Homepage data field is detected, and testing result is preserved in the database, specifically includes following steps:
Traverse all quality inspection rules;
According to first page of illness case content involved in each single item quality inspection rule, first page of illness case content is extracted from tables of data
Come;
According to quality inspection rule, judge whether first page of illness case content is legal.
14. according to the method for claim 13, characterized in that examined to Medical record database field according to quality inspection rule
Survey the normalization for specifically including the integrality of detection data, the standard of detection data, detection data;
The detection integrality includes the percentage of head rice for detecting Medical record database and filling in, including detects required field integrality,
Detect non-required field integrality and detection combination field integrality;
The examination criteria includes the utilization rate for detecting each code, standard diagnosis and treatment subject register and discharge section office of the court code
Match condition, the court's disease dictionary table version match situation and the court's operation and operation dictionary table version match situation;
The inspection criterion includes detecting single field specification, detection conjunction code field logic, detection combination field to take
With logic, detection combination field time logic.
15. according to the method for claim 13, characterized in that the testing result includes test results report and problem
Detail list;
The quality measurements are reported as whole quality measurements, including the indices of quality inspection rule, accordingly ask
Inscribe chain;The problem link, which may link to, is connected to corresponding problem detail list;
The problem detail list is distributed according to quality inspection result items, and each problem detail list is asked comprising what a result items recorded
Inscribe data;Problem detail list is stored according to patient's identification number, date of birth, admission time and problem field;Patient's identification number, date of birth
Phase and admission time are used for positioning Medical record database, and problem field is the data of problem field.
16. Medical record database quality detecting system utilizes the method described in claim 1 to 15 any one, characterized in that
Including data import modul, hospital data is converted to unified format, database is imported into according to classifying rules;With,
Detection module carries out Data Detection and quality testing to case of hospital homepage data.
17. system according to claim 16, characterized in that the system further includes standardized module, for according to
Standardization dictionary is standardized the data of importing, including code standardization and format specification;Also to data file
Content is identified, if identifying nonstandard file, stops the quality inspection of the first page of illness case of the hospital;With,
Data statistic analysis module, it is for statistical analysis to data according to quality inspection rule, analyze all hospitals in certain period
The overall condition of Medical record database show that quality measurements are reported, and provides corresponding problem detail list.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810127119.3A CN108389621B (en) | 2018-02-08 | 2018-02-08 | Method and system for detecting data quality of first page of medical record |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810127119.3A CN108389621B (en) | 2018-02-08 | 2018-02-08 | Method and system for detecting data quality of first page of medical record |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108389621A true CN108389621A (en) | 2018-08-10 |
CN108389621B CN108389621B (en) | 2020-08-04 |
Family
ID=63075474
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810127119.3A Active CN108389621B (en) | 2018-02-08 | 2018-02-08 | Method and system for detecting data quality of first page of medical record |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108389621B (en) |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109446192A (en) * | 2018-11-09 | 2019-03-08 | 贵州医渡云技术有限公司 | Data test method and device |
CN109659034A (en) * | 2018-11-30 | 2019-04-19 | 平安医疗健康管理股份有限公司 | Data Quality Assessment Methodology, device, equipment and the storage medium of first page of illness case |
CN110033838A (en) * | 2019-03-13 | 2019-07-19 | 武汉金豆医疗数据科技有限公司 | A kind of triple logic verification systems of medical data and its method of calibration |
CN110136788A (en) * | 2019-05-14 | 2019-08-16 | 清华大学 | It is a kind of based on the case history quality detecting method, device, equipment and the storage medium that detect automatically |
CN110532273A (en) * | 2019-08-30 | 2019-12-03 | 北京明略软件系统有限公司 | The processing method and processing device of tables of data, storage medium, electronic device |
CN110827978A (en) * | 2019-09-25 | 2020-02-21 | 云知声智能科技股份有限公司 | Hospitalization condition identification method and device |
CN111161815A (en) * | 2019-12-27 | 2020-05-15 | 深圳中兴网信科技有限公司 | Medical data detection method, device, terminal and computer-readable storage medium |
CN111933301A (en) * | 2020-06-30 | 2020-11-13 | 望海康信(北京)科技股份公司 | DRG grouper forming system, method and corresponding equipment, storage medium |
CN112559523A (en) * | 2020-12-11 | 2021-03-26 | 北京锐安科技有限公司 | Data detection method and device, electronic equipment and storage medium |
CN113052410A (en) * | 2019-12-26 | 2021-06-29 | 医渡云(北京)技术有限公司 | Quality control method and device for electronic medical record data |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101582100A (en) * | 2008-05-17 | 2009-11-18 | 侯红卫 | Terminal medical record quality evaluation input system and input method thereof |
CN103593816A (en) * | 2013-11-25 | 2014-02-19 | 方正国际软件有限公司 | Medical history document memorizing device and memorizing method |
US20140379718A1 (en) * | 2013-06-21 | 2014-12-25 | Virtual Radiologic Corporation | Radiology data processing and standardization techniques |
CN105808951A (en) * | 2016-03-10 | 2016-07-27 | 宁波金唐软件有限公司 | Quality control method and apparatus for electronic medical record |
CN106295144A (en) * | 2016-07-29 | 2017-01-04 | 广州天健软件有限公司 | A kind of medical data acquisition method of quality control |
-
2018
- 2018-02-08 CN CN201810127119.3A patent/CN108389621B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101582100A (en) * | 2008-05-17 | 2009-11-18 | 侯红卫 | Terminal medical record quality evaluation input system and input method thereof |
US20140379718A1 (en) * | 2013-06-21 | 2014-12-25 | Virtual Radiologic Corporation | Radiology data processing and standardization techniques |
CN103593816A (en) * | 2013-11-25 | 2014-02-19 | 方正国际软件有限公司 | Medical history document memorizing device and memorizing method |
CN105808951A (en) * | 2016-03-10 | 2016-07-27 | 宁波金唐软件有限公司 | Quality control method and apparatus for electronic medical record |
CN106295144A (en) * | 2016-07-29 | 2017-01-04 | 广州天健软件有限公司 | A kind of medical data acquisition method of quality control |
Cited By (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109446192B (en) * | 2018-11-09 | 2021-06-29 | 贵州医渡云技术有限公司 | Data testing method and device |
CN109446192A (en) * | 2018-11-09 | 2019-03-08 | 贵州医渡云技术有限公司 | Data test method and device |
CN109659034A (en) * | 2018-11-30 | 2019-04-19 | 平安医疗健康管理股份有限公司 | Data Quality Assessment Methodology, device, equipment and the storage medium of first page of illness case |
CN110033838A (en) * | 2019-03-13 | 2019-07-19 | 武汉金豆医疗数据科技有限公司 | A kind of triple logic verification systems of medical data and its method of calibration |
CN110136788A (en) * | 2019-05-14 | 2019-08-16 | 清华大学 | It is a kind of based on the case history quality detecting method, device, equipment and the storage medium that detect automatically |
CN110136788B (en) * | 2019-05-14 | 2021-08-17 | 清华大学 | Medical record quality inspection method, device, equipment and storage medium based on automatic detection |
CN110532273A (en) * | 2019-08-30 | 2019-12-03 | 北京明略软件系统有限公司 | The processing method and processing device of tables of data, storage medium, electronic device |
CN110827978A (en) * | 2019-09-25 | 2020-02-21 | 云知声智能科技股份有限公司 | Hospitalization condition identification method and device |
CN113052410A (en) * | 2019-12-26 | 2021-06-29 | 医渡云(北京)技术有限公司 | Quality control method and device for electronic medical record data |
CN111161815A (en) * | 2019-12-27 | 2020-05-15 | 深圳中兴网信科技有限公司 | Medical data detection method, device, terminal and computer-readable storage medium |
CN111933301A (en) * | 2020-06-30 | 2020-11-13 | 望海康信(北京)科技股份公司 | DRG grouper forming system, method and corresponding equipment, storage medium |
CN112559523A (en) * | 2020-12-11 | 2021-03-26 | 北京锐安科技有限公司 | Data detection method and device, electronic equipment and storage medium |
WO2022121337A1 (en) * | 2020-12-11 | 2022-06-16 | 北京锐安科技有限公司 | Data exploration method and apparatus, and electronic device and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN108389621B (en) | 2020-08-04 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108389621A (en) | Medical record database quality determining method and system | |
Metlay et al. | Measuring symptomatic and functional recovery in patients with community-acquired pneumonia | |
Williams et al. | Hospital episode statistics: time for clinicians to get involved? | |
Considine et al. | Nurses' documentation of physiological observations in three acute care settings | |
CA2461214A1 (en) | System and method of improved recording of medical transactions | |
CN107273698A (en) | The processing in artificial intelligence training standard storehouse and detection method, system | |
Pearl et al. | Assessing the quality of last menstrual period date on California birth records | |
Huang et al. | The perceptions of physicians and nurses regarding the establishment of patient safety in a regional teaching hospital in Taiwan | |
US11875884B2 (en) | Expression of clinical logic with positive and negative explainability | |
CN115185936B (en) | Medical clinical data quality analysis system based on big data | |
CN115064230A (en) | DRG block code generation method and system | |
Bain et al. | Routinely collected data in national and regional databases-an under-used resource | |
Munroe et al. | Increasing accuracy in documentation through the application of a structured emergency nursing framework: a multisite quasi‐experimental study | |
US20080275732A1 (en) | Using patterns of medical treatment codes to determine when further medical expertise is called for | |
CN110335649B (en) | Clinical medicine test data platform based on Filemaker database | |
Eftekhar-Vaghefi et al. | Gaining insight into the prevention of maternal death using narrative analysis: an experience from Kerman, Iran | |
Deily et al. | The impact of health information technology adoption by outpatient facilities on pregnancy outcomes | |
Harding et al. | Accuracy of screening tools for pap smears in general practice | |
CN115798667A (en) | Physical examination report generation method and device, computer equipment and storage medium | |
CN109448846A (en) | A kind of analysis method for calculating rare sick disease incidence based on medical insurance big data | |
CN108682454A (en) | A kind of voice medical order management system and method based on mobile terminal | |
Bae | The association between health status and job satisfaction among female workers: A nationwide cross‐sectional study | |
Coco | How often do physicians address other medical problems while providing prenatal care? | |
Hegarty et al. | Nursing documentation: non-physical dimensions of end-of-life care in acute wards | |
Anderson et al. | Overview of secondary data analysis with a description of heart failure hospitalizations from the national hospital discharge survey |
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 |