Property:DataElementDescription
Jump to navigation
Jump to search
This is a property of type Text.
D
A
D
"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]] +
P
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if drug in field name was given +
''True'' if influenza drugs were given +
3
3rd generation cephalosporins contains manually collected doses of 3rd generation cephalosporins that were given. +
A
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. +
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. +
Ap_DiasBP is the diastolic blood pressure. +
Ap_SysBP is the systolic blood pressure. +
S
C
CT_Scan contains the manually counted number of CT scans done during a patient's stay in our unit. +
O
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. +
C
Chest Xrays (CXR) contains the manually counted number of chest xrays (CXR) done during a patient's stay in our unit. +
A
Contains the number of '''abdominal ultrasounds''' a client has had during an admission to our unit. +
S
Contains the number of any sputum specimens (including endotracheal secretions) sent for "culture and sensitivity" for bacteria or fungus. +
B
Contains the number of blood cultures a patient has had during an admission to our unit. +
E
Contains the number of heart ultrasounds (echocardiograms) a client has had during an admission to our unit. +
A
Control of urination and bowel movements; component of [[ADL]] +
C
Creatinine contains the number of creatinines done during a patient's stay in our unit. +
R
Critical care patients on a long term ventilator ([[LTV]]). +
T
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. +
D
Date and time when the patient changed status from what is documented in [[Service/Location field]] to [[Dispo field]].. +
Date of Birth (DOB) is the data a patient was born. +
S
Date the record was created on the data collector's laptop; created automatically by [[CCMDB.accdb]]. +
L
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. +
F
FIO2 is the '''fraction of inspired oxygen'''[http://en.wikipedia.org/wiki/FiO2] in the gas mixture breathed by the patient. +
G
Field does not contain any relevant data. +
A
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. +
R
F
H
H2-Blockers contains manually collected doses of H2-Blockers that were given. +
Heparin SQ contains manually collected doses of Heparin SQ that were given. +
P
Info about the living situation of the patient prior to the current hospitalization. +
L
F
Last Name of patient +
L
Last Name of patient +
Last time the record was closed with the "Close - with updates" button +
S
Legacy field replaced by [[Boarding Loc]] and [[Service tmp entry]] +
M
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. +
A
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]] +
H
Not currently used +
N
Notes in L_PHI table is used by the data processor to comment on data ad-hoc where needed. +
P
PCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L. +
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. +
S
SGPT_ALT contains the number of SGPTs and ALTs done during a patient's stay in our unit. +
R
Service of the attending physician for medicine data, and the type of admit diagnosis for critical care patients. +
C
Specific chronic pre-existing conditions used for [[APACHE]] score. +
A
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]]. +
C
The CCI code for and entry in the [[L CCI Picklist subform]], from [[s_CCI_Picklist table]]. +
D
The Dispo field contains information about what happens to the patient at the end of their admission. +
E
The ER Delay is the difference between the pre-ER [[Boarding Loc]] and first post-ER [[Boarding Loc]], for patients arriving from the ER. +
P
The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See [[Serial number]]. +
I
The actual ICD10 code. +
P
D
A
The eye component of the [[Glasgow_Coma_Scale]]. +
S
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. +
P
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. +
A
The motor component of the [[Glasgow_Coma_Scale]]. +
The number of years between [[Date of Birth]] and the last birthday prior to or on ([[Admit DtTm]] otherwise). +
C
The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals. +
A
C
The patient's level in . +
H
P
The patient's PHIN . +
K
S
N
T
The patient's Temperature level in °C. +
W
H
P
The patient's postal code. +
R
D
The priority of an [[ICD10]] diagnosis, used to rank and group. +
P
D
The type of an [[ICD10]] diagnosis ([[Comorbid Diagnosis]], [[Admit Diagnosis]] or [[Acquired Diagnosis / Complication]]) +
C
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]]. +
D
The unique identifier/index of records in the Critical Care and Medicine Database. +
C
The unique person identifier from [[Cognos]]. +
A
The verbal component of the [[Glasgow_Coma_Scale]]. +
V
This field is used only as an identifier to combine data from the same hospitalization and should not be used as a date. +
S
Time the record was created on the data collector's laptop; created automatically by [[CCMDB.accdb]]. +
Time the record was last sent. +
T
D
True for [[Acquired Diagnosis / Complication]] when [[Dx Date]] legitimately missing. +
P
True if a continuous infusion of Heparin was given +
A
True when patient APACH II data is complete +
L
True when patient Labs data is complete +
T
True when patient Tmp data is complete +
C
True when patient comorbid diagnosis data is complete +
D
True when patient diagnosis data is complete +
P
True when patient pharmacy diagnosis data is complete +
C
Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data. +
L
Unique identifier of the [[L_ICD10 table]] +
P
Unique random number id per patient that combines the [[D_ID]]s across admissions/encounters. +
U
Urine_CS contains the number of any urine specimens sent for "culture and sensitivity" for bacteria or fungus. +
N
Used by data collectors to keep notes during collection. +
V
VBG contains manually collected venous blood gas counts. +
A
antipseudomonals contains manually collected doses of antipseudomonals that were given. +
B
benzodiazepines cont inf contains manually collected doses of benzodiazepines cont inf that were given. +
C
carbapenems contains manually collected doses of carbapenems that were given. +
ceftazidime contains manually collected doses of ceftazidime that were given. +
A
checkbox is checked/true when no Accept DtTm is documented for a patient who came from from the ER. +
F
fluoroquinolones contains manually collected doses of fluoroquinolones that were given. +
furosemide cont inf contains manually collected doses of furosemide cont inf that were given. +
I
insulin cont inf contains manually collected doses of insulin cont inf that were given. +
O
opioids cont inf contains manually collected doses of opioids cont inf that were given. +
P
propofol cont inf contains manually collected doses of propofol cont inf that were given. +
S
R
status of the data in the record. Possible values are complete, sent, questioned and vetted. +
T
tigecyline contains manually collected doses of tigecyline that were given. +
A
true when patient ADL data is complete +
R
true when patient registry data is complete +
V
vanco alternatives contains manually collected doses of vanco alternatives that were given. +
vancomycin contains manually collected doses of vancomycin that were given. +