Search by property
Jump to navigation
Jump to search
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
- +
- ''True'' if drug in field name was given +
- ''True'' if influenza drugs were given +
- ABG contains manually collected arterial blood gas counts. +
- Albumin_25pct contains number of doses of 25% Albumin that were given. +
- Albumin_5pct contains the number of doses of 5% Albumin that were given. +
- Ap_DiasBP is the diastolic blood pressure. +
- Ap_SysBP is the systolic blood pressure. +
- Biological sex of the patient at birth; options are "male" and "female". +
- Control of urination and bowel movements; component of [[ADL]] +
- Critical care patients on a long term ventilator ([[LTV]]). +
- Date of Birth (DOB) is the data a patient was born. +
- Field does not contain any relevant data. +
- LMWH contains manually collected doses of LMWH that were given. +
- Last Name of patient +
- Last time the record was closed with the "Close - with updates" button +
- Legacy field replaced by [[Boarding Loc]] and [[Service tmp entry]] +
- Mean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3) +
- Need for help with bathing; component of [[ADL]]. +
- Need for help with dressing; component of [[ADL]]. +
- Need for help with feeding; component of [[ADL]] +
- Need for help with toiletting; component of [[ADL]] +
- Need for help with transferring; component of [[ADL]] +
- Not currently used +
- PO2 is the partial pressure of oxygen in the patient's arterial blood. +
- PPI contains manually collected doses of PPI that were given. +
- Platelets contains number of doses of platelets that were given. +
- Specific chronic pre-existing conditions used for [[APACHE]] score. +
- The acidity or basicity of the patient's arterial blood. +
- The actual ICD10 code. +
- The date/time of a [[CCI]] procedure +
- The date/time of an [[ICD10]] diagnosis. +
- The eye component of the [[Glasgow_Coma_Scale]]. +
- The motor component of the [[Glasgow_Coma_Scale]]. +
- The patient's Alveolar-arterial oxygen tension difference level in . +
- The patient's level in . +
- The patient's Heart Rate level in beats/min. +
- The patient's PHIN . +
- The patient's Potassium level in mmol/L. +
- The patient's Serum CO2 level in mmol/L. +
- The patient's Sodium level in mmol/L. +
- The patient's Temperature level in °C. +
- The patient's White Blood Count level in x10<sup>9</sup>/L. +
- The patient's hematocrit level in percentage. +
- The patient's postal code. +
- The patient's respiratory rate level in breaths/min. +
- The priority of an [[ICD10]] diagnosis, used to rank and group. +
- The type of a [[CCI]] procedure (comorbid, admit or acquired) +
- The unique person identifier from [[Cognos]]. +
- The verbal component of the [[Glasgow_Coma_Scale]]. +
- Time the record was last sent. +
- True if a continuous infusion of Heparin was given +
- True when patient APACH II data is complete +
- True when patient Labs data is complete +
- True when patient Tmp data is complete +
- True when patient comorbid diagnosis data is complete +
- True when patient diagnosis data is complete +
- True when patient pharmacy diagnosis data is complete +
- Unique identifier of the [[L_ICD10 table]] +
- Used by data collectors to keep notes during collection. +
- VBG contains manually collected venous blood gas counts. +
- azoles contains manually collected doses of azoles that were given. +
- fungins contains manually collected doses of fungins that were given. +
- spare1 contains manually collected doses of spare1 that were given. +
- spare2 contains manually collected doses of spare2 that were given. +
- spare3 contains manually collected doses of spare3 that were given. +
- spare4 contains manually collected doses of spare4 that were given. +
- spare5 contains manually collected doses of spare5 that were given. +
- spare6 contains manually collected doses of spare6 that were given. +
- true when patient ADL data is complete +
- true when patient registry data is complete +
- "DC" for critical care patients if life-support treatment is terminated, blank for all others. +
- '''Checkbox''' that is set to true for''' a single [[Admit Diagnosis]]''' per ward stay that is the [[Primary Admit Diagnosis]] +
- 3rd generation cephalosporins contains manually collected doses of 3rd generation cephalosporins that were given. +
- Angio coronary contained the manually counted number of coronary angiograms done during a stay in our unit, or on the way there. +
- Angio_others contained the manually counted number of non-coronary angiograms done during a stay in our unit, or on the way there. +
- CBC contains the number of CBCs done during a patient's stay in our unit. +
- CT_Scan contains the manually counted number of CT scans done during a patient's stay in our unit. +
- 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. +
- Chest Xrays (CXR) contains the manually counted number of chest xrays (CXR) done during a patient's stay in our unit. +
- Contains the number of '''abdominal ultrasounds''' a client has had during an admission to our unit. +
- Contains the number of any sputum specimens (including endotracheal secretions) sent for "culture and sensitivity" for bacteria or fungus. +
- Contains the number of blood cultures a patient has had during an admission to our unit. +
- Contains the number of heart ultrasounds (echocardiograms) a client has had during an admission to our unit. +
- Creatinine contains the number of creatinines done during a patient's stay in our unit. +
- Cross-check field that will contain data if [[Transfer_Ready_DtTm field]] is empty +
- Date and time the '''intent to discharge''' a patient to a lower level in the [[Level of care hierarchy]] was documented. +
- Date and time when the patient changed status from what is documented in [[Service/Location field]] to [[Dispo field]].. +
- Date the record was created on the data collector's laptop; created automatically by [[CCMDB.accdb]]. +
- 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 is the '''fraction of inspired oxygen'''[http://en.wikipedia.org/wiki/FiO2] in the gas mixture breathed by the patient. +
- First [[Service tmp entry]] DtTm for pts who came from the '''ER department''' only +
- First non-ER [[Boarding Loc|Boarding location]] date and time, or start of ([[Service/Location field | Service Location]]) for legacy records. +
- Free choice use by collectors to help collection, this field has no consistent meaning. +
- Fresh Frozen Plasma / FFP contains manually collected doses of FFP that were given. +
- H2-Blockers contains manually collected doses of H2-Blockers that were given. +
- Heparin SQ contains manually collected doses of Heparin SQ that were given. +
- Info about the living situation of the patient prior to the current hospitalization. +
- MRI contains the manually counted number of MRIs done during a patient's stay in our unit. +
- Magnesium contains the number of magnesiums done during a patient's stay in our unit. +
- Notes in L_PHI table is used by the data processor to comment on data ad-hoc where needed. +
- PCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L. +
- PT_PTT contains the number of PTs and PTTs done during a patient's stay in our unit. +
- Pentaspan contains the number of doses or Pentaspan that were given while in the unit. +
- 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 contains the number of SGPTs and ALTs done during a patient's stay in our unit. +
- Service of the attending physician for medicine data, and the type of admit diagnosis for critical care patients. +
- The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition. +
- 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]]. +
- The CCI code for and entry in the [[L CCI Picklist subform]], from [[s_CCI_Picklist table]]. +
- The Dispo field contains information about what happens to the patient at the end of their admission. +
- The ER Delay is the difference between the pre-ER [[Boarding Loc]] and first post-ER [[Boarding Loc]], for patients arriving from the ER. +
- The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See [[Serial number]]. +
- 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. +
- The most recent "originating service" which sends the patients to their [[Service/Location field| current service location]]. +
- 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. +
- The most recent previous '''physical location''' (with [[#exceptions]]) of a patient before arriving at the collection location. +
- The number of years between [[Date of Birth]] and the last birthday prior to or on ([[Admit DtTm]] otherwise). +
- The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals. +
- The type of a CCI Procedure as per [[CCI Collection]], ie admit or acquired +
- The type of an [[ICD10]] diagnosis ([[Comorbid Diagnosis]], [[Admit Diagnosis]] or [[Acquired Diagnosis / Complication]]) +
- The unique identifier/index of [[CCI Procedure]]'s first component in [[s_CCI_1 table]]. +
- The unique identifier/index of [[CCI Procedure]]'s second component in [[s_CCI_2 table]]. +
- The unique identifier/index of records in the Critical Care and Medicine Database. +
- This field is used only as an identifier to combine data from the same hospitalization and should not be used as a date. +
- Time the record was created on the data collector's laptop; created automatically by [[CCMDB.accdb]]. +
- Troponincontains the number of troponins done during a patient's stay in our unit. +
- True for [[Acquired Diagnosis / Complication]] when [[Dx Date]] legitimately missing. +
- Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data. +
- Unique random number id per patient that combines the [[D_ID]]s across admissions/encounters. +
- Urine_CS contains the number of any urine specimens sent for "culture and sensitivity" for bacteria or fungus. +
- Voluven contains the number of doses or Voluven that were given while in the unit. +
- antipseudomonals contains manually collected doses of antipseudomonals that were given. +
- benzodiazepines cont inf contains manually collected doses of benzodiazepines cont inf that were given. +
- carbapenems contains manually collected doses of carbapenems that were given. +
- ceftazidime contains manually collected doses of ceftazidime that were given. +
- checkbox is checked/true when no Accept DtTm is documented for a patient who came from from the ER. +
- fluoroquinolones contains manually collected doses of fluoroquinolones that were given. +
- furosemide cont inf contains manually collected doses of furosemide cont inf that were given. +
- insulin cont inf contains manually collected doses of insulin cont inf that were given. +
- opioids cont inf contains manually collected doses of opioids cont inf that were given. +
- propofol cont inf contains manually collected doses of propofol cont inf that were given. +
- status of the data in the record. Possible values are complete, sent, questioned and vetted. +
- tigecyline contains manually collected doses of tigecyline that were given. +
- vanco alternatives contains manually collected doses of vanco alternatives that were given. +
- vancomycin contains manually collected doses of vancomycin that were given. +