Created APACHE Chronic query

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