title: Transforming the Premier Perspective Hospital Database into the Observational Medical Outcomes Partnership (OMOP) Common Data Model.
abstract: BACKGROUND
  The Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) has been implemented on various claims and electronic health record (EHR) databases, but has not been applied to a hospital transactional database. This study addresses the implementation of the OMOP CDM on the U.S. Premier Hospital database.
  
  
  METHODS
  We designed and implemented an extract, transform, load (ETL) process to convert the Premier hospital database into the OMOP CDM. Standard charge codes in Premier were mapped between the OMOP version 4.0 Vocabulary and standard charge descriptions. Visit logic was added to impute the visit dates. We tested the conversion by replicating a published study using the raw and transformed databases. The Premier hospital database was compared to a claims database, in regard to prevalence of disease.
  
  
  RESULTS
  The data transformed into the CDM resulted in 1% of the data being discarded due to data errors in the raw data. A total of 91.4% of Premier standard charge codes were mapped successfully to a standard vocabulary. The results of the replication study resulted in a similar distribution of patient characteristics. The comparison to the claims data yields notable similarities and differences amongst conditions represented in both databases.
  
  
  CONCLUSIONS
  The transformation of the Premier database into the OMOP CDM version 4.0 adds value in conducting analyses due to successful mapping of the drugs and procedures. The addition of visit logic gives ordinality to drugs and procedures that wasn't present prior to the transformation. Comparing conditions in Premier against a claims database can provide an understanding about Premier's potential use in pharmacoepidemiology studies that are traditionally conducted via claims databases.
  The conversion of the Premier database into the OMOP CDM 4.0 was completed successfully. The next steps include refinement of vocabularies and mappings and continual maintenance of the transformed CDM.
authors.affiliation: Janssen Research & Development.
authors.forename: Rupa
authors.initials: R
authors.lastname: Makadia
authors.affiliation: Janssen Research & Development.
authors.forename: Patrick B
authors.initials: PB
authors.lastname: Ryan
references.citation: J Pain Palliat Care Pharmacother. 2013 Mar;27(1):62-70
references.pmid: 23302094
references.citation: JAMA. 2010 May 26;303(20):2035-42
references.pmid: 20501925
references.citation: N Engl J Med. 2000 Jun 22;342(25):1878-86
references.pmid: 10861324
references.citation: Pharmacoepidemiol Drug Saf. 2011 Jan;20(1):76-82
references.pmid: 21182155
references.citation: Drug Saf. 2013 Feb;36(2):119-34
references.pmid: 23329543
references.citation: J Biomed Inform. 2012 Aug;45(4):689-96
references.pmid: 22683994
references.citation: J Am Med Inform Assoc. 2012 Jan-Feb;19(1):54-60
references.pmid: 22037893
references.citation: Ann Intern Med. 2010 Nov 2;153(9):600-6
references.pmid: 21041580
references.citation: N Engl J Med. 2005 Jul 28;353(4):349-61
references.pmid: 16049209