Collector dictionary

From CCMDB Wiki
Jump to navigationJump to search

Registry

In the collection tool CCMDB.mdb the registry data is all in the L_Log table.

Show   
 DescriptionStart dateEnd date
LastName fieldLast Name of patient1 January 19001 January 2100
FirstName fieldLast Name of patient1 January 19001 January 2100
PHIN fieldThe patient's PHIN .1 January 19001 January 2100
Date of BirthDate of Birth (DOB) is the data a patient was born.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
DC Treatment"DC" for critical care patients if life-support treatment is terminated, blank for all others.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
Sex fieldBiological sex of the patient at birth; options are "male" and "female".1 January 19001 January 2100
Postal Code fieldThe patient's postal code.1 January 20121 January 2100
Pre acute living situation fieldInfo about the living situation of the patient prior to the current hospitalization.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
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
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

ADT - via EPR

Admission, discharge and transfer data

Show   
 DescriptionStart dateEnd date
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
Sex fieldBiological sex of the patient at birth; options are "male" and "female".1 January 19001 January 2100
R Filter FieldCritical care patients on a long term ventilator (LTV).1 January 19001 January 2100
Postal Code fieldThe patient's postal code.1 January 20121 January 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
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

APACHE

Apache has physiological components and diagnostic components.

Show   
 DescriptionStart dateEnd date
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 Verbal fieldThe verbal 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 Eye fieldThe eye 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

ADLs - Activities of Daily Living

Collected according to ADL General Collection Information.

Show   
 DescriptionStart dateEnd date
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

Diagnoses

This stores our version of ICD10 (see ICD10 Diagnosis List), collected following the ICD10 collection instructions.

Show   
 DescriptionStart dateEnd date
ICD10 codeThe actual ICD10 code.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
D ID fieldThe unique identifier/index of records in the Critical Care and Medicine Database.1 January 19001 January 2100
L ICD10 IDUnique identifier of the L_ICD10 table1 January 19001 January 2100
Dx DateThe date/time of an ICD10 diagnosis.1 January 19001 January 2100
Dx Date unknownTrue for Acquired Diagnosis / Complication when Dx Date legitimately missing.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
Dx PriorityThe priority of an ICD10 diagnosis, used to rank and group.1 January 19001 January 2100
Dx PrimaryTrue for the Admit Diagnosis that is the Primary Admit Diagnosis1 January 19001 January 2100

Procedures

This stores our version of CCI, collected following the CCI Collection instructions.

CCI Picklist

Show   
 DescriptionStart dateEnd date
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
D ID fieldThe unique identifier/index of records in the Critical Care and Medicine Database.1 January 19001 January 2100
Px DateThe date/time of a CCI procedure1 January 19001 January 2100
Px CountThe type of a CCI procedure (comorbid, admit or acquired)1 January 19001 January 2100
Px TypeThe type of a CCI Procedure as per CCI Collection, ie admit or acquired1 January 19001 January 2100

CCI Component

See CCI component 1 codes - what organ was something done to, CCI component 2 codes - what was done for possible values.

Show   
 DescriptionStart dateEnd date
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
D ID fieldThe unique identifier/index of records in the Critical Care and Medicine Database.1 January 19001 January 2100
Px DateThe date/time of a CCI procedure1 January 19001 January 2100
Px CountThe type of a CCI procedure (comorbid, admit or acquired)1 January 19001 January 2100
Px TypeThe type of a CCI Procedure as per CCI Collection, ie admit or acquired1 January 19001 January 2100

Pharmacy

Show   
 DescriptionStart dateEnd date
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
D ID fieldThe unique identifier/index of records in the Critical Care and Medicine Database.1 January 19001 January 2100
PPIPPI contains manually collected doses of PPI that were given.1 January 19001 January 2100
H2-BlockersH2-Blockers contains manually collected doses of H2-Blockers that were given.1 January 19001 January 2100
Heparin SQHeparin SQ contains manually collected doses of Heparin SQ that were given.1 January 19001 January 2100
LMWHLMWH contains manually collected doses of LMWH that were given.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
Opioids cont infopioids cont inf contains manually collected doses of opioids cont inf that were given.1 January 19001 January 2100
Propofol cont infpropofol cont inf contains manually collected doses of propofol cont inf that were given.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
Furosemide cont inffurosemide cont inf contains manually collected doses of furosemide cont inf that were given.1 January 19001 January 2100
Azolesazoles contains manually collected doses of azoles that were given.1 January 19001 January 2100
Funginsfungins contains manually collected doses of fungins that were given.1 January 19001 January 2100
Antipseudomonalsantipseudomonals contains manually collected doses of antipseudomonals that were given.1 January 19001 January 2100
Vancomycinvancomycin contains manually collected doses of vancomycin that were given.1 January 19001 January 2100
Fluoroquinolonesfluoroquinolones contains manually collected doses of fluoroquinolones that were given.1 January 19001 January 2100
Carbapenemscarbapenems contains manually collected doses of carbapenems that were given.1 January 19001 January 2100
Vanco alternativesvanco alternatives contains manually collected doses of vanco alternatives that were given.1 January 19001 January 2100
3rd generation cephalosporins3rd generation cephalosporins contains manually collected doses of 3rd generation cephalosporins that were given.1 January 19001 January 2100
Ceftazidimeceftazidime contains manually collected doses of ceftazidime that were given.1 January 19001 January 2100
Tigecylinetigecyline contains manually collected doses of tigecyline that were given.1 January 19001 January 2100
Spare1spare1 contains manually collected doses of spare1 that were given.1 January 19001 January 2100
Spare2spare2 contains manually collected doses of spare2 that were given.1 January 19001 January 2100
Spare3spare3 contains manually collected doses of spare3 that were given.1 January 19001 January 2100
Spare4spare4 contains manually collected doses of spare4 that were given.1 January 19001 January 2100
Spare5spare5 contains manually collected doses of spare5 that were given.1 January 19001 January 2100
Spare6spare6 contains manually collected doses of spare6 that were given.1 January 19001 January 2100

TISS28

See TISS Items SMW for a list of elements we collect as part of TISS.

Temporary project data

See Projects for a list of current and past projects.

Related articles

Related articles: