Auto Data Dictionary

what is this?

This article generates a list of data fields in the critical care and medicine database using the template and Semantic Mediawiki.

Work in progress, all articles need to be updated for this to work.

data fields

by link

Data fields

by list

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

	InTable	FieldDataType	ElementDescription
3rd generation cephalosporins	L_Pharm_Flowsheet table	number
ADL Bathing	L_Log table	string
ADL Complete	L_Log table	boolean
ADL Continence	L_Log table	string
ADL Dressing	L_Log table	string
ADL Feeding	L_Log table	string
ADL Toiletting	L_Log table	string
ADL Transfering	L_Log table	string
AP Dias BP Field	L_Log table	number
AP Eye field	L_Log table	string
AP Motor field	L_Log table	string
AP Sys BP Field	L_Log table	number
AP Verbal field	L_Log table	string
ARF (APACHE)	L_Log table	number
AaDO2	N/A	number
Abdominal ultrasound	L_Labs_Flowsheet table	integer
Accept DtTm field	L_Log table	date
Accept DtTm missing field	L_Log table	boolean
Admit Type for APACHE II	L_Log table	string
Age	Created Variables Common 2021 table Created Variables CC 2021 table	number
Albumin 25pct	L_Labs_Flowsheet table	integer
Albumin 5pct	L_Labs_Flowsheet table	integer
Angio coronary field	L_Labs_Flowsheet table	integer
Angio others field	L_Labs_Flowsheet table	integer
Antipseudomonals	L_Pharm_Flowsheet table	number
Ap Complete	L_Log table	boolean
Ap SapsSysBP field	L_Log table	number
Arrive DtTm field	N/A	date
Arterial blood gas (labs)	L_Labs_Flowsheet table	integer
Azoles	L_Pharm_Flowsheet table	number
Benzodiazepines cont inf	L_Pharm_Flowsheet table	number
Blood culture	L_Labs_Flowsheet table	not entered
CBC	L_Labs_Flowsheet table	integer
CCI 1 Code	N/A	number
CCI 2 Code	N/A	number
CCI Picklist Code	L_CCI_Picklist table	string
CT Scan (labs)	L_Labs_Flowsheet table	integer
CXR	L_Labs_Flowsheet table	integer
Carbapenems	L_Pharm_Flowsheet table	number
Ceftazidime	L_Pharm_Flowsheet table	number
Chart number	L_Log table L_PHI table	string
Chronic Health APACHE	L_Log table	string
ClientGUID field	L_Log table	string
ClientVisitGUID field	L_Log table	string
Como Complete	L_Log table	boolean
Creatinine (APACHE)	L_Log table	number
Creatinine (labs)	L_Labs_Flowsheet table	integer
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
DC Treatment	L_Log table	string
Date of Birth	L_Log table L_PHI table	date
Diag Complete	L_Log table	boolean
Dispo DtTm field	L_Log table	date
Dispo field	L_Log table	number
Dx Date	L_ICD10 table	date
Dx Date unknown	L_ICD10 table	boolean
Dx Primary	L_ICD10 table	boolean
Dx Priority	L_ICD10 table	number
Dx Type	L_ICD10 table	string
ER Delay	Created Variables Common 2021 table	date
Echocardiogram	L_Labs_Flowsheet table	number
FFP	L_Labs_Flowsheet table	integer
FiO2	L_Log table	number
FirstName field	L_Log table L_PHI table	string
Fluoroquinolones	L_Pharm_Flowsheet table	number
Fungins	L_Pharm_Flowsheet table	number
Furosemide cont inf	L_Pharm_Flowsheet table	number
GCS sedated field	L_Log table	boolean
H2-Blockers	L_Pharm_Flowsheet table	number
HCT	L_Log table	number
HR	L_Log table	number
Heparin SQ	L_Pharm_Flowsheet table	number
Hospitalization ID	L_Log table L_Person table	number
ICD10 code	L_ICD10 table s_ICD10 table	string
Insulin cont inf	L_Pharm_Flowsheet table	number
K	L_Log table	number
L ICD10 ID	L_ICD10 table	number
LMWH	L_Pharm_Flowsheet table	number
Labs Complete	L_Log table	boolean
LastChanged DtTm field	L_Log table	date
LastName field	L_Log table L_PHI table	string
LastOpened DtTm field	L_Log table	date
MRI (labs)	L_Labs_Flowsheet table	integer
Magnesium (labs)	L_Labs_Flowsheet table	integer
Mean BP	Created Variables CC 2021 table	number
Na	L_Log table	number
Notes field	L_Log table	memo
Notes field (L PHI)	L_PHI table	string
Off ward field	L_Log table	number
Opioids cont inf	L_Pharm_Flowsheet table	number
PCO2	L_Log table	number
PH	L_Log table	number
PHIN field	L_Log table L_PHI table	number
PO2	L_Log table	number
PPI	L_Pharm_Flowsheet table	number
PT PTT	L_Labs_Flowsheet table	integer
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
Pentaspan	L_Labs_Flowsheet table	integer
Person ID field	L_Log table L_Person table	number
Pharm 1st or 2nd generation cephalosporins	L_Log table	boolean
Pharm 4th generation cephalosporins	L_Log table	boolean
Data fields