Created APACHE Chronic query: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "Category:Created Variables CC table" to "Category:Created_Variables_CC_2021 table" |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
<onlyinclude>The [[Created_APACHE_Chronic query]] in [[CFE]] provides a replacement of the [[Chronic Health APACHE]] field to the [[Created_Variables_Common_maker_2021 query]]. </onlyinclude> | {{DISPLAYTITLE:created_APACHE_Chronic query}}<onlyinclude>The [[Created_APACHE_Chronic query]] in [[CFE]] provides a replacement of the [[Chronic Health APACHE]] field to the [[Created_Variables_Common_maker_2021 query]]. </onlyinclude> | ||
== Implementation == | == 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. | 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 | === No need to consider ''Drug-induced immunosuppression'' === | ||
We were initially collecting the ''Immunosuppressed'' part of this as CCI code | 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 == | == Log == | ||
* 2022-11-29 - updated to no longer reference query L_CCI_Component_APACHE_Comorbids since CCIs wouldn't track Comborbids | * 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-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 | ||