Auto Data Dictionary

what is this?

This article generates a list of data fields in the critical care and medicine database using the Template:Data element and Semantic Mediawiki.

What if a field is missing

This only includes fields that have their own article and that properly use the Template:Data element. If field is missing, check that article exists and template is used correctly.

data fields

This is a list of fields in the Critical Care and Medicine Database

	InTable	FieldDataType	FieldLength	DataElementDescription	DataElementStartDate	DataElementEndDate	FieldCreatedRaw
3rd generation cephalosporins	L Pharm Flowsheet table	number	integer	3rd generation cephalosporins contains manually collected doses of 3rd generation cephalosporins that were given.	1 January 1900	1 January 2100	Raw
ADL Bathing	L Log table	string	15	Need for help with bathing; component of ADL.	1 January 1900	1 January 2100	Raw
ADL Complete	L Log table	boolean	not entered	true when patient ADL data is complete	1 January 2000	31 December 2100	Raw
ADL Continence	L Log table	string	15	Control of urination and bowel movements; component of ADL	1 January 1900	1 January 2100	Raw
ADL Dressing	L Log table	string	15	Need for help with dressing; component of ADL.	1 January 1900	1 January 2100	Raw
ADL Feeding	L Log table	string	15	Need for help with feeding; component of ADL	1 January 1900	1 January 2100	Raw
ADL Toiletting	L Log table	string	15	Need for help with toiletting; component of ADL	1 January 1900	1 January 2100	Raw
ADL Transfering	L Log table	string	15	Need for help with transferring; component of ADL	1 January 1900	1 January 2100	Raw
AP Dias BP Field	L Log table	number	single	Ap_DiasBP is the diastolic blood pressure.	1 January 1900	1 January 2100	Raw
AP Eye field	L Log table	string	13	The eye component of the Glasgow_Coma_Scale.	1 January 1900	1 January 2100	Raw
AP Motor field	L Log table	string	19	The motor component of the Glasgow_Coma_Scale.	1 January 1900	1 January 2100	Raw
AP Sys BP Field	L Log table	number	single	Ap_SysBP is the systolic blood pressure.	1 January 1900	1 January 2100	Raw
AP Verbal field	L Log table	string	26	The verbal component of the Glasgow_Coma_Scale.	1 January 1900	1 January 2100	Raw
ARF (APACHE)	L Log table	number	single	The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.	1 January 1900	1 January 2100	Raw
AaDO2	Created variables CC table	number	___	The patient's Potassium level in mmol/L.	1 January 1900	1 January 2100	Created
Abdominal ultrasound	L Labs Flowsheet table	integer	integer	Contains the number of abdominal ultrasounds a client has had during an admission to our unit.	1 January 1900	1 January 2100	Raw
Accept DtTm field	L Log table	date	not entered	The date and time when the patient is accepted from the ER department ONLY.	1 July 2016	1 January 2100	Raw
Accept DtTm missing field	L Log table	boolean	not entered	checkbox is checked/true when no Accept DtTm is documented for a patient who came from from the ER.	1 July 2016	1 January 2100	Raw
Admit Type for APACHE II	L Log table	string	10	Admit type for APACHE	1 January 1900	1 January 2100	Raw
Age	Created variables common Created variables CC table	number		The number of years between Date of Birth and the last birthday prior to or on (Accept DtTm if applicable, Arrive DtTm otherwise).	1 January 1900	1 January 2100	Created
Albumin 25pct	L Labs Flowsheet table	integer	integer	Albumin_25pct contains number of doses of 25% Albumin that were given.	1 January 1900	1 January 2100	Raw
Albumin 5pct	L Labs Flowsheet table	integer	integer	Albumin_5pct contains the number of doses of 5% Albumin that were given.	1 January 1900	1 January 2100	Raw
Angio coronary field	L Labs Flowsheet table	integer	integer	Angio coronary contained the manually counted number of coronary angiograms done during a stay in our unit, or on the way there.	1 January 1900	3 April 2017	Raw
Angio others field	L Labs Flowsheet table	integer	integer	Angio_others contained the manually counted number of non-coronary angiograms done during a stay in our unit, or on the way there.	1 January 1900	3 April 2017	Raw
Antipseudomonals	L Pharm Flowsheet table	number	integer	antipseudomonals contains manually collected doses of antipseudomonals that were given.	1 January 1900	1 January 2100	Raw
Ap Complete	L Log table	boolean	not entered	True when patient APACH II data is complete	1 January 2000	31 December 2100	Raw
Ap SapsSysBP field	L Log table	number	long integer		1 January 1900	1 January 2000	Raw
ApLab Complete	L Log table	boolean	not entered	True when patient APACHE II lab data is complete	1 January 2000	31 December 2016	Raw
Arrive DtTm field	L Log table	date	not entered	Date and time when the patient physically arrived on unit.	1 July 2016	1 January 2100	Raw
Arterial blood gas (labs)	L Labs Flowsheet table	integer	long	The Arterial Blood Gas contains manually collected arterial blood gas counts.	1 January 1900	1 January 2100	Raw
Azoles	L Pharm Flowsheet table	number	integer	azoles contains manually collected doses of azoles that were given.	1 January 1900	1 January 2100	Raw
Benzodiazepines cont inf	L Pharm Flowsheet table	number	integer	benzodiazepines cont inf contains manually collected doses of benzodiazepines cont inf that were given.	1 January 1900	1 January 2100	Raw
Blood culture	L Labs Flowsheet table	integer	integer	Contains the number of blood cultures a patient has had during an admission to our unit.	1 January 1900	1 January 2100	Raw
CBC	L Labs Flowsheet table	integer	integer	CBC contains the number of CBCs done during a patient's stay in our unit.	1 January 1900	1 January 2100	Raw
CT Scan (labs)	L Labs Flowsheet table	integer	integer	CT_Scan contains the manually counted number of CT scans done during a patient's stay in our unit.	1 January 1900	1 January 2100	Raw
CXR	L Labs Flowsheet table	integer	integer	Chest Xrays (CXR) contains the manually counted number of chest xrays (CXR) done during a patient's stay in our unit.	1 January 1900	1 January 2100	Raw
Carbapenems	L Pharm Flowsheet table	number	integer	carbapenems contains manually collected doses of carbapenems that were given.	1 January 1900	1 January 2100	Raw
Ceftazidime	L Pharm Flowsheet table	number	integer	ceftazidime contains manually collected doses of ceftazidime that were given.	1 January 1900	1 January 2100	Raw
Chart number	L Log table L PHI table	string	8	The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals.	1 January 1900	1 January 2100	Raw
Chronic Health APACHE	L Log table	string	30	Specific chronic pre-existing conditions used for APACHE score.	1 January 1900	1 January 2100	Raw
Como Complete	L Log table	boolean	not entered	True when patient comorbid diagnosis data is complete	1 January 2000	31 December 2100	Raw
Creatinine (APACHE)	L Log table	number	single	The patient's level in .	1 January 1900	1 January 2100	Raw
Creatinine (labs)	L Labs Flowsheet table	integer	integer	Creatinine contains the number of creatinines done during a patient's stay in our unit.	1 January 1900	1 January 2100	Raw
D ID field	L Log table L Dxs table L TmpV2 table L Como table L ICD10 table L Labs DSM table L TISS Form table L TISS Item table L Labs Flowsheet table L PCH table L PHI table L Pharm Flowsheet table L TISS76 table L CCI Picklist table L CCI Component table	string	18	The unique identifier/index of records in the Critical Care and Medicine Database.	1 January 1900	1 January 2100	Raw
DC Treatment	L Log table	string	50	"DC" for critical care patients if life-support treatment is terminated, blank for all others.	1 January 1900	1 January 2100	Raw
Date of Birth	L Log table L PHI table	date	not entered	Date of Birth (DOB) is the data a patient was born.	1 January 1900	1 January 2100	Raw
Diag Complete	L Log table	boolean	not entered	True when patient diagnosis data is complete	1 January 2000	31 December 2100	Raw
Dispo DtTm field	L Log table	date	not entered	Date and time when the patient changed status from what is documented in Service/Location field to Dispo field..	1 July 2016	1 January 2100	Raw
Dispo field	L Log table	integer	long	The Dispo field contains information about what happens to the patient at the end of their admission.	1 July 2016	1 January 2100	Raw
Dx Date	L ICD10 table	date	not entered	The date/time of an ICD10 diagnosis.	1 January 1900	1 January 2100	Raw
Dx Date unknown	L ICD10 table	boolean	not entered	True for Acquired Diagnosis / Complication when Dx Date legitimately missing.	1 January 1900	1 January 2100	Raw
Dx Primary	L ICD10 table	boolean	not entered	True for the Admit Diagnosis that is the Primary Admit Diagnosis	1 January 1900	1 January 2100	Raw
Dx Priority	L ICD10 table	number	single	The priority of an ICD10 diagnosis, used to rank and group.	1 January 1900	1 January 2100	Raw
Dx Type	L ICD10 table	string	8	The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication)	1 January 1900	1 January 2100	Raw
ER Delay	Created variables common	date	n/a	The ER Delay is the difference between the Accept DtTm and Arrive_DtTm for patients arriving from the ER.	1 January 1900	1 January 2100	Created
Echocardiogram	L Labs Flowsheet table	integer	integer	Contains the number of heart ultrasounds (echocardiograms) a client has had during an admission to our unit.	1 January 1900	1 January 2100	Raw
FFP	L Labs Flowsheet table	integer	integer	Fresh Frozen Plasma / FFP contains manually collected doses of FFP that were given.	1 January 1900	1 January 2100	Raw
FiO2	L Log table	number	single	FIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient.	1 January 1900	1 January 2100	Raw
FinalCheck field	L Log table	boolean	not entered	Legacy; used to be checked when all data is complete, now see RecordStatus field.	1 January 1900	24 May 2013	Raw
FirstName field	L Log table L PHI table	string	40	Last Name of patient	1 January 1900	1 January 2100	Raw
Fluoroquinolones	L Pharm Flowsheet table	number	integer	fluoroquinolones contains manually collected doses of fluoroquinolones that were given.	1 January 1900	1 January 2100	Raw
Fungins	L Pharm Flowsheet table	number	integer	fungins contains manually collected doses of fungins that were given.	1 January 1900	1 January 2100	Raw
Furosemide cont inf	L Pharm Flowsheet table	number	integer	furosemide cont inf contains manually collected doses of furosemide cont inf that were given.	1 January 1900	1 January 2100	Raw
GCS sedated field	L Log table	boolean	not entered	The GCS sedated field is a checkbox used together with the Glasgow Coma Scale; if the patient is sedated when the GCS is assessed, this box is checked.	22 September 2016	1 January 2100	Raw
H2-Blockers	L Pharm Flowsheet table	number	integer	H2-Blockers contains manually collected doses of H2-Blockers that were given.	1 January 1900	1 January 2100	Raw
HCT	L Log table	number	single	The patient's hematocrit level in percentage.	1 January 1900	1 January 2100	Raw
HR	L Log table	number	single	The patient's Heart Rate level in beats/min.	1 January 1900	1 January 2100	Raw
Heparin SQ	L Pharm Flowsheet table	number	integer	Heparin SQ contains manually collected doses of Heparin SQ that were given.	1 January 1900	1 January 2100	Raw
ICD10 code	S ICD10 table L ICD10 table	string	10	The actual ICD10 code.	1 January 1900	1 January 2100	Raw
Insulin cont inf	L Pharm Flowsheet table	number	integer	insulin cont inf contains manually collected doses of insulin cont inf that were given.	1 January 1900	1 January 2100	Raw
K	L Log table	number	single	The patient's Potassium level in mmol/L.	1 January 1900	1 January 2100	Raw
L ICD10 ID	L ICD10 table	number	long	Unique identifier of the L_ICD10 table	1 January 1900	1 January 2100	Raw
LMWH	L Pharm Flowsheet table	number	integer	LMWH contains manually collected doses of LMWH that were given.	1 January 1900	1 January 2100	Raw
Labs Complete	L Log table	boolean	not entered	True when patient Labs data is complete	1 January 2000	31 December 2100	Raw
LastChanged DtTm field	L Log table	date	not entered	Last time the record was changed.	1 January 2016	31 December 2100	Raw
LastName field	L Log table L PHI table	string	40	Last Name of patient	1 January 1900	1 January 2100	Raw
LastOpened DtTm field	L Log table	date	not entered	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.	1 January 2016	31 December 2100	Raw
MRI (labs)	L Labs Flowsheet table	integer	integer	MRI contains the manually counted number of MRIs done during a patient's stay in our unit.	1 January 1900	1 January 2100	Raw
Magnesium (labs)	L Labs Flowsheet table	integer	integer	Magnesium contains the number of magnesiums done during a patient's stay in our unit.	1 January 1900	1 January 2100	Raw
Mean BP	Created variables CC table	number	single	Mean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3)	1 January 1900	1 January 2100	Created
Na	L Log table	number	single	The patient's Sodium level in mmol/L.	1 January 1900	1 January 2100	Raw
Notes field	L Log table	memo	not entered	Used by data collectors to keep notes during collection.	1 January 1900	1 January 2100	Raw
Notes field (L PHI)	L PHI table	memo	not entered	Notes in L_PHI table is used by the data processor to comment on data ad-hoc where needed.	1 January 1900	1 January 2100	Raw
Off ward field	L Log table	number	long integer	Checked/true if the patient who meets the Definition of a Medicine Service admission or Definition of an ICU 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.	1 July 2016	1 January 2100	Raw
Opioids cont inf	L Pharm Flowsheet table	number	integer	opioids cont inf contains manually collected doses of opioids cont inf that were given.	1 January 1900	1 January 2100	Raw
PCO2	L Log table	number	single	PCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L.	1 January 1900	1 January 2100	Raw
PH	L Log table	number	single	The acidity or basicity of the patient's arterial blood.	1 January 1900	1 January 2100	Raw
PHIN field	L Log table L PHI table	number	Long Integer	The patient's PHIN .	1 January 1900	1 January 2100	Raw
PO2	L Log table	number	single	PO2 is the partial pressure of oxygen in the patient's arterial blood.	1 January 1900	1 January 2100	Raw
PPI	L Pharm Flowsheet table	number	integer	PPI contains manually collected doses of PPI that were given.	1 January 1900	1 January 2100	Raw
PT PTT	L Labs Flowsheet table	integer	integer	PT_PTT contains the number of PTs and PTTs done during a patient's stay in our unit.	1 January 1900	1 January 2100	Raw
Packed cells	L Labs Flowsheet table	integer	integer	Packed cells contains doses of packed cells that were given.	1 January 1900	1 January 2100	Raw
Pat ID field	L Log table L Dxs table L TmpV2 table L Como table L ICD10 table L PCH table L TISS Form table L TISS Item table L Labs Flowsheet table L PHI table L Pharm Flowsheet table L CCI Picklist table L CCI Component table	number	Long Integer	The Pat_ID field contains a unique-per-location identifying number per patient ward admission. See Serial number.	1 January 1900	1 January 2100	Raw
Pentaspan	L Labs Flowsheet table	integer	integer	Pentaspan contains the number of doses or Pentaspan that were given while in the unit.		12 June 2014	Raw
Person ID field	L Person table L Log table	number	long integer	Unique id per patient that combines the D_IDs across admissions/encounters.	1 January 1900	1 January 2100	Created
Pharm 1st or 2nd generation cephalosporins	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm 4th generation cephalosporins	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Complete	L Log table	boolean	not entered	True when patient pharmacy diagnosis data is complete	1 January 2000	31 December 2100	Raw
Pharm Direct thrombin inhibitors	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Dobutamine cont inf	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Dopamine cont inf	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Epinephrine cont inf	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Factor Xa inhibitors	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Flow Complete	L Log table	boolean	not entered	Unused field	1 January 2000	31 December 2100	Raw
Pharm H2 blockers	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Heparin cont inf	L Log table	boolean	not entered	True if a continuous infusion of Heparin was given	1 January 2012	1 January 2100	Raw
Pharm Heparinoids	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm LMWH	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Milrinone cont inf	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Norepinephrine cont inf	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm PPI	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Paralytics cont inf	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Phenylephrine cont inf	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Vasopressin cont inf	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm Vitamin K antagonists field	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm aminoglycosides	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm amiodarones	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm amphotericin B	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm anti-TB drugs	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm antistaph penicillins	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm benzodiazepines	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm bosentan	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm corticosteroids	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm furosemide	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm heparin sq	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm influenza drugs	L Log table	boolean	not entered	True if influenza drugs were given	1 January 2012	1 January 2100	Raw
Pharm insulin	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm macrolides	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm opioids	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm propofol	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm special upper GI bleeding agents	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm statins	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm viagra-type vasodilators	L Log table	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Platelets	L Labs Flowsheet table	integer	integer	Platelets contains number of doses of platelets that were given.	1 January 1900	1 January 2100	Raw
Postal Code field	L Log table	string	6	The patient's postal code.	1 January 2012	1 January 2100	Raw
Pre acute living situation field	L Log table	number	long integer	Info about the living situation of the patient prior to the current hospitalization.	1 July 2016	1 January 2100	Raw
Pre-admit Inpatient Institution field	L Log table	number	long integer	The previous inpatient location of patients who were already inpatients elsewhere and who have been under medical care continuously before coming to our unit.	1 July 2016	1 January 2100	Raw
Previous Location field	L Log table	number	long integer	The most recent previous physical location of a patient before arriving at the collection location.	1 July 2016	1 January 2100	Raw
Previous Service field	L Log table	number	long integer	The most recent "originating service" which sends the patients to their current service location.	1 July 2016	1 January 2100	Raw
Propofol cont inf	L Pharm Flowsheet table	number	integer	propofol cont inf contains manually collected doses of propofol cont inf that were given.	1 January 1900	1 January 2100	Raw
Province field	L Log table	string	2	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.	1 January 1900	1 January 2100	Raw
Px Count	L CCI Picklist table L CCI Component table	date	not entered	The type of a CCI procedure (comorbid, admit or acquired)	1 January 1900	1 January 2100	Raw
Px Date	L CCI Picklist table L CCI Component table	date	not entered	The date/time of a CCI procedure	1 January 1900	1 January 2100	Raw
Px Type	L CCI Picklist table L CCI Component table	string	not entered	The type of a CCI Procedure as per CCI Collection, ie admit or acquired	1 January 1900	1 January 2100	Raw
R Complete	L Log table	boolean	not entered	true when patient registry data is complete	1 January 2000	31 December 2100	Raw
R Filter Field	L Log table	string	10	Critical care patients on a long term ventilator (LTV).	1 January 1900	1 January 2100	Raw
RR	L Log table	number	single	The patient's respiratory rate level in breaths/min.	1 January 1900	1 January 2100	Raw
Record	L Log table	string	8	Free choice use by collectors to help collection, this field has no consistent meaning.	1 January 1900	31 December 2100	Raw
RecordStatus field	L Log table	string	20	status of the data in the record. Possible values are complete, sent, questioned and vetted.	24 April 2013	1 January 2100	Raw
Registry Patient Type	N/A	string	10	Service of the attending physician for medicine data, and the type of admit diagnosis for critical care patients.	1 April 1997	9 May 2018	Raw
Room nr	L Log table	string	15	Legacy element that was never used consistently.	1 January 1900	31 December 2100	Raw
S dispo.loc type	S dispo table	string	20	Indeed, what is the description? Especially in contrast to S dispo.service type.	1 July 2016	1 January 2100	Raw
S dispo.service type	S dispo table	string	10	Indeed, what is the description? Especially in contrast to S dispo.loc_type.	1 July 2016	1 January 2100	Raw
SGPT ALT (labs)	L Labs Flowsheet table	integer	integer	SGPT_ALT contains the number of SGPTs and ALTs done during a patient's stay in our unit.	1 January 1900	1 January 2100	Raw
SentDtTm field	L Log table	date	not entered	Time the record was last sent.	1 January 1900	1 January 2100	Raw
Serum CO2	L Log table	number	single	The patient's Serum CO2 level in mmol/L.	1 January 1900	1 January 2100	Raw
Service/Location field	L Log table	number	long integer	Collection location a patient is admitted to.	1 July 2016	1 January 2100	Raw
Sex field	L Log table	string	7	Biological sex of the patient at birth; options are "male" and "female".	1 January 1900	1 January 2100	Raw
Spare1	L Pharm Flowsheet table	number	integer	spare1 contains manually collected doses of spare1 that were given.	1 January 1900	1 January 2100	Raw
Spare2	L Pharm Flowsheet table	number	integer	spare2 contains manually collected doses of spare2 that were given.	1 January 1900	1 January 2100	Raw
Spare3	L Pharm Flowsheet table	number	integer	spare3 contains manually collected doses of spare3 that were given.	1 January 1900	1 January 2100	Raw
Spare4	L Pharm Flowsheet table	number	integer	spare4 contains manually collected doses of spare4 that were given.	1 January 1900	1 January 2100	Raw
Spare5	L Pharm Flowsheet table	number	integer	spare5 contains manually collected doses of spare5 that were given.	1 January 1900	1 January 2100	Raw
Spare6	L Pharm Flowsheet table	number	integer	spare6 contains manually collected doses of spare6 that were given.	1 January 1900	1 January 2100	Raw
Sputum C+S	L Labs Flowsheet table	integer	integer	Contains the number of any sputum specimens (including endotracheal secretions) sent for "culture and sensitivity" for bacteria or fungus.	1 January 1900	1 January 2100	Raw
Start Date field	L Log table	date	not entered	Date the record was created on the data collector's laptop; created automatically by CCMDB.mdb.	25 February 2011	1 January 2100	Raw
Start Time field	L Log table	date	not entered	Time the record was created on the data collector's laptop; created automatically by CCMDB.mdb.	25 February 2011	1 January 2100	Raw
TR info status field	L Log table	string	19	Cross-check field that will contain data if Transfer_Ready_DtTm field is empty	5 May 2016	1 January 2100	Raw
Temperature	L Log table	number	single	The patient's Temperature level in °C.	1 January 1900	1 January 2100	Raw
Tigecyline	L Pharm Flowsheet table	number	integer	tigecyline contains manually collected doses of tigecyline that were given.	1 January 1900	1 January 2100	Raw
Tmp Complete	L Log table	boolean	not entered	True when patient Tmp data is complete	1 January 2000	31 December 2100	Raw
Transfer Delay	Created variables common	number	single	Transfer Delay is the difference between Dispo_DtTM and Transfer_Ready_DtTm in decimal days.	15 January 1999	1 January 2100	Created
Transfer Ready DtTm field	L Log table	date	not entered	Date and time the intent to discharge a patient to a lower level in the #hierarchy of levels of care was documented.	1 July 2016	1 January 2100	Raw
Troponin	L Labs Flowsheet table	integer	integer	Troponincontains the number of troponins done during a patient's stay in our unit.	1 January 1900	1 January 2100	Raw
Urine CS	L Labs Flowsheet table	integer	integer	Urine_CS contains the number of any urine specimens sent for "culture and sensitivity" for bacteria or fungus.	1 January 1900	1 January 2100	Raw
Vanco alternatives	L Pharm Flowsheet table	number	integer	vanco alternatives contains manually collected doses of vanco alternatives that were given.	1 January 1900	1 January 2100	Raw
Vancomycin	L Pharm Flowsheet table	number	integer	vancomycin contains manually collected doses of vancomycin that were given.	1 January 1900	1 January 2100	Raw
Visit Admit DtTm field	L Log table	date	not entered	The Visit Admit DtTm field contains the first entry in the visit location history in EPR for current visit at a hospital site.	1 January 2003	1 January 2100	Raw
Voluven	L Labs Flowsheet table	integer	integer	Voluven contains the number of doses or Voluven that were given while in the unit.	1 January 1900	12 June 2014	Raw
WBC	L Log table	number	single	The patient's White Blood Count level in x109/L.	1 January 1900	1 January 2100	Raw