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 | 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 |
|
ADT - via EPR
Admission, discharge and transfer data
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
Collected according to ADL General Collection Information.
Diagnoses
This stores our version of ICD10 (see ICD10 Diagnosis List), collected following the ICD10 collection instructions.
Procedures
This stores our version of CCI, collected following the CCI Collection instructions.
See CCI component 1 codes - what organ was something done to, CCI component 2 codes - what was done for possible values.
| 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 | | Px Date | The date/time of a CCI procedure | 11 July 1988 | 1 January 2100 | | Px Count | The type of a CCI procedure (comorbid, admit or acquired) | 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 |
|
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
See TISS Item List for a list of elements we collect as part of TISS.
Temporary project data
See Projects for a list of current and past projects.
Related articles