CCMDB Wiki

Data dictionary: Difference between revisions

← Older edit
Added link to projects.
m Text replacement - "[[Category: " to "[[Category:"
 
(36 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Discuss | who=Julie | question=Attempt at a easier to follow data dictionary. Is this what you had in mind?
== Instruction ==
  Yes, this is what I have in  mind. Thanks.  Some suggestions:
On any of the tables below, click on the links in the left columns to find out our definitions and instructions for those fields.  
* 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). For the ICD10 and CCI, we can use the 1 Jan 2019 as the official start date.  we can do similarly for the end dates of some discontinued table (similar in L_Labs). --[[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. Ttenbergen 14:49, 2019 January 3 (CST)
* 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.
}}


{{DT | I will do the following:
For an alphabetic listing, see [[Auto Data Dictionary]].
* add the TISS elements
* add some created variables (e.g. Age, LOS, Apache score and the other APACHE component points (GCS, Acute Physiological, Age, etc) , Charlson score, delays, etc).
* can you add a link here the article of the sites and units/wards we are collecting and also the corresponding start collection dates. This is usually being asked by users.  
}}


For an alphabetic listing, see [[Auto Data Dictionary]].  
== Scope ==
See [[Site and Location table]] for a list of where we collect data.
 
See [[Total admissions ICU/Med]] for a recent count of records.
 
See [[Data Request Status ICU/Med]] for how many requests we have had.  


== 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.accdb]] this data is split out from the other in L_Log for [[PHIA]] reasons.


=== [[L_PHI table]] ===
=== [[L_PHI table]] ===
Line 22: 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 32: 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 42: 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 48: 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 75: 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 87: 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 - CC only==
See [[TISS Item List]] for a list of elements we collect as part of TISS.
=== [[L_TISS_Form table]] ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Form table]] }}
=== [[L_TISS_Item table]] ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Item table]] }}
 
== Created Variables ==
We have some data elements we generate rather than calculate directly.
{{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"