title: Integrating feedback from a clinical data warehouse into practice organisation.
abstract: A patient oriented hospital information system (ARIANE) was inaugurated at the Sherbrooke University hospital (CHUS) in 1990 and a clinical data warehouse (CDW) completed 2004. The CDW is updated from ARIANE every 24h and includes ICD discharge diagnosis data, visit DRG and SNOMED encoding. The data is encrypted on storage. Data is accessed according to institutional approval. To facilitate data access two levels of tool have been made accessible using a web-browser. The first level consists of a 'dashboard' that has a defined design and enables a set of pre-determined dynamic queries about a patient population. This level can be operated with minimal training. The second level uses a convivial database query tool, which requires some prior training. Two prototype dashboards have been designed and evaluated for acceptability. The first for the emergency department enables analysis of patient occupancy. The second for the biochemistry department enables quality assurance evaluation. In most cases worldwide the clinical data warehouse is only beginning to be exploited, often impeded by lack of connection between different enterprise databases. Our CDW is expected rapidly to create a culture change so that clinical practice can be continuously evaluated using compiled data readily available from the electronic health record/hospital information system.
authors.affiliation: Centre informatisé de recherche évaluative en soins et systèmes de la santé (CIRESSS Program), Centre hospitalier universitaire de Sherbrooke, Qué., Canada J1H 5N4. andrew.grant@usherbrooke.ca
authors.forename: Andrew
authors.initials: A
authors.lastname: Grant
authors.forename: Andriy
authors.initials: A
authors.lastname: Moshyk
authors.forename: Hassan
authors.initials: H
authors.lastname: Diab
authors.forename: Philippe
authors.initials: P
authors.lastname: Caron
authors.forename: Fabien
authors.initials: F
authors.lastname: de Lorenzi
authors.forename: Guy
authors.initials: G
authors.lastname: Bisson
authors.forename: Line
authors.initials: L
authors.lastname: Menard
authors.forename: Richard
authors.initials: R
authors.lastname: Lefebvre
authors.forename: Patricia
authors.initials: P
authors.lastname: Gauthier
authors.forename: Richard
authors.initials: R
authors.lastname: Grondin
authors.forename: Michel
authors.initials: M
authors.lastname: Desautels
mesh_terms: D003258:Consumer Behavior; D003628:Database Management Systems / Q000458:organization & administration*; D005246:Feedback; D006785:Hospitals, University / Q000458:organization & administration*; D016247:Information Storage and Retrieval / Q000379:methods*; D008491:Medical Informatics Applications; D008498:Medical Record Linkage / Q000379:methods*; D016347:Medical Records Systems, Computerized / Q000458:organization & administration*; D011792:Quebec; D012984:Software; D012985:Software Design; D018511:Systems Integration; D014584:User-Computer Interface