Auto Data Dictionary

From CCMDB Wiki
Jump to navigation Jump to search

This page generates an automatically updated list of data fields in the Critical Care and Medicine Database based on contents of this wiki. For a more general overview see Data User Portal for the Manitoba Critical Care and Medicine Databases. For information on the general data structure, see CCMDB Data Structure. For information on data encoded in the Entity–attribute–value model of the L_Tmp_V2 table, see Projects. For details on information derived from this data, see Indicators.

data fields

We collect a total of 180 fields, but since much of our data is relational this doesn't really give an indication of how many things we collect.

Currently collected

This is a list of fields in the Critical Care and Medicine Database

 TableTabData typelengthDescriptionStart dateCreated vs raw
ADL BathingL_Log tableADLstring15Need for help with bathing; component of ADL.1 October 2003Raw
ADL ContinenceL_Log tableADLstring15Control of urination and bowel movements; component of ADL1 October 2003Raw
ADL DressingL_Log tableADLstring15Need for help with dressing; component of ADL.1 October 2003Raw
ADL FeedingL_Log tableADLstring15Need for help with feeding; component of ADL1 October 2003Raw
ADL ToilettingL_Log tableADLstring15Need for help with toiletting; component of ADL1 October 2003Raw
ADL TransferingL_Log tableADLstring15Need for help with transferring; component of ADL1 October 2003Raw
AP Dias BP FieldL_Log tableApachenumbersingleAp_DiasBP is the diastolic blood pressure.11 July 1988Raw
AP Eye fieldL_Log tableApachestring13The eye component of the Glasgow_Coma_Scale.11 July 1988Raw
AP Motor fieldL_Log tableApachestring19The motor component of the Glasgow_Coma_Scale.11 July 1988Raw
AP Sys BP FieldL_Log tableApachenumbersingleAp_SysBP is the systolic blood pressure.11 July 1988Raw
AP Verbal fieldL_Log tableApachestring26The verbal component of the Glasgow_Coma_Scale.11 July 1988Raw
ARF (APACHE)L_Log tableApachenumbersingleThe ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.11 July 1988Raw
AaDO2N/AApachenumberN/AThe patient's Alveolar-arterial oxygen tension difference level in .11 July 1988Created
Admit Type for APACHE IIL_Log tableApachestring10The 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 1988Raw
AgeCreated Variables Common 2021 table
Created Variables CC 2021 table
not statednumberThe number of years between Date of Birth and the last birthday prior to or on (Admit DtTm otherwise).11 July 1988Created
AntipseudomonalsL_Pharm_Flowsheet tablePharmnumberintegerantipseudomonals contains manually collected doses of antipseudomonals that were given.11 July 1988Raw
AzolesL_Pharm_Flowsheet tablePharmnumberintegerazoles contains manually collected doses of azoles that were given.11 July 1988Raw
CCI 1 CodeN/ACCInumberlong integerThe unique identifier/index of CCI Procedure's first component in s_CCI_1 table.1 January 2019Raw
CCI 2 CodeN/ACCInumberlong integerThe unique identifier/index of CCI Procedure's second component in s_CCI_2 table.1 January 2019Raw
CCI Picklist CodeL_CCI_Picklist tableCCIstring20The CCI code for and entry in the L CCI Picklist subform, from s_CCI_Picklist table.1 January 2019Raw
CarbapenemsL_Pharm_Flowsheet tablePharmnumberintegercarbapenems contains manually collected doses of carbapenems that were given.11 July 1988Raw
Chart numberL_Log table
L_PHI table
Top Rowstring8The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals.11 July 1988Raw
ClientGUID fieldL_Log tablenot statedstring16The unique person identifier from Cognos.29 August 2022Raw
ClientVisitGUID fieldL_Log tablenot statedstring16Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data.29 August 2022Raw
Creatinine (APACHE)L_Log tableApachenumbersingleThe patient's level in .11 July 1988Raw
D ID fieldL_Log table
L_Labs_Flowsheet table
L_Pharm_Flowsheet table
L_PHI table
L_TISS_Form table
L_TISS_Item table
L TISS76 table
L_Labs_DSM table
L_ICD10 table
L_PCH table
L CCI Component table
L_CCI_Picklist table
L Como table
L_Dxs table
L_TmpV2 table
not statedstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 1988Raw
Date of BirthL_Log table
L_PHI table
Top Rowdatenot enteredDate of Birth (DOB) is the data a patient was born.11 July 1988Raw
Dispo DtTm fieldL_Log tableDispodatenot enteredDate and time when the patient changed status from what is documented in Service/Location field to Dispo field..1 July 2016Raw
Dispo fieldL_Log tableDisponumberlongThe Dispo field contains information about what happens to the patient at the end of their admission.1 July 2016Raw
Dx DateL_ICD10 tableICD10datenot enteredThe date/time of an ICD10 diagnosis.11 July 1988Raw
Dx Date unknownL_ICD10 tableICD10booleannot enteredTrue for Acquired Diagnosis / Complication when Dx Date legitimately missing.11 July 1988Raw
Dx PrimaryL_ICD10 tableICD10booleannot enteredCheckbox that is set to true for a single Admit Diagnosis per ward stay that is the Primary Admit Diagnosis11 July 1988Raw
Dx PriorityL_ICD10 tableICD10numbersingleThe priority of an ICD10 diagnosis, used to rank and group.11 July 1988Raw
Dx TypeL_ICD10 tableICD10string8The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication)11 July 1988Raw
ER DelayCreated Variables Common 2021 tablenot stateddaten/aThe 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 1988Created
FiO2L_Log tableApachenumbersingleFIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient.11 July 1988Raw
FirstName fieldL_Log table
L_PHI table
Top Rowstring40Last Name of patient11 July 1988Raw
FluoroquinolonesL_Pharm_Flowsheet tablePharmnumberintegerfluoroquinolones contains manually collected doses of fluoroquinolones that were given.11 July 1988Raw
FunginsL_Pharm_Flowsheet tablePharmnumberintegerfungins contains manually collected doses of fungins that were given.11 July 1988Raw
HCTL_Log tableApachenumbersingleThe patient's hematocrit level in percentage.11 July 1988Raw
HRL_Log tableApachenumbersingleThe patient's Heart Rate level in beats/min.11 July 1988Raw
Hospitalization IDL_Log table
L_Person table
not statednumberlong integerNot currently used11 July 1988Created
ICD10 codeL_ICD10 table
s_ICD10 table
ICD10string10The actual ICD10 code.11 July 1988Raw
KL_Log tableApachenumbersingleThe patient's Potassium level in mmol/L.11 July 1988Raw
L ICD10 IDL_ICD10 tableICD10numberlongUnique identifier of the L_ICD10 table11 July 1988Raw
LastName fieldL_Log table
L_PHI table
Top Rowstring40Last Name of patient11 July 1988Raw
LastOpened DtTm fieldL_Log tablenot stateddatenot enteredDate/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 2016Raw
Mean BPCreated Variables CC 2021 tableApachenumbersingleMean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3)11 July 1988Created
NaL_Log tableApachenumbersingleThe patient's Sodium level in mmol/L.11 July 1988Raw
Notes fieldL_Log tableTop Rowmemonot enteredUsed by data collectors to keep notes during collection.11 July 1988Raw
Notes field (L PHI)L_PHI tablenot statedstringnot enteredNotes in L_PHI table is used by the data processor to comment on data ad-hoc where needed.11 July 1988Raw
PCO2L_Log tableApachenumbersinglePCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L.11 July 1988Raw
PHL_Log tableApachenumbersingleThe acidity or basicity of the patient's arterial blood.11 July 1988Raw
PHIN fieldL_Log table
L_PHI table
Top RownumberLong IntegerThe patient's PHIN .11 July 1988Raw
PO2L_Log tableApachenumbersinglePO2 is the partial pressure of oxygen in the patient's arterial blood.11 July 1988Raw
Pat ID fieldL_Log table
L_Labs_Flowsheet table
L_Pharm_Flowsheet table
L_PHI table
L_TISS_Form table
L_TISS_Item table
L_ICD10 table
L_PCH table
L CCI Component table
L_CCI_Picklist table
L Como table
L_Dxs table
L_TmpV2 table
Top RownumberLong IntegerThe Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number.11 July 1988Raw
Person ID fieldL_Log table
L_Person table
not statednumberlong integerUnique random number id per patient that combines the D_IDs across admissions/encounters.11 July 1988Created
Pharm Direct thrombin inhibitorsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm Dobutamine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm Dopamine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm Epinephrine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm Factor Xa inhibitorsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm H2 blockersL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm Heparin cont infL_Log tablePharmbooleannot enteredTrue if a continuous infusion of Heparin was given1 January 2012Raw
Pharm HeparinoidsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm LMWHL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm Milrinone cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm Norepinephrine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm PPIL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm Paralytics cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm Phenylephrine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm Vasopressin cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm Vitamin K antagonists fieldL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm amiodaronesL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm amphotericin BL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm anti-TB drugsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm benzodiazepinesL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm bosentanL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm corticosteroidsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm furosemideL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm heparin sqL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm influenza drugsL_Log tablePharmbooleannot enteredTrue if influenza drugs were given1 January 2012Raw
Pharm insulinL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm opioidsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm propofolL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm special upper GI bleeding agentsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm statinsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Pharm viagra-type vasodilatorsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 2012Raw
Postal Code fieldL_Log tableDispostring6The patient's postal code.1 January 2012Raw
Pre acute living situation fieldL_Log tableDisponumberlong integerInfo about the living situation of the patient prior to the current hospitalization.1 July 2016Raw
Pre-admit Inpatient Institution fieldL_Log tableDisponumberlong integerThe 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 2016Raw
Previous Location fieldL_Log tableDisponumberlong integerThe most recent previous physical location (with #exceptions) of a patient before arriving at the collection location.1 July 2016Raw
Province fieldL_Log tableDispostring2Province 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 1988Raw
Px CountL CCI Component table
L_CCI_Picklist table
CCIdatenot enteredThe type of a CCI procedure (comorbid, admit or acquired)11 July 1988Raw
Px DateL CCI Component table
L_CCI_Picklist table
CCIdatenot enteredThe date/time of a CCI procedure11 July 1988Raw
Px TypeL CCI Component table
L_CCI_Picklist table
CCIstringnot enteredThe type of a CCI Procedure as per CCI Collection, ie admit or acquired11 July 1988Raw
RRL_Log tableApachenumbersingleThe patient's respiratory rate level in breaths/min.11 July 1988Raw
RecordStatus fieldL_Log tableTop Rowstring20status of the data in the record. Possible values are complete, sent, questioned and vetted.24 April 2013Raw
s_dispo.loc_types_dispo tablestring20The 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 2016Raw
SentDtTm fieldL_Log tablenot stateddatenot enteredTime the record was last sent.11 July 1988Raw
Serum CO2L_Log tableApachenumbersingleThe patient's Serum CO2 level in mmol/L.11 July 1988Raw
Service/Location fieldL_Log tableDisponumberlong integerLegacy field replaced by Boarding Loc and Service tmp entry1 July 2016Raw
Sex fieldL_Log tableDispostring7Biological sex of the patient at birth; options are "male" and "female".11 July 1988Raw
Start Date fieldL_Log tablenot stateddatenot enteredDate the record was created on the data collector's laptop; created automatically by CCMDB.accdb.25 February 2011Raw
Start Time fieldL_Log tablenot stateddatenot enteredTime the record was created on the data collector's laptop; created automatically by CCMDB.accdb.25 February 2011Raw
TemperatureL_Log tableApachenumbersingleThe patient's Temperature level in °C.11 July 1988Raw
Vanco alternativesL_Pharm_Flowsheet tablePharmnumberintegervanco alternatives contains manually collected doses of vanco alternatives that were given.11 July 1988Raw
VancomycinL_Pharm_Flowsheet tablePharmnumberintegervancomycin contains manually collected doses of vancomycin that were given.11 July 1988Raw
Visit Admit DtTm fieldL_Log tableDispodatenot enteredThe Visit Admit DtTm field is the start of the hospital registration for the current admission. If from ER, this is also the Triage DtTm.1 January 2003Raw
WBCL_Log tableApachenumbersingleThe patient's White Blood Count level in x109/L.11 July 1988Raw

Legacy data

Click to see legacy data only   

Full list

Click to see full list   
This is a list of fields in the Critical Care and Medicine Database
 TableTabData typelengthDescriptionStart dateEnd dateCreated vs raw
3rd generation cephalosporinsL_Pharm_Flowsheet tablePharmnumberinteger3rd generation cephalosporins contains manually collected doses of 3rd generation cephalosporins that were given.20 October 201111 March 2013Raw
ADL BathingL_Log tableADLstring15Need for help with bathing; component of ADL.1 October 20031 January 2100Raw
ADL CompleteL_Log tableTop Rowbooleannot enteredtrue when patient ADL data is complete1 January 200031 December 2100Raw
ADL ContinenceL_Log tableADLstring15Control of urination and bowel movements; component of ADL1 October 20031 January 2100Raw
ADL DressingL_Log tableADLstring15Need for help with dressing; component of ADL.1 October 20031 January 2100Raw
ADL FeedingL_Log tableADLstring15Need for help with feeding; component of ADL1 October 20031 January 2100Raw
ADL ToilettingL_Log tableADLstring15Need for help with toiletting; component of ADL1 October 20031 January 2100Raw
ADL TransferingL_Log tableADLstring15Need for help with transferring; component of ADL1 October 20031 January 2100Raw
AP Dias BP FieldL_Log tableApachenumbersingleAp_DiasBP is the diastolic blood pressure.11 July 19881 January 2100Raw
AP Eye fieldL_Log tableApachestring13The eye component of the Glasgow_Coma_Scale.11 July 19881 January 2100Raw
AP Motor fieldL_Log tableApachestring19The motor component of the Glasgow_Coma_Scale.11 July 19881 January 2100Raw
AP Sys BP FieldL_Log tableApachenumbersingleAp_SysBP is the systolic blood pressure.11 July 19881 January 2100Raw
AP Verbal fieldL_Log tableApachestring26The verbal component of the Glasgow_Coma_Scale.11 July 19881 January 2100Raw
ARF (APACHE)L_Log tableApachenumbersingleThe ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.11 July 19881 January 2100Raw
AaDO2N/AApachenumberN/AThe patient's Alveolar-arterial oxygen tension difference level in .11 July 19881 January 2100Created
Abdominal ultrasoundL_Labs_Flowsheet tableLabintegerintegerContains the number of abdominal ultrasounds a client has had during an admission to our unit.11 July 198831 December 2018Raw
Accept DtTm fieldL_Log tablenot stateddatenot enteredFirst Service tmp entry DtTm for pts who came from the ER department only1 July 201622 April 2022Raw
Accept DtTm missing fieldL_Log tablenot statedbooleannot enteredcheckbox is checked/true when no Accept DtTm is documented for a patient who came from from the ER.1 July 201622 April 2022Raw
Admit Type for APACHE IIL_Log tableApachestring10The 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 19881 January 2100Raw
AgeCreated Variables Common 2021 table
Created Variables CC 2021 table
not statednumberThe number of years between Date of Birth and the last birthday prior to or on (Admit DtTm otherwise).11 July 19881 January 2100Created
Albumin 25pctL_Labs_Flowsheet tableLabintegerintegerAlbumin_25pct contains number of doses of 25% Albumin that were given.11 July 198831 December 2018Raw
Albumin 5pctL_Labs_Flowsheet tableLabintegerintegerAlbumin_5pct contains the number of doses of 5% Albumin that were given.11 July 198831 December 2018Raw
Angio coronary fieldL_Labs_Flowsheet tableLabintegerintegerAngio coronary contained the manually counted number of coronary angiograms done during a stay in our unit, or on the way there.11 July 19883 April 2017Raw
Angio others fieldL_Labs_Flowsheet tableLabintegerintegerAngio_others contained the manually counted number of non-coronary angiograms done during a stay in our unit, or on the way there.11 July 19883 April 2017Raw
AntipseudomonalsL_Pharm_Flowsheet tablePharmnumberintegerantipseudomonals contains manually collected doses of antipseudomonals that were given.11 July 19881 January 2100Raw
Ap CompleteL_Log tableTop Rowbooleannot enteredTrue when patient APACH II data is complete1 January 200031 December 2100Raw
Ap SapsSysBP fieldL_Log tablenot statednumberlong integer 11 July 198813 May 2014Raw
Arrive DtTm fieldN/ADispodatenot enteredFirst non-ER Boarding location date and time, or start of ( Service Location) for legacy records.1 July 201622 April 2022Raw
Arterial blood gas (labs)L_Labs_Flowsheet tableLabintegerlongABG contains manually collected arterial blood gas counts.11 July 198831 December 2018Raw
AzolesL_Pharm_Flowsheet tablePharmnumberintegerazoles contains manually collected doses of azoles that were given.11 July 19881 January 2100Raw
Benzodiazepines cont infL_Pharm_Flowsheet tablePharmnumberintegerbenzodiazepines cont inf contains manually collected doses of benzodiazepines cont inf that were given.29 November 201113 May 2014Raw
Blood cultureL_Labs_Flowsheet tableLabnot enteredintegerContains the number of blood cultures a patient has had during an admission to our unit.17 March 2017Raw
CBCL_Labs_Flowsheet tableLabintegerintegerCBC contains the number of CBCs done during a patient's stay in our unit.11 July 198831 December 2018Raw
CCI 1 CodeN/ACCInumberlong integerThe unique identifier/index of CCI Procedure's first component in s_CCI_1 table.1 January 20191 January 2100Raw
CCI 2 CodeN/ACCInumberlong integerThe unique identifier/index of CCI Procedure's second component in s_CCI_2 table.1 January 20191 January 2100Raw
CCI Picklist CodeL_CCI_Picklist tableCCIstring20The CCI code for and entry in the L CCI Picklist subform, from s_CCI_Picklist table.1 January 20191 January 2100Raw
CT Scan (labs)L_Labs_Flowsheet tableLabintegerintegerCT_Scan contains the manually counted number of CT scans done during a patient's stay in our unit.11 July 198831 December 2018Raw
CXRL_Labs_Flowsheet tableLabintegerintegerChest Xrays (CXR) contains the manually counted number of chest xrays (CXR) done during a patient's stay in our unit.11 July 198831 December 2018Raw
CarbapenemsL_Pharm_Flowsheet tablePharmnumberintegercarbapenems contains manually collected doses of carbapenems that were given.11 July 19881 January 2100Raw
CeftazidimeL_Pharm_Flowsheet tablePharmnumberintegerceftazidime contains manually collected doses of ceftazidime that were given.2 January 20128 March 2013Raw
Chart numberL_Log table
L_PHI table
Top Rowstring8The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals.11 July 19881 January 2100Raw
Chronic Health APACHEL_Log tableApachestring30Specific chronic pre-existing conditions used for APACHE score.17 February 2022Raw
ClientGUID fieldL_Log tablenot statedstring16The unique person identifier from Cognos.29 August 20221 January 2100Raw
ClientVisitGUID fieldL_Log tablenot statedstring16Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data.29 August 20221 January 2100Raw
Como CompleteL_Log tableTop Rowbooleannot enteredTrue when patient comorbid diagnosis data is complete1 January 200031 December 2100Raw
Creatinine (APACHE)L_Log tableApachenumbersingleThe patient's level in .11 July 19881 January 2100Raw
Creatinine (labs)L_Labs_Flowsheet tableLabintegerintegerCreatinine contains the number of creatinines done during a patient's stay in our unit.11 July 198817 March 2017Raw
D ID fieldL_Log table
L_Labs_Flowsheet table
L_Pharm_Flowsheet table
L_PHI table
L_TISS_Form table
L_TISS_Item table
L TISS76 table
L_Labs_DSM table
L_ICD10 table
L_PCH table
L CCI Component table
L_CCI_Picklist table
L Como table
L_Dxs table
L_TmpV2 table
not statedstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
DC TreatmentL_Log tablenot statedstring50"DC" for critical care patients if life-support treatment is terminated, blank for all others.11 July 198810 May 2022Raw
Date of BirthL_Log table
L_PHI table
Top Rowdatenot enteredDate of Birth (DOB) is the data a patient was born.11 July 19881 January 2100Raw
Diag CompleteL_Log tableTop Rowbooleannot enteredTrue when patient diagnosis data is complete1 January 200031 December 2100Raw
Dispo DtTm fieldL_Log tableDispodatenot enteredDate and time when the patient changed status from what is documented in Service/Location field to Dispo field..1 July 20161 January 2100Raw
Dispo fieldL_Log tableDisponumberlongThe Dispo field contains information about what happens to the patient at the end of their admission.1 July 20161 January 2100Raw
Dx DateL_ICD10 tableICD10datenot enteredThe date/time of an ICD10 diagnosis.11 July 19881 January 2100Raw
Dx Date unknownL_ICD10 tableICD10booleannot enteredTrue for Acquired Diagnosis / Complication when Dx Date legitimately missing.11 July 19881 January 2100Raw
Dx PrimaryL_ICD10 tableICD10booleannot enteredCheckbox that is set to true for a single Admit Diagnosis per ward stay that is the Primary Admit Diagnosis11 July 19881 January 2100Raw
Dx PriorityL_ICD10 tableICD10numbersingleThe priority of an ICD10 diagnosis, used to rank and group.11 July 19881 January 2100Raw
Dx TypeL_ICD10 tableICD10string8The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication)11 July 19881 January 2100Raw
ER DelayCreated Variables Common 2021 tablenot stateddaten/aThe 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 19881 January 2100Created
EchocardiogramL_Labs_Flowsheet tableLabnumberintegerContains the number of heart ultrasounds (echocardiograms) a client has had during an admission to our unit.11 July 198831 December 2018Raw
FFPL_Labs_Flowsheet tableLabintegerintegerFresh Frozen Plasma / FFP contains manually collected doses of FFP that were given.11 July 198831 December 2018Raw
FiO2L_Log tableApachenumbersingleFIO2 is the fraction of inspired oxygen[2] in the gas mixture breathed by the patient.11 July 19881 January 2100Raw
FirstName fieldL_Log table
L_PHI table
Top Rowstring40Last Name of patient11 July 19881 January 2100Raw
FluoroquinolonesL_Pharm_Flowsheet tablePharmnumberintegerfluoroquinolones contains manually collected doses of fluoroquinolones that were given.11 July 19881 January 2100Raw
FunginsL_Pharm_Flowsheet tablePharmnumberintegerfungins contains manually collected doses of fungins that were given.11 July 19881 January 2100Raw
Furosemide cont infL_Pharm_Flowsheet tablePharmnumberintegerfurosemide cont inf contains manually collected doses of furosemide cont inf that were given.21 December 20119 May 2014Raw
GCS sedated fieldL_Log tableApachebooleannot enteredField does not contain any relevant data.22 September 201615 June 2021Raw
H2-BlockersL_Pharm_Flowsheet tablePharmnumberintegerH2-Blockers contains manually collected doses of H2-Blockers that were given.24 December 200912 May 2014Raw
HCTL_Log tableApachenumbersingleThe patient's hematocrit level in percentage.11 July 19881 January 2100Raw
HRL_Log tableApachenumbersingleThe patient's Heart Rate level in beats/min.11 July 19881 January 2100Raw
Heparin SQL_Pharm_Flowsheet tablePharmnumberintegerHeparin SQ contains manually collected doses of Heparin SQ that were given.28 November 201113 May 2014Raw
Hospitalization IDL_Log table
L_Person table
not statednumberlong integerNot currently used11 July 19881 January 2100Created
ICD10 codeL_ICD10 table
s_ICD10 table
ICD10string10The actual ICD10 code.11 July 19881 January 2100Raw
Insulin cont infL_Pharm_Flowsheet tablePharmnumberintegerinsulin cont inf contains manually collected doses of insulin cont inf that were given.6 December 201113 May 2014Raw
KL_Log tableApachenumbersingleThe patient's Potassium level in mmol/L.11 July 19881 January 2100Raw
L ICD10 IDL_ICD10 tableICD10numberlongUnique identifier of the L_ICD10 table11 July 19881 January 2100Raw
LMWHL_Pharm_Flowsheet tablePharmnumberintegerLMWH contains manually collected doses of LMWH that were given.6 December 201131 December 2011Raw
Labs CompleteL_Log tableTop Rowbooleannot enteredTrue when patient Labs data is complete1 January 200031 December 2100Raw
LastChanged DtTm fieldL_Log tableTop Rowdatenot enteredLast time the record was closed with the "Close - with updates" button6 January 202131 December 2999Raw
LastName fieldL_Log table
L_PHI table
Top Rowstring40Last Name of patient11 July 19881 January 2100Raw
LastOpened DtTm fieldL_Log tablenot stateddatenot enteredDate/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 20161 January 2100Raw
MRI (labs)L_Labs_Flowsheet tableLabintegerintegerMRI contains the manually counted number of MRIs done during a patient's stay in our unit.11 July 198831 December 2018Raw
Magnesium (labs)L_Labs_Flowsheet tableLabintegerintegerMagnesium contains the number of magnesiums done during a patient's stay in our unit.11 July 198831 December 2018Raw
Mean BPCreated Variables CC 2021 tableApachenumbersingleMean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3)11 July 19881 January 2100Created
NaL_Log tableApachenumbersingleThe patient's Sodium level in mmol/L.11 July 19881 January 2100Raw
Notes fieldL_Log tableTop Rowmemonot enteredUsed by data collectors to keep notes during collection.11 July 19881 January 2100Raw
Notes field (L PHI)L_PHI tablenot statedstringnot enteredNotes in L_PHI table is used by the data processor to comment on data ad-hoc where needed.11 July 19881 January 2100Raw
Off ward fieldL_Log tableDisponumberlong integerChecked/true if the patient who meets the Definition of a Medicine Laptop Admission or Definition of a Critical Care Laptop Admission spent any time in a bed that is not at their actual collection location between "Arrive DtTm" and Dispo DtTm. The patient must be covered by the attending of the service of the home unit that is credited with the "off ward" designation.1 July 201629 January 2020Raw
Opioids cont infL_Pharm_Flowsheet tablePharmnumberintegeropioids cont inf contains manually collected doses of opioids cont inf that were given.6 December 201113 May 2014Raw
PCO2L_Log tableApachenumbersinglePCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L.11 July 19881 January 2100Raw
PHL_Log tableApachenumbersingleThe acidity or basicity of the patient's arterial blood.11 July 19881 January 2100Raw
PHIN fieldL_Log table
L_PHI table
Top RownumberLong IntegerThe patient's PHIN .11 July 19881 January 2100Raw
PO2L_Log tableApachenumbersinglePO2 is the partial pressure of oxygen in the patient's arterial blood.11 July 19881 January 2100Raw
PPIL_Pharm_Flowsheet tablePharmnumberintegerPPI contains manually collected doses of PPI that were given.12 September 201112 May 2014Raw
PT PTTL_Labs_Flowsheet tableLabintegerintegerPT_PTT contains the number of PTs and PTTs done during a patient's stay in our unit.11 July 198817 March 2017Raw
Pat ID fieldL_Log table
L_Labs_Flowsheet table
L_Pharm_Flowsheet table
L_PHI table
L_TISS_Form table
L_TISS_Item table
L_ICD10 table
L_PCH table
L CCI Component table
L_CCI_Picklist table
L Como table
L_Dxs table
L_TmpV2 table
Top RownumberLong IntegerThe Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number.11 July 19881 January 2100Raw
PentaspanL_Labs_Flowsheet tableLabintegerintegerPentaspan contains the number of doses or Pentaspan that were given while in the unit.12 June 2014Raw
Person ID fieldL_Log table
L_Person table
not statednumberlong integerUnique random number id per patient that combines the D_IDs across admissions/encounters.11 July 19881 January 2100Created
Pharm 1st or 2nd generation cephalosporinsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20127 August 2013Raw
Pharm 4th generation cephalosporinsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 201228 February 2013Raw
Pharm CompleteL_Log tableTop Rowbooleannot enteredTrue when patient pharmacy diagnosis data is complete1 January 200031 December 2100Raw
Pharm Direct thrombin inhibitorsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Dobutamine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Dopamine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Epinephrine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Factor Xa inhibitorsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm H2 blockersL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Heparin cont infL_Log tablePharmbooleannot enteredTrue if a continuous infusion of Heparin was given1 January 20121 January 2100Raw
Pharm HeparinoidsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm LMWHL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Milrinone cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Norepinephrine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm PPIL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Paralytics cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Phenylephrine cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Vasopressin cont infL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Vitamin K antagonists fieldL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm aminoglycosidesL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20125 March 2013Raw
Pharm amiodaronesL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm amphotericin BL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm anti-TB drugsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm antistaph penicillinsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 201219 February 2013Raw
Pharm benzodiazepinesL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm bosentanL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm corticosteroidsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm furosemideL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm heparin sqL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm influenza drugsL_Log tablePharmbooleannot enteredTrue if influenza drugs were given1 January 20121 January 2100Raw
Pharm insulinL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm macrolidesL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 201217 March 2013Raw
Pharm opioidsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm propofolL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm special upper GI bleeding agentsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm statinsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm viagra-type vasodilatorsL_Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
PlateletsL_Labs_Flowsheet tableLabintegerintegerPlatelets contains number of doses of platelets that were given.11 July 198831 December 2018Raw
Postal Code fieldL_Log tableDispostring6The patient's postal code.1 January 20121 January 2100Raw
Pre acute living situation fieldL_Log tableDisponumberlong integerInfo about the living situation of the patient prior to the current hospitalization.1 July 20161 January 2100Raw
Pre-admit Inpatient Institution fieldL_Log tableDisponumberlong integerThe 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 20161 January 2100Raw
Previous Location fieldL_Log tableDisponumberlong integerThe most recent previous physical location (with #exceptions) of a patient before arriving at the collection location.1 July 20161 January 2100Raw
Previous Service fieldL_Log tableDisponumberlong integerThe most recent "originating service" which sends the patients to their current service location.1 July 20167 September 2022Raw
Propofol cont infL_Pharm_Flowsheet tablePharmnumberintegerpropofol cont inf contains manually collected doses of propofol cont inf that were given.6 December 201113 May 2014Raw
Province fieldL_Log tableDispostring2Province 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 19881 January 2100Raw
Px CountL CCI Component table
L_CCI_Picklist table
CCIdatenot enteredThe type of a CCI procedure (comorbid, admit or acquired)11 July 19881 January 2100Raw
Px DateL CCI Component table
L_CCI_Picklist table
CCIdatenot enteredThe date/time of a CCI procedure11 July 19881 January 2100Raw
Px TypeL CCI Component table
L_CCI_Picklist table
CCIstringnot enteredThe type of a CCI Procedure as per CCI Collection, ie admit or acquired11 July 19881 January 2100Raw
R CompleteL_Log tableTop Rowbooleannot enteredtrue when patient registry data is complete1 January 200031 December 2100Raw
R Filter FieldL_Log tableDispostring10Critical care patients on a long term ventilator (LTV).11 July 19881 January 2019Raw
RRL_Log tableApachenumbersingleThe patient's respiratory rate level in breaths/min.11 July 19881 January 2100Raw
RecordL_Log tableTop Rowstring8Free choice use by collectors to help collection, this field has no consistent meaning.1 January 190031 December 2100Raw
RecordStatus fieldL_Log tableTop Rowstring20status of the data in the record. Possible values are complete, sent, questioned and vetted.24 April 20131 January 2100Raw
Registry Patient TypeN/ADispostring10Service of the attending physician for medicine data, and the type of admit diagnosis for critical care patients.1 April 19979 May 2018Raw
s_dispo.loc_types_dispo tablestring20The 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 20161 January 2100Raw
SGPT ALT (labs)L_Labs_Flowsheet tableLabintegerintegerSGPT_ALT contains the number of SGPTs and ALTs done during a patient's stay in our unit.11 July 198817 March 2017Raw
SentDtTm fieldL_Log tablenot stateddatenot enteredTime the record was last sent.11 July 19881 January 2100Raw
Serum CO2L_Log tableApachenumbersingleThe patient's Serum CO2 level in mmol/L.11 July 19881 January 2100Raw
Service/Location fieldL_Log tableDisponumberlong integerLegacy field replaced by Boarding Loc and Service tmp entry1 July 20161 January 2100Raw
Sex fieldL_Log tableDispostring7Biological sex of the patient at birth; options are "male" and "female".11 July 19881 January 2100Raw
Spare1L_Pharm_Flowsheet tablePharmnumberintegerspare1 contains manually collected doses of spare1 that were given.8 December 20128 December 2012Raw
Spare2L_Pharm_Flowsheet tablePharmnumberintegerspare2 contains manually collected doses of spare2 that were given.8 December 20128 December 2012Raw
Spare3L_Pharm_Flowsheet tablePharmnumberintegerspare3 contains manually collected doses of spare3 that were given.8 December 20128 December 2012Raw
Spare4L_Pharm_Flowsheet tablePharmnumberintegerspare4 contains manually collected doses of spare4 that were given.8 December 20128 December 2012Raw
Spare5L_Pharm_Flowsheet tablePharmnumberintegerspare5 contains manually collected doses of spare5 that were given.8 December 20128 December 2012Raw
Spare6L_Pharm_Flowsheet tablePharmnumberintegerspare6 contains manually collected doses of spare6 that were given.8 December 20128 December 2012Raw
Sputum C+SL_Labs_Flowsheet tableLabintegerintegerContains the number of any sputum specimens (including endotracheal secretions) sent for "culture and sensitivity" for bacteria or fungus.11 July 198817 March 2017Raw
Start Date fieldL_Log tablenot stateddatenot enteredDate the record was created on the data collector's laptop; created automatically by CCMDB.accdb.25 February 20111 January 2100Raw
Start Time fieldL_Log tablenot stateddatenot enteredTime the record was created on the data collector's laptop; created automatically by CCMDB.accdb.25 February 20111 January 2100Raw
TR info status fieldL_Log tableDispostring19Cross-check field that will contain data if Transfer_Ready_DtTm field is empty5 May 201615 October 2020Raw
TemperatureL_Log tableApachenumbersingleThe patient's Temperature level in °C.11 July 19881 January 2100Raw
TigecylineL_Pharm_Flowsheet tablePharmnumberintegertigecyline contains manually collected doses of tigecyline that were given.21 July 201226 August 2012Raw
Tmp CompleteL_Log tableTop Rowbooleannot enteredTrue when patient Tmp data is complete1 January 200031 December 2100Raw
Transfer Ready DtTm fieldL_Log tableDispodatenot enteredDate and time the intent to discharge a patient to a lower level in the Level of care hierarchy was documented.1 June 199915 October 2020Raw
TroponinL_Labs_Flowsheet tableLabintegerintegerTroponincontains the number of troponins done during a patient's stay in our unit.11 July 198817 March 2017Raw
Urine CSL_Labs_Flowsheet tableLabintegerintegerUrine_CS contains the number of any urine specimens sent for "culture and sensitivity" for bacteria or fungus.11 July 198817 March 2017Raw
Vanco alternativesL_Pharm_Flowsheet tablePharmnumberintegervanco alternatives contains manually collected doses of vanco alternatives that were given.11 July 19881 January 2100Raw
VancomycinL_Pharm_Flowsheet tablePharmnumberintegervancomycin contains manually collected doses of vancomycin that were given.11 July 19881 January 2100Raw
Venous blood gas (labs)L_Labs_Flowsheet tableLabintegerlongVBG contains manually collected venous blood gas counts.11 July 198831 December 2018Raw
Visit Admit DtTm fieldL_Log tableDispodatenot enteredThe Visit Admit DtTm field is the start of the hospital registration for the current admission. If from ER, this is also the Triage DtTm.1 January 20031 January 2100Raw
VoluvenL_Labs_Flowsheet tableLabintegerintegerVoluven contains the number of doses or Voluven that were given while in the unit.11 July 198812 June 2014Raw
WBCL_Log tableApachenumbersingleThe patient's White Blood Count level in x109/L.11 July 19881 January 2100Raw

Background / Implementation of this page

This page aggregates data from other pages that use the Template:Data element using Semantic Mediawiki. If a field is not listed, check that a corresponding article exists and Template:Data element is used correctly.

Related articles

Related articles: