Data dictionary: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,851 edits
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,851 edits
No edit summary
Line 1: Line 1:
{{Discuss | who=Julie | question=Attempt at a easier to follow data dictionary. Is this what you had in mind? }}
{{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:
* 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).
* 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.
* 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).
* 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)}}
For an alphabetic listing, see [[Auto Data Dictionary]].  
For an alphabetic listing, see [[Auto Data Dictionary]].  


Revision as of 11:05, 3 January 2019

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:
  • 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).
  • 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.
  • 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).
  • How about info on some ongoing tmp projects - perhaps include a list of projects and the associated data being collected.
 --JMojica 10:05, 2019 January 3 (CST)
  • SMW


  • Cargo


  • Categories

For an alphabetic listing, see Auto Data Dictionary.

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.

L_PHI table

Something went wrong with this query and it has no data - please tell Tina Tenbergen

L_Log table - Registry

Something went wrong with this query and it has no data - please tell Tina Tenbergen

ADT

Admission, discharge and transfer data

L_Log table - physiological components

Something went wrong with this query and it has no data - please tell Tina Tenbergen

APACHE

Apache has physiological components and diagnostic components.

L_Log table - physiological components

Something went wrong with this query and it has no data - please tell Tina Tenbergen

Diagnostic components

ADLs - Activities of Daily Living

Collected according to ADL General Collection Information. Something went wrong with this query and it has no data - please tell Tina Tenbergen

Diagnoses

ICD10 - L_ICD10 table

This stores our version of ICD10 (see ICD10 Diagnosis List), collected following the ICD10 collection instructions. Something went wrong with this query and it has no data - please tell Tina Tenbergen

Old dx schema

In this schema procedures were coded together with diagnoses.

Diagnoses - L_Dxs table

Something went wrong with this query and it has no data - please tell Tina Tenbergen

Comorbids - L_Como table

Something went wrong with this query and it has no data - please tell Tina Tenbergen

Procedures

This stores our version of CCI, collected following the CCI Collection instructions.

L_CCI_Picklist table

See CCI Picklist for possible values. Something went wrong with this query and it has no data - please tell Tina Tenbergen

L_CCI_Component table

See CCI component 1 codes - what organ was something done to, CCI component 2 codes - what was done for possible values. Something went wrong with this query and it has no data - please tell Tina Tenbergen

Old dx coding schema

In the old dx coding schema procedures were coded together with diagnoses, see #L_Dxs table.

Labs

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

Something went wrong with this query and it has no data - please tell Tina Tenbergen

DSM Data

Something went wrong with this query and it has no data - please tell Tina Tenbergen

Pharmacy

Something went wrong with this query and it has no data - please tell Tina Tenbergen

Temporary project data

L_TmpV2 table

Something went wrong with this query and it has no data - please tell Tina Tenbergen

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Data_dictionary&oldid=133082"