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.

Work in progress, all articles need to be updated for this to work. See #field list

data fields

by link

Data fields

by list

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
Data fields

L_Log

Pat_ID]]

Pat_ID 

Last Name (LastName)

Last Name 

First Name(FirstName)

First Name 

PHIN

PHIN 

Date of Birth(Birth)

Date of Birth 

Chart

Chart 

Start time(start_Time)

Start time 

Start date(start_Date)

Start date 

Notes field(Notes)

Notes field 

DC Treatment (R_dc_treat)

DC Treatment 

Province Field (R_Province)

Province Field 

Sex field (R_Sex)

Sex field 

Registry Patient Type (R_Type)

Registry Patient Type 

Last Opened field (LastOpened_DtTm)

Last Opened field 

Pre acute living situation field

Pre acute living situation field 

Pre-admit Inpatient Institution field

Pre-admit Inpatient Institution field 

Previous Location field

Previous Location field 

Previous Service field

Previous Service field 

Off ward field

Off ward field 

Service/Location field

Service/Location field 

Dispo field

Dispo field 

Visit Admit DtTm field

Visit Admit DtTm field 

Accept_DtTm field

Accept_DtTm field 

Arrive_DtTm field

Arrive_DtTm field 

Dispo_DtTm field

Dispo_DtTm field 

Transfer_Ready_DtTm field

Transfer_Ready_DtTm field 

TR_info_status field

TR_info_status field 

ADL

ADL General Collection Information 

Fields:

• ADL_Bathing
• ADL_Dressing
• ADL_Toileting
• ADL_Transfering
• ADL_Continence
• ADL_Feeding

Apache fields

Admit Type for APACHE II (Ap_AdmitType)

Admit Type for APACHE II 

Chronic Health APACHE (Ap_Chronic)

Chronic Health APACHE 

Temperature (Ap_Temp)

Temperature  

SAPS BP Field (Ap_SapsSysBP)

SAPS BP Field 

AP Sys BP Field (Ap_APSysBP)

AP Sys BP Field 

AP Dias BP Field (Ap_APDiasBP)

AP Dias BP Field 

HR (Ap_HeartRate)

HR 

RR (Ap_RespRate)

RR 

Glasgow Coma Scale

Glasgow Coma Scale 

Fields:

• Ap_Eye
• Ap_Motor
• Ap_Verbal

FiO2 (Ap_FIO2)

FiO2 

PO2 Ap_PO2

PO2 

CO2 Ap_CO2

CO2 

pH (Ap_pH)

pH 

Serum CO2 (Ap_SerCO2)

Serum CO2 

Na (Ap_Na)

Na 

K Ap_K

K 

HCT (Ap_Hemat)

HCT 

WBC Ap_WBC

WBC 

Creatinine (Ap_Creat)

Creatinine  

ARF (APACHE) (Ap_ARF)

ARF (APACHE) 

Administrative fields

Final Check

Final Check 

R_Complete

 R_Complete 

ADL_Complete

 ADL_Complete 

Ap_Complete

 Ap_Complete 

ApLab_Complete

 ApLab_Complete 

Labs_Complete

 Labs_Complete 

Tmp_Complete

 Tmp_Complete 

Como_Complete

 Como_Complete 

Diag_Complete

 Diag_Complete 

Pharm_Complete

 Pharm_Complete 

Pharm_Flow_Complete

 Pharm_Flow_Complete 

Record

 Record 

Room_nr

 Room_nr 

RecordStatus

 RecordStatus 

LastChanged_DtTm

 LastChanged_DtTm 

[[pharm_* entries

For the following fields see Category:Pharmacy:

• pharm_Vitamin K antagonists
• pharm_Heparin cont inf
• pharm_Direct thrombin inhibitors
• pharm_Heparinoids
• pharm_Factor Xa inhibitors
• pharm_Dopamine cont inf
• pharm_Dobutamine cont inf
• pharm_Norepinephrine cont inf
• pharm_Epinephrine cont inf
• pharm_Phenylephrine cont inf
• pharm_Vasopressin cont inf
• pharm_Milrinone cont inf
• pharm_Paralytics cont inf
• pharm_corticosteroids
• pharm_amphotericin B
• pharm_macrolides
• pharm_1st or 2nd generation cephalosporins
• pharm_4th generation cephalosporins
• pharm_antistaph penicillins
• pharm_aminoglycosides
• pharm_influenza drugs
• pharm_bosentan
• pharm_viagra-type vasodilators
• pharm_special upper GI bleeding agents
• pharm_amiodarones
• pharm_anti-TB drugs
• pharm_statins
• pharm_PPI
• pharm_H2_blockers
• pharm_furosemide
• pharm_heparin_sq
• pharm_LMWH
• pharm_benzodiazepines
• pharm_opioids
• pharm_propofol
• pharm_insulin

pre-2016 Time and Place changes fields

R_Location

 R_Location 

R_AdmitFrom

 R_AdmitFrom 

R_DischargedTo

 R_DischargedTo 

R_HospitalPrevious

 R_HospitalPrevious 

R_SurviveExpire

 R_SurviveExpire 

R_AdmDate

 R_AdmDate 

R_AdmTime

 R_AdmTime 

R_TRDate

 R_TRDate 

R_TRTime

 R_TRTime 

R_DisDate

 R_DisDate 

R_DisTime

 R_DisTime 

R_Filter

 R_Filter 

Var1

 Var1 

Var2

 Var2 

Var3

 Var3 

Var4

 Var4 

Var5

 Var5 

Var6

 Var6 

Postal Code field

Postal Code field