System and method for analyzing de-identified health care data
View Patent ↗A system and method for creating a unique alias associated with an individual identified in a health care database such that health care data, and particularly pharmaceutical-related data, can be efficiently gathered and analyzed. The system has a first data store for storing at least one record where each record includes a plurality of identification fields which when concatenated uniquely identify an individual, and at least one health care field corresponding to health care data associated with the individual. The system also has a second data store, and a processor. The processor selects a record of the first data store, then selects a subset of the plurality of identification fields within the selected record, and concatenates the selected subset of identification fields. Then the processor stores the concatenated identification fields in a record in the second data store with the at least one health care field from the selected record of the first data store.
1. A system for de-identifying health care data comprising:
at least one health care database, the at least one health care database including at least one patient record, each patient record including a plurality of identification fields associated with a patient and at least one health care field, wherein at least one subset of the identification fields associated with a patient uniquely identifies the patient; and
one or more processors in communication with the at least one health care database and a second database, wherein the one or more processors execute instructions that cause the one or more processors to:
select a patient record from the at least one health care database,
extract alphanumeric information from a plurality of the identification fields included in the patient record, the extracted alphanumeric information uniquely identifying the patient;
generate an encrypted unique patient identifier by encrypting the extracted alphanumeric information,
generate a de-identified patient record, wherein the de-identified patient record includes the at least one health care field that is included in the selected patient record and the encrypted unique patient identifier, and wherein the de-identified patient record does not include any information that identifies the patient other than the encrypted unique patient identifier, and
transmit the de-identified patient record to the second database.
2. A method for de-identifying health care data comprising:
selecting, by one or more processors, a patient record from at least one health care database, wherein the at least one health care database includes at least one patient record, each patient record including a plurality of identification fields associated with a patient and at least one health care field, and wherein at least one subset of the identification fields associated with a patient uniquely identifies the patient;
extracting alphanumeric information from a plurality of the identification fields included in the patient record, the extracted alphanumeric information uniquely identifying the patient;
generating an encrypted unique patient identifier by encrypting the extracted alphanumeric information;
generating a de-identified patient record, wherein the de-identified patient record includes the at least one health care field that is included in the selected patient record and the encrypted unique patient identifier, and wherein the de-identified patient record does not include any information that identifies the patient other than the encrypted unique patient identifier; and
transmitting the de-identified patient record to a second database.
3. A non-transitory computer-readable medium encoded with instructions that, when executed by one or more processors, cause the one or more processors to perform operations comprising:
selecting a patient record from at least one health care database, wherein the at least one health care database includes at least one patient record, each patient record including a plurality of identification fields associated with a patient and at least one health care field, and wherein at least one subset of the identification fields associated with a patient uniquely identifies the patient;
extracting alphanumeric information from a plurality of the identification fields included in the patient record, the extracted alphanumeric information uniquely identifying the patient;
generating an encrypted unique patient identifier by encrypting the extracted alphanumeric information;
encrypting the unique patient identifier;
generating a de-identified patient record, wherein the de-identified patient record includes the at least one health care field that is included in the selected patient record and the encrypted unique patient identifier, and wherein the de-identified patient record does not include any information that identifies the patient other than the encrypted unique patient identifier; and
transmitting the de-identified patient record to a second database.
4. The system of claim 1 , wherein the at least one health care field that is included in the selected patient record comprises pharmaceutical claims data, medical claims data, or hospital claims data.
5. The system of claim 1 , wherein the one or more processors execute instructions that cause the one or more processors to:
identify one or more records stored in the second database that include the encrypted unique patient identifier, and
generate a report based on data included in the identified records.
6. The system of claim 1 , wherein the one or more processors execute instructions that cause the one or more processors to generating an encrypted unique patient identifier comprises concatenating the extracted alphanumeric information.
7. The system of claim 1 , wherein the plurality of identification fields included in the selected patient record include one or more of a patient's name, address, social security number, birthday, or gender.
8. The method of claim 2 , wherein the at least one health care field that is included in the selected patient record comprises pharmaceutical claims data, medical claims data, or hospital claims data.
9. The method of claim 2 further comprising:
identifying one or more records stored in the second database that include the encrypted unique patient identifier; and
generating a report based on data included in the identified records.
10. The method of claim 2 , wherein generating an encrypted unique patient identifier comprises concatenating the extracted alphanumeric information.
11. The method of claim 2 , wherein the plurality of identification fields included in the selected patient record include one or more of a patient's name, address, social security number, birthday, or gender.
12. The computer-readable medium of claim 3 , wherein the at least one health care field that is included in the selected patient record comprises pharmaceutical claims data, medical claims data, or hospital claims data.
13. The computer-readable medium of claim 3 , further comprising:
identifying one or more records stored in the second database that include the encrypted unique patient identifier; and
generating a report based on data included in the identified records.
14. The computer-readable medium of claim 3 , wherein generating an encrypted unique patient identifier comprises concatenating the extracted alphanumeric information.
15. The computer-readable medium of claim 3 , wherein the plurality of identification fields included in the selected patient record include one or more of a patient's name, address, social security number, birthday, or gender.