This page provides links to various collection elements in the Medicine and ICU database.
Registry
In the collection tool CCMDB.accdb the registry data is all in the L_Log table.
| Show
|
| | Description | Start date | End date |
|---|
| LastName field | Last Name of patient | 11 July 1988 | 1 January 2100 | | FirstName field | Last Name of patient | 11 July 1988 | 1 January 2100 | | PHIN field | The patient's PHIN . | 11 July 1988 | 1 January 2100 | | Date of Birth | Date of Birth (DOB) is the data a patient was born. | 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 | | 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 | | Sex field | Biological sex of the patient at birth; options are "male" and "female". | 11 July 1988 | 1 January 2100 | | Postal Code field | The patient's postal code. | 1 January 2012 | 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 | | 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 |
|
ADT - via EPR
Admission, discharge and transfer data
| Show
|
| | Description | Start date | End date |
|---|
| 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 | | Sex field | Biological sex of the patient at birth; options are "male" and "female". | 11 July 1988 | 1 January 2100 | | Postal Code field | The patient's postal code. | 1 January 2012 | 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 |
|
APACHE
Apache has physiological components and diagnostic components.
| Show
|
| | Description | Start date | End date |
|---|
| 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 |
|
ADLs - Activities of Daily Living
Diagnoses
Procedures
Pharmacy
| Show
|
| | Description | Start date | End date |
|---|
| 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 | | D ID field | The unique identifier/index of records in the Critical Care and Medicine Database. | 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 | | Vancomycin | vancomycin contains manually collected doses of vancomycin that were given. | 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 |
|
TISS28
Temporary project data
See Projects for a list of current and past projects.
Related articles