Created APACHE Chronic query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(10 intermediate revisions by the same user not shown)
Line 2: Line 2:


== Implementation ==
== Implementation ==
Lists all records that have APACHE Chronic based either on ICD10 or on old [[Chronic Health APACHE]] variable.  
Lists a value for [[Chronic Health APACHE]] variable. For records with a [[Dispo_DtTm]] < 2019-01-01, the value from the [[Ap_Chronic]] field is used, for records with a [[Dispo_DtTm]] >= 2019-01-01, a value derived from [[ICD10 Diagnoses]] via [[L_ICD10_APACHE_Comorbids query]] is used.  


{{DJ |
=== No need to consider ''Drug-induced immunosuppression'' ===
* We could change it to something that deliberately chooses how to derive based on time, but is there any advantage to that?
We were initially collecting the ''Immunosuppressed'' part of this as CCI code ''Drug-induced immunosuppression'' and then changed it to ICD10 code [[Past history of immunosuppressive drugs or corticosteroids]]. Since we did not stop collecting the "old" way [[Chronic Health APACHE]] before that change we don't need to give consideration to the ''Drug-induced immunosuppression'' records.
** For records with [[Dispo DtTm]] before '''the transition date''' it provides the content of the [[Chronic Health APACHE]] field.
** For records with [[Dispo DtTm]] after'''the transition date''' it provides a count of the qualifying diagnoses as per [[L_ICD10_APACHE_Comorbids query]]
}}
 
 
=== No need to consider [[Drug-induced immunosuppression]] ===
We were initially collecting the ''Immunosuppressed'' part of this as [[Drug-induced immunosuppression]] and then changed it to [[Past history of immunosuppressive drugs or corticosteroids]]. Since we did not stop collecting the "old" way [[Chronic Health APACHE]] before that change we don't need to give consideration to the [[Drug-induced immunosuppression]] records.  


== Log ==
== Log ==
* 2022-11-29 - updated to no longer reference query L_CCI_Component_APACHE_Comorbids since CCIs wouldn't track Comborbids
* 2022-06-20 - updated [[Created_APACHE_Chronic query]] to start using ICD10 derived Chronic Health scoring for values >= 2019-01-01
* 2022-04-06 - implemented
* 2022-04-06 - implemented


Line 22: Line 17:
[[Category:Centralized_data_front_end.accdb]]
[[Category:Centralized_data_front_end.accdb]]
[[Category:Created Variables]]
[[Category:Created Variables]]
[[Category:Created Variables CC table]]
[[Category:Created_Variables_CC_2021 table]]

Latest revision as of 13:42, 2023 May 4

The Created_APACHE_Chronic query in CFE provides a replacement of the Chronic Health APACHE field to the Created_Variables_Common_maker_2021 query.

Implementation

Lists a value for Chronic Health APACHE variable. For records with a Dispo_DtTm < 2019-01-01, the value from the Ap_Chronic field is used, for records with a Dispo_DtTm >= 2019-01-01, a value derived from ICD10 Diagnoses via L_ICD10_APACHE_Comorbids query is used.

No need to consider Drug-induced immunosuppression

We were initially collecting the Immunosuppressed part of this as CCI code Drug-induced immunosuppression and then changed it to ICD10 code Past history of immunosuppressive drugs or corticosteroids. Since we did not stop collecting the "old" way Chronic Health APACHE before that change we don't need to give consideration to the Drug-induced immunosuppression records.

Log

  • 2022-11-29 - updated to no longer reference query L_CCI_Component_APACHE_Comorbids since CCIs wouldn't track Comborbids
  • 2022-06-20 - updated Created_APACHE_Chronic query to start using ICD10 derived Chronic Health scoring for values >= 2019-01-01
  • 2022-04-06 - implemented

Related articles

Related articles: