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
- AP Motor field + (The motor component of the [[Glasgow_Coma_Scale]].)
- 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<sup>9</sup>/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.)
- Insulin cont inf + (insulin cont inf contains manually collected doses of insulin cont inf that were given.)
- Opioids cont inf + (opioids cont inf contains manually collected doses of opioids cont inf that were given.)
- Propofol cont inf + (propofol cont inf contains manually collected doses of propofol cont inf that were given.)
- Spare1 + (spare1 contains manually collected doses of spare1 that were given.)
- Spare2 + (spare2 contains manually collected doses of spare2 that were given.)
- Spare3 + (spare3 contains manually collected doses of spare3 that were given.)
- Spare4 + (spare4 contains manually collected doses of spare4 that were given.)
- Spare5 + (spare5 contains manually collected doses of spare5 that were given.)
- Spare6 + (spare6 contains manually collected doses of spare6 that were given.)
- RecordStatus field + (status of the data in the record. Possible values are complete, sent, questioned and vetted.)
- Tigecyline + (tigecyline contains manually collected doses of tigecyline that were given.)
- ADL Complete + (true when patient ADL data is complete)
- R Complete + (true when patient registry data is complete)
- Vanco alternatives + (vanco alternatives contains manually collected doses of vanco alternatives that were given.)
- Vancomycin + (vancomycin contains manually collected doses of vancomycin that were given.)