Auto Data Dictionary

From CCMDB Wiki
Jump to navigationJump to search

what is this?

This article generates a list of data fields in the critical care and medicine database using the Template:Data element and Semantic Mediawiki.

What if a field is missing

This only includes fields that have their own article and that properly use the Template:Data element. If field is missing, check that article exists and template is used correctly.

data fields

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

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.1 January 19001 January 2100Raw
ADL BathingL Log tableADLstring15Need for help with bathing; component of ADL.1 January 19001 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 January 19001 January 2100Raw
ADL DressingL Log tableADLstring15Need for help with dressing; component of ADL.1 January 19001 January 2100Raw
ADL FeedingL Log tableADLstring15Need for help with feeding; component of ADL1 January 19001 January 2100Raw
ADL ToilettingL Log tableADLstring15Need for help with toiletting; component of ADL1 January 19001 January 2100Raw
ADL TransferingL Log tableADLstring15Need for help with transferring; component of ADL1 January 19001 January 2100Raw
AP Dias BP FieldL Log tableApachenumbersingleAp_DiasBP is the diastolic blood pressure.1 January 19001 January 2100Raw
AP Eye fieldL Log tableApachestring13The eye component of the Glasgow_Coma_Scale.1 January 19001 January 2100Raw
AP Motor fieldL Log tableApachestring19The motor component of the Glasgow_Coma_Scale.1 January 19001 January 2100Raw
AP Sys BP FieldL Log tableApachenumbersingleAp_SysBP is the systolic blood pressure.1 January 19001 January 2100Raw
AP Verbal fieldL Log tableApachestring26The verbal component of the Glasgow_Coma_Scale.1 January 19001 January 2100Raw
ARF (APACHE)L Log tableApachenumbersingleThe ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.1 January 19001 January 2100Raw
AaDO2Created variables CC tableApachenumber___The patient's Potassium level in mmol/L.1 January 19001 January 2100Created
Abdominal ultrasoundL Labs Flowsheet tableLabintegerintegerContains the number of abdominal ultrasounds a client has had during an admission to our unit.1 January 190031 December 2018Raw
Accept DtTm fieldL Log tablenot stateddatenot enteredThe date and time when the patient is accepted from the ER department ONLY.1 July 20161 January 2100Raw
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 20161 January 2100Raw
Admit Type for APACHE IIL Log tableApachestring10Admit type for APACHE1 January 19001 January 2100Raw
AgeCreated variables common
Created variables CC table		not statednumberThe number of years between Date of Birth and the last birthday prior to or on (Accept DtTm if applicable, Arrive DtTm otherwise).1 January 19001 January 2100Created
Albumin 25pctL Labs Flowsheet tableLabintegerintegerAlbumin_25pct contains number of doses of 25% Albumin that were given.1 January 190031 December 2018Raw
Albumin 5pctL Labs Flowsheet tableLabintegerintegerAlbumin_5pct contains the number of doses of 5% Albumin that were given.1 January 190031 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.1 January 19003 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.1 January 19003 April 2017Raw
AntipseudomonalsL Pharm Flowsheet tablePharmnumberintegerantipseudomonals contains manually collected doses of antipseudomonals that were given.1 January 19001 January 2100Raw
Ap CompleteL Log tableTop Rowbooleannot enteredTrue when patient APACH II data is complete1 January 200031 December 2100Raw
ApLab CompleteL Log tableTop Rowbooleannot enteredTrue when patient APACHE II lab data is complete1 January 200031 December 2016Raw
Arrive DtTm fieldL Log tableDispodatenot enteredDate and time when the patient physically arrived on unit.1 July 20161 January 2100Raw
Arterial blood gas (labs)L Labs Flowsheet tableLabintegerlongABG contains manually collected arterial blood gas counts.1 January 190031 December 2018Raw
AzolesL Pharm Flowsheet tablePharmnumberintegerazoles contains manually collected doses of azoles that were given.1 January 19001 January 2100Raw
Benzodiazepines cont infL Pharm Flowsheet tablePharmnumberintegerbenzodiazepines cont inf contains manually collected doses of benzodiazepines cont inf that were given.1 January 19001 January 2100Raw
Blood cultureL Labs Flowsheet tableLabintegerintegerContains the number of blood cultures a patient has had during an admission to our unit.1 January 19001 January 2100Raw
CBCL Labs Flowsheet tableLabintegerintegerCBC contains the number of CBCs done during a patient's stay in our unit.1 January 190031 December 2018Raw
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.1 January 190031 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.1 January 190031 December 2018Raw
CarbapenemsL Pharm Flowsheet tablePharmnumberintegercarbapenems contains manually collected doses of carbapenems that were given.1 January 19001 January 2100Raw
CeftazidimeL Pharm Flowsheet tablePharmnumberintegerceftazidime contains manually collected doses of ceftazidime that were given.1 January 19001 January 2100Raw
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.1 January 19001 January 2100Raw
Chronic Health APACHEL Log tableApachestring30Specific chronic pre-existing conditions used for APACHE score.1 January 19001 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 .1 January 19001 January 2100Raw
Creatinine (labs)L Labs Flowsheet tableLabintegerintegerCreatinine contains the number of creatinines done during a patient's stay in our unit.1 January 19001 January 2100Raw
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.1 January 19001 January 2100Raw
DC TreatmentL Log tablenot statedstring50"DC" for critical care patients if life-support treatment is terminated, blank for all others.1 January 19001 January 2100Raw
Date of BirthL Log table
L PHI table		Top Rowdatenot enteredDate of Birth (DOB) is the data a patient was born.1 January 19001 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.1 January 19001 January 2100Raw
Dx Date unknownL ICD10 tableICD10booleannot enteredTrue for Acquired Diagnosis / Complication when Dx Date legitimately missing.1 January 19001 January 2100Raw
Dx PrimaryL ICD10 tableICD10booleannot enteredTrue for the Admit Diagnosis that is the Primary Admit Diagnosis1 January 19001 January 2100Raw
Dx PriorityL ICD10 tableICD10numbersingleThe priority of an ICD10 diagnosis, used to rank and group.1 January 19001 January 2100Raw
Dx TypeL ICD10 tableICD10string8The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication)1 January 19001 January 2100Raw
ER DelayCreated variables commonnot stateddaten/aThe ER Delay is the difference between the Accept DtTm and Arrive_DtTm for patients arriving from the ER.1 January 19001 January 2100Created
EchocardiogramL Labs Flowsheet tableLabnumberintegerContains the number of heart ultrasounds (echocardiograms) a client has had during an admission to our unit.1 January 190031 December 2018Raw
FFPL Labs Flowsheet tableLabintegerintegerFresh Frozen Plasma / FFP contains manually collected doses of FFP that were given.1 January 190031 December 2018Raw
FiO2L Log tableApachenumbersingleFIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient.1 January 19001 January 2100Raw
FinalCheck fieldL Log tableTop Rowbooleannot enteredLegacy; used to be checked when all data is complete, now see RecordStatus field.1 January 190024 May 2013Raw
FirstName fieldL Log table
L PHI table		Top Rowstring40Last Name of patient1 January 19001 January 2100Raw
FluoroquinolonesL Pharm Flowsheet tablePharmnumberintegerfluoroquinolones contains manually collected doses of fluoroquinolones that were given.1 January 19001 January 2100Raw
FunginsL Pharm Flowsheet tablePharmnumberintegerfungins contains manually collected doses of fungins that were given.1 January 19001 January 2100Raw
Furosemide cont infL Pharm Flowsheet tablePharmnumberintegerfurosemide cont inf contains manually collected doses of furosemide cont inf that were given.1 January 19001 January 2100Raw
GCS sedated fieldL Log tableApachebooleannot enteredThe GCS sedated field is a checkbox used together with the Glasgow Coma Scale; if the patient is sedated when the GCS is assessed, this box is checked.22 September 20161 January 2100Raw
H2-BlockersL Pharm Flowsheet tablePharmnumberintegerH2-Blockers contains manually collected doses of H2-Blockers that were given.1 January 19001 January 2100Raw
HCTL Log tableApachenumbersingleThe patient's hematocrit level in percentage.1 January 19001 January 2100Raw
HRL Log tableApachenumbersingleThe patient's Heart Rate level in beats/min.1 January 19001 January 2100Raw
Heparin SQL Pharm Flowsheet tablePharmnumberintegerHeparin SQ contains manually collected doses of Heparin SQ that were given.1 January 19001 January 2100Raw
ICD10 codeL ICD10 table
S ICD10 table		ICD10string10The actual ICD10 code.1 January 19001 January 2100Raw
Insulin cont infL Pharm Flowsheet tablePharmnumberintegerinsulin cont inf contains manually collected doses of insulin cont inf that were given.1 January 19001 January 2100Raw
KL Log tableApachenumbersingleThe patient's Potassium level in mmol/L.1 January 19001 January 2100Raw
L ICD10 IDL ICD10 tableICD10numberlongUnique identifier of the L_ICD10 table1 January 19001 January 2100Raw
LMWHL Pharm Flowsheet tablePharmnumberintegerLMWH contains manually collected doses of LMWH that were given.1 January 19001 January 2100Raw
Labs CompleteL Log tableTop Rowbooleannot enteredTrue when patient Labs data is complete1 January 200031 December 2100Raw
LastChanged DtTm fieldL Log tablenot stateddatenot enteredLast time the record was changed.1 January 201631 December 2100Raw
LastName fieldL Log table
L PHI table		Top Rowstring40Last Name of patient1 January 19001 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.1 January 201631 December 2100Raw
MRI (labs)L Labs Flowsheet tableLabintegerintegerMRI contains the manually counted number of MRIs done during a patient's stay in our unit.1 January 190031 December 2018Raw
Magnesium (labs)L Labs Flowsheet tableLabintegerintegerMagnesium contains the number of magnesiums done during a patient's stay in our unit.1 January 190031 December 2018Raw
Mean BPCreated variables CC tableApachenumbersingleMean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3)1 January 19001 January 2100Created
NaL Log tableApachenumbersingleThe patient's Sodium level in mmol/L.1 January 19001 January 2100Raw
Notes fieldL Log tableTop Rowmemonot enteredUsed by data collectors to keep notes during collection.1 January 19001 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.1 January 19001 January 2100Raw
Off ward fieldL Log tableDisponumberlong integerChecked/true if the patient who meets the Definition of a Medicine Service admission or Definition of an ICU 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 20161 January 2100Raw
Opioids cont infL Pharm Flowsheet tablePharmnumberintegeropioids cont inf contains manually collected doses of opioids cont inf that were given.1 January 19001 January 2100Raw
PCO2L Log tableApachenumbersinglePCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L.1 January 19001 January 2100Raw
PHL Log tableApachenumbersingleThe acidity or basicity of the patient's arterial blood.1 January 19001 January 2100Raw
PHIN fieldL Log table
L PHI table		Top RownumberLong IntegerThe patient's PHIN .1 January 19001 January 2100Raw
PO2L Log tableApachenumbersinglePO2 is the partial pressure of oxygen in the patient's arterial blood.1 January 19001 January 2100Raw
PPIL Pharm Flowsheet tablePharmnumberintegerPPI contains manually collected doses of PPI that were given.1 January 19001 January 2100Raw
PT PTTL Labs Flowsheet tableLabintegerintegerPT_PTT contains the number of PTs and PTTs done during a patient's stay in our unit.1 January 19001 January 2100Raw
Packed cellsL Labs Flowsheet tableLabintegerintegerPacked cells contains doses of packed cells that were given.1 January 190031 December 2018Raw
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		PharmnumberLong IntegerThe Pat_ID field contains a unique-per-location identifying number per patient ward admission. See Serial number.1 January 19001 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.1 January 19001 January 2100Created
Pharm 1st or 2nd generation cephalosporinsL Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
Pharm 4th generation cephalosporinsL Log tablePharmbooleannot enteredTrue if drug in field name was given1 January 20121 January 2100Raw
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 Flow CompleteL Log tableTop Rowbooleannot enteredUnused field1 January 200031 December 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 20121 January 2100Raw
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 20121 January 2100Raw
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 20121 January 2100Raw
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.1 January 190031 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 (except #Bed Borrows) 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 20161 January 2100Raw
Propofol cont infL Pharm Flowsheet tablePharmnumberintegerpropofol cont inf contains manually collected doses of propofol cont inf that were given.1 January 19001 January 2100Raw
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.1 January 19001 January 2100Raw
Px CountL CCI Component table
L CCI Picklist table		CCIdatenot enteredThe type of a CCI procedure (comorbid, admit or acquired)1 January 19001 January 2100Raw
Px DateL CCI Component table
L CCI Picklist table		CCIdatenot enteredThe date/time of a CCI procedure1 January 19001 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 acquired1 January 19001 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).1 January 19001 January 2100Raw
RRL Log tableApachenumbersingleThe patient's respiratory rate level in breaths/min.1 January 19001 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
Room nrL Log tablenot statedstring15Legacy element that was never used consistently.1 January 190031 December 2100Raw
S dispo.loc typeS dispo tablestring20 1 July 20161 January 2100Raw
S dispo.service typeS dispo tablestring10 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.1 January 19001 January 2100Raw
SentDtTm fieldL Log tablenot stateddatenot enteredTime the record was last sent.1 January 19001 January 2100Raw
Serum CO2L Log tableApachenumbersingleThe patient's Serum CO2 level in mmol/L.1 January 19001 January 2100Raw
Service/Location fieldL Log tableDisponumberlong integerCollection location a patient is admitted to.1 July 20161 January 2100Raw
Sex fieldL Log tableDispostring7Biological sex of the patient at birth; options are "male" and "female".1 January 19001 January 2100Raw
Spare1L Pharm Flowsheet tablePharmnumberintegerspare1 contains manually collected doses of spare1 that were given.1 January 19001 January 2100Raw
Spare2L Pharm Flowsheet tablePharmnumberintegerspare2 contains manually collected doses of spare2 that were given.1 January 19001 January 2100Raw
Spare3L Pharm Flowsheet tablePharmnumberintegerspare3 contains manually collected doses of spare3 that were given.1 January 19001 January 2100Raw
Spare4L Pharm Flowsheet tablePharmnumberintegerspare4 contains manually collected doses of spare4 that were given.1 January 19001 January 2100Raw
Spare5L Pharm Flowsheet tablePharmnumberintegerspare5 contains manually collected doses of spare5 that were given.1 January 19001 January 2100Raw
Spare6L Pharm Flowsheet tablePharmnumberintegerspare6 contains manually collected doses of spare6 that were given.1 January 19001 January 2100Raw
Sputum C+SL Labs Flowsheet tableLabintegerintegerContains the number of any sputum specimens (including endotracheal secretions) sent for "culture and sensitivity" for bacteria or fungus.1 January 19001 January 2100Raw
Start Date fieldL Log tablenot stateddatenot enteredDate the record was created on the data collector's laptop; created automatically by CCMDB.mdb.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.mdb.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 20161 January 2100Raw
TemperatureL Log tableApachenumbersingleThe patient's Temperature level in °C.1 January 19001 January 2100Raw
TigecylineL Pharm Flowsheet tablePharmnumberintegertigecyline contains manually collected doses of tigecyline that were given.1 January 19001 January 2100Raw
Tmp CompleteL Log tableTop Rowbooleannot enteredTrue when patient Tmp data is complete1 January 200031 December 2100Raw
Transfer DelayCreated variables commonnot statednumbersingleTransfer Delay is the difference between Dispo_DtTm and Transfer_Ready_DtTm in decimal days.15 January 19991 January 2100Created
Transfer Ready DtTm fieldL Log tableDispodatenot enteredDate and time the intent to discharge a patient to a lower level in the #hierarchy of levels of care was documented.1 July 20161 January 2100Raw
TroponinL Labs Flowsheet tableLabintegerintegerTroponincontains the number of troponins done during a patient's stay in our unit.1 January 19001 January 2100Raw
Urine CSL Labs Flowsheet tableLabintegerintegerUrine_CS contains the number of any urine specimens sent for "culture and sensitivity" for bacteria or fungus.1 January 19001 January 2100Raw
Vanco alternativesL Pharm Flowsheet tablePharmnumberintegervanco alternatives contains manually collected doses of vanco alternatives that were given.1 January 19001 January 2100Raw
VancomycinL Pharm Flowsheet tablePharmnumberintegervancomycin contains manually collected doses of vancomycin that were given.1 January 19001 January 2100Raw
Venous blood gas (labs)L Labs Flowsheet tableLabintegerlongVBG contains manually collected venous blood gas counts.1 January 190031 December 2018Raw
Visit Admit DtTm fieldL Log tableDispodatenot enteredThe Visit Admit DtTm field contains the first entry in the visit location history in EPR for current visit at a hospital site.1 January 20031 January 2100Raw
VoluvenL Labs Flowsheet tableLabintegerintegerVoluven contains the number of doses or Voluven that were given while in the unit.1 January 190012 June 2014Raw
WBCL Log tableApachenumbersingleThe patient's White Blood Count level in x109/L.1 January 19001 January 2100Raw
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Auto_Data_Dictionary&oldid=135389"