Charlson Comorbid coding (pre ICD10): Difference between revisions

m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
Line 6: Line 6:
See [[List of diagnosis codes corresponding to Charlson Comorbidities (pre ICD10)]].   
See [[List of diagnosis codes corresponding to Charlson Comorbidities (pre ICD10)]].   


The Charlson Comorbid diagnoses and their scores are a subset of [[s_AllDiagnoses table]] table in [[CCMDB.mdb]]. Actual values are stored in stored in the [[L_Como table]].
The Charlson Comorbid diagnoses and their scores are a subset of [[s_AllDiagnoses table]] table in [[CCMDB.accdb]]. Actual values are stored in stored in the [[L_Como table]].


== SAS coding macro ''comorbid3'' ==
== SAS coding macro ''comorbid3'' ==
Line 61: Line 61:


=== function ''Charlson_score_function''===
=== function ''Charlson_score_function''===
The function ''Charlson_score_function (Pat_ID)'' in [[CCMDB.mdb]] looks up and returns the score in query s_charlsonScore.
The function ''Charlson_score_function (Pat_ID)'' in [[CCMDB.accdb]] looks up and returns the score in query s_charlsonScore.


== Centralized data front end.mdb ==
== Centralized data front end.mdb ==