| | Description | Start date | End date |
|---|
| D ID field | The unique identifier/index of records in the Critical Care and Medicine Database. | 11 July 1988 | 1 January 2100 |
| Pat ID field | The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number. | 11 July 1988 | 1 January 2100 |
| Person ID field | Unique random number id per patient that combines the D_IDs across admissions/encounters. | 11 July 1988 | 1 January 2100 |
| L ICD10 ID | Unique identifier of the L_ICD10 table | 11 July 1988 | 1 January 2100 |
| ICD10 code | The actual ICD10 code. | 11 July 1988 | 1 January 2100 |
| Hospitalization ID | Not currently used | 11 July 1988 | 1 January 2100 |
| ClientGUID field | The unique person identifier from Cognos. | 29 August 2022 | 1 January 2100 |
| ClientVisitGUID field | Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data. | 29 August 2022 | 1 January 2100 |
| LastName field | Last Name of patient | 11 July 1988 | 1 January 2100 |
| FirstName field | Last Name of patient | 11 July 1988 | 1 January 2100 |
| CCI 1 Code | The unique identifier/index of CCI Procedure's first component in s_CCI_1 table. | 1 January 2019 | 1 January 2100 |
| Age | The number of years between Date of Birth and the last birthday prior to or on (Admit DtTm otherwise). | 11 July 1988 | 1 January 2100 |
| PHIN field | The patient's PHIN . | 11 July 1988 | 1 January 2100 |
| Px Date | The date/time of a CCI procedure | 11 July 1988 | 1 January 2100 |
| Dx Date | The date/time of an ICD10 diagnosis. | 11 July 1988 | 1 January 2100 |
| CCI 2 Code | The unique identifier/index of CCI Procedure's second component in s_CCI_2 table. | 1 January 2019 | 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 2019 | 1 January 2100 |
| Date of Birth | Date of Birth (DOB) is the data a patient was born. | 11 July 1988 | 1 January 2100 |
| Dx Date unknown | True for Acquired Diagnosis / Complication when Dx Date legitimately missing. | 11 July 1988 | 1 January 2100 |
| Px Count | The type of a CCI procedure (comorbid, admit or acquired) | 11 July 1988 | 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. | 11 July 1988 | 1 January 2100 |
| SentDtTm field | Time the record was last sent. | 11 July 1988 | 1 January 2100 |
| Dx Type | The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication) | 11 July 1988 | 1 January 2100 |
| 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. | 11 July 1988 | 1 January 2100 |
| s_dispo.hospital | aggregating field for s_dispo table used to ??? | 1 July 2016 | 1 January 2100 |
| ER Delay | The ER Delay is the difference between the pre-ER Boarding Loc and first post-ER Boarding Loc, for patients arriving from the ER. | 11 July 1988 | 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 | The list provides a broader description of service and/ location of the patient's Previous Location,Pre-admit Inpatient Institution or Dispo field and found useful when providing reports. | 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 | 11 July 1988 | 1 January 2100 |
| s_dispo.inpatient | whether a location is an in-patient location | 1 July 2016 | 1 January 2100 |
| Notes field | Used by data collectors to keep notes during collection. | 11 July 1988 | 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. | 11 July 1988 | 1 January 2100 |
| Px Type | The type of a CCI Procedure as per CCI Collection, ie admit or acquired | 11 July 1988 | 1 January 2100 |
| s_dispo.geoRegion | aggregating field for s_dispo table used to ??? | 1 July 2016 | 1 January 2100 |
| Mean BP | Mean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3) | 11 July 1988 | 1 January 2100 |
| Azoles | azoles contains manually collected doses of azoles that were given. | 11 July 1988 | 1 January 2100 |
| Fungins | fungins contains manually collected doses of fungins that were given. | 11 July 1988 | 1 January 2100 |
| Antipseudomonals | antipseudomonals contains manually collected doses of antipseudomonals that were given. | 11 July 1988 | 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. | 11 July 1988 | 1 January 2100 |
| Vancomycin | vancomycin contains manually collected doses of vancomycin that were given. | 11 July 1988 | 1 January 2100 |
| Sex field | Biological sex of the patient at birth; options are "male" and "female". | 11 July 1988 | 1 January 2100 |
| Fluoroquinolones | fluoroquinolones contains manually collected doses of fluoroquinolones that were given. | 11 July 1988 | 1 January 2100 |
| Carbapenems | carbapenems contains manually collected doses of carbapenems that were given. | 11 July 1988 | 1 January 2100 |
| Vanco alternatives | vanco alternatives contains manually collected doses of vanco alternatives that were given. | 11 July 1988 | 1 January 2100 |
| s_dispo.program | aggregating field for s_dispo table used to define the Program | 1 July 2016 | 1 January 2100 |
| s_dispo.center | aggregating field for s_dispo table used to define the order in which sites and units are listed on reports. | 1 July 2016 | 1 January 2100 |
| s_dispo.geog | aggregating field for s_dispo table used to | 1 July 2016 | 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 . | 11 July 1988 | 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 | 1 January 2100 |
| 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 (with #exceptions) of a patient before arriving at the collection location. | 1 July 2016 | 1 January 2100 |
| Service/Location field | Encodes which program a record is part of. | 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 | This field is used only as an identifier to combine data from the same hospitalization and should not be used as a date. | 1 January 2003 | 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 |
| ADL Bathing | Need for help with bathing; component of ADL. | 1 October 2003 | 1 January 2100 |
| ADL Dressing | Need for help with dressing; component of ADL. | 1 October 2003 | 1 January 2100 |
| ADL Toiletting | Need for help with toiletting; component of ADL | 1 October 2003 | 1 January 2100 |
| ADL Transfering | Need for help with transferring; component of ADL | 1 October 2003 | 1 January 2100 |
| ADL Continence | Control of urination and bowel movements; component of ADL | 1 October 2003 | 1 January 2100 |
| ADL Feeding | Need for help with feeding; component of ADL | 1 October 2003 | 1 January 2100 |
| Admit Type for APACHE II | The Admit Type for APACHE II is a way to classify patients' surgical status and one of the elements used to generate the APACHE score. | 11 July 1988 | 1 January 2100 |
| Temperature | The patient's Temperature level in °C. | 11 July 1988 | 1 January 2100 |
| AP Sys BP Field | Ap_SysBP is the systolic blood pressure. | 11 July 1988 | 1 January 2100 |
| AP Dias BP Field | Ap_DiasBP is the diastolic blood pressure. | 11 July 1988 | 1 January 2100 |
| HR | The patient's Heart Rate level in beats/min. | 11 July 1988 | 1 January 2100 |
| RR | The patient's respiratory rate level in breaths/min. | 11 July 1988 | 1 January 2100 |
| AP_Eye field | The eye component of the Glasgow_Coma_Scale. | 11 July 1988 | 1 January 2100 |
| AP_Motor field | The motor component of the Glasgow_Coma_Scale. | 11 July 1988 | 1 January 2100 |
| AP_Verbal field | The verbal component of the Glasgow_Coma_Scale. | 11 July 1988 | 1 January 2100 |
| FiO2 | FIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient. | 11 July 1988 | 1 January 2100 |
| PO2 | PO2 is the partial pressure of oxygen in the patient's arterial blood. | 11 July 1988 | 1 January 2100 |
| PCO2 | PCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L. | 11 July 1988 | 1 January 2100 |
| PH | The acidity or basicity of the patient's arterial blood. | 11 July 1988 | 1 January 2100 |
| Serum CO2 | The patient's Serum CO2 level in mmol/L. | 11 July 1988 | 1 January 2100 |
| Na | The patient's Sodium level in mmol/L. | 11 July 1988 | 1 January 2100 |
| K | The patient's Potassium level in mmol/L. | 11 July 1988 | 1 January 2100 |
| HCT | The patient's hematocrit level in percentage. | 11 July 1988 | 1 January 2100 |
| WBC | The patient's White Blood Count level in x109/L. | 11 July 1988 | 1 January 2100 |
| Creatinine (APACHE) | The patient's level in . | 11 July 1988 | 1 January 2100 |
| ARF (APACHE) | The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition. | 11 July 1988 | 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 |
| 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 |
| Record | Free choice use by collectors to help collection, this field has no consistent meaning. | 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 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 |