Auto Data Dictionary: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m m
m m
Line 1: Line 1:
== what is this? ==
== what is this? ==
This article transcludes the articles for our data fields, or ideally their <nowiki><onlyinclude></nowiki> sections.  
This article generates a list of data fields in the critical care and medicine database using the [[:template ]] 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.  
== 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:
== data fields ==
*ADL_Bathing
=== by link ===
*ADL_Dressing
<!-- As generated by [[Semantic Mediawiki]] -->
*ADL_Toileting
{{#ask: [[Category:Data structure]] [[FieldName::>""]]  
*ADL_Transfering
| limit=0
*ADL_Continence
| searchlabel=Data fields
*ADL_Feeding
| ?InTable
 
| ?FieldDataType
== [[:Category:APACHE II|Apache fields]] ==
| ?ElementDescription
 
| format=broadtable
=== [[Admit Type for APACHE II]] (Ap_AdmitType) ===  
|link=all
{{:Admit Type for APACHE II}}
|headers=show
=== [[Chronic Health APACHE]] (Ap_Chronic) ===
|intro=This is a list of fields in the Critical Care and Medicine Database
{{:Chronic Health APACHE}}
|class=sortable wikitable smwtable
=== [[Temperature]] (Ap_Temp) ===
}}
{{:Temperature }}
=== by list ===
=== [[SAPS BP Field]] (Ap_SapsSysBP) ===
<!-- As generated by [[Semantic Mediawiki]] -->
{{:SAPS BP Field}}
{{#ask: [[Category:Data structure]]   [[FieldName::>""]]  
=== [[AP Sys BP Field]] (Ap_APSysBP) ===
| searchlabel=Data fields
{{:AP Sys BP Field}}
| ?InTable
=== [[AP Dias BP Field]] (Ap_APDiasBP) ===
| ?FieldDataType
{{:AP Dias BP Field}}
| ?ElementDescription
=== [[HR]] (Ap_HeartRate) ===
| intro=This is a list of fields in the Critical Care and Medicine Database
{{:HR}}
| format=table
=== [[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 16:48, 24 November 2016

what is this?

This article generates a list of data fields in the critical care and medicine database using the template and Semantic Mediawiki.

Work in progress, all articles need to be updated for this to work.

data fields

by link

Data fields

by list

This is a list of fields in the Critical Care and Medicine Database

 InTableFieldDataTypeElementDescription
3rd generation cephalosporinsL_Pharm_Flowsheet tablenumber
ADL BathingL_Log tablestring
ADL CompleteL_Log tableboolean
ADL ContinenceL_Log tablestring
ADL DressingL_Log tablestring
ADL FeedingL_Log tablestring
ADL ToilettingL_Log tablestring
ADL TransferingL_Log tablestring
AP Dias BP FieldL_Log tablenumber
AP Eye fieldL_Log tablestring
AP Motor fieldL_Log tablestring
AP Sys BP FieldL_Log tablenumber
AP Verbal fieldL_Log tablestring
ARF (APACHE)L_Log tablenumber
AaDO2N/Anumber
Abdominal ultrasoundL_Labs_Flowsheet tableinteger
Accept DtTm fieldL_Log tabledate
Accept DtTm missing fieldL_Log tableboolean
Admit Type for APACHE IIL_Log tablestring
AgeCreated Variables Common 2021 table
Created Variables CC 2021 table
number
Albumin 25pctL_Labs_Flowsheet tableinteger
Albumin 5pctL_Labs_Flowsheet tableinteger
Angio coronary fieldL_Labs_Flowsheet tableinteger
Angio others fieldL_Labs_Flowsheet tableinteger
AntipseudomonalsL_Pharm_Flowsheet tablenumber
Ap CompleteL_Log tableboolean
Ap SapsSysBP fieldL_Log tablenumber
Arrive DtTm fieldN/Adate
Arterial blood gas (labs)L_Labs_Flowsheet tableinteger
AzolesL_Pharm_Flowsheet tablenumber
Benzodiazepines cont infL_Pharm_Flowsheet tablenumber
Blood cultureL_Labs_Flowsheet tablenot entered
CBCL_Labs_Flowsheet tableinteger
CCI 1 CodeN/Anumber
CCI 2 CodeN/Anumber
CCI Picklist CodeL_CCI_Picklist tablestring
CT Scan (labs)L_Labs_Flowsheet tableinteger
CXRL_Labs_Flowsheet tableinteger
CarbapenemsL_Pharm_Flowsheet tablenumber
CeftazidimeL_Pharm_Flowsheet tablenumber
Chart numberL_Log table
L_PHI table
string
Chronic Health APACHEL_Log tablestring
ClientGUID fieldL_Log tablestring
ClientVisitGUID fieldL_Log tablestring
Como CompleteL_Log tableboolean
Creatinine (APACHE)L_Log tablenumber
Creatinine (labs)L_Labs_Flowsheet tableinteger
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
string
DC TreatmentL_Log tablestring
Date of BirthL_Log table
L_PHI table
date
Diag CompleteL_Log tableboolean
Dispo DtTm fieldL_Log tabledate
Dispo fieldL_Log tablenumber
Dx DateL_ICD10 tabledate
Dx Date unknownL_ICD10 tableboolean
Dx PrimaryL_ICD10 tableboolean
Dx PriorityL_ICD10 tablenumber
Dx TypeL_ICD10 tablestring
ER DelayCreated Variables Common 2021 tabledate
EchocardiogramL_Labs_Flowsheet tablenumber
FFPL_Labs_Flowsheet tableinteger
FiO2L_Log tablenumber
FirstName fieldL_Log table
L_PHI table
string
FluoroquinolonesL_Pharm_Flowsheet tablenumber
FunginsL_Pharm_Flowsheet tablenumber
Furosemide cont infL_Pharm_Flowsheet tablenumber
GCS sedated fieldL_Log tableboolean
H2-BlockersL_Pharm_Flowsheet tablenumber
HCTL_Log tablenumber
HRL_Log tablenumber
Heparin SQL_Pharm_Flowsheet tablenumber
Hospitalization IDL_Log table
L_Person table
number
ICD10 codeL_ICD10 table
s_ICD10 table
string
Insulin cont infL_Pharm_Flowsheet tablenumber
KL_Log tablenumber
L ICD10 IDL_ICD10 tablenumber
LMWHL_Pharm_Flowsheet tablenumber
Labs CompleteL_Log tableboolean
LastChanged DtTm fieldL_Log tabledate
LastName fieldL_Log table
L_PHI table
string
LastOpened DtTm fieldL_Log tabledate
MRI (labs)L_Labs_Flowsheet tableinteger
Magnesium (labs)L_Labs_Flowsheet tableinteger
Mean BPCreated Variables CC 2021 tablenumber
NaL_Log tablenumber
Notes fieldL_Log tablememo
Notes field (L PHI)L_PHI tablestring
Off ward fieldL_Log tablenumber
Opioids cont infL_Pharm_Flowsheet tablenumber
PCO2L_Log tablenumber
PHL_Log tablenumber
PHIN fieldL_Log table
L_PHI table
number
PO2L_Log tablenumber
PPIL_Pharm_Flowsheet tablenumber
PT PTTL_Labs_Flowsheet tableinteger
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
number
PentaspanL_Labs_Flowsheet tableinteger
Person ID fieldL_Log table
L_Person table
number
Pharm 1st or 2nd generation cephalosporinsL_Log tableboolean
Pharm 4th generation cephalosporinsL_Log tableboolean
Data fields