Systems and methods for integrating data

Patent metadata

Field	Value
Publication number	US-10649983-B1
Application number	US-201715684927-A
Country	US
Kind code	B1
Filing date	Aug 23, 2017
Priority date	Sep 11, 2013
Publication date	May 12, 2020
Grant date	May 12, 2020

Abstract

Systems and methods for integrating data are described. In an example embodiment, a plurality of data attributes of comparison data and the plurality of data attributes of a master record are respectively compared to determine that there is a difference, the comparison data originating from a data source. A relative level of source priority of the data source of the comparison data is determined relative to the data source of a current state version of the master record in accordance with source evaluation criteria. The current state version of the master record is stored in reference data based on a determination that there is a difference and that the source priority of the data source of the comparison data is equal to or greater than the data source of the current state version of the master record. Mapped comparison data is used to update the current state version of the master record based on the determination that there is a difference and that the source significance of the data source of the comparison data is equal to or greater than the data source of the current state version of the master record to create an updated state version of the master record, the mapped comparison data being based on the comparison data. Additional methods and systems are disclosed.

First claim

What is claimed is:

1. A method comprising:
obtaining comparison data relevant to prescription drug claims, medical claims, or both the prescription drug claims and the medical claims provided by a plurality of various data sources, wherein:
the plurality of various data sources includes at least one of a benefit manager database, a data supplier database, a data manager database, and a pharmacy database,
the plurality of various data sources is deployed on respective devices,
the data manager database is configured for storing source data received from at least one of the plurality of various data sources, a master data record, and a reference data record,
the reference data record includes a plurality of data attributes that are associated with a plurality of verified data attributes of the master data record,
the plurality of data attributes of the reference data record includes a source significance that is deemed less than a source significance of the corresponding plurality of verified data attributes of the master data record, and
the source significance represents a level of data currentness and data correctness;

determining a current state version of the master data record by:
respectively comparing at least one of the plurality of data attributes of the reference data record with the corresponding one of the plurality of verified data attributes of the master data record to determine whether there is a difference; or
determining a relative level of source priority of a data source of the plurality of various data sources from which the reference data record is originated from relative to a data source of the plurality of various data sources of the current state version of the master data record in accordance with source evaluation criteria;

in response to a determination that there is a difference and that the relative level of source priority of the data source of the reference data record is equal to or greater than the data source of the current state version of the master data record, updating the current state version of the master data record based on the reference data record and storing the current state version of the master data record in the reference data record;
in response to a determination that there is a difference and that the source significance of the reference data record is equal to or greater than the source significance of the master data record, updating the current state version of the master data record based on the reference data record and storing the current state version of the master data record in the reference data record; and
in response to a determination that there is a difference and that the source significance of the reference data record is less than the source significance of the master data record, keeping the reference data record in the reference data record.

2. The method of claim 1 , further comprising:
identifying a date associated with the reference data record; and
determining whether the date associated with the reference data record is more current than the date associated with the current state version of the master data record, wherein storing the current state version of the master data record in the reference data record and using the reference data record to update the current state version of the master data record are further based on the date associated with the reference data record is more current than the date associated with the current state version of the master data record.

3. The method of claim 1 , further comprising:
determining that the reference data record is previously stored as comparison data,
wherein the using the comparison data to update the current state version of the master data record is further based on a determination that the comparison data is already stored in the reference data record.

4. The method of claim 3 , further comprising:
formatting the comparison data in accordance with a standardized format to create formatted comparison data;
splitting the comparison data in accordance with a standardized field splits format; and
mapping the formatted comparison data into a plurality of data fields based on the standardized field splits format to create the mapped comparison data.

5. The method of claim 3 , further comprising:
comparing the source data against a plurality of available master data records to identify matching source data and nonmatching source data among the source data, the plurality of available master data records including the master data record;
formatting the nonmatching source data in accordance with a standardized format to create formatted source data;
splitting the nonmatching source data in accordance with a standardized field splits format; and
mapping the formatted source data into a plurality of data fields based on the standardized field splits format to create the mapped formatted source data,
wherein the mapped formatted source data includes the comparison data.

6. The method of claim 5 , further comprising:
determining that there is no standardized format for the at least one of the plurality of various data sources;
transmitting the nonmatching source data to a manual processing device; and
receiving a transmission including the standardized format from the manual processing device,
wherein formatting the nonmatching source data in accordance with the standardized format is based on receipt of the transmission.

7. The method of claim 5 , wherein the standardized format includes a standardized spelling format, a standardized capitalization format, a wording appearance format, and a numbering appearance format.

8. The method of claim 5 , wherein comparing the source data against the plurality of available master data records comprises:
respectively comparing a plurality of source data identifiers with a plurality of master data record identifiers of the master data record, the master data record including the plurality of available master data records;
when a source data identifier of the plurality of source data identifiers matches a master data record identifier of the plurality of master data record identifiers, identifying a source data portion associated with the source data identifier as being matching source data;
when a source data identifier is missing, blank, or similar but matching at least a portion of a plurality of remaining data attributes of the source data portion matches a corresponding portion of the plurality of available master data records, identifying the source data portion as being matching source data; and
when the source data portion of the source data has not otherwise been identified as being matching source data, identifying the source data portion as being nonmatching source data.

9. The method of claim 8 , wherein the source data portion is a portion of the source data.

10. The method of claim 8 , further comprising:
receiving a source data transformation to correct a portion of the source data correcting a portion of the source data with the source data transformation to create the source data portion.

11. The method of claim 8 , wherein the source data identifier and the master data record identifier includes NPI.

12. The method of claim 8 , wherein the source data identifier and the master data record identifier includes a telephone number, an address, or a telephone number and an address.

13. The method of claim 3 , further comprising:
identifying a source data provider associated with the comparison data;
determining whether a source data import from the source data provider has previously been performed; and
when a determination is made that

Assignees

• Express Scripts Inc
• Express Scripts Strategic Dev Inc

Inventors

• Lequeux Blayne S

Classifications

• G06F16/215 Primary

  Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors · CPC title

• G06F16/24 Primary

  Querying · CPC title