| | Description | Start date | End date |
|---|
| D ID field | The unique identifier/index of records in the Critical Care and Medicine Database. | 1 January 1900 | 1 January 2100 |
| Pat ID field | The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number. | 1 January 1900 | 1 January 2100 |
| Person ID field | Unique random number id per patient that combines the D_IDs across admissions/encounters. | 1 January 1900 | 1 January 2100 |
| L ICD10 ID | Unique identifier of the L_ICD10 table | 1 January 1900 | 1 January 2100 |
| ICD10 code | The actual ICD10 code. | 1 January 1900 | 1 January 2100 |
| LastName field | Last Name of patient | 1 January 1900 | 1 January 2100 |
| Age | The number of years between Date of Birth and the last birthday prior to or on (Accept DtTm if applicable, Arrive DtTm otherwise). | 1 January 1900 | 1 January 2100 |
| FirstName field | Last Name of patient | 1 January 1900 | 1 January 2100 |
| CCI 1 Code | The unique identifier/index of CCI Procedure's first component in s_CCI_1 table. | 1 January 1900 | 1 January 2100 |
| PHIN field | The patient's PHIN . | 1 January 1900 | 1 January 2100 |
| CBC | CBC contains the number of CBCs done during a patient's stay in our unit. | 1 January 1900 | 31 December 2018 |
| PPI | PPI contains manually collected doses of PPI that were given. | 1 January 1900 | 31 December 2011 |
| Px Date | The date/time of a CCI procedure | 1 January 1900 | 1 January 2100 |
| Dx Date | The date/time of an ICD10 diagnosis. | 1 January 1900 | 1 January 2100 |
| CCI 2 Code | The unique identifier/index of CCI Procedure's second component in s_CCI_2 table. | 1 January 1900 | 1 January 2100 |
| CCI Picklist Code | The CCI code for and entry in the L CCI Picklist subform, from s_CCI_Picklist table. | 1 January 1900 | 1 January 2100 |
| Date of Birth | Date of Birth (DOB) is the data a patient was born. | 1 January 1900 | 1 January 2100 |
| PT PTT | PT_PTT contains the number of PTs and PTTs done during a patient's stay in our unit. | 1 January 1900 | 17 March 2017 |
| H2-Blockers | H2-Blockers contains manually collected doses of H2-Blockers that were given. | 1 January 1900 | 1 January 2100 |
| Dx Date unknown | True for Acquired Diagnosis / Complication when Dx Date legitimately missing. | 1 January 1900 | 1 January 2100 |
| Px Count | The type of a CCI procedure (comorbid, admit or acquired) | 1 January 1900 | 1 January 2100 |
| Chart number | The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals. | 1 January 1900 | 1 January 2100 |
| Heparin SQ | Heparin SQ contains manually collected doses of Heparin SQ that were given. | 1 January 1900 | 1 January 2100 |
| SentDtTm field | Time the record was last sent. | 1 January 1900 | 1 January 2100 |
| Dx Type | The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication) | 1 January 1900 | 1 January 2100 |
| Transfer Delay | Transfer Delay is the difference between Dispo_DtTm and Transfer_Ready_DtTm in decimal days. | 15 January 1999 | 1 January 2100 |
| FFP | Fresh Frozen Plasma / FFP contains manually collected doses of FFP that were given. | 1 January 1900 | 31 December 2018 |
| LMWH | LMWH contains manually collected doses of LMWH that were given. | 1 January 1900 | 31 December 2011 |
| Start Date field | Date the record was created on the data collector's laptop; created automatically by CCMDB.accdb. | 25 February 2011 | 1 January 2100 |
| Dx Priority | The priority of an ICD10 diagnosis, used to rank and group. | 1 January 1900 | 1 January 2100 |
| Platelets | Platelets contains number of doses of platelets that were given. | 1 January 1900 | 31 December 2018 |
| ER Delay | The ER Delay is the difference between the Accept DtTm and Arrive_DtTm for patients arriving from the ER. | 1 January 1900 | 1 January 2100 |
| Benzodiazepines cont inf | benzodiazepines cont inf contains manually collected doses of benzodiazepines cont inf that were given. | 1 January 1900 | 1 January 2100 |
| Start Time field | Time the record was created on the data collector's laptop; created automatically by CCMDB.accdb. | 25 February 2011 | 1 January 2100 |
| S dispo.loc type | | 1 July 2016 | 1 January 2100 |
| Dx Primary | Checkbox that is set to true for a single Admit Diagnosis per ward stay that is the Primary Admit Diagnosis | 1 January 1900 | 1 January 2100 |
| Notes field | Used by data collectors to keep notes during collection. | 1 January 1900 | 1 January 2100 |
| Albumin 25pct | Albumin_25pct contains number of doses of 25% Albumin that were given. | 1 January 1900 | 31 December 2018 |
| Opioids cont inf | opioids cont inf contains manually collected doses of opioids cont inf that were given. | 1 January 1900 | 1 January 2100 |
| Notes field (L PHI) | Notes in L_PHI table is used by the data processor to comment on data ad-hoc where needed. | 1 January 1900 | 1 January 2100 |
| Albumin 5pct | Albumin_5pct contains the number of doses of 5% Albumin that were given. | 1 January 1900 | 31 December 2018 |
| Propofol cont inf | propofol cont inf contains manually collected doses of propofol cont inf that were given. | 1 January 1900 | 1 January 2100 |
| FinalCheck field | Legacy; used to be checked when all data is complete, now see RecordStatus field. | 1 January 1900 | 24 May 2013 |
| Px Type | The type of a CCI Procedure as per CCI Collection, ie admit or acquired | 1 January 1900 | 1 January 2100 |
| Creatinine (labs) | Creatinine contains the number of creatinines done during a patient's stay in our unit. | 1 January 1900 | 17 March 2017 |
| Insulin cont inf | insulin cont inf contains manually collected doses of insulin cont inf that were given. | 1 January 1900 | 1 January 2100 |
| DC Treatment | "DC" for critical care patients if life-support treatment is terminated, blank for all others. | 1 January 1900 | 1 January 2100 |
| Magnesium (labs) | Magnesium contains the number of magnesiums done during a patient's stay in our unit. | 1 January 1900 | 31 December 2018 |
| Furosemide cont inf | furosemide cont inf contains manually collected doses of furosemide cont inf that were given. | 1 January 1900 | 1 January 2100 |
| Mean BP | Mean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3) | 1 January 1900 | 1 January 2100 |
| SGPT ALT (labs) | SGPT_ALT contains the number of SGPTs and ALTs done during a patient's stay in our unit. | 1 January 1900 | 17 March 2017 |
| Azoles | azoles contains manually collected doses of azoles that were given. | 1 January 1900 | 1 January 2100 |
| Troponin | Troponincontains the number of troponins done during a patient's stay in our unit. | 1 January 1900 | 17 March 2017 |
| Fungins | fungins contains manually collected doses of fungins that were given. | 1 January 1900 | 1 January 2100 |
| CXR | Chest Xrays (CXR) contains the manually counted number of chest xrays (CXR) done during a patient's stay in our unit. | 1 January 1900 | 31 December 2018 |
| Antipseudomonals | antipseudomonals contains manually collected doses of antipseudomonals that were given. | 1 January 1900 | 1 January 2100 |
| Province field | Province 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. | 1 January 1900 | 1 January 2100 |
| CT Scan (labs) | CT_Scan contains the manually counted number of CT scans done during a patient's stay in our unit. | 1 January 1900 | 31 December 2018 |
| Vancomycin | vancomycin contains manually collected doses of vancomycin that were given. | 1 January 1900 | 1 January 2100 |
| Sex field | Biological sex of the patient at birth; options are "male" and "female". | 1 January 1900 | 1 January 2100 |
| Angio coronary field | Angio coronary contained the manually counted number of coronary angiograms done during a stay in our unit, or on the way there. | 1 January 1900 | 3 April 2017 |
| Fluoroquinolones | fluoroquinolones contains manually collected doses of fluoroquinolones that were given. | 1 January 1900 | 1 January 2100 |
| Angio others field | Angio_others contained the manually counted number of non-coronary angiograms done during a stay in our unit, or on the way there. | 1 January 1900 | 3 April 2017 |
| Carbapenems | carbapenems contains manually collected doses of carbapenems that were given. | 1 January 1900 | 1 January 2100 |
| Registry Patient Type | Service of the attending physician for medicine data, and the type of admit diagnosis for critical care patients. | 1 April 1997 | 9 May 2018 |
| Echocardiogram | Contains the number of heart ultrasounds (echocardiograms) a client has had during an admission to our unit. | 1 January 1900 | 31 December 2018 |
| Vanco alternatives | vanco alternatives contains manually collected doses of vanco alternatives that were given. | 1 January 1900 | 1 January 2100 |
| Abdominal ultrasound | Contains the number of abdominal ultrasounds a client has had during an admission to our unit. | 1 January 1900 | 31 December 2018 |
| 3rd generation cephalosporins | 3rd generation cephalosporins contains manually collected doses of 3rd generation cephalosporins that were given. | 1 January 1900 | 1 January 2100 |
| Sputum C+S | Contains the number of any sputum specimens (including endotracheal secretions) sent for "culture and sensitivity" for bacteria or fungus. | 1 January 1900 | 17 March 2017 |
| Ceftazidime | ceftazidime contains manually collected doses of ceftazidime that were given. | 1 January 1900 | 31 December 2011 |
| Blood culture | Contains the number of blood cultures a patient has had during an admission to our unit. | | 17 March 2017 |
| Tigecyline | tigecyline contains manually collected doses of tigecyline that were given. | 1 January 1900 | 31 December 2011 |
| Urine CS | Urine_CS contains the number of any urine specimens sent for "culture and sensitivity" for bacteria or fungus. | 1 January 1900 | 17 March 2017 |
| Spare1 | spare1 contains manually collected doses of spare1 that were given. | 1 January 1900 | 1 January 2100 |
| Arterial blood gas (labs) | ABG contains manually collected arterial blood gas counts. | 1 January 1900 | 31 December 2018 |
| Spare2 | spare2 contains manually collected doses of spare2 that were given. | 1 January 1900 | 1 January 2100 |
| S dispo.service type | | 1 July 2016 | 1 January 2100 |
| Spare3 | spare3 contains manually collected doses of spare3 that were given. | 1 January 1900 | 1 January 2100 |
| Venous blood gas (labs) | VBG contains manually collected venous blood gas counts. | 1 January 1900 | 31 December 2018 |
| R Filter Field | Critical care patients on a long term ventilator (LTV). | 1 January 1900 | 1 January 2019 |
| Pentaspan | Pentaspan contains the number of doses or Pentaspan that were given while in the unit. | | 12 June 2014 |
| Spare4 | spare4 contains manually collected doses of spare4 that were given. | 1 January 1900 | 1 January 2100 |
| MRI (labs) | MRI contains the manually counted number of MRIs done during a patient's stay in our unit. | 1 January 1900 | 31 December 2018 |
| Spare5 | spare5 contains manually collected doses of spare5 that were given. | 1 January 1900 | 1 January 2100 |
| Voluven | Voluven contains the number of doses or Voluven that were given while in the unit. | 1 January 1900 | 12 June 2014 |
| Spare6 | spare6 contains manually collected doses of spare6 that were given. | 1 January 1900 | 1 January 2100 |
| Postal Code field | The patient's postal code. | 1 January 2012 | 1 January 2100 |
| AaDO2 | The patient's Alveolar-arterial oxygen tension difference level in . | 1 January 1900 | 1 January 2100 |
| LastOpened DtTm field | Date/Time the record was last closed with the "Close - with updates" button. This will usually be the last time the collector updated the record. | 14 April 2016 | 31 December 2999 |
| Pre acute living situation field | Info about the living situation of the patient prior to the current hospitalization. | 1 July 2016 | 1 January 2100 |
| Pre-admit Inpatient Institution field | The 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 2016 | 1 January 2100 |
| Previous Location field | The most recent previous physical location (except #Bed Borrows) of a patient before arriving at the collection location. | 1 July 2016 | 1 January 2100 |
| Previous Service field | The most recent "originating service" which sends the patients to their current service location. | 1 July 2016 | 1 January 2100 |
| Off ward field | Checked/true if the patient who meets the Definition of a Medicine Laptop Admission or Definition of a Critical Care Laptop Admission spent any time in a bed that is not at their actual collection location between Arrive DtTm and Dispo DtTm. The patient must be covered by the attending of the service of the home unit that is credited with the "off ward" designation. | 1 July 2016 | 29 January 2020 |
| Service/Location field | Legacy field replaced by Boarding Loc and Service tmp entry | 1 July 2016 | 1 January 2100 |
| Dispo field | The Dispo field contains information about what happens to the patient at the end of their admission. | 1 July 2016 | 1 January 2100 |
| Visit Admit DtTm field | The Visit Admit DtTm field is the start of the current inpatient admission. | 1 January 2003 | 1 January 2100 |
| EPR Admit DtTm field | arrival time on the unit as per Cognos/ EPR data | 27 October 2019 | 1 November 2020 |
| Accept DtTm field | The date and time when the patient is accepted from the ER department ONLY. | 1 July 2016 | 1 January 2100 |
| Accept DtTm missing field | checkbox is checked/true when no Accept DtTm is documented for a patient who came from from the ER. | 1 July 2016 | 1 January 2100 |
| Arrive DtTm field | Date and time when the patient physically arrived on unit ( Service Location) OR in a Boarding location. | 1 July 2016 | 1 January 2100 |
| Dispo DtTm field | Date and time when the patient changed status from what is documented in Service/Location field to Dispo field.. | 1 July 2016 | 1 January 2100 |
| Transfer Ready DtTm field | Date and time the intent to discharge a patient to a lower level in the Level of care hierarchy was documented. | 1 July 2016 | 15 October 2020 |
| TR info status field | Cross-check field that will contain data if Transfer_Ready_DtTm field is empty | 5 May 2016 | 15 October 2020 |
| ADL Bathing | Need for help with bathing; component of ADL. | 1 January 1900 | 1 January 2100 |
| ADL Dressing | Need for help with dressing; component of ADL. | 1 January 1900 | 1 January 2100 |
| ADL Toiletting | Need for help with toiletting; component of ADL | 1 January 1900 | 1 January 2100 |
| ADL Transfering | Need for help with transferring; component of ADL | 1 January 1900 | 1 January 2100 |
| ADL Continence | Control of urination and bowel movements; component of ADL | 1 January 1900 | 1 January 2100 |
| ADL Feeding | Need for help with feeding; component of ADL | 1 January 1900 | 1 January 2100 |
| Admit Type for APACHE II | Admit type for APACHE | 1 January 1900 | 1 January 2100 |
| Chronic Health APACHE | Specific chronic pre-existing conditions used for APACHE score. | 1 January 1900 | 1 January 2100 |
| Temperature | The patient's Temperature level in °C. | 1 January 1900 | 1 January 2100 |
| AP Sys BP Field | Ap_SysBP is the systolic blood pressure. | 1 January 1900 | 1 January 2100 |
| AP Dias BP Field | Ap_DiasBP is the diastolic blood pressure. | 1 January 1900 | 1 January 2100 |
| HR | The patient's Heart Rate level in beats/min. | 1 January 1900 | 1 January 2100 |
| RR | The patient's respiratory rate level in breaths/min. | 1 January 1900 | 1 January 2100 |
| AP Eye field | The eye component of the Glasgow_Coma_Scale. | 1 January 1900 | 1 January 2100 |
| AP Motor field | The motor component of the Glasgow_Coma_Scale. | 1 January 1900 | 1 January 2100 |
| AP Verbal field | The verbal component of the Glasgow_Coma_Scale. | 1 January 1900 | 1 January 2100 |
| FiO2 | FIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient. | 1 January 1900 | 1 January 2100 |
| GCS sedated field | The GCS sedated field is a checkbox used together with the Glasgow Coma Scale; if the patient is sedated when the GCS is assessed, this box is checked. | 22 September 2016 | 1 January 2100 |
| PO2 | PO2 is the partial pressure of oxygen in the patient's arterial blood. | 1 January 1900 | 1 January 2100 |
| PCO2 | PCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L. | 1 January 1900 | 1 January 2100 |
| PH | The acidity or basicity of the patient's arterial blood. | 1 January 1900 | 1 January 2100 |
| Serum CO2 | The patient's Serum CO2 level in mmol/L. | 1 January 1900 | 1 January 2100 |
| Na | The patient's Sodium level in mmol/L. | 1 January 1900 | 1 January 2100 |
| K | The patient's Potassium level in mmol/L. | 1 January 1900 | 1 January 2100 |
| HCT | The patient's hematocrit level in percentage. | 1 January 1900 | 1 January 2100 |
| WBC | The patient's White Blood Count level in x109/L. | 1 January 1900 | 1 January 2100 |
| Creatinine (APACHE) | The patient's level in . | 1 January 1900 | 1 January 2100 |
| ARF (APACHE) | The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition. | 1 January 1900 | 1 January 2100 |
| R Complete | true when patient registry data is complete | 1 January 2000 | 31 December 2100 |
| ADL Complete | true when patient ADL data is complete | 1 January 2000 | 31 December 2100 |
| RecordStatus field | status of the data in the record. Possible values are complete, sent, questioned and vetted. | 24 April 2013 | 1 January 2100 |
| Ap Complete | True when patient APACH II data is complete | 1 January 2000 | 31 December 2100 |
| ApLab Complete | True when patient APACHE II lab data is complete | 1 January 2000 | 31 December 2016 |
| Labs Complete | True when patient Labs data is complete | 1 January 2000 | 31 December 2100 |
| Tmp Complete | True when patient Tmp data is complete | 1 January 2000 | 31 December 2100 |
| Como Complete | True when patient comorbid diagnosis data is complete | 1 January 2000 | 31 December 2100 |
| Diag Complete | True when patient diagnosis data is complete | 1 January 2000 | 31 December 2100 |
| Pharm Complete | True when patient pharmacy diagnosis data is complete | 1 January 2000 | 31 December 2100 |
| Pharm Flow Complete | Unused field | 1 January 2000 | 31 December 2100 |
| Record | Free choice use by collectors to help collection, this field has no consistent meaning. | 1 January 1900 | 31 December 2100 |
| Room nr | Legacy element that was never used consistently. | 1 January 1900 | 31 December 2100 |
| LastChanged DtTm field | Last time the record was closed with the "Close - with updates" button | 6 January 2021 | 31 December 2999 |
| Pharm Vitamin K antagonists field | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm Heparin cont inf | True if a continuous infusion of Heparin was given | 1 January 2012 | 1 January 2100 |
| Pharm Direct thrombin inhibitors | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm Heparinoids | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm Factor Xa inhibitors | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm Dopamine cont inf | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm Dobutamine cont inf | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm Norepinephrine cont inf | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm Epinephrine cont inf | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm Phenylephrine cont inf | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm Vasopressin cont inf | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm Milrinone cont inf | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm Paralytics cont inf | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm corticosteroids | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm amphotericin B | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm macrolides | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm 1st or 2nd generation cephalosporins | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm 4th generation cephalosporins | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm antistaph penicillins | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm aminoglycosides | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm influenza drugs | True if influenza drugs were given | 1 January 2012 | 1 January 2100 |
| Pharm bosentan | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm viagra-type vasodilators | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm special upper GI bleeding agents | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm amiodarones | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm anti-TB drugs | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm statins | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm PPI | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm H2 blockers | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm furosemide | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm heparin sq | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm LMWH | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm benzodiazepines | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm opioids | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm propofol | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
| Pharm insulin | True if drug in field name was given | 1 January 2012 | 1 January 2100 |
