CCMDB Wiki

Auto Data Dictionary: Difference between revisions

← Older editNewer edit →
m Text replacement - "External User Portal for the Manitoba Critical Care and Medicine Databases" to "Data User Portal for the Manitoba Critical Care and Medicine Databases"
(30 intermediate revisions by the same user not shown)
Line 1: Line 1:
== what is this? ==
This page generates an automatically updated list of '''data fields''' in the Critical Care and Medicine Database based on contents of this wiki. For a more general overview see [[Data User Portal for the Manitoba Critical Care and Medicine Databases]]. For information on the general data structure, see [[CCMDB Data Structure]]. For information on data encoded in the [[Entity–attribute–value model of the L_Tmp_V2 table]], see [[Projects]]. For details on information derived from this data, see [[Indicators]].
This article transcludes the articles for our data fields, or ideally their <nowiki><onlyinclude></nowiki> sections.  


Work in progress, all articles need to be updated for this to work.
== data fields ==
== L_Log ==
We collect a total of '''{{#ask: [[Category:Data structure]]   [[FieldName::>""]]  
=== [[Pat_ID]] ===  
| limit=1000
{{:Pat_ID}}
| format=count
=== [[Last Name]] (LastName) ===
}}''' fields, but since much of our data is relational this doesn't really give an indication of how many things we collect.
{{: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}}
=== [[FinalCheck]] ===
{{: FinalCheck}}
=== [[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:  
=== Currently collected ===
*ADL_Bathing
{{#ask: [[Category:Data structure]]  [[FieldName::>""]] [[DataElementEndDate::1 January 2100]]
*ADL_Dressing
| ?InTable = Table
*ADL_Toileting
| ?FieldCCMDBTab= Tab
*ADL_Transfering
| ?FieldDataType= Data type
*ADL_Continence
| ?FieldLength= length
*ADL_Feeding
| ?DataElementDescription=Description
| ?DataElementStartDate=Start date
| ?FieldCreatedRaw=Created vs raw
| limit=1000
| intro=This is a list of fields in the Critical Care and Medicine Database
| format=table
}}


== [[:Category:APACHE II|Apache fields]] ==
=== Legacy data ===
{{Collapsable
| always= Click to see legacy data only
| full=
{{#ask: [[Category:Data structure]]  [[FieldName::>""]] [[DataElementEndDate:!1 January 2100]]
| ?InTable = Table
| ?FieldCCMDBTab= Tab
| ?FieldDataType= Data type
| ?FieldLength= length
| ?DataElementDescription=Description
| ?DataElementStartDate=Start date
| ?DataElementEndDate=End date
| ?FieldCreatedRaw=Created vs raw
| limit=1000
| intro=This is a list of fields in the Critical Care and Medicine Database
| format=table
}}
}}


=== [[Admit Type for APACHE II]] (Ap_AdmitType) ===  
=== Full list ===
{{:Admit Type for APACHE II}}
{{Collapsable
=== [[Chronic Health APACHE]] (Ap_Chronic) ===  
| always= Click to see full list
{{:Chronic Health APACHE}}
| full=  
=== [[Temperature]] (Ap_Temp) ===
{{#ask: [[Category:Data structure]] [[FieldName::>""]] |
{{:Temperature }}
| ?InTable = Table
=== [[SAPS BP Field]] (Ap_SapsSysBP) ===  
| ?FieldCCMDBTab= Tab
{{:SAPS BP Field}}
| ?FieldDataType= Data type
=== [[AP Sys BP Field]] (Ap_APSysBP) ===
| ?FieldLength= length
{{:AP Sys BP Field}}
| ?DataElementDescription=Description
=== [[AP Dias BP Field]] (Ap_APDiasBP) ===
| ?DataElementStartDate=Start date
{{:AP Dias BP Field}}
| ?DataElementEndDate=End date
=== [[HR]] (Ap_HeartRate) ===
| ?FieldCreatedRaw=Created vs raw
{{:HR}}
| limit=1000
=== [[RR]] (Ap_RespRate) ===  
| intro=This is a list of fields in the Critical Care and Medicine Database
{{:RR}}
| format=table
=== [[Glasgow Coma Scale]] ===
}}
{{:Glasgow Coma Scale}}
}}


Fields:
== Background / Implementation of this page ==
* Ap_Eye
This page aggregates data from other pages that use the [[:Template:Data element]] using [[Semantic Mediawiki]].
* Ap_Motor
If a field is not listed, check that a corresponding article exists and [[:Template:Data element]] is used correctly.
* 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)}}


==TODO==
== Related articles ==  
{{Related Articles}}


==todo==


 
[[Category: Data structure]]
=== 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}}
=== PostalCode ===
{{: PostalCode}}
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Auto_Data_Dictionary"