Data Collector Portal: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
No edit summary
 
(4 intermediate revisions by one other user not shown)
Line 9: Line 9:
__TOC__
__TOC__
<!-- don't put content here directly, if we are going to keep that page let's transclude it. Or let's get rid of it... but let's not put some here and some there -->
<!-- don't put content here directly, if we are going to keep that page let's transclude it. Or let's get rid of it... but let's not put some here and some there -->
==Purpose and Mission==
{{DL | that is duplicate content from [[CCMDB#Purpose and Mission]]. Can we just link from here or should we pull it into a template? }}
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 [[: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
*Maintain the quality of the data 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 requests that require data analysis.
*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.


== Information for new collectors ==
== Information for new collectors ==
Line 36: Line 53:


== Information for all collectors ==
== Information for all collectors ==
=== Info about our program ===
* [[CCMDB]] and [[CCMDB.accdb]]
* [[Publications, abstracts, presentations using the Critical Care and Medicine Database]]
* [[Reporting]]
* [[History and Background of the Critical Care and Medicine Database]]
* [[:Category: Data Use]]
=== How to Structure your Day ===
* [[News and backup]]
* Review recent changes on the wiki
* [[Cognos data import]] if delayed complete discharges as per [[EPR]]
* focus on new admissions as per [[Overstay2 Overview]] if your site participates in this project
* if your site does not participate in the Overstay2 project, focus on completing the oldest discharges/transfers first as per the [[MR List]]
* [[News and backup]] and [[Sending Patients]]
== Data Entry Components ==
===[[Cognos data import]]===
* [[Cognos2 Service Starter]] see also [[Service tmp entry]]
* [[Cognos2 Ender]]
* [[Cognos2 Unit Starter]] see also [[Boarding Loc]]
=====Admissions=====
* [[Definition of a Critical Care Program Admission]]
** [[Apache]] for ICU collection only
* [[Definition of a Medicine Program Admission]]
** [[ADL]] for medicine collection only
** [[ALERT Scale]] and [[ALERT Scale timing of assessment]] for medicine collection only
* [[Demographics]] for both
* [[Minimal Data Set]] for both
===== Diagnoses =====
===== Diagnoses =====
* [[ICD10 collection]]
* [[ICD10 collection]]
* [[ICD10 Diagnosis List]] '''(slow)'''
* [[ICD10 Diagnosis List]] '''(slow)'''
* [[Admit Diagnosis]]
* [[Comorbid Diagnosis]]
* [[Acquired Diagnosis]]


===== Procedures =====
===== Procedures =====
Line 45: Line 95:
* [[CCI component 1 codes - what organ was something done to]]
* [[CCI component 1 codes - what organ was something done to]]
* [[CCI component 2 codes - what was done]]
* [[CCI component 2 codes - what was done]]
* [[Admit Procedure]]
* [[Acquired Procedure]]
* [[Converting Lab Counts to CCI]]
* [[TISS28 Collection Guide]] for ICU only
* [[Pharmacy collection]] for ICU only
====Discharges====
* [[Cognos2 Ender]]
* [[Dispo field]]
* [[Transfer Ready DtTm tmp entry]]
* [[Tmp Project Collection]]


==== Communication ====
== Miscellaneous ==
* [[Communication for the CCMDB]]
* [[How to edit the wiki]]
* [[Discussion & Question Instruction]]
** [[Questions]] - list of questions/discussion entries currently on the wiki - anyone, please answer if you know.
* [[Task Team Meeting - Rolling Agenda and Minutes]]
 
==== Misc ====
* [[Contact]]  /  [[p:Contact list | Contact list on private wiki, requires login]]
* [[Contact]]  /  [[p:Contact list | Contact list on private wiki, requires login]]
* [[Site and Location table]]
* [[Site and Location table]]
* Agenda for next Data Collector Team [[Meeting]]
* Agenda for next Data Collector Team [[Meeting]]
* [[Database_Request_Process| Database Request Process]]
* [[p:Main Page | vacation list]]
* [[p:Main Page | vacation list]]
* [[:Category:Work Place Information | Work Place Information]]
* [[:Category:Work Place Information | Work Place Information]]
* [[Confidential waste disposal]]
* [[Confidential waste disposal]]
* [[Troubleshooting]]
* [[Troubleshooting]]
* [[Projects]] currently part of [[Tmp Project Collection]]
* [[Sending Patients]]


=== Info about our program ===
==== Communication ====
* [[CCMDB]]  
* [[Communication for the CCMDB]]
* [[Publications, abstracts, presentations using the Critical Care and Medicine Database]]
* [[Task Team Meeting - Rolling Agenda and Minutes]]
* [[Reporting]]
* [[How to edit the wiki]]
* [[History and Background of the Critical Care and Medicine Database]]
** [[Discussion & Question Instruction]]
* [[:Category: Data Use]]
** [[Questions]] - list of questions/discussion entries currently on the wiki - anyone, please answer if you know.


=== Back office ===
=== Main office ===
* [[Data Processing]]
* [[Data Processing]]
* [[Statistical Analysis]] and [[Reporting]]
* [[Statistical Analysis]] and [[Reporting]]
* [[Database_Request_Process| Database Request Process]]


== Related articles ==  
== Related articles ==  

Latest revision as of 02:44, 25 January 2026

The Portal is a type of “table of contents”, which is designed to help collectors navigate the wiki. It contains a series of links to various pages, which provide information about our program as well as many detailed aspects of data collection.

This page is:

  • a good starting point for new collectors as they learn how to collect data.
  • a convenient reference point for more experienced staff, as it provides links to many different topics in one place.

The Portal is by no means an all inclusive list of links. Use the search engine to find items of specific interest. Also, as the wiki is constantly evolving and improving, please feel free to add anything to this page to make it more complete and user friendly for collectors.

Purpose and Mission

that is duplicate content from CCMDB#Purpose and Mission. Can we just link from here or should we pull it into a template?

  • SMW


  • Cargo


  • Categories

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 data 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 requests 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.

Information for new collectors

The following links serve as an "orientation package" for new Medicine and ICU collectors at all three hospital sites.

Please review them before and during your orientation, to familiarize yourself with many aspects of data collection as well as to start learning how to navigate the wiki.

Expand the following collapsible box to find site specific details:

Site Specific Collection Details   

Information for all collectors

Info about our program

How to Structure your Day

Data Entry Components

Cognos data import

Admissions
Diagnoses
Procedures

Discharges

Miscellaneous

Communication

Main office

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Data_Collector_Portal&oldid=168527"