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

• Start Time field  + (Time the record was created on the data collector's laptop; created automatically by [[CCMDB.accdb]].)

• 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.)
• 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.)
• GCS sedated field  + (Field does not contain any relevant data.)
• Arrive DtTm field  + (First non-ER [[Boarding Loc|Boarding location]] date and time, or start of ([[Service/Location field | Service Location]]) for legacy records.)
• LastChanged DtTm field  + (Last time the record was closed with the "Close - with updates" button)
• Notes field (L PHI)  + (Notes in L_PHI table is used by the data processor to comment on data ad-hoc where needed.)
• Registry Patient Type  + (Service of the attending physician for medicine data, and the type of admit diagnosis for critical care patients.)
• Pat ID field  + (The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See [[Serial number]].)
• Px Date  + (The date/time of a [[CCI]] procedure)
• Dx Date  + (The date/time of an [[ICD10]] diagnosis.)
• 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  +
• SentDtTm field  + (Time the record was last sent.)
• 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.)
• Notes field  + (Used by data collectors to keep notes during collection.)
• 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)