Template:CollectorDictionaryQuery

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.

Show

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 11 July 1988 1 January 2100 Person ID field 11 July 1988 1 January 2100 L ICD10 ID 11 July 1988 1 January 2100 ICD10 code 11 July 1988 1 January 2100 Hospitalization ID Not currently used 11 July 1988 1 January 2100 ClientGUID field 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 Age 11 July 1988 1 January 2100 FirstName field Last Name of patient 11 July 1988 1 January 2100 CCI 1 Code 1 January 2019 1 January 2100 PHIN field The patient's PHIN . 11 July 1988 1 January 2100 Px Date 11 July 1988 1 January 2100 Dx Date 11 July 1988 1 January 2100 CCI 2 Code 1 January 2019 1 January 2100 CCI Picklist Code 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 11 July 1988 1 January 2100 Px Count 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 11 July 1988 1 January 2100 Start Date field 25 February 2011 1 January 2100 Dx Priority 11 July 1988 1 January 2100 s_dispo.hospital 1 July 2016 1 January 2100 ER Delay 11 July 1988 1 January 2100 Start Time field 25 February 2011 1 January 2100 s_dispo.loc_type 1 July 2016 1 January 2100 Dx Primary 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 11 July 1988 1 January 2100 s_dispo.geoRegion 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 s_dispo.meanLOS3STD 1 July 2016 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 1 July 2016 1 January 2100 s_dispo.center 1 July 2016 1 January 2100 s_dispo.geog 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 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 1 July 2016 1 January 2100 ADL Bathing 1 October 2003 1 January 2100 ADL Dressing 1 October 2003 1 January 2100 ADL Toiletting 1 October 2003 1 January 2100 ADL Transfering 1 October 2003 1 January 2100 ADL Continence 1 October 2003 1 January 2100 ADL Feeding 1 October 2003 1 January 2100 Admit Type for APACHE II 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 11 July 1988 1 January 2100 AP_Motor field 11 July 1988 1 January 2100 AP_Verbal field 11 July 1988 1 January 2100 FiO2 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