S charlson dxs table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m log: logging
m updt
Line 1: Line 1:
Table that contains the subset of s_alldiagnoses that are [[:Category:Charlson Comorbid Diagnosis|Charlson comorbids]]. Used in [[Charlson Comorbid coding]].
Table that contains the subset of s_alldiagnoses that are [[:Category:Charlson Comorbid Diagnosis|Charlson comorbids]]. Used in [[Charlson Comorbid coding]].
Diff table because it lists como categories instead of dx ones...


== data structure ==
== data structure ==
* ''charlson_category'' - Charlson element that the dx corresponds to, e.g. MI
* ''charlson_category'' - Charlson element that the dx corresponds to, e.g. MI
* ''Diagnosis_code'' - CCMDB code corresponding to one used in table [[s_Alldiagnoses]] and [[L_DXs]]
* ''Diagnosis_code'' - CCMDB code corresponding to one used in table [[s_Alldiagnoses]] and [[L_DXs]]
* ''allow_admit'' - can't remember what this is used for right now... {{discussion}}
* ''allow_como'' - can't remember what this is used for right now... {{discussion}}
* ''comments'' - Charlson and testing specific comments


== dx on here but not in s_alldiagnoses ==
== dx on here but not in s_alldiagnoses ==
Line 11: Line 16:
* 40600
* 40600
* 84900
* 84900
diff table because it lists como categories instead of dx ones...


== log ==
== log ==
Line 21: Line 22:
** confirmed that comopoints had been same in both...  
** confirmed that comopoints had been same in both...  




[[Category: Data structure]]
[[Category: Data structure]]
[[Category: Charlson Comorbid Diagnosis|*]]
[[Category: Charlson Comorbid Diagnosis|*]]

Revision as of 09:46, 25 June 2014

Table that contains the subset of s_alldiagnoses that are Charlson comorbids. Used in Charlson Comorbid coding.

Diff table because it lists como categories instead of dx ones...

data structure

  • charlson_category - Charlson element that the dx corresponds to, e.g. MI
  • Diagnosis_code - CCMDB code corresponding to one used in table s_Alldiagnoses and L_DXs
  • allow_admit - can't remember what this is used for right now... Template:Discussion
  • allow_como - can't remember what this is used for right now... Template:Discussion
  • comments - Charlson and testing specific comments

dx on here but not in s_alldiagnoses

Template:Discussion I am cleaning this up to avoid problems and just realized that there are codes that don't have counterparts in s_alldiagnoses... why? All codes ever used should be in s_alldiagnoses, and just be inactive if legacy now! Ttenbergen 10:40, 2014 June 25 (CDT)

  • 29901
  • 40600
  • 84900

log

2014-06-24

  • Removing columns MainDiagnosis, SubDiagnosis, ComoPoints from this table. Had them in there for convenience when reviewing the table, but it is duplication that may cause confusion, so eliminating it. Ttenbergen 10:25, 2014 June 25 (CDT)
    • confirmed that comopoints had been same in both...