Auto Data Dictionary: Difference between revisions

Revision as of 17:15, 24 November 2016

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

field list

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

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

@@ Line 2: / Line 2: @@
 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.
+Work in progress, all articles need to be updated for this to work. See [[#field list]]
 == data fields ==
@@ Line 37: / Line 37: @@
 | format=table
 }}
+== field list ==
+== 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 General Collection Information|ADL]] ===
+ ADL General Collection Information
+Fields:
+*ADL_Bathing
+*ADL_Dressing
+*ADL_Toileting
+*ADL_Transfering
+*ADL_Continence
+*ADL_Feeding
+== [[:Category:APACHE II|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