Charlson Comorbid coding (pre ICD10)

The Charlson Comorbid score is the sum of points for all Comorbid Diagnoses that have a Charlson score associated with them. Template:Discussion

• is that the definition we use? Where is the master definition? Ttenbergen 22:18, 2014 January 15 (CST)
  • maybe a link to the original paper? Ttenbergen 23:14, 2014 May 26 (CDT)

• do we, and if not, should we include any subset of diagnoses (as opposed to comorbids) that are also allowed as diagnoses, in the calculation of the score? Ttenbergen 22:18, 2014 January 15 (CST) Ttenbergen 23:14, 2014 May 26 (CDT)

SAS coding macro comorbid3

The statistician has a SAS macro called "comorbid3" that calculates the score for data after import. This is important because the addition of points has exceptions for mutually exclusive dxs (eg mild and severe diabetes).

Summary: Add dx scores except following:

• score only the higher of
  • mild moderate diabetes
  • moderate / severe liver disease
• only one count in case there are several cancers

sas code

as of 2015-09-22

     if Charlson_category='AIDS      ' then Comopts=6; 
     if Charlson_category='CHF       ' then Comopts=1;
     if Charlson_category='CVA       ' then Comopts=1;
     if Charlson_category='Dementia  ' then Comopts=1;
     if Charlson_category='Diabetes  ' then do;  **mutually exclusive**;
           if ComorbidCode in (30089) then Comopts=2;
           else Comopts=1; *Diabetes has pt=1 while Diabetes with chronic comp has pt=2 *;
     end; 
     if Charlson_category='Leukemia  ' then Comopts=2; 
     if Charlson_category='Liver     ' then do;  **mutually exclusive**;
           if ComorbidCode in (40787,40887) then Comopts=1;
           else Comopts=3;  *Mild liver disease has pt=1 while moderate/severe liver disease has pt=3 *;
     end;
     if Charlson_category='Lymphoma  ' then Comopts=2;
     if Charlson_category='MI        ' then Comopts=1;
     if Charlson_category='Malignancy' then do;  **mutually exclusive**;
           if ComorbidCode in (70001,70101,70201,70301,70401,70501,    
                        70601,70701,70801,70901,71001,71101,
                             71201,71301,71401,71501,71601,71701,
                             71801,71901,72001,72101,72201,72301,
                             72401,72501,74901,74901,74800,74801 
                      )  then Comopts=6;    * any tumor has pt=2 while Solid Tumor has pt=6 *;
           else Comopts=2;
     end;
     if Charlson_category='PVD       ' then Comopts=1;
     if Charlson_category='connective' then Comopts=1;
     if Charlson_category='plegia    ' then Comopts=2;
     if Charlson_category='pulmonary ' then Comopts=1; 
     if Charlson_category='renal     ' then Comopts=2;
     if Charlson_category='ulcer     ' then Comopts=1;

CCMBD.mdb

queries

• s_charlson_score

sums the scores in

• s_charlson__combined

which unions (ie no duplicates)

• s_charlson_adm - list of scores for the highest-scoring admit dx per charlson category
• s_charlson_como - list of scores for the highest-scoring comorbid dx per charlson category

function Charlson_score_function

The function Charlson_score_function (Pat_ID) in CCMDB.mdb looks up and returns the score in query s_charlsonScore.

Centralized data front end.mdb

• Charlson Comorbid Score query