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.