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	ElementDescription	DataElementStartDate	DataElementEndDate	FieldCreatedRaw
3rd generation cephalosporins	L_Pharm_Flowsheet table	number	integer		20 October 2011	11 March 2013	Raw
ADL Bathing	L_Log table	string	15		1 October 2003	1 January 2100	Raw
ADL Complete	L_Log table	boolean	not entered		1 January 2000	31 December 2100	Raw
ADL Continence	L_Log table	string	15		1 October 2003	1 January 2100	Raw
ADL Dressing	L_Log table	string	15		1 October 2003	1 January 2100	Raw
ADL Feeding	L_Log table	string	15		1 October 2003	1 January 2100	Raw
ADL Toiletting	L_Log table	string	15		1 October 2003	1 January 2100	Raw
ADL Transfering	L_Log table	string	15		1 October 2003	1 January 2100	Raw
AP Dias BP Field	L_Log table	number	single		11 July 1988	1 January 2100	Raw
AP Eye field	L_Log table	string	13		11 July 1988	1 January 2100	Raw
AP Motor field	L_Log table	string	19		11 July 1988	1 January 2100	Raw
AP Sys BP Field	L_Log table	number	single		11 July 1988	1 January 2100	Raw
AP Verbal field	L_Log table	string	26		11 July 1988	1 January 2100	Raw
ARF (APACHE)	L_Log table	number	single		11 July 1988	1 January 2100	Raw
AaDO2	N/A	number	N/A		11 July 1988	1 January 2100	Created
Abdominal ultrasound	L_Labs_Flowsheet table	integer	integer		11 July 1988	31 December 2018	Raw
Accept DtTm field	L_Log table	date	not entered		1 July 2016	22 April 2022	Raw
Accept DtTm missing field	L_Log table	boolean	not entered		1 July 2016	22 April 2022	Raw
Admit Type for APACHE II	L_Log table	string	10		11 July 1988	1 January 2100	Raw
Age	Created Variables Common 2021 table Created Variables CC 2021 table	number			11 July 1988	1 January 2100	Created
Albumin 25pct	L_Labs_Flowsheet table	integer	integer		11 July 1988	31 December 2018	Raw
Albumin 5pct	L_Labs_Flowsheet table	integer	integer		11 July 1988	31 December 2018	Raw
Angio coronary field	L_Labs_Flowsheet table	integer	integer		11 July 1988	3 April 2017	Raw
Angio others field	L_Labs_Flowsheet table	integer	integer		11 July 1988	3 April 2017	Raw
Antipseudomonals	L_Pharm_Flowsheet table	number	integer		11 July 1988	1 January 2100	Raw
Ap Complete	L_Log table	boolean	not entered		1 January 2000	31 December 2100	Raw
Ap SapsSysBP field	L_Log table	number	long integer		11 July 1988	13 May 2014	Raw
Arrive DtTm field	N/A	date	not entered		1 July 2016	22 April 2022	Raw
Arterial blood gas (labs)	L_Labs_Flowsheet table	integer	long		11 July 1988	31 December 2018	Raw
Azoles	L_Pharm_Flowsheet table	number	integer		11 July 1988	1 January 2100	Raw
Benzodiazepines cont inf	L_Pharm_Flowsheet table	number	integer		29 November 2011	13 May 2014	Raw
Blood culture	L_Labs_Flowsheet table	not entered	integer			17 March 2017	Raw
CBC	L_Labs_Flowsheet table	integer	integer		11 July 1988	31 December 2018	Raw
CCI 1 Code	N/A	number	long integer		1 January 2019	1 January 2100	Raw
CCI 2 Code	N/A	number	long integer		1 January 2019	1 January 2100	Raw
CCI Picklist Code	L_CCI_Picklist table	string	20		1 January 2019	1 January 2100	Raw
CT Scan (labs)	L_Labs_Flowsheet table	integer	integer		11 July 1988	31 December 2018	Raw
CXR	L_Labs_Flowsheet table	integer	integer		11 July 1988	31 December 2018	Raw
Carbapenems	L_Pharm_Flowsheet table	number	integer		11 July 1988	1 January 2100	Raw
Ceftazidime	L_Pharm_Flowsheet table	number	integer		2 January 2012	8 March 2013	Raw
Chart number	L_Log table L_PHI table	string	8		11 July 1988	1 January 2100	Raw
Chronic Health APACHE	L_Log table	string	30			17 February 2022	Raw
ClientGUID field	L_Log table	string	16		29 August 2022	1 January 2100	Raw
ClientVisitGUID field	L_Log table	string	16		29 August 2022	1 January 2100	Raw
Como Complete	L_Log table	boolean	not entered		1 January 2000	31 December 2100	Raw
Creatinine (APACHE)	L_Log table	number	single		11 July 1988	1 January 2100	Raw
Creatinine (labs)	L_Labs_Flowsheet table	integer	integer		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	string	18		11 July 1988	1 January 2100	Raw
DC Treatment	L_Log table	string	50		11 July 1988	10 May 2022	Raw
Date of Birth	L_Log table L_PHI table	date	not entered		11 July 1988	1 January 2100	Raw
Diag Complete	L_Log table	boolean	not entered		1 January 2000	31 December 2100	Raw
Dispo DtTm field	L_Log table	date	not entered		1 July 2016	1 January 2100	Raw
Dispo field	L_Log table	number	long		1 July 2016	1 January 2100	Raw
Dx Date	L_ICD10 table	date	not entered		11 July 1988	1 January 2100	Raw
Dx Date unknown	L_ICD10 table	boolean	not entered		11 July 1988	1 January 2100	Raw
Dx Primary	L_ICD10 table	boolean	not entered		11 July 1988	1 January 2100	Raw
Dx Priority	L_ICD10 table	number	single		11 July 1988	1 January 2100	Raw
Dx Type	L_ICD10 table	string	8		11 July 1988	1 January 2100	Raw
ER Delay	Created Variables Common 2021 table	date	n/a		11 July 1988	1 January 2100	Created
Echocardiogram	L_Labs_Flowsheet table	number	integer		11 July 1988	31 December 2018	Raw
FFP	L_Labs_Flowsheet table	integer	integer		11 July 1988	31 December 2018	Raw
FiO2	L_Log table	number	single		11 July 1988	1 January 2100	Raw
FirstName field	L_Log table L_PHI table	string	40		11 July 1988	1 January 2100	Raw
Fluoroquinolones	L_Pharm_Flowsheet table	number	integer		11 July 1988	1 January 2100	Raw
Fungins	L_Pharm_Flowsheet table	number	integer		11 July 1988	1 January 2100	Raw
Furosemide cont inf	L_Pharm_Flowsheet table	number	integer		21 December 2011	9 May 2014	Raw
GCS sedated field	L_Log table	boolean	not entered		22 September 2016	15 June 2021	Raw
H2-Blockers	L_Pharm_Flowsheet table	number	integer		24 December 2009	12 May 2014	Raw
HCT	L_Log table	number	single		11 July 1988	1 January 2100	Raw
HR	L_Log table	number	single		11 July 1988	1 January 2100	Raw
Heparin SQ	L_Pharm_Flowsheet table	number	integer		28 November 2011	13 May 2014	Raw
Hospitalization ID	L_Log table L_Person table	number	long integer		11 July 1988	1 January 2100	Created
ICD10 code	L_ICD10 table s_ICD10 table	string	10		11 July 1988	1 January 2100	Raw
Insulin cont inf	L_Pharm_Flowsheet table	number	integer		6 December 2011	13 May 2014	Raw
K	L_Log table	number	single		11 July 1988	1 January 2100	Raw
L ICD10 ID	L_ICD10 table	number	long		11 July 1988	1 January 2100	Raw
LMWH	L_Pharm_Flowsheet table	number	integer		6 December 2011	31 December 2011	Raw
Labs Complete	L_Log table	boolean	not entered		1 January 2000	31 December 2100	Raw
LastChanged DtTm field	L_Log table	date	not entered		6 January 2021	31 December 2999	Raw
LastName field	L_Log table L_PHI table	string	40		11 July 1988	1 January 2100	Raw
LastOpened DtTm field	L_Log table	date	not entered		14 April 2016	1 January 2100	Raw
MRI (labs)	L_Labs_Flowsheet table	integer	integer		11 July 1988	31 December 2018	Raw
Magnesium (labs)	L_Labs_Flowsheet table	integer	integer		11 July 1988	31 December 2018	Raw
Mean BP	Created Variables CC 2021 table	number	single		11 July 1988	1 January 2100	Created
Na	L_Log table	number	single		11 July 1988	1 January 2100	Raw
Notes field	L_Log table	memo	not entered		11 July 1988	1 January 2100	Raw
Notes field (L PHI)	L_PHI table	string	not entered		11 July 1988	1 January 2100	Raw
Off ward field	L_Log table	number	long integer		1 July 2016	29 January 2020	Raw
Opioids cont inf	L_Pharm_Flowsheet table	number	integer		6 December 2011	13 May 2014	Raw
PCO2	L_Log table	number	single		11 July 1988	1 January 2100	Raw
PH	L_Log table	number	single		11 July 1988	1 January 2100	Raw
PHIN field	L_Log table L_PHI table	number	Long Integer		11 July 1988	1 January 2100	Raw
PO2	L_Log table	number	single		11 July 1988	1 January 2100	Raw
PPI	L_Pharm_Flowsheet table	number	integer		12 September 2011	12 May 2014	Raw
PT PTT	L_Labs_Flowsheet table	integer	integer		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	number	Long Integer		11 July 1988	1 January 2100	Raw
Pentaspan	L_Labs_Flowsheet table	integer	integer			12 June 2014	Raw
Person ID field	L_Log table L_Person table	number	long integer		11 July 1988	1 January 2100	Created
Pharm 1st or 2nd generation cephalosporins	L_Log table	boolean	not entered		1 January 2012	7 August 2013	Raw
Pharm 4th generation cephalosporins	L_Log table	boolean	not entered		1 January 2012	28 February 2013	Raw
Pharm Complete	L_Log table	boolean	not entered		1 January 2000	31 December 2100	Raw
Pharm Direct thrombin inhibitors	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm Dobutamine cont inf	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm Dopamine cont inf	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm Epinephrine cont inf	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm Factor Xa inhibitors	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm H2 blockers	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm Heparin cont inf	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm Heparinoids	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm LMWH	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm Milrinone cont inf	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm Norepinephrine cont inf	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm PPI	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm Paralytics cont inf	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm Phenylephrine cont inf	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm Vasopressin cont inf	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm Vitamin K antagonists field	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm aminoglycosides	L_Log table	boolean	not entered		1 January 2012	5 March 2013	Raw
Pharm amiodarones	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm amphotericin B	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm anti-TB drugs	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm antistaph penicillins	L_Log table	boolean	not entered		1 January 2012	19 February 2013	Raw
Pharm benzodiazepines	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm bosentan	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm corticosteroids	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm furosemide	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm heparin sq	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm influenza drugs	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm insulin	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm macrolides	L_Log table	boolean	not entered		1 January 2012	17 March 2013	Raw
Pharm opioids	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm propofol	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm special upper GI bleeding agents	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm statins	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Pharm viagra-type vasodilators	L_Log table	boolean	not entered		1 January 2012	1 January 2100	Raw
Platelets	L_Labs_Flowsheet table	integer	integer		11 July 1988	31 December 2018	Raw
Postal Code field	L_Log table	string	6		1 January 2012	1 January 2100	Raw
Pre acute living situation field	L_Log table	number	long integer		1 July 2016	1 January 2100	Raw
Pre-admit Inpatient Institution field	L_Log table	number	long integer		1 July 2016	1 January 2100	Raw
Previous Location field	L_Log table	number	long integer		1 July 2016	1 January 2100	Raw
Previous Service field	L_Log table	number	long integer		1 July 2016	7 September 2022	Raw
Propofol cont inf	L_Pharm_Flowsheet table	number	integer		6 December 2011	13 May 2014	Raw
Province field	L_Log table	string	2		11 July 1988	1 January 2100	Raw
Px Count	L CCI Component table L_CCI_Picklist table	date	not entered		11 July 1988	1 January 2100	Raw
Px Date	L CCI Component table L_CCI_Picklist table	date	not entered		11 July 1988	1 January 2100	Raw
Px Type	L CCI Component table L_CCI_Picklist table	string	not entered		11 July 1988	1 January 2100	Raw
R Complete	L_Log table	boolean	not entered		1 January 2000	31 December 2100	Raw
R Filter Field	L_Log table	string	10		11 July 1988	1 January 2019	Raw
RR	L_Log table	number	single		11 July 1988	1 January 2100	Raw
Record	L_Log table	string	8		1 January 1900	31 December 2100	Raw
RecordStatus field	L_Log table	string	20		24 April 2013	1 January 2100	Raw
Registry Patient Type	N/A	string	10		1 April 1997	9 May 2018	Raw
SGPT ALT (labs)	L_Labs_Flowsheet table	integer	integer		11 July 1988	17 March 2017	Raw
SentDtTm field	L_Log table	date	not entered		11 July 1988	1 January 2100	Raw
Serum CO2	L_Log table	number	single		11 July 1988	1 January 2100	Raw
Service/Location field	L_Log table	number	long integer		1 July 2016	1 January 2100	Raw
Sex field	L_Log table	string	7		11 July 1988	1 January 2100	Raw
Spare1	L_Pharm_Flowsheet table	number	integer		8 December 2012	8 December 2012	Raw
Spare2	L_Pharm_Flowsheet table	number	integer		8 December 2012	8 December 2012	Raw
Spare3	L_Pharm_Flowsheet table	number	integer		8 December 2012	8 December 2012	Raw
Spare4	L_Pharm_Flowsheet table	number	integer		8 December 2012	8 December 2012	Raw
Spare5	L_Pharm_Flowsheet table	number	integer		8 December 2012	8 December 2012	Raw
Spare6	L_Pharm_Flowsheet table	number	integer		8 December 2012	8 December 2012	Raw
Sputum C+S	L_Labs_Flowsheet table	integer	integer		11 July 1988	17 March 2017	Raw
Start Date field	L_Log table	date	not entered		25 February 2011	1 January 2100	Raw
Start Time field	L_Log table	date	not entered		25 February 2011	1 January 2100	Raw
TR info status field	L_Log table	string	19		5 May 2016	15 October 2020	Raw
Temperature	L_Log table	number	single		11 July 1988	1 January 2100	Raw
Tigecyline	L_Pharm_Flowsheet table	number	integer		21 July 2012	26 August 2012	Raw
Tmp Complete	L_Log table	boolean	not entered		1 January 2000	31 December 2100	Raw
Transfer Ready DtTm field	L_Log table	date	not entered		1 June 1999	15 October 2020	Raw
Troponin	L_Labs_Flowsheet table	integer	integer		11 July 1988	17 March 2017	Raw
Urine CS	L_Labs_Flowsheet table	integer	integer		11 July 1988	17 March 2017	Raw
Vanco alternatives	L_Pharm_Flowsheet table	number	integer		11 July 1988	1 January 2100	Raw
Vancomycin	L_Pharm_Flowsheet table	number	integer		11 July 1988	1 January 2100	Raw
Venous blood gas (labs)	L_Labs_Flowsheet table	integer	long		11 July 1988	31 December 2018	Raw
Visit Admit DtTm field	L_Log table	date	not entered		1 January 2003	1 January 2100	Raw
Voluven	L_Labs_Flowsheet table	integer	integer		11 July 1988	12 June 2014	Raw
WBC	L_Log table	number	single		11 July 1988	1 January 2100	Raw
s_dispo.loc_type	s_dispo table	string	20		1 July 2016	1 January 2100	Raw