COMPUTER-IMPLEMENTED SYSTEM AND METHOD FOR ASSOCIATING PRESCRIPTION DATA AND DE-DUPLICATION
A prescription association system and method for grouping together prescription-related transactions and creating groups or “clusters” of prescriptions having similar characteristics. Through an association process, the prescription cluster describes the events surrounding prescription activity. This includes prescribing patterns, payer influences, and patient acceptance of therapy. The same prescription transaction from one data provider may contain additional or different information that can enhance a corresponding duplicate transaction or set of claim lifecycle transactions from another provider. The disclosed processes create unique linking across claims, payers, and patients and form the basis for relating and measuring payer, patient, practitioner, and pharmaceutical promotion influences on healthcare utilization and treatment.
1 . Processor-implemented method for associating prescription-related data, comprising the steps of:
providing at least one processor configured to
receive incoming batch transaction data from a plurality of sources, said incoming batch transaction data being standardized and stored to an operational data store and comprising a plurality of classifications;
process the classifications in order to obtain attributes for the classifications;
process the attributes to determine matches among the attributes for a respective classification for a predetermined period of time,
wherein the at least one processor matches the attributes via:
a primary association pass, whereby the primary association pass compares attributes reflecting at least one of (1) prescription number, (ii) prescription fill date, or (iii) refill code of the incoming batch transaction data to attributes in existing event clusters; and
a secondary association pass, whereby the secondary association pass compares attributes reflecting at least one of (i) pharmacy ID, (ii) prescription number, (iii) drug identification number, or (iv) prescription fill of the incoming batch transaction data to attributes in said existing event clusters;
wherein, when no match has occurred in either the primary or secondary association pass, the at least one processor matches incoming attribute groups to attributes in existing event clusters via:
a tertiary association pass, whereby the tertiary association pass compares attributes reflecting a tertiary incoming attribute group of the incoming batch transaction data to attributes in said existing event clusters;
a quaternary association pass, whereby the quaternary association pass compares attributes reflecting a quaternary incoming attribute group of the incoming bath transaction data to attributes in said existing event clusters;
a quinary association pass, whereby the quinary association pass compares attributes reflecting a quinary incoming attribute group of the incoming batch transaction data to attributes in said existing event clusters; and
updating existing event clusters to include one more attributes of the incoming batch transaction data when a match with one or more existing event clusters has occurred in the primary, secondary, tertiary, quaternary, or quinary association passes, thereby identifying events associated with the prescription-related data; and
grouping into one or more event clusters the matches for each attribute during the predetermined period of time to identify events associates with the prescription-related data that do not match an existing event cluster.
2 . The method of claim 1 ,
wherein the tertiary incoming attribute group comprise at least two of the following: prescription fill date, refill code, drug identification number, gender and age,
wherein the quaternary incoming attribute group comprise at least two of the following: prescription fill date, refill code, drug identification number, practitioner and days; supply; and
wherein the quinary incoming attribute group comprise at least two of the following: prescription fill date, refill code and number of refills authorized.
3 . The method of claim 1 , wherein the events comprise prescribing patterns, payer influences, and patient acceptance of therapy.
4 . The method of claim 1 , wherein the operational data store is capable of providing attributes for use in identification of transactions.
5 . The method of claim 1 , wherein the grouping of the matches in the computer system comprises the step of designating one of the plurality of attributes as an anchor to upon which the grouped matches will be based.
6 . The method of claim 1 , wherein the quinary association attributes comprise pharmacy identification, prescription number, refill code, and a prescription fill date with a specified range.
7 . The method of claim 1 , wherein the quaternary association attributes comprise pharmacy identification, prescription number, drug identification code, and a prescription fill date within a specified range.
8 . The method of claim 1 , wherein the quinary association attributes comprise pharmacy identification, prescription fill date, drug identification code, new or refill code, patient gender code, and patient age within a specified range.
9 . A computer system for associating prescription-related data, comprising:
a memory;
a communication device operatively coupled to the memory to receive incoming batch transaction data from a plurality of sources, said incoming batch transaction data relating to the prescription-related data, said batch transaction data comprising a plurality of predetermined classifications; and
at least one processor, operatively coupled to the communications device for processing the classifications in order to obtain attributes for the classifications and processing the attributes to determine matches among the attributes for a respective classification for a predetermined period of time;
wherein the at least one processor matches the attributes via:
a primary association pass, whereby the primary association pass compares attributes reflecting at least one of (i) prescription number, (ii) prescription fill date, or (iii) refill code of the incoming batch transaction data to attribute in existing event cluster;
a secondary association pass, whereby the secondary association pass compares attributes reflecting at least one of (i) parmarch ID, (ii) prescription number, (iii) drug identification number, or (iv) prescription fill of the incoming batch transaction data to attribute in said existing event clusters; wherein, when no match has occurred in either the primary or secondary association pass, the at least one processor matches incoming attribute groups to attribute in existing event clusters; via:
a tertiary association pass, whereby the tertiary association pass compares attributes reflecting a tertiary incoming attribute group of the incoming batch transaction data to attribute in said existing event clusters:
a quaternary association pass, whereby the quaternary association pass compares attributes reflecting a quaternary incoming attribute group of the incoming batch transaction data to attributes in said existing event clusters; and
a quinary association pass, whereby the quinary association pass compares attributes reflecting a quinary incoming attribute group of the incoming batch transaction data to attributes in said existing event clusters;
wherein the at least one processor updates existing clusters to include one more attributes of the incoming batch transaction data when a match with one or more existing event clusters has occurred in the primary, secondary, tertiary, quaternary, or quinary association passes, thereby identifying event associated with the prescription-related data; and
wherein the at least one processor groups into one or more event clusters the matches for each attribute during the predetermined period of time to identify event associated with the prescription-related data that do not match an existing event cluster.
10 . The computer system of claim 9 , wherein tertiary incoming attribute group comprises at least two of pharmacy identification number, data source code, prescription fill date, refill code, prescription number, drug identification number, and claim status code.
11 . The computer system of claim 10 , wherein the quaternary incomes attribute group prescribing patterns, payer influences and patient acceptance of therapy.
12 . The computer system of claim 11 , wherein the quinary incoming attribute group pharmacy identification, prescription number, refill code, and a prescription fill date within a specific range.
13 . The computer system of claim 12 , wherein the quaternary incoming attribute group comprises pharmacy identification, prescription number, drug identification code, and a prescription fill date within a specified range.
14 . The computer system of claim 13 , further comprising the step of processing the matches to identify and remove duplicates in the batch transaction data.
15 . A computer network for associating prescription-related data, comprising:
at least one memory device;
at least one communication device operatively coupled to the at least one memory device to receive incoming batch transaction data from a plurality of sources, said incoming batch transaction data relating to the prescription-related data, said incoming batch transaction data comprising a plurality of predetermined classifications;
and at least one processor, operatively coupled to the communications device for processing the classifications in order to obtain attributes for the classifications and processing the attributes to determine matches among the attributes for a respective classification for a predetermined period of time;
wherein the at least one processor
(i) processes the attributes by identifying a first matching attributes comprising pharmacy identification, prescription number, refill code, and a prescription fill date within a specified range,
(ii) processes the attributes by identifying a second matching attribute comprising pharmacy identification, prescription number, drug identification code, and a prescription fill date within a specified range,
(iii) processes the attributes by identifying a third matching attribute comprising prescription fill date, refill code, drug identification number, gender and age,
(iv) processes the attributes by identifying a fourth matching attribute comprising fill date, refill code, drug identification number, practitioner and days' supply,
(vii) processes the attributes by identifying a fifth matching attribute comprising prescription fill date, refill code and number of refills authorized,
(viii) updates existing event clusters to include one more attributes of the incoming batch transaction data when a match with one or more existing event clusters has occurred in the first, second, third, fourth or fifth matching attribute processes; and
(ix) groups into one or more event clusters the matches for each attribute during the predetermined period of time to identify events associates with the prescription-related data that do not match an existing event cluster.