Auto Data Dictionary: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
m clean-up
Line 1: Line 1:
== what is this? ==
Crohn's Disease== 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]].  
This article generates a list of data fields in the critical care and medicine database using the [[:Template:Data element]] and [[Semantic Mediawiki]].  


Line 182: Line 182:
=== [[RecordStatus]] ===
=== [[RecordStatus]] ===
   RecordStatus  
   RecordStatus  
=== [[LastChanged_DtTm]] ===
=== [[LastChanged_DtTm field]] ===
   LastChanged_DtTm  
   LastChanged_DtTm  
=== [[pharm_* entries ===
=== pharm_* entries ===
For the following fields see [[:Category:Pharmacy]]:
For the following fields see [[:Category:Pharmacy]]:
* pharm_Vitamin K antagonists
* pharm_Vitamin K antagonists
Line 248: Line 248:
=== [[R_Filter]] ===
=== [[R_Filter]] ===
   R_Filter  
   R_Filter  
=== [[Var1]] ===
  Var1
=== [[Var2]] ===
  Var2
=== [[Var3]] ===
  Var3
=== [[Var4]] ===
  Var4
=== [[Var5]] ===
  Var5
=== [[Var6]] ===
  Var6
=== [[Postal Code field]] ===
=== [[Postal Code field]] ===
  Postal Code field
  Postal Code field

Revision as of 15:18, 1 February 2017

Crohn's Disease== 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 field

 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

Postal Code field

Postal Code field
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Auto_Data_Dictionary&oldid=52296"