Collector dictionary

From CCMDB Wiki
Jump to navigation Jump to search

This page provides links to various collection elements in the Medicine and ICU database.

Registry

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

Show   
 DescriptionStart dateEnd date
LastName fieldLast Name of patient11 July 19881 January 2100
FirstName fieldLast Name of patient11 July 19881 January 2100
PHIN fieldThe patient's PHIN .11 July 19881 January 2100
Date of BirthDate of Birth (DOB) is the data a patient was born.11 July 19881 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.11 July 19881 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.11 July 19881 January 2100
Sex fieldBiological sex of the patient at birth; options are "male" and "female".11 July 19881 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 (with #exceptions) of a patient before arriving at the collection location.1 July 20161 January 2100
Service/Location fieldLegacy field replaced by Boarding Loc and Service tmp entry1 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

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.11 July 19881 January 2100
Sex fieldBiological sex of the patient at birth; options are "male" and "female".11 July 19881 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 (with #exceptions) of a patient before arriving at the collection location.1 July 20161 January 2100
Service/Location fieldLegacy field replaced by Boarding Loc and Service tmp entry1 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 fieldThis 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 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

APACHE

Apache has physiological components and diagnostic components.

Show   
 DescriptionStart dateEnd date
Admit Type for APACHE IIThe 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 2100
TemperatureThe patient's Temperature level in °C.11 July 19881 January 2100
AP Sys BP FieldAp_SysBP is the systolic blood pressure.11 July 19881 January 2100
AP Dias BP FieldAp_DiasBP is the diastolic blood pressure.11 July 19881 January 2100
HRThe patient's Heart Rate level in beats/min.11 July 19881 January 2100
RRThe patient's respiratory rate level in breaths/min.11 July 19881 January 2100
AP Eye fieldThe eye component of the Glasgow_Coma_Scale.11 July 19881 January 2100
AP Motor fieldThe motor component of the Glasgow_Coma_Scale.11 July 19881 January 2100
AP Verbal fieldThe verbal component of the Glasgow_Coma_Scale.11 July 19881 January 2100
FiO2FIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient.11 July 19881 January 2100
PO2PO2 is the partial pressure of oxygen in the patient's arterial blood.11 July 19881 January 2100
PCO2PCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L.11 July 19881 January 2100
PHThe acidity or basicity of the patient's arterial blood.11 July 19881 January 2100
Serum CO2The patient's Serum CO2 level in mmol/L.11 July 19881 January 2100
NaThe patient's Sodium level in mmol/L.11 July 19881 January 2100
KThe patient's Potassium level in mmol/L.11 July 19881 January 2100
HCTThe patient's hematocrit level in percentage.11 July 19881 January 2100
WBCThe patient's White Blood Count level in x109/L.11 July 19881 January 2100
Creatinine (APACHE)The patient's level in .11 July 19881 January 2100
ARF (APACHE)The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.11 July 19881 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 October 20031 January 2100
ADL DressingNeed for help with dressing; component of ADL.1 October 20031 January 2100
ADL ToilettingNeed for help with toiletting; component of ADL1 October 20031 January 2100
ADL TransferingNeed for help with transferring; component of ADL1 October 20031 January 2100
ADL ContinenceControl of urination and bowel movements; component of ADL1 October 20031 January 2100
ADL FeedingNeed for help with feeding; component of ADL1 October 20031 January 2100

Diagnoses

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

Show   
 DescriptionStart dateEnd date
Pat ID fieldThe Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number.11 July 19881 January 2100
D ID fieldThe unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100
L ICD10 IDUnique identifier of the L_ICD10 table11 July 19881 January 2100
ICD10 codeThe actual ICD10 code.11 July 19881 January 2100
Dx DateThe date/time of an ICD10 diagnosis.11 July 19881 January 2100
Dx Date unknownTrue for Acquired Diagnosis / Complication when Dx Date legitimately missing.11 July 19881 January 2100
Dx TypeThe type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication)11 July 19881 January 2100
Dx PriorityThe priority of an ICD10 diagnosis, used to rank and group.11 July 19881 January 2100
Dx PrimaryCheckbox that is set to true for a single Admit Diagnosis per ward stay that is the Primary Admit Diagnosis11 July 19881 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-laptop identifying number for patient ward admissions. See Serial number.11 July 19881 January 2100
D ID fieldThe unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100
Px DateThe date/time of a CCI procedure11 July 19881 January 2100
CCI Picklist CodeThe CCI code for and entry in the L CCI Picklist subform, from s_CCI_Picklist table.1 January 20191 January 2100
Px CountThe type of a CCI procedure (comorbid, admit or acquired)11 July 19881 January 2100
Px TypeThe type of a CCI Procedure as per CCI Collection, ie admit or acquired11 July 19881 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-laptop identifying number for patient ward admissions. See Serial number.11 July 19881 January 2100
D ID fieldThe unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100
Px DateThe date/time of a CCI procedure11 July 19881 January 2100
Px CountThe type of a CCI procedure (comorbid, admit or acquired)11 July 19881 January 2100
Px TypeThe type of a CCI Procedure as per CCI Collection, ie admit or acquired11 July 19881 January 2100

Pharmacy

Show   
 DescriptionStart dateEnd date
Pat ID fieldThe Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number.11 July 19881 January 2100
D ID fieldThe unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100
Azolesazoles contains manually collected doses of azoles that were given.11 July 19881 January 2100
Funginsfungins contains manually collected doses of fungins that were given.11 July 19881 January 2100
Antipseudomonalsantipseudomonals contains manually collected doses of antipseudomonals that were given.11 July 19881 January 2100
Vancomycinvancomycin contains manually collected doses of vancomycin that were given.11 July 19881 January 2100
Fluoroquinolonesfluoroquinolones contains manually collected doses of fluoroquinolones that were given.11 July 19881 January 2100
Carbapenemscarbapenems contains manually collected doses of carbapenems that were given.11 July 19881 January 2100
Vanco alternativesvanco alternatives contains manually collected doses of vanco alternatives that were given.11 July 19881 January 2100

TISS28

See TISS Item List 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: