Duplicate resolution system and method for data management

• US 20030126156A1
• Filed: 12/20/2002
• Published: 07/03/2003
• Est. Priority Date: 12/21/2001
• Status: Abandoned Application

• Current Assignee: Jay A. Stoltenberg, Sheri L. Stoltenberg
• Original Assignee: Jay A. Stoltenberg, Sheri L. Stoltenberg
• Inventors: Stoltenberg, Jay A., Stoltenberg, Sheri L.
• Application Number:
  US10/325,796
• Publication Number:
  US 20030126156A1
• Time in Patent Office: Days
• US Class Current: 707/104.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: G16H 15/00 ICT specially adapted for medical reports, e.g. generation or transmission thereof

Abstract

A system is provided for merging hospital database records and assuring real-time patient field updates during registration processes. A find tool identifies potential duplicate records, data overlays and duplicate guarantor numbers within a master patient index (MPI) or enterprise master patient index (EMPI) database of a hospital database. After the data is scored, a merge tool merges the data and gives the user the ability to review potential duplicate records online and decide on an operation to be performed thereon. A guard tool complements the merge tool as a means for preventing duplicate records and data overlays during the registration process. The user can continue with the new registration or choose an existing record from the duplicate matching screen as the data is inputted, thereby keeping the current inputs clean in “real-time.”

Claims

1. A duplicate resolution system for allowing a user to manage hospital database records in a hospital database, comprising:

a find tool means for allowing a host database to identify potential duplicate data within said hospital database, wherein potential duplicate data is scored using matching routines;

a merge tool means for allowing said user to review said potential duplicate data online from said host database, wherein said user may choose from a plurality of operations to be performed on said potential duplicate data based on said score, wherein at least one of said operations is adapted to allow for a merging of two or more potential duplicates in said potential duplicate data into one record; and

,

a guard tool means for preventing new duplicate data during a registration process, wherein said host database is queried to indicate a likelihood that said new duplicate data is a match to an existing record within said hospital database.

2. The system of claim 1, wherein said find tool means further comprises a means for breaking down said potential duplicate, thereby forming a group of tables containing fields.

3. The system of claim 2, wherein said matching routines allow for such scoring by being adapted to compare said fields of said group, wherein said fields are selected from the group consisting of date of birth, name, sex, social security number, maiden name, and alias.

4. The system of claim 1, wherein said merge tool means further comprises a merge tool screen for displaying said potential duplicate data.

5. The system of claim 4, wherein said merge tool screen further comprises a tool bar menu with menu items.

6. The system of claim 5, wherein said menu items are selected from the group consisting of file, reports, queues, and tools.

7. The system of claim 4, wherein said merge tool screen further comprises a plurality of bar buttons for allowing said user to actuate said operations.

8. The system of claim 1, wherein said guard tool means further comprises a means for creating transaction records based on said new duplicate data, wherein said transaction records may be sent throughout various ancillary systems including back to said host database.

9. The system of claim 8, further comprising a means for listening continuously in on a secure socket layer for any transactions creating said transaction records.

10. The system of claim 8, further comprising a means for logging said transaction records and continuously checking a status of said host database.

11. A duplicate resolution method for allowing a user to manage hospital database records in a hospital database, comprising the steps of:

loading said hospital database records into a host database to allow for an identifying of potential duplicate data within said hospital database;

scoring said potential duplicate data using matching routines;

allowing a user to review said potential duplicate data online from said host database;

allowing said user to perform one or more operations on said potential duplicate data based on said score, wherein at least one of said operations is adapted to merge two or more potential duplicates in said potential duplicate data into one record; and

,

preventing new duplicate data during a registration process by allowing said user to query said host database to indicate a likelihood that any new duplicate data is a match to an existing record within said hospital database.

12. The method of claim 11, wherein after the step of loading said hospital database records, one or more fields of said potential duplicate data is read into an array to form groups for such scoring, wherein all scores over a minimum match score value are checked against any duplicates in said array.

13. The method of claim 12, wherein said groups are sorted such that a report is created for said user to perform said operations on said potential duplicate data.

14. The system of claim 11, wherein said matching routines allow for such scoring by being adapted to compare fields selected from the group consisting of date of birth, name, sex, social security number, maiden name, and alias.

15. The method of claim 11, wherein for the step of preventing new duplicate data during a registration process, a transaction record is created based on said new duplicate data, wherein said transaction records may be sent throughout various ancillary systems including back to said host database for logging and updating.

16. A duplicate resolution method for managing hospital database records, comprising the steps of:

allowing said hospital database records to be loaded into a host database to allow for an identifying of potential duplicate data within a hospital database;

allowing said potential duplicate data to be scored within said host database using matching routines;

reviewing said potential duplicate data online from said host database;

performing one or more operations on said potential duplicate data group based on said score;

wherein at least one of said operations is adapted to merge two or more potential duplicates in said potential duplicate data into one record; and

,

querying said host database to indicate a likelihood that any new duplicate data is a match to an existing record within said hospital database.

17. The method of claim 16, wherein said operations further include placing said group into a bypass record queue, placing said group into a supervisor review queue, placing said group into pull-chart queue, unmerging said group, and force merging said group.

18. The method of claim 16, further comprising the step of receiving a transaction record created based on said new duplicate data, wherein said transaction records may be sent throughout various ancillary systems including back to said host database for logging and updating.