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

• ClientVisitGUID field  + (Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data.)

• Sex field  + (Biological sex of the patient at birth; options are "male" and "female".)
• CBC  + (CBC contains the number of CBCs done during a patient's stay in our unit.)
• CT Scan (labs)  + (CT_Scan contains the manually counted number of CT scans done during a patient's stay in our unit.)
• 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.)
• 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.)
• Creatinine (labs)  + (Creatinine contains the number of creatinines done during a patient's stay in our unit.)
• 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]].)
• 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.)
• Pre acute living situation field  + (Info about the living situation of the patient prior to the current hospitalization.)
• FirstName field  + (Last Name of patient)
• LastName field  + (Last Name of patient)
• 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.)
• 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.)
• PT PTT  + (PT_PTT contains the number of PTs and PTTs done during a patient's stay in our unit.)
• 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.)
• ARF (APACHE)  + (The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.)
• Dispo field  + (The Dispo field contains information about what happens to the patient at the end of their admission.)
• 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.)
• 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 Location field  + (The most recent previous '''physical location''' (with [[#exceptions]]) of a patient before arriving at the collection location.)
• Chart number  + (The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals.)
• AaDO2  + (The patient's Alveolar-arterial oxygen tension difference level in .)
• Creatinine (APACHE)  + (The patient's level in .)
• HR  + (The patient's Heart Rate level in beats/min.)
• PHIN field  + (The patient's PHIN .)
• K  + (The patient's Potassium level in mmol/L.)
• Serum CO2  + (The patient's Serum CO2 level in mmol/L.)
• Na  + (The patient's Sodium level in mmol/L.)
• Temperature  + (The patient's Temperature level in °C.)
• WBC  + (The patient's White Blood Count level in x10⁹/L.)
• HCT  + (The patient's hematocrit level in percentage.)
• Postal Code field  + (The patient's postal code.)
• RR  + (The patient's respiratory rate level in breaths/min.)
• CCI 1 Code  + (The unique identifier/index of [[CCI Procedure]]'s first component in [[s_CCI_1 table]].)
• CCI 2 Code  + (The unique identifier/index of [[CCI Procedure]]'s second component in [[s_CCI_2 table]].)
• D ID field  + (The unique identifier/index of records in the Critical Care and Medicine Database.)
• ClientGUID field  + (The unique person identifier from [[Cognos]].)
• Visit Admit DtTm field  + (This field is used only as an identifier to combine data from the same hospitalization and should not be used as a date.)
• Start Time field  + (Time the record was created on the data collector's laptop; created automatically by [[CCMDB.accdb]].)
• Troponin  + (Troponincontains the number of troponins done during a patient's stay in our unit.)
• Ap Complete  + (True when patient APACH II data is complete)
• Labs Complete  + (True when patient Labs data is complete)
• Tmp Complete  + (True when patient Tmp data is complete)
• Como Complete  + (True when patient comorbid diagnosis data is complete)
• Diag Complete  + (True when patient diagnosis data is complete)
• Pharm Complete  + (True when patient pharmacy diagnosis data is complete)
• ClientVisitGUID field  +
• L ICD10 ID  + (Unique identifier of the [[L_ICD10 table]])
• Person ID field  + (Unique random number id per patient that combines the [[D_ID]]s across admissions/encounters.)
• Notes field  + (Used by data collectors to keep notes during collection.)
• Accept DtTm missing field  + (checkbox is checked/true when no Accept DtTm is documented for a patient who came from from the ER.)
• RecordStatus field  + (status of the data in the record. Possible values are complete, sent, questioned and vetted.)
• ADL Complete  + (true when patient ADL data is complete)
• R Complete  + (true when patient registry data is complete)