Charlson Comorbid coding (pre ICD10): Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 23: Line 23:


== Centralized data front end.mdb ==
== Centralized data front end.mdb ==
* query Charlson_Comorbid_Score
* [[Charlson Comorbid Score query]]


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

Revision as of 10:23, 2014 June 25

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)

Template:Discussion

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

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