CCMDB Wiki

Template:DataDictionaryQuery

Revision as of 13:36, 21 April 2022 by Ttenbergen (talk | contribs) (updated to only list fields that are still collected)

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.

 FieldDataTypeFieldLengthDataElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
D ID fieldstring18The unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100Raw
Pat ID fieldnumberLong IntegerThe Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number.11 July 19881 January 2100Raw
Person ID fieldnumberlong integerUnique random number id per patient that combines the D_IDs across admissions/encounters.11 July 19881 January 2100Created
L ICD10 IDnumberlongUnique identifier of the L_ICD10 table11 July 19881 January 2100Raw
ICD10 codestring10The actual ICD10 code.11 July 19881 January 2100Raw
Hospitalization IDnumberlong integerNot currently used11 July 19881 January 2100Created
ClientGUID fieldstring16The unique person identifier from Cognos.29 August 20221 January 2100Raw
ClientVisitGUID fieldstring16Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data.29 August 20221 January 2100Raw
LastName fieldstring40Last Name of patient11 July 19881 January 2100Raw
FirstName fieldstring40Last Name of patient11 July 19881 January 2100Raw
CCI 1 Codenumberlong integerThe unique identifier/index of CCI Procedure's first component in s_CCI_1 table.1 January 20191 January 2100Raw
Agenumbernot enteredThe number of years between Date of Birth and the last birthday prior to or on (Admit DtTm otherwise).11 July 19881 January 2100Created
PHIN fieldnumberLong IntegerThe patient's PHIN .11 July 19881 January 2100Raw
Px Datedatenot enteredThe date/time of a CCI procedure11 July 19881 January 2100Raw
Dx Datedatenot enteredThe date/time of an ICD10 diagnosis.11 July 19881 January 2100Raw
CCI 2 Codenumberlong integerThe unique identifier/index of CCI Procedure's second component in s_CCI_2 table.1 January 20191 January 2100Raw
CCI Picklist Codestring20The CCI code for and entry in the L CCI Picklist subform, from s_CCI_Picklist table.1 January 20191 January 2100Raw
Date of Birthdatenot enteredDate of Birth (DOB) is the data a patient was born.11 July 19881 January 2100Raw
Dx Date unknownbooleannot enteredTrue for Acquired Diagnosis / Complication when Dx Date legitimately missing.11 July 19881 January 2100Raw
Px Countdatenot enteredThe type of a CCI procedure (comorbid, admit or acquired)11 July 19881 January 2100Raw
Chart numberstring8The 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
SentDtTm fielddatenot enteredTime the record was last sent.11 July 19881 January 2100Raw
Dx Typestring8The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication)11 July 19881 January 2100Raw
Start Date fielddatenot enteredDate the record was created on the data collector's laptop; created automatically by CCMDB.accdb.25 February 20111 January 2100Raw
Dx PrioritynumbersingleThe priority of an ICD10 diagnosis, used to rank and group.11 July 19881 January 2100Raw
s_dispo.hospitalstring100aggregating field for s_dispo table used to ???1 July 20161 January 2100Raw
ER Delaydaten/aThe ER Delay is the difference between the initial ER Boarding Loc and first post-ER Boarding Loc, for patients arriving from the ER.11 July 19881 January 2100Created
Start Time fielddatenot enteredTime the record was created on the data collector's laptop; created automatically by CCMDB.accdb.25 February 20111 January 2100Raw
s_dispo.loc_typestring20The 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
Dx Primarybooleannot enteredCheckbox that is set to true for a single Admit Diagnosis per ward stay that is the Primary Admit Diagnosis11 July 19881 January 2100Raw
s_dispo.inpatientboolean14whether a location is an in-patient location1 July 20161 January 2100Raw
Notes fieldmemonot enteredUsed by data collectors to keep notes during collection.11 July 19881 January 2100Raw
Notes field (L PHI)stringnot enteredNotes in L_PHI table is used by the data processor to comment on data ad-hoc where needed.11 July 19881 January 2100Raw
Px Typestringnot enteredThe type of a CCI Procedure as per CCI Collection, ie admit or acquired11 July 19881 January 2100Raw
s_dispo.geoRegionstring10aggregating field for s_dispo table used to ???1 July 20161 January 2100Raw
Mean BPnumbersingleMean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3)11 July 19881 January 2100Created
Azolesnumberintegerazoles contains manually collected doses of azoles that were given.11 July 19881 January 2100Raw
Funginsnumberintegerfungins contains manually collected doses of fungins that were given.11 July 19881 January 2100Raw
Antipseudomonalsnumberintegerantipseudomonals contains manually collected doses of antipseudomonals that were given.11 July 19881 January 2100Raw
Province fieldstring2Province 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
Vancomycinnumberintegervancomycin contains manually collected doses of vancomycin that were given.11 July 19881 January 2100Raw
Sex fieldstring7Biological sex of the patient at birth; options are "male" and "female".11 July 19881 January 2100Raw
Fluoroquinolonesnumberintegerfluoroquinolones contains manually collected doses of fluoroquinolones that were given.11 July 19881 January 2100Raw
s_dispo.meanLOS3STDmean LOS plus 3*STD for the location used by Function long LOS() for soft-check on long LOS admissions.1 July 20161 January 2100Raw
Carbapenemsnumberintegercarbapenems contains manually collected doses of carbapenems that were given.11 July 19881 January 2100Raw
Vanco alternativesnumberintegervanco alternatives contains manually collected doses of vanco alternatives that were given.11 July 19881 January 2100Raw
s_dispo.programstring3aggregating field for s_dispo table used to define the Program1 July 20161 January 2100Raw
s_dispo.centernumberlong integeraggregating field for s_dispo table used to define the order in which sites and units are listed on reports.1 July 20161 January 2100Raw
s_dispo.geogstring9aggregating field for s_dispo table used to1 July 20161 January 2100Raw
Postal Code fieldstring6The patient's postal code.1 January 20121 January 2100Raw
AaDO2numberN/AThe patient's Alveolar-arterial oxygen tension difference level in .11 July 19881 January 2100Created
LastOpened DtTm fielddatenot 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
pre_acute_living_situation fieldnumberlong integerInfo about the living situation of the patient prior to the current hospitalization.1 July 20161 January 2100Raw
Pre-admit Inpatient Institution fieldnumberlong 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 fieldnumberlong integerThe most recent previous physical location (with #exceptions) of a patient before arriving at the collection location.1 July 20161 January 2100Raw
Service/Location fieldnumberlong integerEncodes which program a record is part of.1 July 20161 January 2100Raw
Dispo fieldnumberlongThe Dispo field contains information about what happens to the patient at the end of their admission.1 July 20161 January 2100Raw
Visit Admit DtTm fielddatenot enteredThis field is used only as an identifier to combine data from the same hospitalization and should not be used as a date.1 January 20031 January 2100Raw
Dispo DtTm fielddatenot enteredDate and time when the patient changed status from what is documented in Service/Location field to Dispo field..1 July 20161 January 2100Raw
ADL Bathingstring15Need for help with bathing; component of ADL.1 October 20031 January 2100Raw
ADL Dressingstring15Need for help with dressing; component of ADL.1 October 20031 January 2100Raw
ADL Toilettingstring15Need for help with toiletting; component of ADL1 October 20031 January 2100Raw
ADL Transferingstring15Need for help with transferring; component of ADL1 October 20031 January 2100Raw
ADL Continencestring15Control of urination and bowel movements; component of ADL1 October 20031 January 2100Raw
ADL Feedingstring15Need for help with feeding; component of ADL1 October 20031 January 2100Raw
Admit Type for APACHE IIstring10The 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
TemperaturenumbersingleThe patient's Temperature level in °C.11 July 19881 January 2100Raw
AP Sys BP FieldnumbersingleAp_SysBP is the systolic blood pressure.11 July 19881 January 2100Raw
AP Dias BP FieldnumbersingleAp_DiasBP is the diastolic blood pressure.11 July 19881 January 2100Raw
HRnumbersingleThe patient's Heart Rate level in beats/min.11 July 19881 January 2100Raw
RRnumbersingleThe patient's respiratory rate level in breaths/min.11 July 19881 January 2100Raw
AP_Eye fieldstring13The eye component of the Glasgow_Coma_Scale.11 July 19881 January 2100Raw
AP_Motor fieldstring19The motor component of the Glasgow_Coma_Scale.11 July 19881 January 2100Raw
AP_Verbal fieldstring26The verbal component of the Glasgow_Coma_Scale.11 July 19881 January 2100Raw
FiO2numbersingleFIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient.11 July 19881 January 2100Raw
PO2numbersinglePO2 is the partial pressure of oxygen in the patient's arterial blood.11 July 19881 January 2100Raw
PCO2numbersinglePCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L.11 July 19881 January 2100Raw
PHnumbersingleThe acidity or basicity of the patient's arterial blood.11 July 19881 January 2100Raw
Serum CO2numbersingleThe patient's Serum CO2 level in mmol/L.11 July 19881 January 2100Raw
NanumbersingleThe patient's Sodium level in mmol/L.11 July 19881 January 2100Raw
KnumbersingleThe patient's Potassium level in mmol/L.11 July 19881 January 2100Raw
HCTnumbersingleThe patient's hematocrit level in percentage.11 July 19881 January 2100Raw
WBCnumbersingleThe patient's White Blood Count level in x109/L.11 July 19881 January 2100Raw
Creatinine (APACHE)numbersingleThe patient's level in .11 July 19881 January 2100Raw
ARF (APACHE)numbersingleThe ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.11 July 19881 January 2100Raw
R Completebooleannot enteredtrue when patient registry data is complete1 January 200031 December 2100Raw
ADL Completebooleannot enteredtrue when patient ADL data is complete1 January 200031 December 2100Raw
RecordStatus fieldstring20status of the data in the record. Possible values are complete, sent, questioned and vetted.24 April 20131 January 2100Raw
Ap Completebooleannot enteredTrue when patient APACH II data is complete1 January 200031 December 2100Raw
Labs Completebooleannot enteredTrue when patient Labs data is complete1 January 200031 December 2100Raw
Tmp Completebooleannot enteredTrue when patient Tmp data is complete1 January 200031 December 2100Raw
Como Completebooleannot enteredTrue when patient comorbid diagnosis data is complete1 January 200031 December 2100Raw
Diag Completebooleannot enteredTrue when patient diagnosis data is complete1 January 200031 December 2100Raw
Pharm Completebooleannot enteredTrue when patient pharmacy diagnosis data is complete1 January 200031 December 2100Raw
Recordstring8Free choice use by collectors to help collection, this field has no consistent meaning.1 January 190031 December 2100Raw
LastChanged DtTm fielddatenot enteredLast time the record was closed with the "Close - with updates" button6 January 202131 December 2999Raw
Pharm Vitamin K antagonists fieldbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Heparin cont infbooleannot enteredTrue if a continuous infusion of Heparin was given1 January 20121 January 2100Raw
Pharm Direct thrombin inhibitorsbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Heparinoidsbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Factor Xa inhibitorsbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Dopamine cont infbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Dobutamine cont infbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Norepinephrine cont infbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Epinephrine cont infbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Phenylephrine cont infbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Vasopressin cont infbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Milrinone cont infbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm Paralytics cont infbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm corticosteroidsbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm amphotericin Bbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm influenza drugsbooleannot enteredTrue if influenza drugs were given1 January 20121 January 2100Raw
Pharm bosentanbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm viagra-type vasodilatorsbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm special upper GI bleeding agentsbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm amiodaronesbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm anti-TB drugsbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm statinsbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm PPIbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm H2 blockersbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm furosemidebooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm heparin sqbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm LMWHbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm benzodiazepinesbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm opioidsbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm propofolbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm insulinbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Template:DataDictionaryQuery&oldid=155716"