Created APACHE Chronic query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "<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> {{Todo | who = Tina | question = * The query needs to eventually be triggered when the button "calc created variables" on the front screen of CFE is pressed. }} == Implementation == * For records with Dispo DtTm before '''the transition date''' it provides the con..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (16 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 == | |||
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 == | == 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 20: | Line 19: | ||
[[Category:Centralized_data_front_end.accdb]] | [[Category:Centralized_data_front_end.accdb]] | ||
[[Category:Created Variables]] | [[Category:Created Variables]] | ||
[[Category: | [[Category:Created_Variables_CC_2021 table]] | ||
Latest revision as of 19:20, 13 November 2024
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: |