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

• Age  + (The number of years between [[Date of Birth]] and the last birthday prior to or on ([[Admit DtTm]] otherwise).)
• 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.)
• Dx Priority  + (The priority of an [[ICD10]] diagnosis, used to rank and group.)
• Px Type  + (The type of a CCI Procedure as per [[CCI Collection]], ie admit or acquired)
• Px Count  + (The type of a [[CCI]] procedure (comorbid, admit or acquired))
• Dx Type  + (The type of an [[ICD10]] diagnosis ([[Comorbid Diagnosis]], [[Admit Diagnosis]] or [[Acquired Diagnosis / Complication]]))
• 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]].)
• AP Verbal field  + (The verbal component of the [[Glasgow_Coma_Scale]].)
• 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]].)

• SentDtTm field  + (Time the record was last sent.)

• Troponin  + (Troponincontains the number of troponins done during a patient's stay in our unit.)
• Dx Date unknown  + (True for [[Acquired Diagnosis / Complication]] when [[Dx Date]] legitimately missing.)
• Pharm Heparin cont inf  + (True if a continuous infusion of Heparin was given)
• 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  + (Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data.)
• 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.)
• Urine CS  + (Urine_CS contains the number of any urine specimens sent for "culture and sensitivity" for bacteria or fungus.)
• Notes field  + (Used by data collectors to keep notes during collection.)
• Venous blood gas (labs)  + (VBG contains manually collected venous blood gas counts.)
• Voluven  + (Voluven contains the number of doses or Voluven that were given while in the unit.)
• Antipseudomonals  + (antipseudomonals contains manually collected doses of antipseudomonals that were given.)
• Azoles  + (azoles contains manually collected doses of azoles that were given.)
• Benzodiazepines cont inf  + (benzodiazepines cont inf contains manually collected doses of benzodiazepines cont inf that were given.)
• Carbapenems  + (carbapenems contains manually collected doses of carbapenems that were given.)
• Ceftazidime  + (ceftazidime contains manually collected doses of ceftazidime that were given.)
• Accept DtTm missing field  + (checkbox is checked/true when no Accept DtTm is documented for a patient who came from from the ER.)
• Fluoroquinolones  + (fluoroquinolones contains manually collected doses of fluoroquinolones that were given.)
• Fungins  + (fungins contains manually collected doses of fungins that were given.)
• Furosemide cont inf  + (furosemide cont inf contains manually collected doses of furosemide cont inf that were given.)