Auto Data Dictionary

From CCMDB Wiki
Revision as of 00:44, 2017 January 8 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search

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 (APACHE) (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