System for processing and consolidating records

• US 6,912,549 B2
• Filed: 11/06/2001
• Issued: 06/28/2005
• Est. Priority Date: 09/05/2001
• Status: Active Grant

• Current Assignee: Cerner Innovation, Inc. (Oracle Corporation)
• Original Assignee: Siemens Medical Solutions Health Services Corporation (Siemens AG)
• Inventors: Brown, Barbara Claire, Rotter, Joann Molaro
• Primary Examiner(s): Robinson, Greta
• Assistant Examiner(s): DODDS, HAROLD E
• Application Number:
  US09/993,041
• Publication Number:
  US 20030046280A1
• Time in Patent Office: 1,330 Days
• Field of Search: 707 1- 6, 707 8- 10, 707100-102, 707/104.1, 707200-203, 707/205, 707/206, 705 1- 3, 709200-203, 709/223, 709/224
• US Class Current: 1/1
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G16H 10/60 for patient-specific data, e.g. for electronic patient records
• CPC Class Codes: G16Z 99/00 Subject matter not provided for in other main groups of this subclass
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

A system prevents the creation of duplicate records and identifies, groups, and consolidates duplicate records and manages the associated workload. A method consolidates multiple records that are associated with a single entity and are stored in at least one record repository. The method involves identifying first and second records and applying record matching criteria to compare data element content of the first and second identified records to determine commonality data. The commonality data is indicative of a likelihood the first and second records are associated with a common entity. The first and second record content is merged into a composite record in response to the determined commonality data. One of the first and second records are selected as a surviving record based on earliest date of record creation or relative content of the first and second records.

Claims

1. A method for consolidating multiple records associated with a single entity and stored in at least one record repository, comprising the steps of:

identifying a first record;

identifying a second record;

applying record matching criteria to compare data element content of said first and second identified records to determine commonality data indicative of a likelihood said first and second records are associated with a common entity; and

merging said first and second record content into a composite record in response to said determined commonality data and excluding at least a portion of replicated and redundant information occurring in said content.

2. A method according to claim 1, including the step of,

selecting one of said first and second records as a surviving record based on at least one of, (a) earliest date of record creation and (b) relative content of said first and second records and

transferring a first identified element of the non-selected record into said surviving record to form said composite record.

3. A method according to claim 2, including the step of,

substituting identified elements of the selected record for corresponding elements of the non-selected record for inclusion in said composite record.

4. A method according to claim 1, including the step of,

initiating generation of a record comparison menu showing a first data item of said first record and a corresponding second data item of said second record and prompting a user to select one of said first and second data items for inclusion in said composite record.

5. A method according to claim 4, wherein

said record comparison menu shows said first data item of said first record and said corresponding second data item of said second record side by side for comparison.

6. A method according to claim 1, including the step of,

initiating generation of a record comparison menu showing a first data item of said first record and a corresponding second data item of said second record in response to detection of at least one of, (a) a particular data element in either of said first or said second record and (b) a difference in data content of a record field common to said first and second records.

7. A method according to claim 1, wherein

said steps of identifying first and second records comprise identifying said first and second records using first and second record identifiers respectively.

8. A method according to claim 1, wherein

said step of applying said record matching criteria comprises parsing said first and second records to identify presence of a plurality of predetermined record fields using probabilistic matching for particular text items.

9. A method according to claim 1, wherein

said commonality data comprises a measure quantifying detected occurrence of predetermined record items in both said first and said second records.

10. A method according to claim 9, wherein

said predetermined record items comprise at least one of, (a) text strings and (b) record fields identified by keyword text items.

11. A method according to claim 1, wherein

said merging step includes merging clinical data comprising at least one of (a) electro-cardiograph (ECG) or electro-encepholograph (EEG) data, (b) x-ray data, (c) laboratory test result data, (d) physical characteristic data, (e) previous diagnosis data, (f) allergy data, (g) ventilation data, (h) blood oxygen or pressure data, (i) infusion pump data and (j) pulse data.

12. A method according to claim 1, wherein

said entity comprises at least one of, (a) a patient, (b) an individual, (c) a company, (d) an organization, and (e) a goods item.

13. A method according to claim 1, including the step of,

at least one of, (a) deleting a redundant identifier identifying an item common to both said first and second record from said composite record, and (b) amending an identifier identifying an item common to both said first and second record in said composite record.

14. A method for consolidating multiple healthcare records associated with a patient and stored in at least one record repository, comprising the steps of:

in response to a single entry of user identification and password information for accessing a plurality of concurrently operating applications for,

identifying a first record;

identifying a second record;

applying record matching criteria to compare data element content of said first and second identified records to determine commonality data indicative of a likelihood said first and second records are associated with a common patient; and

merging said first and second record content into a composite record in response to said determined commonality data and excluding at least a portion of replicated and redundant information occurring in said content.

15. A method according to claim 14, including the step of,

at least one of, (a) deleting a redundant identifier identifying an item common to both said first and second record from said composite record, and (b) amending an identifier identifying an item common to both said first and second record in said composite record.

16. A method according to claim 15, wherein

said redundant identifier identifying an item common to both said first and second record comprises an identifier identifying at least one of, (a) a specific patient, (b) a patient record, (c) an element of a patient record and (d) particular patient clinical data.

17. A method according to claim 14, including the step of,

selecting one of said first and second records as a surviving record based on at least one of, (a) earliest date of record creation and (b) relative content of said first and second records and

automatically transferring a first identified element of the non-selected record into said surviving record to form said composite record.

18. A method according to claim 17, wherein

said transferred first identified element comprises at least one of, (a) a user identifier, and (b) record entries concerning medical services delivered to said patient.

19. A method according to claim 17, including the step of,

automatically substituting identified non-clinical elements of the selected record for corresponding elements of the non-selected record for inclusion in said composite record.

20. A method according to claim 19, wherein

said substituted identified elements comprise at least one of, (a) patient address information, (b) patient name, (c) patient physical characteristics and (d) patient non-clinical data.

21. A method according to claim 19, including the step of,

applying a substitution rule for automatically substituting a particular element of said identified elements, said rule comprising at least one of, (a) include only said particular element of said first record in said composite record, (b) include only said particular element of said second record in said composite record, (c) include only a first record particular element, if present in said first record, in said composite record, and (d) include only a second record particular element, if present in said second record, in said composite record.

22. A method according to claim 21, including the step of,

wherein different substitution rules are applicable to particular data items of said first and second records in response to user selection.

23. A method according to claim 14, wherein

said merging step comprises the step of incorporating clinical data of both said first and second records in said composite record.

24. A method according to claim 23, wherein

said step of merging clinical data comprises automatically merging clinical data of said first and second records unless a predetermined condition is satisfied indicating said clinical data is to be merged subject to manual involvement.

25. A method according to claim 14, including the step of,

applying different rules in merging clinical data than in merging non-clinical data of said first and second records.

28. A method according to claim 24, wherein

said predetermined condition identifies at least one of, (a) said patient is on a physician patient list and (b) said clinical data of said second record duplicates said clinical data of said first record.

26. A method for consolidating multiple records associated with a single entity and stored in at least one record repository, comprising the steps of:

identifying first and second records as being associated with a single entity;

determining from stored record information whether said first and second records are indicated as being associated with different entities;

in response to said determination, applying record matching criteria to compare data element content of said first and second identified records to determine commonality data indicative of a likelihood said first and second records are associated with a common entity; and

merging said first and second record content into a composite record in response to said determined commonality data by excluding at least a portion of replicated and redundant information occurring in said content.

27. A method according to claim 26, including the step of,

receiving and storing an indication said first and second records are associated with different entities in response to a previous determination said first and second records were falsely identified as being associated with a single entity.