Abstract: 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.

Abstract: A system includes a database with at least one dataset with at least one data field corresponding to at least one field of data of a medical claim form, a computing platform in communication with the database, and a memory module. The at least one dataset is formed from de-identified provider information. The memory module contains at least one conversion table for converting between a provider identification code and a corresponding provider name. The computing platform receives a request for information, extracts from the database one or more datasets having information responsive to the request, and forms an output table based on the extracted one or more datasets. The table includes the provider name.