Charlson Comorbid coding (pre ICD10): Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 4: Line 4:
The [[statistician]] has a SAS macro called "comorbid3" that calculates the score for data after import.
The [[statistician]] has a SAS macro called "comorbid3" that calculates the score for data after import.


== CCMBD.mdb function ''Charlson_score_function'' ==
== CCMBD.mdb ==
=== queries ===
* s_charlson_score
calls
* s_charlson__combined
which uses
* 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]] will return the Charlson Score for a patient. It will do this by comparing the contents of L_Como and the table [[s charlson dxs]], using queries ''s_charlson_dx'' and ''s_charlson_score''.
The function ''Charlson_score_function (Pat_ID)'' in [[CCMDB.mdb]] will return the Charlson Score for a patient. It will do this by comparing the contents of L_Como and the table [[s charlson dxs]], using queries ''s_charlson_dx'' and ''s_charlson_score''.




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

Revision as of 16:42, 2013 December 23

The Charlson Comorbid score is calculated by different functions in different parts of CCMDB.

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

calls

  • s_charlson__combined

which uses

  • 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 will return the Charlson Score for a patient. It will do this by comparing the contents of L_Como and the table s charlson dxs, using queries s_charlson_dx and s_charlson_score.