CCMDB Wiki

Data dictionary: Difference between revisions

← Older editNewer edit →
m Text replacement - "Created variables" to "Created Variables"
(25 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Is this it? ==
== Instruction ==
{{Discuss | who=Julie | question=
* Attempt at a easier to follow data dictionary. Is this what you had in mind?
** Yes, this is what I have in  mind. Thanks.  Some suggestions:
*** I just notice some start dates are not the actual start dates - It is important for the users to know how far back the data are available so they can decide the covered period of their study. is it possible to change the date to actual earliest  collection start date (not 1 Jan 1900). --[[User:JMojica|JMojica]] 10:05, 2019 January 3 (CST)
**** The start and end dates are stored on the individual pages. If the list shows 1900 then they were not filled in. If you know what they are and fill them in then this page will list them. I can also change the '''default if-not-filled value in templates''' to something other than 1900-01-01. I just needed a value for ranges and filters to work. '''Do you want me to use a different default value'''? Ttenbergen 14:49, 2019 January 3 (CST)
 
}}
 
{{Discuss | who=Julie | question=
* add a column for program (Critical care only or Medicine only or both).
** I can do that, but the table is already getting quite wide for a web page. Can we lose any of the columns we currently have? The info you mean is always visible in the pages themselves as well, in case that's sufficient. But, yes, we can tweak what the tables should show. It is done in [[Template:DataDictionaryQuery]] (details visible once you edit it...) and removing fields would be easy enough. I can show you how to add fields. Or I can add them once we confirm what we want.
 
}}
 
On any of the tables below, click on the links in the left columns to find out our definitions and instructions for those fields.  
On any of the tables below, click on the links in the left columns to find out our definitions and instructions for those fields.  


Line 26: Line 12:


== Registry ==
== Registry ==
In the collection tool [[CCMDB.mdb]] the registry data is all in the [[L_Log table]]. In the data processing tool [[CFE]] and the central repository [[Centralized data.mdb]] this data is split out from the other in L_Log for [[PHIA]] reasons.
In the collection tool [[CCMDB.accdb]] the registry data is all in the [[L_Log table]]. In the data processing tool [[CFE]] and the central repository [[Centralized data.mdb]] this data is split out from the other in L_Log for [[PHIA]] reasons.


=== [[L_PHI table]] ===
=== [[L_PHI table]] ===
Line 32: Line 18:


=== [[L_Log table]] - Registry ===
=== [[L_Log table]] - Registry ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[Category:Registry Data]] }}
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[Category:Registry Data]] [[DataElementProgram::Med and CC]] OR [[FieldName::>""]] [[InTable::L_Log table]] [[Category:Registry Data]] [[DataElementProgram::not entered]]}}
 
==== CC only ====
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[Category:Registry Data]] [[DataElementProgram::CC]]}}


== ADT - via [[EPR]] ==
== ADT - via [[EPR]] ==
Line 42: Line 31:
== APACHE ==
== APACHE ==
Apache has physiological components and diagnostic components.  
Apache has physiological components and diagnostic components.  
* [[APACHE Scoring table]]
* [[APACHE Acute Dxs in ICD10 codes]]
* [[APACHE Comorbidities in ICD10 codes]]


=== [[L_Log table]] - physiological components===
=== [[L_Log table]] - physiological components===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Apache]] }}
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Apache]] [[DataElementProgram::Med and CC]] OR [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Apache]] [[DataElementProgram::not entered]] }}
 
==== CC only ====
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Apache]] [[DataElementProgram::CC]] }}


=== Diagnostic components ===
=== Diagnostic components ===
Line 52: Line 47:
== ADLs - Activities of Daily Living ==
== ADLs - Activities of Daily Living ==
Collected according to [[ADL General Collection Information]].
Collected according to [[ADL General Collection Information]].
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::ADL]] }}
 
=== Med only ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[FieldCCMDBTab::ADL]] [[DataElementProgram::Med]]}}


== Diagnoses ==
== Diagnoses ==
Line 58: Line 55:
This stores our version of [[ICD10]] (see [[ICD10 Diagnosis List]]), collected following the [[ICD10 collection]] instructions.
This stores our version of [[ICD10]] (see [[ICD10 Diagnosis List]]), collected following the [[ICD10 collection]] instructions.
{{DataDictionaryQuery | Criteria=  [[FieldName::>""]] [[InTable::L_ICD10 table]] }}
{{DataDictionaryQuery | Criteria=  [[FieldName::>""]] [[InTable::L_ICD10 table]] }}
=== Charlson Comorbidities ===
* [[Charlson_Comorbidities_in_ICD10_codes]]


=== Old dx schema ===
=== Old dx schema ===
Line 85: Line 85:
See [[Converting Lab Counts to CCI]] for how the labs described in [[#Pre-CCI manual collection]] are now collected in CCI.  
See [[Converting Lab Counts to CCI]] for how the labs described in [[#Pre-CCI manual collection]] are now collected in CCI.  


=== Pre-CCI manual collection ===
=== Pre-CCI manual collection - CC only ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Labs_Flowsheet table]] }}
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Labs_Flowsheet table]] }}


=== DSM Data ===
=== DSM Data ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L Labs DSM table table]] }}
See [[L_Labs_DSM table]]
 
==== Elements collected via DSM ====
See [[DSM data#DSM results we store]]


== Pharmacy ==
== Pharmacy ==
=== CC only ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Pharm_Flowsheet table]] }}
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Pharm_Flowsheet table]] }}


Line 97: Line 101:
See [[Projects]] for a list of current and past projects.
See [[Projects]] for a list of current and past projects.
=== [[L_TmpV2 table]] ===
=== [[L_TmpV2 table]] ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_TmpV2 table]] }}
{{:L TmpV2 table}}


== TISS28 ==
== TISS28 - CC only==
See [[TISS Items SMW]] for a list of elements we collect as part of TISS.  
See [[TISS Item List]] for a list of elements we collect as part of TISS.  
=== [[L_TISS_Form table]] ===
=== [[L_TISS_Form table]] ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Form table]] }}
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Form table]] }}
Line 106: Line 110:
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Item table]] }}
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Item table]] }}


=== Created variables ===
== Created Variables ==
We have some data elements we generate rather than calculate directly.  
We have some data elements we generate rather than calculate directly.  
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[FieldCreatedRaw::Created]] }}
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[FieldCreatedRaw::Created]] }}
== Related articles ==
{{Related Articles}}




[[Category: Data structure]]
[[Category: Data structure]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Data_dictionary"