Template:DataDictionaryQuery
This template is used by the Data dictionary to help keep data uniformly structured and formatted.
--- This will say something went wrong and that there is no data because here in its definition there are no query criteria - there is nothing wrong with it saying that here.
FieldDataType | FieldLength | DataElementDescription | DataElementStartDate | DataElementEndDate | FieldCreatedRaw | |
---|---|---|---|---|---|---|
D ID field | string | 18 | The unique identifier/index of records in the Critical Care and Medicine Database. | 11 July 1988 | 1 January 2100 | Raw |
Pat ID field | number | Long Integer | The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number. | 11 July 1988 | 1 January 2100 | Raw |
Person ID field | number | long integer | Unique random number id per patient that combines the D_IDs across admissions/encounters. | 11 July 1988 | 1 January 2100 | Created |
L ICD10 ID | number | long | Unique identifier of the L_ICD10 table | 11 July 1988 | 1 January 2100 | Raw |
ICD10 code | string | 10 | The actual ICD10 code. | 11 July 1988 | 1 January 2100 | Raw |
Hospitalization ID | number | long integer | Not currently used | 11 July 1988 | 1 January 2100 | Created |
ClientGUID field | string | 16 | The unique person identifier from Cognos. | 29 August 2022 | 1 January 2100 | Raw |
ClientVisitGUID field | string | 16 | Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data. | 29 August 2022 | 1 January 2100 | Raw |
LastName field | string | 40 | Last Name of patient | 11 July 1988 | 1 January 2100 | Raw |
FirstName field | string | 40 | Last Name of patient | 11 July 1988 | 1 January 2100 | Raw |
CCI 1 Code | number | long integer | The unique identifier/index of CCI Procedure's first component in s_CCI_1 table. | 1 January 2019 | 1 January 2100 | Raw |
Age | number | 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 | Created | |
PHIN field | number | Long Integer | The patient's PHIN . | 11 July 1988 | 1 January 2100 | Raw |
Px Date | date | not entered | The date/time of a CCI procedure | 11 July 1988 | 1 January 2100 | Raw |
Dx Date | date | not entered | The date/time of an ICD10 diagnosis. | 11 July 1988 | 1 January 2100 | Raw |
CCI 2 Code | number | long integer | The unique identifier/index of CCI Procedure's second component in s_CCI_2 table. | 1 January 2019 | 1 January 2100 | Raw |
CCI Picklist Code | string | 20 | The CCI code for and entry in the L CCI Picklist subform, from s_CCI_Picklist table. | 1 January 2019 | 1 January 2100 | Raw |
Date of Birth | date | not entered | Date of Birth (DOB) is the data a patient was born. | 11 July 1988 | 1 January 2100 | Raw |
Dx Date unknown | boolean | not entered | True for Acquired Diagnosis / Complication when Dx Date legitimately missing. | 11 July 1988 | 1 January 2100 | Raw |
Px Count | date | not entered | The type of a CCI procedure (comorbid, admit or acquired) | 11 July 1988 | 1 January 2100 | Raw |
Chart number | string | 8 | 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 | Raw |
SentDtTm field | date | not entered | Time the record was last sent. | 11 July 1988 | 1 January 2100 | Raw |
Dx Type | string | 8 | The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication) | 11 July 1988 | 1 January 2100 | Raw |
Start Date field | date | not entered | Date the record was created on the data collector's laptop; created automatically by CCMDB.accdb. | 25 February 2011 | 1 January 2100 | Raw |
Dx Priority | number | single | The priority of an ICD10 diagnosis, used to rank and group. | 11 July 1988 | 1 January 2100 | Raw |
ER Delay | date | n/a | 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 | Created |
Start Time field | date | not entered | Time the record was created on the data collector's laptop; created automatically by CCMDB.accdb. | 25 February 2011 | 1 January 2100 | Raw |
s_dispo.loc_type | string | 20 | 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 | Raw |
Dx Primary | boolean | not entered | 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 | Raw |
Notes field | memo | not entered | Used by data collectors to keep notes during collection. | 11 July 1988 | 1 January 2100 | Raw |
Notes field (L PHI) | string | not entered | 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 | Raw |
Px Type | string | not entered | The type of a CCI Procedure as per CCI Collection, ie admit or acquired | 11 July 1988 | 1 January 2100 | Raw |
Mean BP | number | single | Mean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3) | 11 July 1988 | 1 January 2100 | Created |
Azoles | number | integer | azoles contains manually collected doses of azoles that were given. | 11 July 1988 | 1 January 2100 | Raw |
Fungins | number | integer | fungins contains manually collected doses of fungins that were given. | 11 July 1988 | 1 January 2100 | Raw |
Antipseudomonals | number | integer | antipseudomonals contains manually collected doses of antipseudomonals that were given. | 11 July 1988 | 1 January 2100 | Raw |
Province field | string | 2 | 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 | Raw |
Vancomycin | number | integer | vancomycin contains manually collected doses of vancomycin that were given. | 11 July 1988 | 1 January 2100 | Raw |
Sex field | string | 7 | Biological sex of the patient at birth; options are "male" and "female". | 11 July 1988 | 1 January 2100 | Raw |
Fluoroquinolones | number | integer | fluoroquinolones contains manually collected doses of fluoroquinolones that were given. | 11 July 1988 | 1 January 2100 | Raw |
Carbapenems | number | integer | carbapenems contains manually collected doses of carbapenems that were given. | 11 July 1988 | 1 January 2100 | Raw |
Vanco alternatives | number | integer | vanco alternatives contains manually collected doses of vanco alternatives that were given. | 11 July 1988 | 1 January 2100 | Raw |
Postal Code field | string | 6 | The patient's postal code. | 1 January 2012 | 1 January 2100 | Raw |
AaDO2 | number | N/A | The patient's Alveolar-arterial oxygen tension difference level in . | 11 July 1988 | 1 January 2100 | Created |
LastOpened DtTm field | date | not entered | 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 | Raw |
Pre acute living situation field | number | long integer | Info about the living situation of the patient prior to the current hospitalization. | 1 July 2016 | 1 January 2100 | Raw |
Pre-admit Inpatient Institution field | number | long integer | 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 | Raw |
Previous Location field | number | long integer | The most recent previous physical location (with #exceptions) of a patient before arriving at the collection location. | 1 July 2016 | 1 January 2100 | Raw |
Service/Location field | number | long integer | Legacy field replaced by Boarding Loc and Service tmp entry | 1 July 2016 | 1 January 2100 | Raw |
Dispo field | number | long | The Dispo field contains information about what happens to the patient at the end of their admission. | 1 July 2016 | 1 January 2100 | Raw |
Visit Admit DtTm field | date | not entered | 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 | Raw |
Dispo DtTm field | date | not entered | 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 | Raw |
ADL Bathing | string | 15 | Need for help with bathing; component of ADL. | 1 October 2003 | 1 January 2100 | Raw |
ADL Dressing | string | 15 | Need for help with dressing; component of ADL. | 1 October 2003 | 1 January 2100 | Raw |
ADL Toiletting | string | 15 | Need for help with toiletting; component of ADL | 1 October 2003 | 1 January 2100 | Raw |
ADL Transfering | string | 15 | Need for help with transferring; component of ADL | 1 October 2003 | 1 January 2100 | Raw |
ADL Continence | string | 15 | Control of urination and bowel movements; component of ADL | 1 October 2003 | 1 January 2100 | Raw |
ADL Feeding | string | 15 | Need for help with feeding; component of ADL | 1 October 2003 | 1 January 2100 | Raw |
Admit Type for APACHE II | string | 10 | 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 | Raw |
Temperature | number | single | The patient's Temperature level in °C. | 11 July 1988 | 1 January 2100 | Raw |
AP Sys BP Field | number | single | Ap_SysBP is the systolic blood pressure. | 11 July 1988 | 1 January 2100 | Raw |
AP Dias BP Field | number | single | Ap_DiasBP is the diastolic blood pressure. | 11 July 1988 | 1 January 2100 | Raw |
HR | number | single | The patient's Heart Rate level in beats/min. | 11 July 1988 | 1 January 2100 | Raw |
RR | number | single | The patient's respiratory rate level in breaths/min. | 11 July 1988 | 1 January 2100 | Raw |
AP Eye field | string | 13 | The eye component of the Glasgow_Coma_Scale. | 11 July 1988 | 1 January 2100 | Raw |
AP Motor field | string | 19 | The motor component of the Glasgow_Coma_Scale. | 11 July 1988 | 1 January 2100 | Raw |
AP Verbal field | string | 26 | The verbal component of the Glasgow_Coma_Scale. | 11 July 1988 | 1 January 2100 | Raw |
FiO2 | number | single | FIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient. | 11 July 1988 | 1 January 2100 | Raw |
PO2 | number | single | PO2 is the partial pressure of oxygen in the patient's arterial blood. | 11 July 1988 | 1 January 2100 | Raw |
PCO2 | number | single | 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 | Raw |
PH | number | single | The acidity or basicity of the patient's arterial blood. | 11 July 1988 | 1 January 2100 | Raw |
Serum CO2 | number | single | The patient's Serum CO2 level in mmol/L. | 11 July 1988 | 1 January 2100 | Raw |
Na | number | single | The patient's Sodium level in mmol/L. | 11 July 1988 | 1 January 2100 | Raw |
K | number | single | The patient's Potassium level in mmol/L. | 11 July 1988 | 1 January 2100 | Raw |
HCT | number | single | The patient's hematocrit level in percentage. | 11 July 1988 | 1 January 2100 | Raw |
WBC | number | single | The patient's White Blood Count level in x109/L. | 11 July 1988 | 1 January 2100 | Raw |
Creatinine (APACHE) | number | single | The patient's level in . | 11 July 1988 | 1 January 2100 | Raw |
ARF (APACHE) | number | single | The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition. | 11 July 1988 | 1 January 2100 | Raw |
R Complete | boolean | not entered | true when patient registry data is complete | 1 January 2000 | 31 December 2100 | Raw |
ADL Complete | boolean | not entered | true when patient ADL data is complete | 1 January 2000 | 31 December 2100 | Raw |
RecordStatus field | string | 20 | status of the data in the record. Possible values are complete, sent, questioned and vetted. | 24 April 2013 | 1 January 2100 | Raw |
Ap Complete | boolean | not entered | True when patient APACH II data is complete | 1 January 2000 | 31 December 2100 | Raw |
Labs Complete | boolean | not entered | True when patient Labs data is complete | 1 January 2000 | 31 December 2100 | Raw |
Tmp Complete | boolean | not entered | True when patient Tmp data is complete | 1 January 2000 | 31 December 2100 | Raw |
Como Complete | boolean | not entered | True when patient comorbid diagnosis data is complete | 1 January 2000 | 31 December 2100 | Raw |
Diag Complete | boolean | not entered | True when patient diagnosis data is complete | 1 January 2000 | 31 December 2100 | Raw |
Pharm Complete | boolean | not entered | True when patient pharmacy diagnosis data is complete | 1 January 2000 | 31 December 2100 | Raw |
Record | string | 8 | Free choice use by collectors to help collection, this field has no consistent meaning. | 1 January 1900 | 31 December 2100 | Raw |
LastChanged DtTm field | date | not entered | Last time the record was closed with the "Close - with updates" button | 6 January 2021 | 31 December 2999 | Raw |
Pharm Vitamin K antagonists field | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm Heparin cont inf | boolean | not entered | True if a continuous infusion of Heparin was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm Direct thrombin inhibitors | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm Heparinoids | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm Factor Xa inhibitors | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm Dopamine cont inf | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm Dobutamine cont inf | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm Norepinephrine cont inf | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm Epinephrine cont inf | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm Phenylephrine cont inf | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm Vasopressin cont inf | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm Milrinone cont inf | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm Paralytics cont inf | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm corticosteroids | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm amphotericin B | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm influenza drugs | boolean | not entered | True if influenza drugs were given | 1 January 2012 | 1 January 2100 | Raw |
Pharm bosentan | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm viagra-type vasodilators | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm special upper GI bleeding agents | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm amiodarones | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm anti-TB drugs | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm statins | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm PPI | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm H2 blockers | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm furosemide | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm heparin sq | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm LMWH | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm benzodiazepines | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm opioids | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm propofol | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |
Pharm insulin | boolean | not entered | True if drug in field name was given | 1 January 2012 | 1 January 2100 | Raw |