CCMDB Wiki

Data dictionary: Difference between revisions

← Older editNewer edit →
m Text replacement - "Created variables" to "Created Variables"
(19 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Is this it? ==
== Instruction ==
{{Discuss | who=Tina | 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.
*** how about adding the program as part of the sub header instead  of table columns.  --[[User:JMojica|JMojica]] 13:36, 2019 June 26 (CDT)
**** That I can do. Putting it on the list. Ttenbergen 13:48, 2019 July 3 (CDT)}}
 
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 18: 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 37: 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===
Line 50: 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 56: 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 83: 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 95: 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 104: 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"