System and method for comparing drug product information
View Patent ↗A system and method for comparing vast amounts of drug product information at granular levels is provided. This comparison is facilitated by the creation of a unique key that maintains the integrity of the comparison system. The unique key may contain a therapeutic class identifier, a clinical formulation identifier, an additional detail identifier, a package equivalent size identifier, a unit dose identifier, and a package quantity identifier.
1. A system comprising:
a network interface communicating with a memory;
the memory communicating with a processor;
and the processor, when executing a computer program, is configured to:
receive a first data feed and a second data feed;
parse the first data feed into first data and the second data feed into second data;
assemble a first unique key by transforming the first data, wherein the first unique key comprises at least one of a package quantity identifier, a therapeutic class identifier, a clinical formulation identifier, an additional detail identifier, a package size equivalent identifier, or a unit dose identifier;
assemble a second unique key by transforming the second data, wherein the second unique key comprises at least one of a package quantity identifier, a therapeutic class identifier, a clinical formulation identifier, an additional detail identifier, a package size equivalent identifier, or a unit dose identifier;
determine a relationship between the first data and the second data by comparing the first unique key and the second unique key;
analyze the relationship to create output data, wherein the output data comprises at least one of: a cost effectiveness of purchasing a drug product from different suppliers, a determination of a lowest cost per unit of the drug product, a manufacturer market share for the drug product, or a strategy for submitting a contract bid for the drug product; and
generate reports based at least partially on the output data.
2. The system of claim 1 , wherein the first unique key is at least one of 25 characters, 22 characters or 18 characters in length.
3. The system of claim 1 , wherein the package quantity identifier is 3 characters in length.
4. The system of claim 1 , wherein the first data feed comprises national drug code data.
5. The system of claim 1 , wherein the first unique key comprises a package size equivalent identifier and at least one of a package quantity identifier, a therapeutic class identifier, a clinical formulation identifier, an additional detail identifier, or a unit dose identifier.
6. A method comprising:
parsing, by a computer-based for determining relationships, a first data feed into first data;
parsing, by a computer-based system, a second data feed into second data;
assembling a first unique key by transforming the first data, wherein the first unique key comprises at least one of a package quantity identifier, a therapeutic class identifier, a clinical formulation identifier, an additional detail identifier, a package size equivalent identifier, or a unit dose identifier;
assembling, by the computer-based system, a second unique key by transforming the second data, wherein the second unique key comprises at least one of a package quantity identifier, a therapeutic class identifier, a clinical formulation identifier, an additional detail identifier, a package size equivalent identifier, or a unit dose identifier;
determining, by a computer-based system a relationship between the first data and the second data by comparing the first unique key and the second unique key; and
creating, by a computer-based system, output data by analyzing the relationship, wherein the output data comprises at least one of: a cost effectiveness of purchasing a drug product from different suppliers, a determination of a lowest cost per unit of the drug product, a manufacturer market share for the drug product, or a strategy for submitting a contract bid for the drug product.
7. The method of claim 6 , wherein at the package quantity identifier is 3 characters in length.
8. The method of claim 6 , wherein the first unique key is at least one of 25 characters, 22 characters or 18 characters in length.
9. The method of claim 6 , wherein the first unique key comprises a package size equivalent identifier and at least one of a package quantity identifier, a therapeutic class identifier, a clinical formulation identifier, an additional detail identifier, or a unit dose identifier.
10. The method of claim 6 , wherein the first unique key comprises a package quantity identifier, a therapeutic identifier, a clinical formulation identifier, a unit dose identifier and at least one of an additional detail identifier and a package size equivalent identifier.
11. The method of claim 6 , wherein the output data comprises national drug code data.
12. The method of claim 6 , wherein the output data is grouped according to report criteria.
13. The method of claim 12 , wherein the output data is further grouped according to bid price.
14. The method of claim 6 , wherein the first data feed and the second data feed are each received from at least one of a pharmaceutical supplier or a healthcare supplier.
15. A non-transitory, tangible computer-readable medium having computer-executable instructions stored thereon that, if executed by a computer, for determining g relationships, cause the computer to perform operations comprising:
parsing a first data feed into first data;
parsing a second data feed into second data;
assembling a first unique key by transforming the first data, wherein the first unique key comprises at least one of a package quantity identifier, a therapeutic class identifier, a clinical formulation identifier, an additional detail identifier, a package size equivalent identifier, or a unit dose identifier;
assembling a second unique key by transforming the second data, wherein the second unique key comprises at least one of a package quantity identifier, a therapeutic class identifier, a clinical formulation identifier, an additional detail identifier, a package size equivalent identifier, or a unit dose identifier;
determining a relationship between the first data and the second data by comparing the first unique key and the second unique key; and
creating output data by analyzing the relationship, wherein the output data comprises at least one of: a cost effectiveness of purchasing a drug product from different suppliers, a determination of a lowest cost per unit of the drug product, a manufacturer market share for the drug product, or a strategy for submitting a contract bid for the drug product.