Auto Data Dictionary: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (→‎data fields: cleanup)
m (→‎data fields: limit=500)
Line 15: Line 15:
| ?DataElementEndDate
| ?DataElementEndDate
| ?FieldCreatedRaw
| ?FieldCreatedRaw
| limit=500
| intro=This is a list of fields in the Critical Care and Medicine Database
| intro=This is a list of fields in the Critical Care and Medicine Database
| format=table
| format=table

Revision as of 21:33, 2017 June 7

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.

What if a field is missing

This only includes fields that have their own article and that properly use the Template:Data element. If field is missing, check that article exists and template is used correctly.

data fields

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
Pharm CompleteL_Log tablebooleannot entered1 January 200031 December 2100Raw
Pharm Direct thrombin inhibitorsL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm Dobutamine cont infL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm Dopamine cont infL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm Epinephrine cont infL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm Factor Xa inhibitorsL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm H2 blockersL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm Heparin cont infL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm HeparinoidsL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm LMWHL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm Milrinone cont infL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm Norepinephrine cont infL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm PPIL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm Paralytics cont infL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm Phenylephrine cont infL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm Vasopressin cont infL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm Vitamin K antagonists fieldL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm aminoglycosidesL_Log tablebooleannot entered1 January 20125 March 2013Raw
Pharm amiodaronesL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm amphotericin BL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm anti-TB drugsL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm antistaph penicillinsL_Log tablebooleannot entered1 January 201219 February 2013Raw
Pharm benzodiazepinesL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm bosentanL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm corticosteroidsL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm furosemideL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm heparin sqL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm influenza drugsL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm insulinL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm macrolidesL_Log tablebooleannot entered1 January 201217 March 2013Raw
Pharm opioidsL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm propofolL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm special upper GI bleeding agentsL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm statinsL_Log tablebooleannot entered1 January 20121 January 2100Raw
Pharm viagra-type vasodilatorsL_Log tablebooleannot entered1 January 20121 January 2100Raw
PlateletsL_Labs_Flowsheet tableintegerinteger11 July 198831 December 2018Raw
Postal Code fieldL_Log tablestring61 January 20121 January 2100Raw
Pre acute living situation fieldL_Log tablenumberlong integer1 July 20161 January 2100Raw
Pre-admit Inpatient Institution fieldL_Log tablenumberlong integer1 July 20161 January 2100Raw
Previous Location fieldL_Log tablenumberlong integer1 July 20161 January 2100Raw
Previous Service fieldL_Log tablenumberlong integer1 July 20167 September 2022Raw
Propofol cont infL_Pharm_Flowsheet tablenumberinteger6 December 201113 May 2014Raw
Province fieldL_Log tablestring211 July 19881 January 2100Raw
Px CountL CCI Component table
L_CCI_Picklist table
datenot entered11 July 19881 January 2100Raw
Px DateL CCI Component table
L_CCI_Picklist table
datenot entered11 July 19881 January 2100Raw
Px TypeL CCI Component table
L_CCI_Picklist table
stringnot entered11 July 19881 January 2100Raw
R CompleteL_Log tablebooleannot entered1 January 200031 December 2100Raw
R Filter FieldL_Log tablestring1011 July 19881 January 2019Raw
RRL_Log tablenumbersingle11 July 19881 January 2100Raw
RecordL_Log tablestring81 January 190031 December 2100Raw
RecordStatus fieldL_Log tablestring2024 April 20131 January 2100Raw
Registry Patient TypeN/Astring101 April 19979 May 2018Raw
s_dispo.loc_types_dispo tablestring201 July 20161 January 2100Raw
SGPT ALT (labs)L_Labs_Flowsheet tableintegerinteger11 July 198817 March 2017Raw
SentDtTm fieldL_Log tabledatenot entered11 July 19881 January 2100Raw
Serum CO2L_Log tablenumbersingle11 July 19881 January 2100Raw
Service/Location fieldL_Log tablenumberlong integer1 July 20161 January 2100Raw
Sex fieldL_Log tablestring711 July 19881 January 2100Raw
Spare1L_Pharm_Flowsheet tablenumberinteger8 December 20128 December 2012Raw
Spare2L_Pharm_Flowsheet tablenumberinteger8 December 20128 December 2012Raw
Spare3L_Pharm_Flowsheet tablenumberinteger8 December 20128 December 2012Raw
Spare4L_Pharm_Flowsheet tablenumberinteger8 December 20128 December 2012Raw
Spare5L_Pharm_Flowsheet tablenumberinteger8 December 20128 December 2012Raw
Spare6L_Pharm_Flowsheet tablenumberinteger8 December 20128 December 2012Raw
Sputum C+SL_Labs_Flowsheet tableintegerinteger11 July 198817 March 2017Raw
Start Date fieldL_Log tabledatenot entered25 February 20111 January 2100Raw
Start Time fieldL_Log tabledatenot entered25 February 20111 January 2100Raw
TR info status fieldL_Log tablestring195 May 201615 October 2020Raw
TemperatureL_Log tablenumbersingle11 July 19881 January 2100Raw
TigecylineL_Pharm_Flowsheet tablenumberinteger21 July 201226 August 2012Raw
Tmp CompleteL_Log tablebooleannot entered1 January 200031 December 2100Raw
Transfer Ready DtTm fieldL_Log tabledatenot entered1 June 199915 October 2020Raw
TroponinL_Labs_Flowsheet tableintegerinteger11 July 198817 March 2017Raw
Urine CSL_Labs_Flowsheet tableintegerinteger11 July 198817 March 2017Raw
Vanco alternativesL_Pharm_Flowsheet tablenumberinteger11 July 19881 January 2100Raw
VancomycinL_Pharm_Flowsheet tablenumberinteger11 July 19881 January 2100Raw
Venous blood gas (labs)L_Labs_Flowsheet tableintegerlong11 July 198831 December 2018Raw
Visit Admit DtTm fieldL_Log tabledatenot entered1 January 20031 January 2100Raw
VoluvenL_Labs_Flowsheet tableintegerinteger11 July 198812 June 2014Raw
WBCL_Log tablenumbersingle11 July 19881 January 2100Raw