Data User Portal for the Manitoba Critical Care and Medicine Databases: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(35 intermediate revisions by 2 users not shown)
Line 1: Line 1:
'''Welcome to the external user's portal for the Manitoba Critial Care and Internal Medicine Ward Databases.'''  Updated {{REVISIONYEAR}}-{{REVISIONMONTH}}-{{REVISIONDAY2}}.  
'''Welcome to the external user's portal for the Manitoba Critical Care and Internal Medicine Ward Databases.'''  Updated {{REVISIONYEAR}}-{{REVISIONMONTH}}-{{REVISIONDAY2}}.  


== Brief History ==
== Data Elements of this Database ==
*Using identical data structure, and stored together, these data include two aspects of inpatient medicine:
*Many, but not all of the conceptual data elements are stored in their own, named data fieldThose that do have their own fields are listed in (1) [[Auto Data Dictionary]].
**The ICU database (ICUDB) began in 1988, including the Medical ICU and Surgical ICU at Winnipeg Health Sciences CentreStarting in 1998 it has included all adult ICUs in the Winnipeg Health Region of the province of Manitoba. The number of the number of hospitals containing adult ICUs, the number of adult ICUs, and the number of beds within the ICUs have fluctuated over time.  As of October 2021 it includes ICUs in 3 Winnipeg hospitals: Health Sciences Centre ([[HSC MICU]], [[HSC SICU]] and [[HSC IICU|Intermediate ICU]] [IICU, a chronic ventilator unit]), St. Boniface Hospital ([[STB MICU | MSICU]], [[STB CICU| Cardiac Surgical ICU]], [[STB ACCU|CCU]]), and Grace Hospital ([[GRA_MICU|MSICU]]). See [[Database Anniversary Dates]] for start dates of specific units.
*The others are listed either in: (2) [[Projects]], (3) [[Indicators]] or (4) [[Created Variables CC table]]. Extracting some of these concepts requires taking multiple individual data elements and combining them.
**The Internal Medicine Ward database (IMWDB) began in 2003, including such wards in hospitals within the Winnipeg Health RegionThe number of wards included increased over time and starting January 2005 includes all Internal Medicine wards in Winnipeg hospitals. See [[Database Anniversary Dates]] for start dates of specific wards.
*Also note that while there are many data elements common to the ICU and Medicine databases, there are some elements that are only obtained for ICU patients (e.g. [[TISS]] elements, and some that are only obtained for the IM ward patients (e.g. [[ADL]]) Note that Wiki pages for any data element says explicitly whether it's included in the ICU and/or Medicine ward data.
*The delineation of ICU versus Medicine ward records is by the [[Program]] field, which is either "CC" or "Med".
*Also see [[CCMDB]]
 
== Legacy Data ==
*Database elements have been modified over time, including: retiring elements, adding elements, modifying elements.  This Wiki records such changesAlmost always, retired elements are retained.
*For more information, see [[Legacy Content]]


== What Constitutes a Single Record of Data ==
== What Constitutes a Single Record of Data ==
*Previously, a single database record represented a patient in a single locationThus when a patient moved from ICU to another ICU a new record was begun, and the same for when an IM ward patient moved from place to place (including even moving from teaching to non-teaching).  But this is artificial, because from the patient perspective, such moves are really parts of a single ''episode'' of inpatient care.  
* The ICU and Medicine Ward databases are organized by what we call a "profile", which could also be called a database "record". The details are slightly different for the Critical Care and Medicine portions of the database. See the following for details.
*But beginning 10/1/2020 for Grace Hospital, and 10/15/2020 for Health Sciences Centre and St. Boniface Hospital, we moved part-way in this direction by: (a) having all moves within IM wards in a single hospital being a single record, (b) having direct movement between MICU and SICU at Health Sciences Centre being a single record. See [[PatientFollow Project]] for details on the transition.  
** [[Definition of a Critical Care Laptop Admission]]
*Our eventual goal is to have a patient's entire hospitalization be a single record.
** [[Definition of a Medicine Laptop Admission]]
 
== Reconstructing an Episode of Care from Multiple Database Records ==
* A database record is a "bookkeeping" element -- it is relevant mainly for administrative purposes of understanding resource utilization, and for benchmarking.   
* To understand and evaluate overall patient care, it is the '''episode''' of medical care that is most important. [See: Fransoo et al. Constructing Episodes of Inpatient Care: Data Infrastructure for Population-based Research. ''BMC Medical Research Methodology'' 12(1):133, 2012]
**An '''episode of hospital''' care includes everything that occurs from initial hospital admission to final hospital discharge (or death).
**An '''episode of ICU care''' includes everything that occurs from initial ICU admission to final ICU discharge (or death).  Thus, an ICU episode may include any number of direct ICU-to-ICU transfers either within or between hospitals.  Also, there may be more than one such ICU episode within a hospital episode, and the medical literature on this provides some guidelines for combining seemingly separate ICU episodes if the time interval between them is sufficiently brief (see Fransoo reference). 
**An '''episode of Internal Medicine ward care''' includes everything that occurs from initial ward admission to final ward discharge (or death).  Since all portions of Medicine ward admission within a single hospital is counted as a single Medicine ward database record, a ward episode may include any number of direct ward-to-ward transfers between hospitals. 
* One reconstructs episodes from single database records by reference to: database records, timing of starting and ending of the records, responsible medical services, and physical locations.
**Remember, of course, that our database does not include information on care provided in hospital except for patients admitted to an adult ICU or to an Internal Medicine ward service.  Thus, one may encounter gaps in trying to reconstruct entire episodes of care.
 
== How the Data is Stored ==
*Although once upon a time this was a single "flat table", it is now a relational database including many separate data tables linked together, including 1-to-1 linkages, 1-to-many linkages and the [[Entity–attribute–value model of the L Tmp V2 table]].  The master record identifier for all table linkages is the [[D ID field]].
*The master list of all included tables can be found in: [[CCMDB_Data_Structure]]. Clicking on any of the tables in that Wiki page will take you to it's own page, which includes what data is contained in it.
*Many data elements containing categories of information are coded.  Example: for the discharge location (disposition) field [[Dispo]] what is stored is not words (e.g. home, other hospital, death etc) but numbers.  The tables holding the translation for such codes are "S-tables", which are listed in the "support tables" item in [[CCMDB_Data_Structure]].
*One of the hardest tables to comprehend is [[L_TmpV2 table]] which we often refer to as the "temp table". 
**While each entry into this table links to a single database record, a single record can have any number of entries in this table, and furthermore, those entries may contain a variety of different types of data.  Each entry includes some variables that identify the nature of the data element stored in that entry, and then the element itself. See [[Entity–attribute–value model of the L Tmp V2 table]] for more info on this data model. The types of data included can be found in [[Projects]].


== Using this Wiki ==
== Using this Wiki ==
Line 19: Line 39:
**The second segment addresses the actual structure of how the data is stored
**The second segment addresses the actual structure of how the data is stored


== Understanding the Data Elements ==
== Requesting Access to Data ==
*Many, but not all of the conceptual data elements are stored in their own, named data field.  Those that do have their own fields are listed in [[Auto Data Dictionary]].
* [[Database Request Process]]
*The others are listed either in [[Projects]] or [[Indicators]] or [[Created Variables CC table]].  Extracting some of these concepts requires taking multiple individual data elements and combining them.
* [[Contact]]
*Also note that while there are many data elements common to the ICU and Medicine databases, there are some elements that are only obtained for ICU patients (e.g. [[TISS]] elements, and some that are only obtained for the IM ward patients (e.g. [[ADL]])  Note that Wiki pages for any data element says explicitly whether it's included in the ICU and/or Medicine ward data.
 
== Brief History ==
*[[History and Background of the Critical Care and Medicine Database]]
*[[Category:About]]


== How the Data is Stored ==
*Using identical data structure, and stored together, these data include two aspects of inpatient medicine:
*Although once upon a time this was a single "flat table", it is now a relational database including many separate data tables linked together, including 1-to-1 linkages, 1-to-many linkages and the [[Entity–attribute–value model of the L Tmp V2 table]].  The master record identifier for all table linkages is the [[D ID field]].
**The ICU database (ICUDB) began in 1988, including the Medical ICU and Surgical ICU at Winnipeg Health Sciences Centre.  Starting in 1998 it has included all adult ICUs in the Winnipeg Health Region of the province of Manitoba. The number of the number of hospitals containing adult ICUs, the number of adult ICUs, and the number of beds within the ICUs have fluctuated over time.  As of October 2021 it includes ICUs in 3 Winnipeg hospitals:  Health Sciences Centre ([[HSC MICU]], [[HSC SICU]] and [[HSC IICU|Intermediate ICU]] [IICU, a chronic ventilator unit]), St. Boniface Hospital ([[STB MICU | MSICU]], [[STB CICU| Cardiac Surgical ICU]], [[STB ACCU|CCU]]), and Grace Hospital ([[GRA_MICU|MSICU]]). See [[Database Anniversary Dates]] for start dates of specific units.
*The master list of all included tables can be found in: [[CCMDB_Data_Structure]]. Clicking on any of the tables in that Wiki page will take you to it's own page, which includes what data is contained in it.
**The Internal Medicine Ward database (IMWDB) began in 2003, including such wards in hospitals within the Winnipeg Health Region.  The number of wards included increased over time and starting January 2005 includes all Internal Medicine wards in Winnipeg hospitals. See [[Database Anniversary Dates]] for start dates of specific wards.
*Many data elements containing categories of information are coded. Example: for the discharge location (disposition) field [[Dispo]] what is stored is not words (e.g. home, other hospital, death etc) but numbers.  The tables holding the translation for such codes are "S-tables", which are listed in the "support tables" item in [[CCMDB_Data_Structure]].
*The delineation of ICU versus Medicine ward records is by the [[Program]] field, which is either "CC" or "Med".
*One of the hardest tables to comprehend is [[L_TmpV2 table]] which we often refer to as the "temp table".
**While each entry into this table links to a single database record, a single record can have any number of entries in this table, and furthermore, those entries may contain a variety of different types of data.  Each entry includes some variables that identify the nature of the data element stored in that entry, and then the element itself. See [[Entity–attribute–value model of the L Tmp V2 table]] for more info on this data model. The types of data included can be found in [[Projects]].


== Related articles ==  
== Related articles ==  
{{Related Articles}}
{{Related Articles}}
[[Category:About]]

Revision as of 16:25, 2021 December 15

Welcome to the external user's portal for the Manitoba Critical Care and Internal Medicine Ward Databases. Updated 2021-12-15.

Data Elements of this Database

  • Many, but not all of the conceptual data elements are stored in their own, named data field. Those that do have their own fields are listed in (1) Auto Data Dictionary.
  • The others are listed either in: (2) Projects, (3) Indicators or (4) Created Variables CC table. Extracting some of these concepts requires taking multiple individual data elements and combining them.
  • Also note that while there are many data elements common to the ICU and Medicine databases, there are some elements that are only obtained for ICU patients (e.g. TISS elements, and some that are only obtained for the IM ward patients (e.g. ADL) Note that Wiki pages for any data element says explicitly whether it's included in the ICU and/or Medicine ward data.
  • Also see CCMDB

Legacy Data

  • Database elements have been modified over time, including: retiring elements, adding elements, modifying elements. This Wiki records such changes. Almost always, retired elements are retained.
  • For more information, see Legacy Content

What Constitutes a Single Record of Data

Reconstructing an Episode of Care from Multiple Database Records

  • A database record is a "bookkeeping" element -- it is relevant mainly for administrative purposes of understanding resource utilization, and for benchmarking.
  • To understand and evaluate overall patient care, it is the episode of medical care that is most important. [See: Fransoo et al. Constructing Episodes of Inpatient Care: Data Infrastructure for Population-based Research. BMC Medical Research Methodology 12(1):133, 2012]
    • An episode of hospital care includes everything that occurs from initial hospital admission to final hospital discharge (or death).
    • An episode of ICU care includes everything that occurs from initial ICU admission to final ICU discharge (or death). Thus, an ICU episode may include any number of direct ICU-to-ICU transfers either within or between hospitals. Also, there may be more than one such ICU episode within a hospital episode, and the medical literature on this provides some guidelines for combining seemingly separate ICU episodes if the time interval between them is sufficiently brief (see Fransoo reference).
    • An episode of Internal Medicine ward care includes everything that occurs from initial ward admission to final ward discharge (or death). Since all portions of Medicine ward admission within a single hospital is counted as a single Medicine ward database record, a ward episode may include any number of direct ward-to-ward transfers between hospitals.
  • One reconstructs episodes from single database records by reference to: database records, timing of starting and ending of the records, responsible medical services, and physical locations.
    • Remember, of course, that our database does not include information on care provided in hospital except for patients admitted to an adult ICU or to an Internal Medicine ward service. Thus, one may encounter gaps in trying to reconstruct entire episodes of care.

How the Data is Stored

  • Although once upon a time this was a single "flat table", it is now a relational database including many separate data tables linked together, including 1-to-1 linkages, 1-to-many linkages and the Entity–attribute–value model of the L Tmp V2 table. The master record identifier for all table linkages is the D ID field.
  • The master list of all included tables can be found in: CCMDB_Data_Structure. Clicking on any of the tables in that Wiki page will take you to it's own page, which includes what data is contained in it.
  • Many data elements containing categories of information are coded. Example: for the discharge location (disposition) field Dispo what is stored is not words (e.g. home, other hospital, death etc) but numbers. The tables holding the translation for such codes are "S-tables", which are listed in the "support tables" item in CCMDB_Data_Structure.
  • One of the hardest tables to comprehend is L_TmpV2 table which we often refer to as the "temp table".
    • While each entry into this table links to a single database record, a single record can have any number of entries in this table, and furthermore, those entries may contain a variety of different types of data. Each entry includes some variables that identify the nature of the data element stored in that entry, and then the element itself. See Entity–attribute–value model of the L Tmp V2 table for more info on this data model. The types of data included can be found in Projects.

Using this Wiki

  • This Wiki is the master source of all information about these databases. These databases have experienced a continuous evolution over time, with numerous changes in what is collected, how it is collected, and how it is stored. Discontinued, "legacy" items are indicated as such in the Wiki.
  • Consequently, the Wiki is highly complex.
  • We have divided this introductory portal page for external users into 2 segments, which overlap:
    • The first segment will help you understand the data contained within the databases
    • The second segment addresses the actual structure of how the data is stored

Requesting Access to Data

Brief History

  • Using identical data structure, and stored together, these data include two aspects of inpatient medicine:
    • The ICU database (ICUDB) began in 1988, including the Medical ICU and Surgical ICU at Winnipeg Health Sciences Centre. Starting in 1998 it has included all adult ICUs in the Winnipeg Health Region of the province of Manitoba. The number of the number of hospitals containing adult ICUs, the number of adult ICUs, and the number of beds within the ICUs have fluctuated over time. As of October 2021 it includes ICUs in 3 Winnipeg hospitals: Health Sciences Centre (HSC MICU, HSC SICU and Intermediate ICU [IICU, a chronic ventilator unit]), St. Boniface Hospital ( MSICU, Cardiac Surgical ICU, CCU), and Grace Hospital (MSICU). See Database Anniversary Dates for start dates of specific units.
    • The Internal Medicine Ward database (IMWDB) began in 2003, including such wards in hospitals within the Winnipeg Health Region. The number of wards included increased over time and starting January 2005 includes all Internal Medicine wards in Winnipeg hospitals. See Database Anniversary Dates for start dates of specific wards.
  • The delineation of ICU versus Medicine ward records is by the Program field, which is either "CC" or "Med".

Related articles

Related articles: