Created APACHE Chronic query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
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.
 
{{TT |
* We could change it to something that deliberately chooses how to derive based on time, but is there any advantage to that?
** 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]]
*** Discussed at Task today, see those minutes for what was decided, taking off Julie's list. [[User:Ttenbergen|Ttenbergen]] 16:02, 2022 June 22 (CDT)
 
}}


{{Todo  
{{Todo  

Revision as of 10:34, 2022 June 30

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.

_after

  • added: 2022-06-14
  • action: 2022-06-14
  • Cargo


  • Categories

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-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: