Auto Data Dictionary: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (removing old style list to see if that's what's breaking the wanted pages special page)
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. See [[#field list]]
== 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 ==
== data fields ==
=== by link ===
<!-- As generated by [[Semantic Mediawiki]] -->
{{#ask: [[Category:Data structure]]  [[FieldName::>""]]
| limit=0
| searchlabel=Data fields
| ?InTable
| ?FieldDataType
| ?FieldLength
| ?ElementDescription
| ?DataElementStartDate
| ?DataElementEndDate
| ?FieldCreatedRaw
| format=broadtable
|link=all
|headers=show
|intro=This is a list of fields in the Critical Care and Medicine Database
|class=sortable wikitable smwtable
}}
=== by list ===
<!-- As generated by [[Semantic Mediawiki]] -->
<!-- As generated by [[Semantic Mediawiki]] -->
{{#ask: [[Category:Data structure]]  [[FieldName::>""]]  
{{#ask: [[Category:Data structure]]  [[FieldName::>""]]  

Revision as of 17:25, 2017 May 3

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