Template:CollectorDictionaryQuery

From CCMDB Wiki
Jump to navigationJump to search

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   
 DescriptionStart dateEnd date
D ID fieldThe unique identifier/index of records in the Critical Care and Medicine Database.1 January 19001 January 2100
Pat ID fieldThe Pat_ID field contains a unique-per-location identifying number per patient ward admission. See Serial number.1 January 19001 January 2100
Person ID fieldUnique random number id per patient that combines the D_IDs across admissions/encounters.1 January 19001 January 2100
L ICD10 IDUnique identifier of the L_ICD10 table1 January 19001 January 2100
ICD10 codeThe actual ICD10 code.1 January 19001 January 2100
LastName fieldLast Name of patient1 January 19001 January 2100
AgeThe 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 2100
FirstName fieldLast Name of patient1 January 19001 January 2100
CCI 1 CodeThe unique identifier/index of CCI Procedure's first component in s_CCI_1 table.1 January 19001 January 2100
PHIN fieldThe patient's PHIN .1 January 19001 January 2100
CBCCBC contains the number of CBCs done during a patient's stay in our unit.1 January 190031 December 2018
PPIPPI contains manually collected doses of PPI that were given.1 January 19001 January 2100
Px DateThe date/time of a CCI procedure1 January 19001 January 2100
Dx DateThe date/time of an ICD10 diagnosis.1 January 19001 January 2100
CCI 2 CodeThe unique identifier/index of CCI Procedure's second component in s_CCI_2 table.1 January 19001 January 2100
CCI Picklist CodeThe CCI code for and entry in the L CCI Picklist subform, from s_CCI_Picklist table.1 January 19001 January 2100
Date of BirthDate of Birth (DOB) is the data a patient was born.1 January 19001 January 2100
PT PTTPT_PTT contains the number of PTs and PTTs done during a patient's stay in our unit.1 January 19001 January 2100
H2-BlockersH2-Blockers contains manually collected doses of H2-Blockers that were given.1 January 19001 January 2100
Dx Date unknownTrue for Acquired Diagnosis / Complication when Dx Date legitimately missing.1 January 19001 January 2100
Px CountThe type of a CCI procedure (comorbid, admit or acquired)1 January 19001 January 2100
Chart numberThe 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 2100
Heparin SQHeparin SQ contains manually collected doses of Heparin SQ that were given.1 January 19001 January 2100
SentDtTm fieldTime the record was last sent.1 January 19001 January 2100
Dx TypeThe type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication)1 January 19001 January 2100
Transfer DelayTransfer Delay is the difference between Dispo_DtTm and Transfer_Ready_DtTm in decimal days.15 January 19991 January 2100
FFPFresh Frozen Plasma / FFP contains manually collected doses of FFP that were given.1 January 190031 December 2018
LMWHLMWH contains manually collected doses of LMWH that were given.1 January 19001 January 2100
Start Date fieldDate the record was created on the data collector's laptop; created automatically by CCMDB.mdb.25 February 20111 January 2100
Dx PriorityThe priority of an ICD10 diagnosis, used to rank and group.1 January 19001 January 2100
PlateletsPlatelets contains number of doses of platelets that were given.1 January 190031 December 2018
ER DelayThe ER Delay is the difference between the Accept DtTm and Arrive_DtTm for patients arriving from the ER.1 January 19001 January 2100
Benzodiazepines cont infbenzodiazepines cont inf contains manually collected doses of benzodiazepines cont inf that were given.1 January 19001 January 2100
Start Time fieldTime the record was created on the data collector's laptop; created automatically by CCMDB.mdb.25 February 20111 January 2100
S dispo.loc type 1 July 20161 January 2100
Dx PrimaryTrue for the Admit Diagnosis that is the Primary Admit Diagnosis1 January 19001 January 2100
Notes fieldUsed by data collectors to keep notes during collection.1 January 19001 January 2100
Albumin 25pctAlbumin_25pct contains number of doses of 25% Albumin that were given.1 January 190031 December 2018
Opioids cont infopioids cont inf contains manually collected doses of opioids cont inf that were given.1 January 19001 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.1 January 19001 January 2100
Albumin 5pctAlbumin_5pct contains the number of doses of 5% Albumin that were given.1 January 190031 December 2018
Propofol cont infpropofol cont inf contains manually collected doses of propofol cont inf that were given.1 January 19001 January 2100
FinalCheck fieldLegacy; used to be checked when all data is complete, now see RecordStatus field.1 January 190024 May 2013
Px TypeThe type of a CCI Procedure as per CCI Collection, ie admit or acquired1 January 19001 January 2100
Creatinine (labs)Creatinine contains the number of creatinines done during a patient's stay in our unit.1 January 19001 January 2100
Insulin cont infinsulin cont inf contains manually collected doses of insulin cont inf that were given.1 January 19001 January 2100
DC Treatment"DC" for critical care patients if life-support treatment is terminated, blank for all others.1 January 19001 January 2100
Magnesium (labs)Magnesium contains the number of magnesiums done during a patient's stay in our unit.1 January 190031 December 2018
Furosemide cont inffurosemide cont inf contains manually collected doses of furosemide cont inf that were given.1 January 19001 January 2100
Mean BPMean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3)1 January 19001 January 2100
SGPT ALT (labs)SGPT_ALT contains the number of SGPTs and ALTs done during a patient's stay in our unit.1 January 19001 January 2100
Azolesazoles contains manually collected doses of azoles that were given.1 January 19001 January 2100
TroponinTroponincontains the number of troponins done during a patient's stay in our unit.1 January 19001 January 2100
Funginsfungins contains manually collected doses of fungins that were given.1 January 19001 January 2100
CXRChest Xrays (CXR) contains the manually counted number of chest xrays (CXR) done during a patient's stay in our unit.1 January 190031 December 2018
Antipseudomonalsantipseudomonals contains manually collected doses of antipseudomonals that were given.1 January 19001 January 2100
Province fieldProvince 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 2100
CT Scan (labs)CT_Scan contains the manually counted number of CT scans done during a patient's stay in our unit.1 January 190031 December 2018
Vancomycinvancomycin contains manually collected doses of vancomycin that were given.1 January 19001 January 2100
Sex fieldBiological sex of the patient at birth; options are "male" and "female".1 January 19001 January 2100
Angio coronary fieldAngio 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 2017
Fluoroquinolonesfluoroquinolones contains manually collected doses of fluoroquinolones that were given.1 January 19001 January 2100
Angio others fieldAngio_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 2017
Carbapenemscarbapenems contains manually collected doses of carbapenems that were given.1 January 19001 January 2100
Registry Patient TypeService of the attending physician for medicine data, and the type of admit diagnosis for critical care patients.1 April 19979 May 2018
EchocardiogramContains the number of heart ultrasounds (echocardiograms) a client has had during an admission to our unit.1 January 190031 December 2018
Vanco alternativesvanco alternatives contains manually collected doses of vanco alternatives that were given.1 January 19001 January 2100
Abdominal ultrasoundContains the number of abdominal ultrasounds a client has had during an admission to our unit.1 January 190031 December 2018
3rd generation cephalosporins3rd generation cephalosporins contains manually collected doses of 3rd generation cephalosporins that were given.1 January 19001 January 2100
Sputum C+SContains the number of any sputum specimens (including endotracheal secretions) sent for "culture and sensitivity" for bacteria or fungus.1 January 19001 January 2100
Ceftazidimeceftazidime contains manually collected doses of ceftazidime that were given.1 January 19001 January 2100
Blood cultureContains the number of blood cultures a patient has had during an admission to our unit.1 January 19001 January 2100
Tigecylinetigecyline contains manually collected doses of tigecyline that were given.1 January 19001 January 2100
Urine CSUrine_CS contains the number of any urine specimens sent for "culture and sensitivity" for bacteria or fungus.1 January 19001 January 2100
Spare1spare1 contains manually collected doses of spare1 that were given.1 January 19001 January 2100
Arterial blood gas (labs)ABG contains manually collected arterial blood gas counts.1 January 190031 December 2018
Spare2spare2 contains manually collected doses of spare2 that were given.1 January 19001 January 2100
S dispo.service type 1 July 20161 January 2100
Spare3spare3 contains manually collected doses of spare3 that were given.1 January 19001 January 2100
Venous blood gas (labs)VBG contains manually collected venous blood gas counts.1 January 190031 December 2018
R Filter FieldCritical care patients on a long term ventilator (LTV).1 January 19001 January 2100
PentaspanPentaspan contains the number of doses or Pentaspan that were given while in the unit.12 June 2014
Spare4spare4 contains manually collected doses of spare4 that were given.1 January 19001 January 2100
MRI (labs)MRI contains the manually counted number of MRIs done during a patient's stay in our unit.1 January 190031 December 2018
Spare5spare5 contains manually collected doses of spare5 that were given.1 January 19001 January 2100
VoluvenVoluven contains the number of doses or Voluven that were given while in the unit.1 January 190012 June 2014
Spare6spare6 contains manually collected doses of spare6 that were given.1 January 19001 January 2100
Postal Code fieldThe patient's postal code.1 January 20121 January 2100
AaDO2The patient's Potassium level in mmol/L.1 January 19001 January 2100
LastOpened DtTm fieldDate/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 2100
Pre acute living situation fieldInfo about the living situation of the patient prior to the current hospitalization.1 July 20161 January 2100
Pre-admit Inpatient Institution fieldThe 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 2100
Previous Location fieldThe most recent previous physical location (except #Bed Borrows) of a patient before arriving at the collection location.1 July 20161 January 2100
Previous Service fieldThe most recent "originating service" which sends the patients to their current service location.1 July 20161 January 2100
Off ward fieldChecked/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 2100
Service/Location fieldCollection location a patient is admitted to.1 July 20161 January 2100
Dispo fieldThe Dispo field contains information about what happens to the patient at the end of their admission.1 July 20161 January 2100
Visit Admit DtTm fieldThe 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 2100
Accept DtTm fieldThe date and time when the patient is accepted from the ER department ONLY.1 July 20161 January 2100
Accept DtTm missing fieldcheckbox is checked/true when no Accept DtTm is documented for a patient who came from from the ER.1 July 20161 January 2100
Arrive DtTm fieldDate and time when the patient physically arrived on unit.1 July 20161 January 2100
Dispo DtTm fieldDate and time when the patient changed status from what is documented in Service/Location field to Dispo field..1 July 20161 January 2100
Transfer Ready DtTm fieldDate 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 2100
TR info status fieldCross-check field that will contain data if Transfer_Ready_DtTm field is empty5 May 20161 January 2100
ADL BathingNeed for help with bathing; component of ADL.1 January 19001 January 2100
ADL DressingNeed for help with dressing; component of ADL.1 January 19001 January 2100
ADL ToilettingNeed for help with toiletting; component of ADL1 January 19001 January 2100
ADL TransferingNeed for help with transferring; component of ADL1 January 19001 January 2100
ADL ContinenceControl of urination and bowel movements; component of ADL1 January 19001 January 2100
ADL FeedingNeed for help with feeding; component of ADL1 January 19001 January 2100
Admit Type for APACHE IIAdmit type for APACHE1 January 19001 January 2100
Chronic Health APACHESpecific chronic pre-existing conditions used for APACHE score.1 January 19001 January 2100
TemperatureThe patient's Temperature level in °C.1 January 19001 January 2100
AP Sys BP FieldAp_SysBP is the systolic blood pressure.1 January 19001 January 2100
AP Dias BP FieldAp_DiasBP is the diastolic blood pressure.1 January 19001 January 2100
HRThe patient's Heart Rate level in beats/min.1 January 19001 January 2100
RRThe patient's respiratory rate level in breaths/min.1 January 19001 January 2100
AP Eye fieldThe eye component of the Glasgow_Coma_Scale.1 January 19001 January 2100
AP Motor fieldThe motor component of the Glasgow_Coma_Scale.1 January 19001 January 2100
AP Verbal fieldThe verbal component of the Glasgow_Coma_Scale.1 January 19001 January 2100
FiO2FIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient.1 January 19001 January 2100
GCS sedated fieldThe 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 2100
PO2PO2 is the partial pressure of oxygen in the patient's arterial blood.1 January 19001 January 2100
PCO2PCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L.1 January 19001 January 2100
PHThe acidity or basicity of the patient's arterial blood.1 January 19001 January 2100
Serum CO2The patient's Serum CO2 level in mmol/L.1 January 19001 January 2100
NaThe patient's Sodium level in mmol/L.1 January 19001 January 2100
KThe patient's Potassium level in mmol/L.1 January 19001 January 2100
HCTThe patient's hematocrit level in percentage.1 January 19001 January 2100
WBCThe patient's White Blood Count level in x109/L.1 January 19001 January 2100
Creatinine (APACHE)The patient's level in .1 January 19001 January 2100
ARF (APACHE)The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.1 January 19001 January 2100
R Completetrue when patient registry data is complete1 January 200031 December 2100
ADL Completetrue when patient ADL data is complete1 January 200031 December 2100
RecordStatus fieldstatus of the data in the record. Possible values are complete, sent, questioned and vetted.24 April 20131 January 2100
Ap CompleteTrue when patient APACH II data is complete1 January 200031 December 2100
ApLab CompleteTrue when patient APACHE II lab data is complete1 January 200031 December 2016
Labs CompleteTrue when patient Labs data is complete1 January 200031 December 2100
Tmp CompleteTrue when patient Tmp data is complete1 January 200031 December 2100
Como CompleteTrue when patient comorbid diagnosis data is complete1 January 200031 December 2100
Diag CompleteTrue when patient diagnosis data is complete1 January 200031 December 2100
Pharm CompleteTrue when patient pharmacy diagnosis data is complete1 January 200031 December 2100
Pharm Flow CompleteUnused field1 January 200031 December 2100
RecordFree choice use by collectors to help collection, this field has no consistent meaning.1 January 190031 December 2100
Room nrLegacy element that was never used consistently.1 January 190031 December 2100
LastChanged DtTm fieldLast time the record was changed.1 January 201631 December 2100
Pharm Vitamin K antagonists fieldTrue if drug in field name was given1 January 20121 January 2100
Pharm Heparin cont infTrue if a continuous infusion of Heparin was given1 January 20121 January 2100
Pharm Direct thrombin inhibitorsTrue if drug in field name was given1 January 20121 January 2100
Pharm HeparinoidsTrue if drug in field name was given1 January 20121 January 2100
Pharm Factor Xa inhibitorsTrue if drug in field name was given1 January 20121 January 2100
Pharm Dopamine cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Dobutamine cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Norepinephrine cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Epinephrine cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Phenylephrine cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Vasopressin cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Milrinone cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Paralytics cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm corticosteroidsTrue if drug in field name was given1 January 20121 January 2100
Pharm amphotericin BTrue if drug in field name was given1 January 20121 January 2100
Pharm macrolidesTrue if drug in field name was given1 January 20121 January 2100
Pharm 1st or 2nd generation cephalosporinsTrue if drug in field name was given1 January 20121 January 2100
Pharm 4th generation cephalosporinsTrue if drug in field name was given1 January 20121 January 2100
Pharm antistaph penicillinsTrue if drug in field name was given1 January 20121 January 2100
Pharm aminoglycosidesTrue if drug in field name was given1 January 20121 January 2100
Pharm influenza drugsTrue if influenza drugs were given1 January 20121 January 2100
Pharm bosentanTrue if drug in field name was given1 January 20121 January 2100
Pharm viagra-type vasodilatorsTrue if drug in field name was given1 January 20121 January 2100
Pharm special upper GI bleeding agentsTrue if drug in field name was given1 January 20121 January 2100
Pharm amiodaronesTrue if drug in field name was given1 January 20121 January 2100
Pharm anti-TB drugsTrue if drug in field name was given1 January 20121 January 2100
Pharm statinsTrue if drug in field name was given1 January 20121 January 2100
Pharm PPITrue if drug in field name was given1 January 20121 January 2100
Pharm H2 blockersTrue if drug in field name was given1 January 20121 January 2100
Pharm furosemideTrue if drug in field name was given1 January 20121 January 2100
Pharm heparin sqTrue if drug in field name was given1 January 20121 January 2100
Pharm LMWHTrue if drug in field name was given1 January 20121 January 2100
Pharm benzodiazepinesTrue if drug in field name was given1 January 20121 January 2100
Pharm opioidsTrue if drug in field name was given1 January 20121 January 2100
Pharm propofolTrue if drug in field name was given1 January 20121 January 2100
Pharm insulinTrue if drug in field name was given1 January 20121 January 2100