Auto Data Dictionary: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (m)
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]].  
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 ==
== data fields ==
Line 37: Line 37:
| format=table
| 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

Revision as of 18:15, 2016 November 24

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

 InTableFieldDataTypeFieldLengthElementDescriptionDataElementStartDateDataElementEndDateFieldCreatedRaw
3rd generation cephalosporinsL_Pharm_Flowsheet tablenumberinteger20 October 201111 March 2013Raw
ADL BathingL_Log tablestring151 October 20031 January 2100Raw
ADL CompleteL_Log tablebooleannot entered1 January 200031 December 2100Raw
ADL ContinenceL_Log tablestring151 October 20031 January 2100Raw
ADL DressingL_Log tablestring151 October 20031 January 2100Raw
ADL FeedingL_Log tablestring151 October 20031 January 2100Raw
ADL ToilettingL_Log tablestring151 October 20031 January 2100Raw
ADL TransferingL_Log tablestring151 October 20031 January 2100Raw
AP Dias BP FieldL_Log tablenumbersingle11 July 19881 January 2100Raw
AP Eye fieldL_Log tablestring1311 July 19881 January 2100Raw
AP Motor fieldL_Log tablestring1911 July 19881 January 2100Raw
AP Sys BP FieldL_Log tablenumbersingle11 July 19881 January 2100Raw
AP Verbal fieldL_Log tablestring2611 July 19881 January 2100Raw
ARF (APACHE)L_Log tablenumbersingle11 July 19881 January 2100Raw
AaDO2N/AnumberN/A11 July 19881 January 2100Created
Abdominal ultrasoundL_Labs_Flowsheet tableintegerinteger11 July 198831 December 2018Raw
Accept DtTm fieldL_Log tabledatenot entered1 July 201622 April 2022Raw
Accept DtTm missing fieldL_Log tablebooleannot entered1 July 201622 April 2022Raw
Admit Type for APACHE IIL_Log tablestring1011 July 19881 January 2100Raw
AgeCreated Variables Common 2021 table
Created Variables CC 2021 table
number11 July 19881 January 2100Created
Albumin 25pctL_Labs_Flowsheet tableintegerinteger11 July 198831 December 2018Raw
Albumin 5pctL_Labs_Flowsheet tableintegerinteger11 July 198831 December 2018Raw
Angio coronary fieldL_Labs_Flowsheet tableintegerinteger11 July 19883 April 2017Raw
Angio others fieldL_Labs_Flowsheet tableintegerinteger11 July 19883 April 2017Raw
AntipseudomonalsL_Pharm_Flowsheet tablenumberinteger11 July 19881 January 2100Raw
Ap CompleteL_Log tablebooleannot entered1 January 200031 December 2100Raw
Ap SapsSysBP fieldL_Log tablenumberlong integer11 July 198813 May 2014Raw
Arrive DtTm fieldN/Adatenot entered1 July 201622 April 2022Raw
Arterial blood gas (labs)L_Labs_Flowsheet tableintegerlong11 July 198831 December 2018Raw
AzolesL_Pharm_Flowsheet tablenumberinteger11 July 19881 January 2100Raw
Benzodiazepines cont infL_Pharm_Flowsheet tablenumberinteger29 November 201113 May 2014Raw
Blood cultureL_Labs_Flowsheet tablenot enteredinteger17 March 2017Raw
CBCL_Labs_Flowsheet tableintegerinteger11 July 198831 December 2018Raw
CCI 1 CodeN/Anumberlong integer1 January 20191 January 2100Raw
CCI 2 CodeN/Anumberlong integer1 January 20191 January 2100Raw
CCI Picklist CodeL_CCI_Picklist tablestring201 January 20191 January 2100Raw
CT Scan (labs)L_Labs_Flowsheet tableintegerinteger11 July 198831 December 2018Raw
CXRL_Labs_Flowsheet tableintegerinteger11 July 198831 December 2018Raw
CarbapenemsL_Pharm_Flowsheet tablenumberinteger11 July 19881 January 2100Raw
CeftazidimeL_Pharm_Flowsheet tablenumberinteger2 January 20128 March 2013Raw
Chart numberL_Log table
L_PHI table
string811 July 19881 January 2100Raw
Chronic Health APACHEL_Log tablestring3017 February 2022Raw
ClientGUID fieldL_Log tablestring1629 August 20221 January 2100Raw
ClientVisitGUID fieldL_Log tablestring1629 August 20221 January 2100Raw
Como CompleteL_Log tablebooleannot entered1 January 200031 December 2100Raw
Creatinine (APACHE)L_Log tablenumbersingle11 July 19881 January 2100Raw
Creatinine (labs)L_Labs_Flowsheet tableintegerinteger11 July 198817 March 2017Raw
D ID fieldL_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
string1811 July 19881 January 2100Raw
DC TreatmentL_Log tablestring5011 July 198810 May 2022Raw
Date of BirthL_Log table
L_PHI table
datenot entered11 July 19881 January 2100Raw
Diag CompleteL_Log tablebooleannot entered1 January 200031 December 2100Raw
Dispo DtTm fieldL_Log tabledatenot entered1 July 20161 January 2100Raw
Dispo fieldL_Log tablenumberlong1 July 20161 January 2100Raw
Dx DateL_ICD10 tabledatenot entered11 July 19881 January 2100Raw
Dx Date unknownL_ICD10 tablebooleannot entered11 July 19881 January 2100Raw
Dx PrimaryL_ICD10 tablebooleannot entered11 July 19881 January 2100Raw
Dx PriorityL_ICD10 tablenumbersingle11 July 19881 January 2100Raw
Dx TypeL_ICD10 tablestring811 July 19881 January 2100Raw
ER DelayCreated Variables Common 2021 tabledaten/a11 July 19881 January 2100Created
EchocardiogramL_Labs_Flowsheet tablenumberinteger11 July 198831 December 2018Raw
FFPL_Labs_Flowsheet tableintegerinteger11 July 198831 December 2018Raw
FiO2L_Log tablenumbersingle11 July 19881 January 2100Raw
FirstName fieldL_Log table
L_PHI table
string4011 July 19881 January 2100Raw
FluoroquinolonesL_Pharm_Flowsheet tablenumberinteger11 July 19881 January 2100Raw
FunginsL_Pharm_Flowsheet tablenumberinteger11 July 19881 January 2100Raw
Furosemide cont infL_Pharm_Flowsheet tablenumberinteger21 December 20119 May 2014Raw
GCS sedated fieldL_Log tablebooleannot entered22 September 201615 June 2021Raw
H2-BlockersL_Pharm_Flowsheet tablenumberinteger24 December 200912 May 2014Raw
HCTL_Log tablenumbersingle11 July 19881 January 2100Raw
HRL_Log tablenumbersingle11 July 19881 January 2100Raw
Heparin SQL_Pharm_Flowsheet tablenumberinteger28 November 201113 May 2014Raw
Hospitalization IDL_Log table
L_Person table
numberlong integer11 July 19881 January 2100Created
ICD10 codeL_ICD10 table
s_ICD10 table
string1011 July 19881 January 2100Raw
Insulin cont infL_Pharm_Flowsheet tablenumberinteger6 December 201113 May 2014Raw
KL_Log tablenumbersingle11 July 19881 January 2100Raw
L ICD10 IDL_ICD10 tablenumberlong11 July 19881 January 2100Raw
LMWHL_Pharm_Flowsheet tablenumberinteger6 December 201131 December 2011Raw
Labs CompleteL_Log tablebooleannot entered1 January 200031 December 2100Raw
LastChanged DtTm fieldL_Log tabledatenot entered6 January 202131 December 2999Raw
LastName fieldL_Log table
L_PHI table
string4011 July 19881 January 2100Raw
LastOpened DtTm fieldL_Log tabledatenot entered14 April 20161 January 2100Raw
MRI (labs)L_Labs_Flowsheet tableintegerinteger11 July 198831 December 2018Raw
Magnesium (labs)L_Labs_Flowsheet tableintegerinteger11 July 198831 December 2018Raw
Mean BPCreated Variables CC 2021 tablenumbersingle11 July 19881 January 2100Created
NaL_Log tablenumbersingle11 July 19881 January 2100Raw
Notes fieldL_Log tablememonot entered11 July 19881 January 2100Raw
Notes field (L PHI)L_PHI tablestringnot entered11 July 19881 January 2100Raw
Off ward fieldL_Log tablenumberlong integer1 July 201629 January 2020Raw
Opioids cont infL_Pharm_Flowsheet tablenumberinteger6 December 201113 May 2014Raw
PCO2L_Log tablenumbersingle11 July 19881 January 2100Raw
PHL_Log tablenumbersingle11 July 19881 January 2100Raw
PHIN fieldL_Log table
L_PHI table
numberLong Integer11 July 19881 January 2100Raw
PO2L_Log tablenumbersingle11 July 19881 January 2100Raw
PPIL_Pharm_Flowsheet tablenumberinteger12 September 201112 May 2014Raw
PT PTTL_Labs_Flowsheet tableintegerinteger11 July 198817 March 2017Raw
Pat ID fieldL_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
numberLong Integer11 July 19881 January 2100Raw
PentaspanL_Labs_Flowsheet tableintegerinteger12 June 2014Raw
Person ID fieldL_Log table
L_Person table
numberlong integer11 July 19881 January 2100Created
Pharm 1st or 2nd generation cephalosporinsL_Log tablebooleannot entered1 January 20127 August 2013Raw
Pharm 4th generation cephalosporinsL_Log tablebooleannot entered1 January 201228 February 2013Raw
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

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