Auto Data Dictionary: Difference between revisions

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}}