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

	Table	Tab	Data type	length	Description	Start date	End date	Created vs raw
3rd generation cephalosporins	L_Pharm_Flowsheet table	Pharm	number	integer	3rd generation cephalosporins contains manually collected doses of 3rd generation cephalosporins that were given.	20 October 2011	11 March 2013	Raw
ADL Bathing	L_Log table	ADL	string	15	Need for help with bathing; component of ADL.	1 October 2003	1 January 2100	Raw
ADL Complete	L_Log table	Top Row	boolean	not entered	true when patient ADL data is complete	1 January 2000	31 December 2100	Raw
ADL Continence	L_Log table	ADL	string	15	Control of urination and bowel movements; component of ADL	1 October 2003	1 January 2100	Raw
ADL Dressing	L_Log table	ADL	string	15	Need for help with dressing; component of ADL.	1 October 2003	1 January 2100	Raw
ADL Feeding	L_Log table	ADL	string	15	Need for help with feeding; component of ADL	1 October 2003	1 January 2100	Raw
ADL Toiletting	L_Log table	ADL	string	15	Need for help with toiletting; component of ADL	1 October 2003	1 January 2100	Raw
ADL Transfering	L_Log table	ADL	string	15	Need for help with transferring; component of ADL	1 October 2003	1 January 2100	Raw
AP Dias BP Field	L_Log table	Apache	number	single	Ap_DiasBP is the diastolic blood pressure.	11 July 1988	1 January 2100	Raw
AP Eye field	L_Log table	Apache	string	13	The eye component of the Glasgow_Coma_Scale.	11 July 1988	1 January 2100	Raw
AP Motor field	L_Log table	Apache	string	19	The motor component of the Glasgow_Coma_Scale.	11 July 1988	1 January 2100	Raw
AP Sys BP Field	L_Log table	Apache	number	single	Ap_SysBP is the systolic blood pressure.	11 July 1988	1 January 2100	Raw
AP Verbal field	L_Log table	Apache	string	26	The verbal component of the Glasgow_Coma_Scale.	11 July 1988	1 January 2100	Raw
ARF (APACHE)	L_Log table	Apache	number	single	The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.	11 July 1988	1 January 2100	Raw
AaDO2	N/A	Apache	number	N/A	The patient's Alveolar-arterial oxygen tension difference level in .	11 July 1988	1 January 2100	Created
Abdominal ultrasound	L_Labs_Flowsheet table	Lab	integer	integer	Contains the number of abdominal ultrasounds a client has had during an admission to our unit.	11 July 1988	31 December 2018	Raw
Accept DtTm field	L_Log table	not stated	date	not entered	First Service tmp entry DtTm for pts who came from the ER department only	1 July 2016	22 April 2022	Raw
Accept DtTm missing field	L_Log table	not stated	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	22 April 2022	Raw
Admit Type for APACHE II	L_Log table	Apache	string	10	The Admit Type for APACHE II is a way to classify patients' surgical status and one of the elements used to generate the APACHE score.	11 July 1988	1 January 2100	Raw
Age	Created Variables Common 2021 table Created Variables CC 2021 table	not stated	number		The number of years between Date of Birth and the last birthday prior to or on (Admit DtTm otherwise).	11 July 1988	1 January 2100	Created
Albumin 25pct	L_Labs_Flowsheet table	Lab	integer	integer	Albumin_25pct contains number of doses of 25% Albumin that were given.	11 July 1988	31 December 2018	Raw
Albumin 5pct	L_Labs_Flowsheet table	Lab	integer	integer	Albumin_5pct contains the number of doses of 5% Albumin that were given.	11 July 1988	31 December 2018	Raw
Angio coronary field	L_Labs_Flowsheet table	Lab	integer	integer	Angio coronary contained the manually counted number of coronary angiograms done during a stay in our unit, or on the way there.	11 July 1988	3 April 2017	Raw
Angio others field	L_Labs_Flowsheet table	Lab	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.	11 July 1988	3 April 2017	Raw
Antipseudomonals	L_Pharm_Flowsheet table	Pharm	number	integer	antipseudomonals contains manually collected doses of antipseudomonals that were given.	11 July 1988	1 January 2100	Raw
Ap Complete	L_Log table	Top Row	boolean	not entered	True when patient APACH II data is complete	1 January 2000	31 December 2100	Raw
Ap SapsSysBP field	L_Log table	not stated	number	long integer		11 July 1988	13 May 2014	Raw
Arrive DtTm field	N/A	Dispo	date	not entered	First non-ER Boarding location date and time, or start of ( Service Location) for legacy records.	1 July 2016	22 April 2022	Raw
Arterial blood gas (labs)	L_Labs_Flowsheet table	Lab	integer	long	ABG contains manually collected arterial blood gas counts.	11 July 1988	31 December 2018	Raw
Azoles	L_Pharm_Flowsheet table	Pharm	number	integer	azoles contains manually collected doses of azoles that were given.	11 July 1988	1 January 2100	Raw
Benzodiazepines cont inf	L_Pharm_Flowsheet table	Pharm	number	integer	benzodiazepines cont inf contains manually collected doses of benzodiazepines cont inf that were given.	29 November 2011	13 May 2014	Raw
Blood culture	L_Labs_Flowsheet table	Lab	not entered	integer	Contains the number of blood cultures a patient has had during an admission to our unit.		17 March 2017	Raw
CBC	L_Labs_Flowsheet table	Lab	integer	integer	CBC contains the number of CBCs done during a patient's stay in our unit.	11 July 1988	31 December 2018	Raw
CCI 1 Code	N/A	CCI	number	long integer	The unique identifier/index of CCI Procedure's first component in s_CCI_1 table.	1 January 2019	1 January 2100	Raw
CCI 2 Code	N/A	CCI	number	long integer	The unique identifier/index of CCI Procedure's second component in s_CCI_2 table.	1 January 2019	1 January 2100	Raw
CCI Picklist Code	L_CCI_Picklist table	CCI	string	20	The CCI code for and entry in the L CCI Picklist subform, from s_CCI_Picklist table.	1 January 2019	1 January 2100	Raw
CT Scan (labs)	L_Labs_Flowsheet table	Lab	integer	integer	CT_Scan contains the manually counted number of CT scans done during a patient's stay in our unit.	11 July 1988	31 December 2018	Raw
CXR	L_Labs_Flowsheet table	Lab	integer	integer	Chest Xrays (CXR) contains the manually counted number of chest xrays (CXR) done during a patient's stay in our unit.	11 July 1988	31 December 2018	Raw
Carbapenems	L_Pharm_Flowsheet table	Pharm	number	integer	carbapenems contains manually collected doses of carbapenems that were given.	11 July 1988	1 January 2100	Raw
Ceftazidime	L_Pharm_Flowsheet table	Pharm	number	integer	ceftazidime contains manually collected doses of ceftazidime that were given.	2 January 2012	8 March 2013	Raw
Chart number	L_Log table L_PHI table	Top Row	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.	11 July 1988	1 January 2100	Raw
Chronic Health APACHE	L_Log table	Apache	string	30	Specific chronic pre-existing conditions used for APACHE score.		17 February 2022	Raw
ClientGUID field	L_Log table	not stated	string	16	The unique person identifier from Cognos.	29 August 2022	1 January 2100	Raw
ClientVisitGUID field	L_Log table	not stated	string	16	Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data.	29 August 2022	1 January 2100	Raw
Como Complete	L_Log table	Top Row	boolean	not entered	True when patient comorbid diagnosis data is complete	1 January 2000	31 December 2100	Raw
Creatinine (APACHE)	L_Log table	Apache	number	single	The patient's level in .	11 July 1988	1 January 2100	Raw
Creatinine (labs)	L_Labs_Flowsheet table	Lab	integer	integer	Creatinine contains the number of creatinines done during a patient's stay in our unit.	11 July 1988	17 March 2017	Raw
D ID field	L_Log table L_Labs_Flowsheet table L_Pharm_Flowsheet table L_PHI table L_TISS_Form table L_TISS_Item table L TISS76 table L_Labs_DSM table L_ICD10 table L_PCH table L CCI Component table L_CCI_Picklist table L Como table L_Dxs table L_TmpV2 table	not stated	string	18	The unique identifier/index of records in the Critical Care and Medicine Database.	11 July 1988	1 January 2100	Raw
DC Treatment	L_Log table	not stated	string	50	"DC" for critical care patients if life-support treatment is terminated, blank for all others.	11 July 1988	10 May 2022	Raw
Date of Birth	L_Log table L_PHI table	Top Row	date	not entered	Date of Birth (DOB) is the data a patient was born.	11 July 1988	1 January 2100	Raw
Diag Complete	L_Log table	Top Row	boolean	not entered	True when patient diagnosis data is complete	1 January 2000	31 December 2100	Raw
Dispo DtTm field	L_Log table	Dispo	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	Dispo	number	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	ICD10	date	not entered	The date/time of an ICD10 diagnosis.	11 July 1988	1 January 2100	Raw
Dx Date unknown	L_ICD10 table	ICD10	boolean	not entered	True for Acquired Diagnosis / Complication when Dx Date legitimately missing.	11 July 1988	1 January 2100	Raw
Dx Primary	L_ICD10 table	ICD10	boolean	not entered	Checkbox that is set to true for a single Admit Diagnosis per ward stay that is the Primary Admit Diagnosis	11 July 1988	1 January 2100	Raw
Dx Priority	L_ICD10 table	ICD10	number	single	The priority of an ICD10 diagnosis, used to rank and group.	11 July 1988	1 January 2100	Raw
Dx Type	L_ICD10 table	ICD10	string	8	The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication)	11 July 1988	1 January 2100	Raw
ER Delay	Created Variables Common 2021 table	not stated	date	n/a	The ER Delay is the difference between the pre-ER Boarding Loc and first post-ER Boarding Loc, for patients arriving from the ER.	11 July 1988	1 January 2100	Created
Echocardiogram	L_Labs_Flowsheet table	Lab	number	integer	Contains the number of heart ultrasounds (echocardiograms) a client has had during an admission to our unit.	11 July 1988	31 December 2018	Raw
FFP	L_Labs_Flowsheet table	Lab	integer	integer	Fresh Frozen Plasma / FFP contains manually collected doses of FFP that were given.	11 July 1988	31 December 2018	Raw
FiO2	L_Log table	Apache	number	single	FIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient.	11 July 1988	1 January 2100	Raw
FirstName field	L_Log table L_PHI table	Top Row	string	40	Last Name of patient	11 July 1988	1 January 2100	Raw
Fluoroquinolones	L_Pharm_Flowsheet table	Pharm	number	integer	fluoroquinolones contains manually collected doses of fluoroquinolones that were given.	11 July 1988	1 January 2100	Raw
Fungins	L_Pharm_Flowsheet table	Pharm	number	integer	fungins contains manually collected doses of fungins that were given.	11 July 1988	1 January 2100	Raw
Furosemide cont inf	L_Pharm_Flowsheet table	Pharm	number	integer	furosemide cont inf contains manually collected doses of furosemide cont inf that were given.	21 December 2011	9 May 2014	Raw
GCS sedated field	L_Log table	Apache	boolean	not entered	Field does not contain any relevant data.	22 September 2016	15 June 2021	Raw
H2-Blockers	L_Pharm_Flowsheet table	Pharm	number	integer	H2-Blockers contains manually collected doses of H2-Blockers that were given.	24 December 2009	12 May 2014	Raw
HCT	L_Log table	Apache	number	single	The patient's hematocrit level in percentage.	11 July 1988	1 January 2100	Raw
HR	L_Log table	Apache	number	single	The patient's Heart Rate level in beats/min.	11 July 1988	1 January 2100	Raw
Heparin SQ	L_Pharm_Flowsheet table	Pharm	number	integer	Heparin SQ contains manually collected doses of Heparin SQ that were given.	28 November 2011	13 May 2014	Raw
Hospitalization ID	L_Log table L_Person table	not stated	number	long integer	Not currently used	11 July 1988	1 January 2100	Created
ICD10 code	L_ICD10 table s_ICD10 table	ICD10	string	10	The actual ICD10 code.	11 July 1988	1 January 2100	Raw
Insulin cont inf	L_Pharm_Flowsheet table	Pharm	number	integer	insulin cont inf contains manually collected doses of insulin cont inf that were given.	6 December 2011	13 May 2014	Raw
K	L_Log table	Apache	number	single	The patient's Potassium level in mmol/L.	11 July 1988	1 January 2100	Raw
L ICD10 ID	L_ICD10 table	ICD10	number	long	Unique identifier of the L_ICD10 table	11 July 1988	1 January 2100	Raw
LMWH	L_Pharm_Flowsheet table	Pharm	number	integer	LMWH contains manually collected doses of LMWH that were given.	6 December 2011	31 December 2011	Raw
Labs Complete	L_Log table	Top Row	boolean	not entered	True when patient Labs data is complete	1 January 2000	31 December 2100	Raw
LastChanged DtTm field	L_Log table	Top Row	date	not entered	Last time the record was closed with the "Close - with updates" button	6 January 2021	31 December 2999	Raw
LastName field	L_Log table L_PHI table	Top Row	string	40	Last Name of patient	11 July 1988	1 January 2100	Raw
LastOpened DtTm field	L_Log table	not stated	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.	14 April 2016	1 January 2100	Raw
MRI (labs)	L_Labs_Flowsheet table	Lab	integer	integer	MRI contains the manually counted number of MRIs done during a patient's stay in our unit.	11 July 1988	31 December 2018	Raw
Magnesium (labs)	L_Labs_Flowsheet table	Lab	integer	integer	Magnesium contains the number of magnesiums done during a patient's stay in our unit.	11 July 1988	31 December 2018	Raw
Mean BP	Created Variables CC 2021 table	Apache	number	single	Mean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3)	11 July 1988	1 January 2100	Created
Na	L_Log table	Apache	number	single	The patient's Sodium level in mmol/L.	11 July 1988	1 January 2100	Raw
Notes field	L_Log table	Top Row	memo	not entered	Used by data collectors to keep notes during collection.	11 July 1988	1 January 2100	Raw
Notes field (L PHI)	L_PHI table	not stated	string	not entered	Notes in L_PHI table is used by the data processor to comment on data ad-hoc where needed.	11 July 1988	1 January 2100	Raw
Off ward field	L_Log table	Dispo	number	long integer	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.	1 July 2016	29 January 2020	Raw
Opioids cont inf	L_Pharm_Flowsheet table	Pharm	number	integer	opioids cont inf contains manually collected doses of opioids cont inf that were given.	6 December 2011	13 May 2014	Raw
PCO2	L_Log table	Apache	number	single	PCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L.	11 July 1988	1 January 2100	Raw
PH	L_Log table	Apache	number	single	The acidity or basicity of the patient's arterial blood.	11 July 1988	1 January 2100	Raw
PHIN field	L_Log table L_PHI table	Top Row	number	Long Integer	The patient's PHIN .	11 July 1988	1 January 2100	Raw
PO2	L_Log table	Apache	number	single	PO2 is the partial pressure of oxygen in the patient's arterial blood.	11 July 1988	1 January 2100	Raw
PPI	L_Pharm_Flowsheet table	Pharm	number	integer	PPI contains manually collected doses of PPI that were given.	12 September 2011	12 May 2014	Raw
PT PTT	L_Labs_Flowsheet table	Lab	integer	integer	PT_PTT contains the number of PTs and PTTs done during a patient's stay in our unit.	11 July 1988	17 March 2017	Raw
Pat ID field	L_Log table L_Labs_Flowsheet table L_Pharm_Flowsheet table L_PHI table L_TISS_Form table L_TISS_Item table L_ICD10 table L_PCH table L CCI Component table L_CCI_Picklist table L Como table L_Dxs table L_TmpV2 table	Top Row	number	Long Integer	The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number.	11 July 1988	1 January 2100	Raw
Pentaspan	L_Labs_Flowsheet table	Lab	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_Log table L_Person table	not stated	number	long integer	Unique random number id per patient that combines the D_IDs across admissions/encounters.	11 July 1988	1 January 2100	Created
Pharm 1st or 2nd generation cephalosporins	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	7 August 2013	Raw
Pharm 4th generation cephalosporins	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	28 February 2013	Raw
Pharm Complete	L_Log table	Top Row	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	Pharm	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	Pharm	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	Pharm	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	Pharm	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	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm H2 blockers	L_Log table	Pharm	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	Pharm	boolean	not entered	True if a continuous infusion of Heparin was given	1 January 2012	1 January 2100	Raw
Pharm Heparinoids	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm LMWH	L_Log table	Pharm	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	Pharm	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	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm PPI	L_Log table	Pharm	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	Pharm	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	Pharm	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	Pharm	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	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm aminoglycosides	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	5 March 2013	Raw
Pharm amiodarones	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm amphotericin B	L_Log table	Pharm	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	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm antistaph penicillins	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	19 February 2013	Raw
Pharm benzodiazepines	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm bosentan	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm corticosteroids	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm furosemide	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm heparin sq	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm influenza drugs	L_Log table	Pharm	boolean	not entered	True if influenza drugs were given	1 January 2012	1 January 2100	Raw
Pharm insulin	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm macrolides	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	17 March 2013	Raw
Pharm opioids	L_Log table	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm propofol	L_Log table	Pharm	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	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Pharm statins	L_Log table	Pharm	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	Pharm	boolean	not entered	True if drug in field name was given	1 January 2012	1 January 2100	Raw
Platelets	L_Labs_Flowsheet table	Lab	integer	integer	Platelets contains number of doses of platelets that were given.	11 July 1988	31 December 2018	Raw
Postal Code field	L_Log table	Dispo	string	6	The patient's postal code.	1 January 2012	1 January 2100	Raw
Pre acute living situation field	L_Log table	Dispo	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	Dispo	number	long integer	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.	1 July 2016	1 January 2100	Raw
Previous Location field	L_Log table	Dispo	number	long integer	The most recent previous physical location (with #exceptions) of a patient before arriving at the collection location.	1 July 2016	1 January 2100	Raw
Previous Service field	L_Log table	Dispo	number	long integer	The most recent "originating service" which sends the patients to their current service location.	1 July 2016	7 September 2022	Raw
Propofol cont inf	L_Pharm_Flowsheet table	Pharm	number	integer	propofol cont inf contains manually collected doses of propofol cont inf that were given.	6 December 2011	13 May 2014	Raw
Province field	L_Log table	Dispo	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.	11 July 1988	1 January 2100	Raw
Px Count	L CCI Component table L_CCI_Picklist table	CCI	date	not entered	The type of a CCI procedure (comorbid, admit or acquired)	11 July 1988	1 January 2100	Raw
Px Date	L CCI Component table L_CCI_Picklist table	CCI	date	not entered	The date/time of a CCI procedure	11 July 1988	1 January 2100	Raw
Px Type	L CCI Component table L_CCI_Picklist table	CCI	string	not entered	The type of a CCI Procedure as per CCI Collection, ie admit or acquired	11 July 1988	1 January 2100	Raw
R Complete	L_Log table	Top Row	boolean	not entered	true when patient registry data is complete	1 January 2000	31 December 2100	Raw
R Filter Field	L_Log table	Dispo	string	10	Critical care patients on a long term ventilator (LTV).	11 July 1988	1 January 2019	Raw
RR	L_Log table	Apache	number	single	The patient's respiratory rate level in breaths/min.	11 July 1988	1 January 2100	Raw
Record	L_Log table	Top Row	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	Top Row	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	Dispo	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
SGPT ALT (labs)	L_Labs_Flowsheet table	Lab	integer	integer	SGPT_ALT contains the number of SGPTs and ALTs done during a patient's stay in our unit.	11 July 1988	17 March 2017	Raw
SentDtTm field	L_Log table	not stated	date	not entered	Time the record was last sent.	11 July 1988	1 January 2100	Raw
Serum CO2	L_Log table	Apache	number	single	The patient's Serum CO2 level in mmol/L.	11 July 1988	1 January 2100	Raw
Service/Location field	L_Log table	Dispo	number	long integer	Legacy field replaced by Boarding Loc and Service tmp entry	1 July 2016	1 January 2100	Raw
Sex field	L_Log table	Dispo	string	7	Biological sex of the patient at birth; options are "male" and "female".	11 July 1988	1 January 2100	Raw
Spare1	L_Pharm_Flowsheet table	Pharm	number	integer	spare1 contains manually collected doses of spare1 that were given.	8 December 2012	8 December 2012	Raw
Spare2	L_Pharm_Flowsheet table	Pharm	number	integer	spare2 contains manually collected doses of spare2 that were given.	8 December 2012	8 December 2012	Raw
Spare3	L_Pharm_Flowsheet table	Pharm	number	integer	spare3 contains manually collected doses of spare3 that were given.	8 December 2012	8 December 2012	Raw
Spare4	L_Pharm_Flowsheet table	Pharm	number	integer	spare4 contains manually collected doses of spare4 that were given.	8 December 2012	8 December 2012	Raw
Spare5	L_Pharm_Flowsheet table	Pharm	number	integer	spare5 contains manually collected doses of spare5 that were given.	8 December 2012	8 December 2012	Raw
Spare6	L_Pharm_Flowsheet table	Pharm	number	integer	spare6 contains manually collected doses of spare6 that were given.	8 December 2012	8 December 2012	Raw
Sputum C+S	L_Labs_Flowsheet table	Lab	integer	integer	Contains the number of any sputum specimens (including endotracheal secretions) sent for "culture and sensitivity" for bacteria or fungus.	11 July 1988	17 March 2017	Raw
Start Date field	L_Log table	not stated	date	not entered	Date the record was created on the data collector's laptop; created automatically by CCMDB.accdb.	25 February 2011	1 January 2100	Raw
Start Time field	L_Log table	not stated	date	not entered	Time the record was created on the data collector's laptop; created automatically by CCMDB.accdb.	25 February 2011	1 January 2100	Raw
TR info status field	L_Log table	Dispo	string	19	Cross-check field that will contain data if Transfer_Ready_DtTm field is empty	5 May 2016	15 October 2020	Raw
Temperature	L_Log table	Apache	number	single	The patient's Temperature level in °C.	11 July 1988	1 January 2100	Raw
Tigecyline	L_Pharm_Flowsheet table	Pharm	number	integer	tigecyline contains manually collected doses of tigecyline that were given.	21 July 2012	26 August 2012	Raw
Tmp Complete	L_Log table	Top Row	boolean	not entered	True when patient Tmp data is complete	1 January 2000	31 December 2100	Raw
Transfer Ready DtTm field	L_Log table	Dispo	date	not entered	Date and time the intent to discharge a patient to a lower level in the Level of care hierarchy was documented.	1 June 1999	15 October 2020	Raw
Troponin	L_Labs_Flowsheet table	Lab	integer	integer	Troponincontains the number of troponins done during a patient's stay in our unit.	11 July 1988	17 March 2017	Raw
Urine CS	L_Labs_Flowsheet table	Lab	integer	integer	Urine_CS contains the number of any urine specimens sent for "culture and sensitivity" for bacteria or fungus.	11 July 1988	17 March 2017	Raw
Vanco alternatives	L_Pharm_Flowsheet table	Pharm	number	integer	vanco alternatives contains manually collected doses of vanco alternatives that were given.	11 July 1988	1 January 2100	Raw
Vancomycin	L_Pharm_Flowsheet table	Pharm	number	integer	vancomycin contains manually collected doses of vancomycin that were given.	11 July 1988	1 January 2100	Raw
Venous blood gas (labs)	L_Labs_Flowsheet table	Lab	integer	long	VBG contains manually collected venous blood gas counts.	11 July 1988	31 December 2018	Raw
Visit Admit DtTm field	L_Log table	Dispo	date	not entered	This field is used only as an identifier to combine data from the same hospitalization and should not be used as a date.	1 January 2003	1 January 2100	Raw
Voluven	L_Labs_Flowsheet table	Lab	integer	integer	Voluven contains the number of doses or Voluven that were given while in the unit.	11 July 1988	12 June 2014	Raw
WBC	L_Log table	Apache	number	single	The patient's White Blood Count level in x109/L.	11 July 1988	1 January 2100	Raw
s_dispo.loc_type	s_dispo table		string	20	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.	1 July 2016	1 January 2100	Raw