S charlson dxs table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 5: | Line 5: | ||
== 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 | * ''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_admit'' - include if it's an admit (we allow a handful) | ||
* ''allow_como'' - include if it's a comorbid (usual scenario) | * ''allow_como'' - include if it's a comorbid (usual scenario) | ||
Revision as of 12:41, 2018 March 5
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...