Search by property

This page provides a simple browsing interface for finding entities described by a property and a named value. Other available search interfaces include the page property search, and the ask query builder.

List of results

• Off ward field  + (Checked/true if the patient who meets the … Checked/true if the patient who meets the [[Definition of a Medicine Laptop Admission]] or [[Definition of a Critical Care Laptop 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. credited with the "off ward" designation.)
• CXR  + (Chest Xrays (CXR) contains the manually counted number of chest xrays (CXR) done during a patient's stay in our unit.)
• Abdominal ultrasound  + (Contains the number of '''abdominal ultrasounds''' a client has had during an admission to our unit.)
• Sputum C+S  + (Contains the number of any sputum specimens (including endotracheal secretions) sent for "culture and sensitivity" for bacteria or fungus.)
• Blood culture  + (Contains the number of blood cultures a patient has had during an admission to our unit.)
• Echocardiogram  + (Contains the number of heart ultrasounds (echocardiograms) a client has had during an admission to our unit.)
• ADL Continence  + (Control of urination and bowel movements; component of [[ADL]])
• Creatinine (labs)  + (Creatinine contains the number of creatinines done during a patient's stay in our unit.)
• R Filter Field  + (Critical care patients on a long term ventilator ([[LTV]]).)
• TR info status field  + (Cross-check field that will contain data if [[Transfer_Ready_DtTm field]] is empty)
• Transfer Ready DtTm field  + (Date and time the '''intent to discharge''' a patient to a lower level in the [[Level of care hierarchy]] was documented.)
• Dispo DtTm field  + (Date and time when the patient changed status from what is documented in [[Service/Location field]] to [[Dispo field]]..)

• Date of Birth  + (Date of Birth (DOB) is the data a patient was born.)

• Start Date field  + (Date the record was created on the data collector's laptop; created automatically by [[CCMDB.accdb]].)
• LastOpened DtTm field  + (Date/Time the record was last closed with the "Close - with updates" button. This will usually be the last time the collector updated the record.)
• FiO2  + (FIO2 is the '''fraction of inspired oxygen'''[http://en.wikipedia.org/wiki/FiO2] in the gas mixture breathed by the patient.)
• GCS sedated field  + (Field does not contain any relevant data.)
• Accept DtTm field  + (First [[Service tmp entry]] DtTm for pts who came from the '''ER department''' only)
• Arrive DtTm field  + (First non-ER [[Boarding Loc|Boarding location]] date and time, or start of ([[Service/Location field | Service Location]]) for legacy records.)
• Record  + (Free choice use by collectors to help collection, this field has no consistent meaning.)
• FFP  + (Fresh Frozen Plasma / FFP contains manually collected doses of FFP that were given.)
• H2-Blockers  + (H2-Blockers contains manually collected doses of H2-Blockers that were given.)
• Heparin SQ  + (Heparin SQ contains manually collected doses of Heparin SQ that were given.)
• Pre acute living situation field  + (Info about the living situation of the patient prior to the current hospitalization.)
• LMWH  + (LMWH contains manually collected doses of LMWH that were given.)
• FirstName field  + (Last Name of patient)
• LastName field  + (Last Name of patient)
• LastChanged DtTm field  + (Last time the record was closed with the "Close - with updates" button)
• Service/Location field  + (Legacy field replaced by [[Boarding Loc]] and [[Service tmp entry]])
• MRI (labs)  + (MRI contains the manually counted number of MRIs done during a patient's stay in our unit.)
• Magnesium (labs)  + (Magnesium contains the number of magnesiums done during a patient's stay in our unit.)
• Mean BP  + (Mean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3))
• ADL Bathing  + (Need for help with bathing; component of [[ADL]].)
• ADL Dressing  + (Need for help with dressing; component of [[ADL]].)
• ADL Feeding  + (Need for help with feeding; component of [[ADL]])
• ADL Toiletting  + (Need for help with toiletting; component of [[ADL]])
• ADL Transfering  + (Need for help with transferring; component of [[ADL]])
• Hospitalization ID  + (Not currently used)
• Notes field (L PHI)  + (Notes in L_PHI table is used by the data processor to comment on data ad-hoc where needed.)
• PCO2  + (PCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L.)
• PO2  + (PO2 is the partial pressure of oxygen in the patient's arterial blood.)
• PPI  + (PPI contains manually collected doses of PPI that were given.)
• PT PTT  + (PT_PTT contains the number of PTs and PTTs done during a patient's stay in our unit.)
• Pentaspan  + (Pentaspan contains the number of doses or Pentaspan that were given while in the unit.)
• Platelets  + (Platelets contains number of doses of platelets that were given.)
• Province field  + (Province 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.)
• SGPT ALT (labs)  + (SGPT_ALT contains the number of SGPTs and ALTs done during a patient's stay in our unit.)
• Registry Patient Type  + (Service of the attending physician for medicine data, and the type of admit diagnosis for critical care patients.)
• Chronic Health APACHE  + (Specific chronic pre-existing conditions used for [[APACHE]] score.)
• ARF (APACHE)  + (The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.)
• Admit Type for APACHE II  + (The Admit Type for APACHE II is a way to classify patients' surgical status and one of the elements used to generate the [[APACHE_Scoring_table#Chronic_Health_Score | APACHE score]].)
• CCI Picklist Code  + (The CCI code for and entry in the [[L CCI Picklist subform]], from [[s_CCI_Picklist table]].)
• Dispo field  + (The Dispo field contains information about what happens to the patient at the end of their admission.)
• ER Delay  + (The ER Delay is the difference between the pre-ER [[Boarding Loc]] and first post-ER [[Boarding Loc]], for patients arriving from the ER.)
• Pat ID field  + (The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See [[Serial number]].)
• PH  + (The acidity or basicity of the patient's arterial blood.)
• ICD10 code  + (The actual ICD10 code.)
• Px Date  + (The date/time of a [[CCI]] procedure)
• Dx Date  + (The date/time of an [[ICD10]] diagnosis.)
• AP Eye field  + (The eye component of the [[Glasgow_Coma_Scale]].)
• s_dispo.loc_type  + (The 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.)
• Previous Service field  + (The most recent "originating service" which sends the patients to their [[Service/Location field| current service location]].)
• Pre-admit Inpatient Institution field  + (The 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.)