title: A Systematic Approach to Creation of a Perioperative Data Warehouse.
abstract: Extraction of data from the electronic medical record is becoming increasingly important for quality improvement initiatives such as the American Society of Anesthesiologists Perioperative Surgical Home. To meet this need, the authors have built a robust and scalable data mart based on their implementation of EPIC containing data from across the perioperative period. The data mart is structured in such a way so as to first simplify the overall EPIC reporting structure into a series of Base Tables and then create several Reporting Schemas each around a specific concept (operating room cases, obstetrics, hospital admission, etc.), which contain all of the data required for reporting on various metrics. This structure allows centralized definitions with simplified reporting by a large number of individuals who access only the Reporting Schemas. In creating the database, the authors were able to significantly reduce the number of required table identifiers from >10 to 3, as well as to correct errors in linkages affecting up to 18.4% of cases. In addition, the data mart greatly simplified the code required to extract data, making the data accessible to individuals who lacked a strong coding background. Overall, this infrastructure represents a scalable way to successfully report on perioperative EPIC data while standardizing the definitions and improving access for end users.
authors.affiliation: From the Departments of *Anesthesiology and Perioperative Medicine and †Medicine, David Geffen School of Medicine at UCLA, Los Angeles, California; and ‡Office of Health Informatics and Analytics, David Geffen School of Medicine at UCLA, Los Angeles, California.
authors.forename: Ira S
authors.initials: IS
authors.lastname: Hofer
authors.forename: Eilon
authors.initials: E
authors.lastname: Gabel
authors.forename: Michael
authors.initials: M
authors.lastname: Pfeffer
authors.forename: Mohammed
authors.initials: M
authors.lastname: Mahbouba
authors.forename: Aman
authors.initials: A
authors.lastname: Mahajan
mesh_terms: D057225:Data Mining / Q000379:methods* / Q000592:standards; D016208:Databases, Factual / Q000592:standards; D057286:Electronic Health Records / Q000592:standards; D006801:Humans; D008498:Medical Record Linkage / Q000379:methods* / Q000592:standards; D059035:Perioperative Period / Q000592:standards; D017064:Process Assessment, Health Care; D058996:Quality Improvement; D019984:Quality Indicators, Health Care