Auto Data Dictionary: Difference between revisions

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.  
Work in progress, all articles need to be updated for this to work. See [[#field list]]


== data fields ==
== data fields ==
Line 37: Line 37:
| format=table
| format=table
}}
}}
== 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 General Collection Information|ADL]] ===
ADL General Collection Information
Fields:
*ADL_Bathing
*ADL_Dressing
*ADL_Toileting
*ADL_Transfering
*ADL_Continence
*ADL_Feeding
== [[:Category:APACHE II|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]] (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