Systems and methods for aggregating data related to employee and patient records
Various aspects described herein relate to systems and methods for merging records from multiple database systems. A method may include comparing, by one or more processors, two or more records of a plurality of records. The plurality of records may be from a plurality of database systems. Each of the plurality of records may be a patient record or an employee record. The method may also include determining, by the one or more processors, that a threshold match exists between the two or more records based upon a set of threshold matching criteria. The method may also include merging, by the one or more processors, the two or more records, based upon determining that the threshold match exists, into a person database entity. A unique entity identifier may be associated with the person database entity.
1. A computer-implemented method for merging records from a plurality of database systems, comprising:
comparing, by one or more processors, two or more records of a plurality of records, wherein the plurality of records are from a plurality of database systems and each of the plurality of records is a patient record or an employee record;
determining, by the one or more processors, that a threshold match exists between the two or more records based upon a set of threshold matching criteria;
merging, by the one or more processors, the two or more records, based upon determining that the threshold match exists, into a person database entity, wherein a unique entity identifier is associated with the person database entity; and
identifying, using the person database entity and the unique entity identifier, anomalous activity by a person associated with the person database entity based on activities associated with the two or more records.
2. The computer-implemented method of claim 1 , wherein each record of the two or more records comprises one or more data points of demographic information, and wherein the threshold match exists when a threshold number of the one or more data points of demographic information of the two or more records match.
3. The computer-implemented method of claim 2 , wherein the one or more data points of demographic information comprise at least one of a name, a date of birth, or a zip code.
4. The computer-implemented method of claim 1 , wherein the set of threshold matching criteria comprises a number of one or more data points of demographic information that can be used to determine the threshold match at a particular confidence rate.
5. The computer-implemented method of claim 1 , wherein the plurality of database systems are associated with a healthcare service provider.
6. The computer-implemented method of claim 1 , wherein the plurality of database systems are associated with a plurality of healthcare service providers.
7. The computer-implemented method of claim 1 , wherein merging the two or more records comprises storing a history of record changes and merges.
8. The computer-implemented method of claim 1 , wherein the person database entity is associated with a set of records pertaining to a single person, the set of records including the two or more records.
9. The computer-implemented method of claim 8 , wherein the single person is a patient and the set of records comprise a plurality of medical records.
10. The computer-implemented method of claim 8 , wherein the single person is an employee and the set of records comprise a plurality of employee records.
11. The computer-implemented method of claim 8 , wherein the single person is both a patient and an employee and the set of records comprise at least one patient record and at least one employee record.
12. The computer-implemented method of claim 8 , further comprising:
determining, by the one or more processors and using a machine learning model, one or more anomalous activities based on data pertaining to the set of records.
13. The computer-implemented method of claim 12 , wherein the one or more anomalous activities comprise:
unauthorized access to patient data; and/or
drug diversion activity.
14. The computer-implemented method of claim 1 , wherein the unique entity identifier facilitates access to the person database entity by a plurality of platforms, each of the plurality of platforms configured to analyze the plurality of records.
15. The computer-implemented method of claim 1 , further comprising updating, by the one or more processors at a second time, the person database entity, wherein the updating comprises:
adding a new record to the person database entity based upon determining that a second threshold match exists between the new record and the two or more records in the person database entity.
16. The computer-implemented method of claim 1 , furthering comprising causing, by the one or more processors, a graphical user interface to be displayed on a computing device of a user for updating the person database entity, wherein the graphical user interface is configured to enable the user to at least one of:
add a new record to the person database entity using one or more first graphical elements of the graphical user interface; or
remove a record of the two or more records from the person database entity using one or more second graphical elements of the graphical user interface.
17. The computer-implemented method of claim 1 , further comprising causing, by the one or more processors, a graphical user interface to be displayed on a computing device of a user, wherein the graphical user interface is configured to enable the user to at least one of:
select records to be merged into the person database entity independent of whether the threshold match exists between the records; or
select records to be not merged into the person database entity independent of whether the threshold match exists between the records.
18. A non-transitory computer readable medium storing instructions which, when executed by one or more processors, cause the one or more processors to perform operations for merging records from a plurality of database systems, comprising:
comparing two or more records of a plurality of records, wherein the plurality of records are from a plurality of database systems and each of the plurality of records is a patient record or an employee record;
determining that a threshold match exists between the two or more records based upon a set of threshold matching criteria;
merging the two or more records, based upon determining that the threshold match exists, into a person database entity, wherein a unique entity identifier is associated with the person database entity; and
using the person database entity and the unique entity identifier to identify anomalous activity by a person associated with the person database entity based on activities associated with the two or more records.
19. The non-transitory computer readable medium of claim 18 , wherein each record of the two or more records comprises one or more data points of demographic information, and wherein the threshold match exists when a threshold number of the one or more data points of demographic information of the two or more records match.
20. A record consolidation system for merging records from a plurality of database systems, comprising:
a memory storing instructions; and
one or more processors operatively connected to the memory and configured to execute the instructions to perform operations including:
comparing two or more records of a plurality of records, wherein the plurality of records are from a plurality of database systems and each of the plurality of records is a patient record or an employee record;
determining that a threshold match exists between the two or more records based upon a set of threshold matching criteria;
merging the two or more records, based upon determining that the threshold match exists, into a person database entity, wherein a unique entity identifier is associated with the person database entity; and
using the person database entity and the unique entity identifier to identify anomalous activity by a person associated with the person database entity based on activities associated with the two or more records.