S charlson dxs table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
rogue codes?
mNo edit summary
 
(13 intermediate revisions by 2 users not shown)
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]].
{{DISPLAYTITLE:S_charlson_dxs table}}{{LegacyContent
|explanation=no longer a separate list in ICD10
|successor=Charlson Comorbidities in ICD10 codes
|content=
 
[[Charlson Comorbidity scoring in pre-ICD10 codes]]
 
Table that contains the subset of s_alldiagnoses that are [[:Category:Charlson Comorbid Diagnosis|Charlson comorbids]]. Used in [[Charlson Comorbid coding (pre ICD10)]].
 
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 the [[s_AllDiagnoses table]] and the[[L Dxs table]]
* ''allow_admit'' - include if it's an admit (we allow a handful)
* ''allow_como'' - include if it's a comorbid (usual scenario)
* ''comments'' - Charlson and testing specific comments


== dx on here but not in s_alldiagnoses ==
== discrepancies between this table and s_alldiagnoses ==
{{discussion}}
discrepancies in como / allow_como columns resp Diag / allow_admit columns
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


saved working query ''1_discrepancies between this table and s_alldiagnoses''


Considering I can't remember how these are used who knows if this is a problem...
Code Diag allow_admit Como allow_como
10200 Yes 0 All -1
10201 Yes 0 All -1
10202 Yes 0 All -1
10203 Yes 0 All -1
10204 Yes 0 All -1
10205 Yes 0 All -1
10206 Yes 0 All -1
10207 Yes 0 All -1
10208 Yes 0 All -1
10209 Yes 0 All -1
10210 Yes 0 All -1
10300 Yes 0 All -1
10301 Yes 0 All -1
10302 Yes 0 All -1
10303 Yes 0 All -1
10304 Yes 0 All -1
10305 Yes 0 All -1
10306 Yes 0 All -1
10307 Yes 0 All -1
10390 Yes 0 All -1
25900 Yes 0 0
29906 Yes 0 All 0
40102 Yes 0 All -1
40103 Yes 0 All -1
41500 Yes 0 All -1
41501 Yes 0 All -1
41502 Yes 0 All -1
52900 Yes 0 All -1
53700 Yes 0 All -1
53800 Yes -1 -1
78101 Yes -1 -1
78102 Yes -1 -1
80500 Yes 0 All -1


== log ==
== 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)
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...
 
== Related articles ==
{{Related Articles}}


I can't think of a reason for the moment why this is even a different table from s_alldiagnoses, really it should just be the subset of that table that has a charlson score... not sure what's up with this...
}}


[[Category: Data structure]]
[[Category: Data structure]]
[[Category: Charlson Comorbid Diagnosis|*]]
[[Category:Charlson Comorbid Diagnosis (pre ICD10)]]

Latest revision as of 14:20, 2023 May 17

Legacy Content

This page contains Legacy Content.
  • Explanation: no longer a separate list in ICD10
  • Successor: Charlson Comorbidities in ICD10 codes

Click Expand to show legacy content.

Charlson Comorbidity scoring in pre-ICD10 codes

Table that contains the subset of s_alldiagnoses that are Charlson comorbids. Used in Charlson Comorbid coding (pre ICD10).

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 the s_AllDiagnoses table and theL Dxs table
  • allow_admit - include if it's an admit (we allow a handful)
  • allow_como - include if it's a comorbid (usual scenario)
  • comments - Charlson and testing specific comments

discrepancies between this table and s_alldiagnoses

discrepancies in como / allow_como columns resp Diag / allow_admit columns

saved working query 1_discrepancies between this table and s_alldiagnoses

Considering I can't remember how these are used who knows if this is a problem...

Code	Diag	allow_admit	Como	allow_como
10200	Yes	0		All	-1
10201	Yes	0		All	-1
10202	Yes	0		All	-1
10203	Yes	0		All	-1
10204	Yes	0		All	-1
10205	Yes	0		All	-1
10206	Yes	0		All	-1
10207	Yes	0		All	-1
10208	Yes	0		All	-1
10209	Yes	0		All	-1
10210	Yes	0		All	-1
10300	Yes	0		All	-1
10301	Yes	0		All	-1
10302	Yes	0		All	-1
10303	Yes	0		All	-1
10304	Yes	0		All	-1
10305	Yes	0		All	-1
10306	Yes	0		All	-1
10307	Yes	0		All	-1
10390	Yes	0		All	-1
25900	Yes	0			0
29906	Yes	0		All	0
40102	Yes	0		All	-1
40103	Yes	0		All	-1
41500	Yes	0		All	-1
41501	Yes	0		All	-1
41502	Yes	0		All	-1
52900	Yes	0		All	-1
53700	Yes	0		All	-1
53800	Yes	-1			-1
78101	Yes	-1			-1
78102	Yes	-1			-1
80500	Yes	0		All	-1

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...

Related articles

Related articles: