Created APACHE Chronic query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (there is no triggering, the queries will simply use this) |
|||
| (14 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
== Implementation == | == Implementation == | ||
* For records with [[ | 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 14: | 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 11:29, 2024 April 8
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: |