CCMDB: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")
(35 intermediate revisions by 4 users not shown)
Line 1: Line 1:
''Note: For info about the ccmdb.mdb Access program, see [[CCMDB.mdb]].''
''Note: For info about the ccmdb.mdb Access program, see [[CCMDB.accdb]].''


The '''C'''ritical '''C'''are and '''M'''edicine '''D'''ata'''b'''ase is a data collection project for Critical Care Units and Internal Medicine Wards within the WRHA.
The '''C'''ritical '''C'''are and '''M'''edicine '''D'''ata'''b'''ase is a data collection project for Critical Care Units and Internal Medicine Wards within the WRHA.
Line 11: Line 11:


*Provide aggregate data for the purpose of monitoring capacity utilization, diagnostics, work load, and outcome trends.
*Provide aggregate data for the purpose of monitoring capacity utilization, diagnostics, work load, and outcome trends.
*Prepare standardized monthly reports are to be available within one month of the reporting period and quarterly reports within 6 weeks of the quarter end.
*Prepare standardized [[:Category: reporting | reports]] are to be available within one month of the reporting period and quarterly reports within 6 weeks of the quarter end.
*Coordinate the collection of data and manage the raw data
*Coordinate the collection of data and manage the raw data
*Maintain the quality of the date to ensure the most accurate possible representation of a patient’s medical condition, outcomes and hospital stay.
*Maintain the quality of the date to ensure the most accurate possible representation of a patient’s medical condition, outcomes and hospital stay.
*Ensure patient data is available within two weeks of patient discharge 95% of the time.  
*Ensure patient data is available within two weeks of patient discharge 95% of the time.  
*To support administrators and researchers by filling basic data requests within two weeks of the request and within one month for request that require data analysis.
*To support administrators and researchers by filling basic data requests within two weeks of the request and within one month for request that require data analysis.
*To use the data collector resources to support special project data collection requests.
*To use the data collector resources to support [[:Category:Project | special projects]] and other [[Database Request Process| data collection requests]] related to patient care quality improvements in the Regional.  
 
== Data ==
'' see also [[:Category: Data Use]]


==Data we collect==
=== Data that we collect ===
=== Data that we collect ===
The following information is collected:
The [[Auto Data Dictionary]] lists all fields collected by our program.
* Registry information - basic patient demographic data - ICU and Medicine
 
**[[Admit, Transfer and Discharge date and time | Admit, Transfer and Discharge date and time]] - ICU and Medicine
Additionally, the [[Main Page]] has a graphical representation of the general categories of things collected.
**[[Moves for Medicine | Moves for Medicine]] - Medicine
*Admitting Diagnosis ([[:Category: Diagnosis Coding |Diagnosis Coding]])- ICU and Medicine
*Complications ([[:Category: Diagnosis Coding | Diagnosis Coding]]) - ICU and Medicine
* [[:Category:APACHE II|APACHE II]] -ICU
* [[Charlson Comorbidity Index]]-ICU and Medicine
* [[MOST]]- Medicine
* [[Labs]] - ICU and HSC Medicine manually and also by using the [[Delphic system |Delphic system]].  
* [[Pharmacy Collection | Pharmacy Collection]] - ICU
* [[Transfusion Audit | Transfusion Audit]] -ICU
* [[:Category:TISS | TISS]] - ICU
* [[Patient Task Tracking |Patient Task Tracking]] Nursing work items - Medicine


=== Locations where we collect ===
=== Locations where we collect ===
We collect data for all Critical Care (ICU) patients in Winnipeg, and for Internal Medicine patients on specific wards at the following hospitals:
See [[Site and Location table]] for the current list of where we collect data, and when we started and stopped collecting at these sites.
*Health Sciences Center (ICU & MED)
*St Boniface Hospital (ICU & MED)
*Victoria General Hospital (ICU & MED)
*Grace General Hospital (ICU & MED)
*Concordia Hospital (ICU)
*Seven Oaks Hospital (ICU)


=== Data Set Size ===
=== Data Set Size ===
The Critical Care and Medicine Database has been collecting increasing amounts of data from critical care and medicine patients at Winnipeg hospitals since 1988.  
The Critical Care and Medicine Database has been collecting increasing amounts of data from critical care and medicine patients at Winnipeg hospitals since mid June, 1988.  


As of September 2008 we had data for over 111,156 patients.
See: [[Total admissions ICU/Med]] for more details.
 
==[[Accreditation]]==
Leading practice award 2012! See: [[Accreditation]]


==Steering Committee==
==Steering Committee==
The Medicine and Critical Care Database team is directed by a steering committee represented by:
see [[Steering committee Terms of Reference]]
*[[Dr. Dan Roberts]]
*[[Trish Ostryzniuk]]
*[[Betty-Lou Rock]]
*[[Dr. Bruce Light]]
*[[Julie Mojica]]
*[[Dr. Allan Garland]]
*[[Tina Tenbergen]]
 
The steering committee members are responsible for the Medicine and Critical Care Database and provide guidance and leadership for it.
 
*Dan Roberts chairs the steering committee
*Dan Roberts, Betty Lou Rock and Bruce Light are responsible for the approval of projects and data requests and confirming that appropriate ethics approval is obtained when necessary
*Trish Ostryzniuk is responsible for the management and training of the data collectors
*Julie Mojica is responsible for aggregate data reporting and statistical analysis
*Tina Tenbergen is responsible for data compilation, transference and storage and as an advisor on process and quality
*Allan Garland attends as a critical care advisor

Revision as of 11:46, 2019 September 22

Note: For info about the ccmdb.mdb Access program, see CCMDB.accdb.

The Critical Care and Medicine Database is a data collection project for Critical Care Units and Internal Medicine Wards within the WRHA.

Purpose and Mission

Mission Statement Medicine and Critical Care Database April 7, 2008

The collection of medical data at the WRHA department of medicine and critical care sites for the purpose of administration, research and quality improvement purposes.

To that end the following services are provided:

  • Provide aggregate data for the purpose of monitoring capacity utilization, diagnostics, work load, and outcome trends.
  • Prepare standardized reports are to be available within one month of the reporting period and quarterly reports within 6 weeks of the quarter end.
  • Coordinate the collection of data and manage the raw data
  • Maintain the quality of the date to ensure the most accurate possible representation of a patient’s medical condition, outcomes and hospital stay.
  • Ensure patient data is available within two weeks of patient discharge 95% of the time.
  • To support administrators and researchers by filling basic data requests within two weeks of the request and within one month for request that require data analysis.
  • To use the data collector resources to support special projects and other data collection requests related to patient care quality improvements in the Regional.

Data

see also Category: Data Use

Data that we collect

The Auto Data Dictionary lists all fields collected by our program.

Additionally, the Main Page has a graphical representation of the general categories of things collected.

Locations where we collect

See Site and Location table for the current list of where we collect data, and when we started and stopped collecting at these sites.

Data Set Size

The Critical Care and Medicine Database has been collecting increasing amounts of data from critical care and medicine patients at Winnipeg hospitals since mid June, 1988.

See: Total admissions ICU/Med for more details.

Accreditation

Leading practice award 2012! See: Accreditation

Steering Committee

see Steering committee Terms of Reference