CCMDB Wiki

Data dictionary: Difference between revisions

← Older editNewer edit →
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,815 edits
No edit summary
m Text replacement - "Created variables" to "Created Variables"
(37 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.  
* 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).  
For an alphabetic listing, see [[Auto Data Dictionary]].
* add a column for program (Critical care only or Medicine only or both).
 
* 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.
== Scope ==
* 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).
See [[Site and Location table]] for a list of where we collect data.  
* How about info on some ongoing tmp projects - perhaps include a list of projects and the associated data being collected.
 
  --[[User:JMojica|JMojica]] 10:05, 2019 January 3 (CST)}}
See [[Total admissions ICU/Med]] for a recent count of records.
For an alphabetic listing, see [[Auto Data Dictionary]].  
 
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.mdb]] this data is split out from the other in L_Log for [[PHIA]] reasons.


=== [[L_PHI table]] ===
=== [[L_PHI table]] ===
Line 17: 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]]}}


== ADT ==
==== CC only ====
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[Category:Registry Data]] [[DataElementProgram::CC]]}}
 
== ADT - via [[EPR]] ==
Admission, discharge and transfer data
Admission, discharge and transfer data


=== [[L_Log table]] - physiological components===
=== [[L_Log table]] ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::dispo]] }}
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Dispo]] }}


== 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 37: 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 43: 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 70: 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]] }}


== Temporary project data ==
== Temporary project data ==
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"