Reconciliation of data across distinct feature sets
Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for linking a first electronic data set to a second set of data fields in a second electronic data set. Automatically identifying a prescribing physician identifier based on the linked first and second electronic data sets. Determining a relationship between a physician associated with the prescribing physician identifier and at least one of the approved entities based on comparing the prescribing physician identifier and identifiers of the one or more approved entities to a fourth set of data fields from a fourth electronic data set. Automatically generating an electronic notification indicating that a product sold by the merchant is eligible for the discount in response to determining a relationship between a physician and the at least one of the approved entities.
1. A computer-implemented method for reconciling data across electronic data sources with distinct feature sets, the method executed by one or more processors, and the method comprising:
receiving, by a data reconciliation system, a first data set including:
a first set of data fields, and
electronic prescription fulfillment data,
wherein the first set of data fields includes at least a merchant identifier for a merchant;
determining, by the data reconciliation system, a match between:
a first data datum from a data field of the first set of data fields, and
a second datum from a data field of a second set of data fields, wherein:
the second set of data fields is included in a second data set,
the second data set is distinct from the first data set, and
the second data set includes third-party prescription information;
generating, by the data reconciliation system, a linked database comprising links between the first data set and the second set of data fields, the links based on the match between the first datum and the second datum;
identifying, by the data reconciliation system, a physician identifier for a physician that prescribed a product provided by the merchant, wherein the physician identifier is automatically identified by analyzing the linked database to obtain information from corresponding data fields of the first and second data sets;
identifying, by the data reconciliation system, one or more entities having an approved relationship with the merchant, based on the merchant identifier;
generating, by the data reconciliation system, a confidence score that characterizes a relationship between the physician and an entity by comparing the physician identifier and a respective identifier for each of the one or more entities, based on information in the linked database;
determining, by the data reconciliation system, a confidence level that indicates information in the linked database accurately identifies products that are eligible to be obtained for a predefined amount, wherein the confidence level is determined based on the confidence score exceeding a threshold confidence score and the relationship between the physician and the entity, and
providing, by the data reconciliation system, an electronic notification that includes information indicating the product prescribed by the physician and provided by the merchant is eligible to be obtained for the predefined amount.
2. The method of claim 1 , further comprising reconciling data from the first and second data sets with data from a plurality of other data sets to determine information related to a sale of the product, and
wherein the electronic notification includes the information related to the sale of the product.
3. The method of claim 1 , further comprising:
determining the relationship between the physician associated with the physician identifier and the entity existed on a dispense date of the product, the dispense date included in datum from the first set of data fields.
4. The method of claim 1 , further comprising determining, from data in a third electronic data set, that the approved relationship between the merchant and the one or more entities with which the physician has a relationship existed on a dispense date of the product, the dispense date included in datum from the first set of data fields.
5. The method of claim 1 , wherein the electronic notification includes the confidence score, the confidence score indicating a likelihood that the product is eligible to be obtained for the predefined amount.
6. The method of claim 5 , wherein the confidence score is determined based on a type of the relationship between the physician and one or more entities.
7. The method of claim 5 , wherein the confidence score is determined based on a number of relationships that the physician has with approved entities.
8. The method of claim 1 , wherein the second data set is a secure data set, the method further comprising accessing the second data set from a secure data repository.
9. The method of claim 1 , wherein the predefined amount is a government mandated transaction amount that is associated with a third data set that is a government maintained data set.
10. A system comprising:
one or more processors; and a data store coupled to the one or more processors having instructions stored thereon which, when executed by the one or more processors, causes the one or more processors to perform operations comprising:
receiving, by a data reconciliation system, a first data set including:
a first set of data fields, and
electronic prescription fulfillment data,
wherein the first set of data fields includes at least a merchant identifier for a merchant;
determining, by the data reconciliation system, a match between:
a first data datum from a data field of the first set of data fields, and
a second datum from a data field of a second set of data fields, wherein:
the second set of data fields is included in a second data set,
the second data set is distinct from the first data set, and
the second data set includes third-party prescription information;
generating, by the data reconciliation system, a linked database comprising links between the first data set and the second set of data fields, the links based on the match between the first datum and the second datum;
identifying, by the data reconciliation system, a physician identifier for a physician that prescribed a product provided by the merchant, wherein the physician identifier is automatically identified by analyzing the linked database to obtain information from corresponding data fields of the first and second data sets;
identifying, by the data reconciliation system, one or more entities having an approved relationship with the merchant, based on the merchant identifier;
generating, by the data reconciliation system, a confidence score that characterizes a relationship between the physician and an entity by comparing the physician identifier and a respective identifier for each of the one or more entities, based on information in the linked database;
determining, by the data reconciliation system, a confidence level that indicates information in the linked database accurately identifies products that are eligible to be obtained for a predefined amount, wherein the confidence level is determined based on the confidence score exceeding a threshold confidence score and the relationship between the physician and the entity, and
providing, by the data reconciliation system, an electronic notification that includes information indicating the product prescribed by the physician and provided by the merchant is eligible to be obtained for the predefined amount.
11. The system of claim 10 , wherein the operations further comprise reconciling data from the first and second data sets with data from a plurality of other data sets to determine information related to a sale of the product, and
wherein the electronic notification includes the information related to the sale of the product.
12. The system of claim 10 , wherein the operations further comprise:
determining the relationship between the physician associated with the physician identifier and the entity existed on a dispense date of the product, the dispense date included in datum from the first set of data fields.
13. The system of claim 10 , wherein the operations further comprises:
determining, from data in a third electronic data set, that the approved relationship between the merchant and the one or more entities with which the physician has a relationship merchant existed on a dispense date of the product, the dispense date included in datum from the first set of data fields.
14. The system of claim 10 , wherein the electronic notification includes the confidence score, the confidence score indicating a likelihood that the product is eligible to be obtained for the predefined amount.
15. The system of claim 14 , wherein the confidence score is determined based on a type of the relationship between the physician and one or more entities.
16. The system of claim 14 , wherein the confidence score is determined based on a number of relationships that the physician has with approved entities.
17. The system of claim 10 , wherein the second data set is a secure data set, the method further comprising accessing the second data set from a secure data repository.
18. A non-transient computer readable medium storing instructions that, when executed by one or more processors, cause the one or more processors to perform operations comprising:
receiving, by a data reconciliation system, a first data set including:
a first set of data fields, and
electronic prescription fulfillment data,
wherein the first set of data fields includes at least a merchant identifier for a merchant;
determining, by the data reconciliation system, a match between:
a first data datum from a data field of the first set of data fields, and
a second datum from a data field of a second set of data fields, wherein,
the second set of data fields is included in a second data set,
the second data set is distinct from the first data set, and
the second data set includes third-party prescription information;
generating, by the data reconciliation system, a linked database comprising links between the first data set and the second set of data fields, the links based on the match between the first datum and the second datum;
identifying, by the data reconciliation system, a physician identifier for a physician that prescribed a product provided by the merchant, wherein the physician identifier is automatically identified by analyzing the linked database to obtain information from corresponding data fields of the first and second data sets;
identifying, by the data reconciliation system, one or more entities having an approved relationship with the merchant, based on the merchant identifier;
generating, by the data reconciliation system, a confidence score that characterizes a relationship between the physician and an entity by comparing the physician identifier and a respective identifier for each of the one or more entities, based on information in the linked database;
determining, by the data reconciliation system, a confidence level that indicates information in the linked database accurately identifies products that are eligible to be obtained for a predefined amount, wherein the confidence level is determined based on the confidence score exceeding a threshold confidence score and the relationship between the physician and the entity, and
providing, by the data reconciliation system, an electronic notification that includes information indicating the product prescribed by the physician and provided by the merchant is eligible to be obtained for the predefined amount.
19. The medium of claim 18 , wherein the operations further comprise reconciling data from the first and second data sets with data from a plurality of other data sets to determine information related to a sale of the product, and
wherein the electronic notification includes the information related to the sale of the product.
20. The medium of claim 18 , wherein the operations further comprise:
determining the relationship between the physician associated with the physician identifier and entity existed on a dispense date of the product, the dispense date included in datum from the first set of data fields.