Data dictionary

From CCMDB Wiki
Jump to navigation Jump to search

Is this it?

  • Attempt at a easier to follow data dictionary. Is this what you had in mind?
    • Yes, this is what I have in mind. Thanks. Some suggestions:
      • I just notice some start dates are not the actual start dates - It is important for the users to know how far back the data are available so they can decide the covered period of their study. is it possible to change the date to actual earliest collection start date (not 1 Jan 1900). --JMojica 10:05, 2019 January 3 (CST)
        • The start and end dates are stored on the individual pages. If the list shows 1900 then they were not filled in. If you know what they are and fill them in then this page will list them. I can also change the default if-not-filled value in templates to something other than 1900-01-01. I just needed a value for ranges and filters to work. Do you want me to use a different default value? Ttenbergen 14:49, 2019 January 3 (CST)
          • This is just fine. no need to change. --JMojica 13:27, 2019 June 26 (CDT)
  • SMW


  • Cargo


  • Categories
  • add a column for program (Critical care only or Medicine only or both).
    • I can do that, but the table is already getting quite wide for a web page. Can we lose any of the columns we currently have? The info you mean is always visible in the pages themselves as well, in case that's sufficient. But, yes, we can tweak what the tables should show. It is done in Template:DataDictionaryQuery (details visible once you edit it...) and removing fields would be easy enough. I can show you how to add fields. Or I can add them once we confirm what we want.
  • SMW


  • Cargo


  • Categories

On any of the tables below, click on the links in the left columns to find out our definitions and instructions for those fields.

For an alphabetic listing, see Auto Data Dictionary.

Scope

See Site and Location table for a list of where we collect data.

See Total admissions ICU/Med for a recent count of records.

See Data Request Status ICU/Med for how many requests we have had.

Registry

In the collection tool CCMDB.mdb the registry data is all in the L_Log table. In the data processing tool CFE and the central repository Centralized data.mdb this data is split out from the other in L_Log for PHIA reasons.

L_PHI table

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
D ID fieldstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
Pat ID fieldnumberLong Integer11 July 19881 January 2100Raw
LastName fieldstring40Last Name of patient11 July 19881 January 2100Raw
FirstName fieldstring40Last Name of patient11 July 19881 January 2100Raw
PHIN fieldnumberLong IntegerThe patient's PHIN .11 July 19881 January 2100Raw
Date of Birthdatenot enteredDate of Birth (DOB) is the data a patient was born.11 July 19881 January 2100Raw
Chart numberstring8The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals.11 July 19881 January 2100Raw
Notes field (L PHI)stringnot enteredNotes in L_PHI table is used by the data processor to comment on data ad-hoc where needed.11 July 19881 January 2100Raw

L_Log table - Registry

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
LastName fieldstring40Last Name of patient11 July 19881 January 2100Raw
FirstName fieldstring40Last Name of patient11 July 19881 January 2100Raw
PHIN fieldnumberLong IntegerThe patient's PHIN .11 July 19881 January 2100Raw
Date of Birthdatenot enteredDate of Birth (DOB) is the data a patient was born.11 July 19881 January 2100Raw
Chart numberstring8The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals.11 July 19881 January 2100Raw
DC Treatmentstring50"DC" for critical care patients if life-support treatment is terminated, blank for all others.11 July 198810 May 2022Raw
Province fieldstring2Province in which the patient is registered with health care. If the patient is not eligible for health care, it records the province that they reside in.11 July 19881 January 2100Raw
Sex fieldstring7Biological sex of the patient at birth; options are "male" and "female".11 July 19881 January 2100Raw
Postal Code fieldstring6The patient's postal code.1 January 20121 January 2100Raw
pre_acute_living_situation fieldnumberlong integerInfo about the living situation of the patient prior to the current hospitalization.1 July 20161 January 2100Raw
Previous_Location fieldnumberlong integer1 July 20161 January 2100Raw
Service/Location fieldnumberlong integerEncodes which program a record is part of.1 July 20161 January 2100Raw
Dispo fieldnumberlongThe Dispo field contains information about what happens to the patient at the end of their admission.1 July 20161 January 2100Raw
Transfer Ready DtTm fielddatenot entered1 June 199915 October 2020Raw

ADT - via EPR

Admission, discharge and transfer data

L_Log table

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
Province fieldstring2Province in which the patient is registered with health care. If the patient is not eligible for health care, it records the province that they reside in.11 July 19881 January 2100Raw
Sex fieldstring7Biological sex of the patient at birth; options are "male" and "female".11 July 19881 January 2100Raw
R Filter Fieldstring1011 July 19881 January 2019Raw
Postal Code fieldstring6The patient's postal code.1 January 20121 January 2100Raw
pre_acute_living_situation fieldnumberlong integerInfo about the living situation of the patient prior to the current hospitalization.1 July 20161 January 2100Raw
Pre-admit Inpatient Institution fieldnumberlong integerThe most recent previous inpatient location of patients who were already inpatients elsewhere and who have been under medical care continuously before coming to our unit.1 July 20161 January 2100Raw
Previous_Location fieldnumberlong integer1 July 20161 January 2100Raw
Previous Service fieldnumberlong integer1 July 20167 September 2022Raw
Off ward fieldnumberlong integer1 July 201629 January 2020Raw
Service/Location fieldnumberlong integerEncodes which program a record is part of.1 July 20161 January 2100Raw
Dispo fieldnumberlongThe Dispo field contains information about what happens to the patient at the end of their admission.1 July 20161 January 2100Raw
Visit Admit DtTm fielddatenot enteredThis field is used only as an identifier to combine data from the same hospitalization and should not be used as a date.1 January 20031 January 2100Raw
Dispo DtTm fielddatenot entered1 July 20161 January 2100Raw
Transfer Ready DtTm fielddatenot entered1 June 199915 October 2020Raw
TR info status fieldstring195 May 201615 October 2020Raw

APACHE

Apache has physiological components and diagnostic components.

L_Log table - physiological components

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
Admit Type for APACHE IIstring1011 July 19881 January 2100Raw
Chronic Health APACHEstring3017 February 2022Raw
TemperaturenumbersingleThe patient's level in .11 July 19881 January 2100Raw
AP Sys BP FieldnumbersingleAp_SysBP is the systolic blood pressure.11 July 19881 January 2100Raw
AP Dias BP FieldnumbersingleAp_DiasBP is the diastolic blood pressure.11 July 19881 January 2100Raw
HRnumbersingleThe patient's level in .11 July 19881 January 2100Raw
RRnumbersingleThe patient's level in .11 July 19881 January 2100Raw
AP_Verbal fieldstring2611 July 19881 January 2100Raw
AP_Motor fieldstring1911 July 19881 January 2100Raw
AP_Eye fieldstring1311 July 19881 January 2100Raw
GCS sedated fieldbooleannot enteredField does not contain any relevant data.22 September 201615 June 2021Raw
FiO2numbersingle11 July 19881 January 2100Raw
PO2numbersinglePO2 is the partial pressure of oxygen in the patient's arterial blood.11 July 19881 January 2100Raw
PCO2numbersinglePCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L.11 July 19881 January 2100Raw
PHnumbersingleThe acidity or basicity of the patient's arterial blood.11 July 19881 January 2100Raw
Serum CO2numbersingleThe patient's level in .11 July 19881 January 2100Raw
NanumbersingleThe patient's level in .11 July 19881 January 2100Raw
KnumbersingleThe patient's level in .11 July 19881 January 2100Raw
HCTnumbersingleThe patient's level in .11 July 19881 January 2100Raw
WBCnumbersingleThe patient's level in .11 July 19881 January 2100Raw
Creatinine (APACHE)numbersingleThe patient's level in .11 July 19881 January 2100Raw
ARF (APACHE)numbersingleThe ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.11 July 19881 January 2100Raw

Diagnostic components

ADLs - Activities of Daily Living

Collected according to ADL General Collection Information.

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
ADL Bathingstring151 October 20031 January 2100Raw
ADL Dressingstring151 October 20031 January 2100Raw
ADL Toilettingstring151 October 20031 January 2100Raw
ADL Transferingstring151 October 20031 January 2100Raw
ADL Continencestring151 October 20031 January 2100Raw
ADL Feedingstring151 October 20031 January 2100Raw

Diagnoses

ICD10 - L_ICD10 table

This stores our version of ICD10 (see ICD10 Diagnosis List), collected following the ICD10 collection instructions.

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
D ID fieldstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
Pat ID fieldnumberLong Integer11 July 19881 January 2100Raw
L ICD10 IDnumberlong11 July 19881 January 2100Raw
ICD10 codestring1011 July 19881 January 2100Raw
Dx Datedatenot entered11 July 19881 January 2100Raw
Dx Date unknownbooleannot entered11 July 19881 January 2100Raw
Dx Typestring811 July 19881 January 2100Raw
Dx Prioritynumbersingle11 July 19881 January 2100Raw
Dx Primarybooleannot entered11 July 19881 January 2100Raw

Old dx schema

In this schema procedures were coded together with diagnoses.

Diagnoses - L_Dxs table

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
D ID fieldstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
Pat ID fieldnumberLong Integer11 July 19881 January 2100Raw

Comorbids - L_Como table

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
D ID fieldstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
Pat ID fieldnumberLong Integer11 July 19881 January 2100Raw

Procedures

This stores our version of CCI, collected following the CCI Collection instructions.

L_CCI_Picklist table

See CCI Picklist for possible values.

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
D ID fieldstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
Pat ID fieldnumberLong Integer11 July 19881 January 2100Raw
Px Datedatenot entered11 July 19881 January 2100Raw
CCI Picklist Codestring201 January 20191 January 2100Raw
Px Countdatenot entered11 July 19881 January 2100Raw
Px Typestringnot entered11 July 19881 January 2100Raw

L_CCI_Component table

See CCI component 1 codes - what organ was something done to, CCI component 2 codes - what was done for possible values.

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
D ID fieldstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
Pat ID fieldnumberLong Integer11 July 19881 January 2100Raw
Px Datedatenot entered11 July 19881 January 2100Raw
Px Countdatenot entered11 July 19881 January 2100Raw
Px Typestringnot entered11 July 19881 January 2100Raw

Old dx coding schema

In the old dx coding schema procedures were coded together with diagnoses, see #L_Dxs table.

Labs

CCI

See Converting Lab Counts to CCI for how the labs described in #Pre-CCI manual collection are now collected in CCI.

Pre-CCI manual collection

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
Pat ID fieldnumberLong Integer11 July 19881 January 2100Raw
D ID fieldstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
CBCintegerintegerCBC contains the number of CBCs done during a patient's stay in our unit.11 July 198831 December 2018Raw
PT PTTintegerintegerPT_PTT contains the number of PTs and PTTs done during a patient's stay in our unit.11 July 198817 March 2017Raw
FFPintegerintegerFresh Frozen Plasma / FFP contains manually collected doses of FFP that were given.11 July 198831 December 2018Raw
PlateletsintegerintegerPlatelets contains number of doses of platelets that were given.11 July 198831 December 2018Raw
Albumin 25pctintegerintegerAlbumin_25pct contains number of doses of 25% Albumin that were given.11 July 198831 December 2018Raw
Albumin 5pctintegerintegerAlbumin_5pct contains the number of doses of 5% Albumin that were given.11 July 198831 December 2018Raw
Creatinine (labs)integerintegerCreatinine contains the number of creatinines done during a patient's stay in our unit.11 July 198817 March 2017Raw
Magnesium (labs)integerintegerMagnesium contains the number of magnesiums done during a patient's stay in our unit.11 July 198831 December 2018Raw
SGPT ALT (labs)integerintegerSGPT_ALT contains the number of SGPTs and ALTs done during a patient's stay in our unit.11 July 198817 March 2017Raw
TroponinintegerintegerTroponincontains the number of troponins done during a patient's stay in our unit.11 July 198817 March 2017Raw
CXRintegerintegerChest Xrays (CXR) contains the manually counted number of chest xrays (CXR) done during a patient's stay in our unit.11 July 198831 December 2018Raw
CT Scan (labs)integerintegerCT_Scan contains the manually counted number of CT scans done during a patient's stay in our unit.11 July 198831 December 2018Raw
Angio coronary fieldintegerintegerAngio coronary contained the manually counted number of coronary angiograms done during a stay in our unit, or on the way there.11 July 19883 April 2017Raw
Angio others fieldintegerintegerAngio_others contained the manually counted number of non-coronary angiograms done during a stay in our unit, or on the way there.11 July 19883 April 2017Raw
EchocardiogramnumberintegerContains the number of heart ultrasounds (echocardiograms) a client has had during an admission to our unit.11 July 198831 December 2018Raw
Abdominal ultrasoundintegerintegerContains the number of abdominal ultrasounds a client has had during an admission to our unit.11 July 198831 December 2018Raw
Sputum C+SintegerintegerContains the number of any sputum specimens (including endotracheal secretions) sent for "culture and sensitivity" for bacteria or fungus.11 July 198817 March 2017Raw
Blood culturenot enteredintegerContains the number of blood cultures a patient has had during an admission to our unit.17 March 2017Raw
Urine CSintegerintegerUrine_CS contains the number of any urine specimens sent for "culture and sensitivity" for bacteria or fungus.11 July 198817 March 2017Raw
Arterial blood gas (labs)integerlongABG contains manually collected arterial blood gas counts.11 July 198831 December 2018Raw
Venous blood gas (labs)integerlongVBG contains manually collected venous blood gas counts.11 July 198831 December 2018Raw
PentaspanintegerintegerPentaspan contains the number of doses or Pentaspan that were given while in the unit.12 June 2014Raw
MRI (labs)integerintegerMRI contains the manually counted number of MRIs done during a patient's stay in our unit.11 July 198831 December 2018Raw
VoluvenintegerintegerVoluven contains the number of doses or Voluven that were given while in the unit.11 July 198812 June 2014Raw

DSM Data

Something went wrong with this query and it has no data - please tell Tina Tenbergen

Pharmacy

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
D ID fieldstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
Pat ID fieldnumberLong Integer11 July 19881 January 2100Raw
PPInumberintegerPPI contains manually collected doses of PPI that were given.12 September 201112 May 2014Raw
H2-BlockersnumberintegerH2-Blockers contains manually collected doses of H2-Blockers that were given.24 December 200912 May 2014Raw
Heparin SQnumberintegerHeparin SQ contains manually collected doses of Heparin SQ that were given.28 November 201113 May 2014Raw
LMWHnumberintegerLMWH contains manually collected doses of LMWH that were given.6 December 201131 December 2011Raw
Benzodiazepines cont infnumberintegerbenzodiazepines cont inf contains manually collected doses of benzodiazepines cont inf that were given.29 November 201113 May 2014Raw
Opioids cont infnumberintegeropioids cont inf contains manually collected doses of opioids cont inf that were given.6 December 201113 May 2014Raw
Propofol cont infnumberintegerpropofol cont inf contains manually collected doses of propofol cont inf that were given.6 December 201113 May 2014Raw
Insulin cont infnumberintegerinsulin cont inf contains manually collected doses of insulin cont inf that were given.6 December 201113 May 2014Raw
Furosemide cont infnumberintegerfurosemide cont inf contains manually collected doses of furosemide cont inf that were given.21 December 20119 May 2014Raw
Azolesnumberintegerazoles contains manually collected doses of azoles that were given.11 July 19881 January 2100Raw
Funginsnumberintegerfungins contains manually collected doses of fungins that were given.11 July 19881 January 2100Raw
Antipseudomonalsnumberintegerantipseudomonals contains manually collected doses of antipseudomonals that were given.11 July 19881 January 2100Raw
Vancomycinnumberintegervancomycin contains manually collected doses of vancomycin that were given.11 July 19881 January 2100Raw
Fluoroquinolonesnumberintegerfluoroquinolones contains manually collected doses of fluoroquinolones that were given.11 July 19881 January 2100Raw
Carbapenemsnumberintegercarbapenems contains manually collected doses of carbapenems that were given.11 July 19881 January 2100Raw
Vanco alternativesnumberintegervanco alternatives contains manually collected doses of vanco alternatives that were given.11 July 19881 January 2100Raw
3rd generation cephalosporinsnumberinteger3rd generation cephalosporins contains manually collected doses of 3rd generation cephalosporins that were given.20 October 201111 March 2013Raw
Ceftazidimenumberintegerceftazidime contains manually collected doses of ceftazidime that were given.2 January 20128 March 2013Raw
Tigecylinenumberintegertigecyline contains manually collected doses of tigecyline that were given.21 July 201226 August 2012Raw
Spare1numberintegerspare1 contains manually collected doses of spare1 that were given.8 December 20128 December 2012Raw
Spare2numberintegerspare2 contains manually collected doses of spare2 that were given.8 December 20128 December 2012Raw
Spare3numberintegerspare3 contains manually collected doses of spare3 that were given.8 December 20128 December 2012Raw
Spare4numberintegerspare4 contains manually collected doses of spare4 that were given.8 December 20128 December 2012Raw
Spare5numberintegerspare5 contains manually collected doses of spare5 that were given.8 December 20128 December 2012Raw
Spare6numberintegerspare6 contains manually collected doses of spare6 that were given.8 December 20128 December 2012Raw

Temporary project data

See Projects for a list of current and past projects.

L_TmpV2 table

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
D ID fieldstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
Pat ID fieldnumberLong Integer11 July 19881 January 2100Raw

TISS28

See TISS Items SMW for a list of elements we collect as part of TISS.

L_TISS_Form table

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
D ID fieldstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
Pat ID fieldnumberLong Integer11 July 19881 January 2100Raw

L_TISS_Item table

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
D ID fieldstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
Pat ID fieldnumberLong Integer11 July 19881 January 2100Raw

Created variables

We have some data elements we generate rather than calculate directly.

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
Person ID fieldnumberlong integer11 July 19881 January 2100Created
Hospitalization IDnumberlong integerNot currently used11 July 19881 January 2100Created
Agenumbernot entered11 July 19881 January 2100Created
ER Delaydaten/a11 July 19881 January 2100Created
Mean BPnumbersingleMean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3)11 July 19881 January 2100Created
AaDO2numberN/AThe patient's level in .11 July 19881 January 2100Created
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Data_dictionary&oldid=137872"