APACHE Acute Diagnoses: Difference between revisions

(One intermediate revision by the same user not shown)

Line 25:

*Starting Jan 2019, Dr. Allan Garland did the mapping of the admit ICD10 codes and CCI codes to the diagnosis categories included in the model.

**The list of admit diagnosis ICD10 codes is shown in [[APACHE Acute Dxs in ICD10 codes]]

~~{{Discuss|JALT~~

* The list of admit CCI procedures used in combination with the admit ICD10 codes is shown in

** There are many questions about that list, I have emailed Julie and Allan for more info. [[User:Ttenbergen|Ttenbergen]] 16:38, 2022 June 15 (CDT)

*** Allan has provided newest list, but there were version control issues. Allan to sent the current master version to Tina and Julie as of today's JALT. [[User:Ttenbergen|Ttenbergen]] 10:11, 2022 July 27 (CDT)

}}

== Implementation in CCMDB ==

The

* [[S_ICD10_APACHE_Dx query]]

draws on the

* [[S_ICD10_APACHE_Dx_patterns table]] and the [[s_ICD10 table]]

The contents of the

* [[S_ICD10_APACHE_Dx query]]

are then used by the

* [[L_ICD10_APACHE_Dx query]]

to provide the list of ICD10 APACHE Acute Diagnoses for patient records.

For a list of these diagnoses on this wiki, see

* [[APACHE Acute Dxs in ICD10 codes]]

For a list of these CCI procedures on this wiki, see

=== Notes from reviewing the list ===

{{TT | just Tina's working notes:

Line 50:

Line 62:

* one of a * of ICD10s AND (one of * of CCI1 and a * of CCI2)

** might be able to do a pattern recognition on that? Or a regular expression?

}}

{{TT |

* I will need to re-think how these are documented on the wiki as well, as the current schema was based on individual dxs meeting criteria and this is quite different. [[User:Ttenbergen|Ttenbergen]] 10:39, 2022 November 15 (CST)

}}

Allan updated the original list and documented some reasons for decisions at item 13 in [[Task Team Meeting - Rolling Agenda and Minutes 2022#‎ICU Database Task Group Meeting – July 13, 2022]].

~~== Implementation in CCMDB ==~~

~~The~~

* [[S_ICD10_APACHE_Dx query]]

~~draws on the~~

* [[S_ICD10_APACHE_Dx_patterns table]] and the [[s_ICD10 table]]

~~The contents of the~~

* [[S_ICD10_APACHE_Dx query]]

~~are then used by the~~

* [[L_ICD10_APACHE_Dx query]]

~~to provide the list of ICD10 APACHE Acute Diagnoses for patient records.~~

~~For a list of these diagnoses on this wiki, see~~

* [[APACHE Acute Dxs in ICD10 codes]]

~~For a list of these CCI procedures on this wiki, see~~

* {{ TT| same as above }}

== Reporting of the Eight Major Diagnostic Categories ==

@@ Line 25: / Line 25: @@
 *Starting Jan 2019, Dr. Allan Garland did the mapping of the admit ICD10 codes and CCI codes to the diagnosis categories included in the model.
 **The list of admit diagnosis ICD10 codes is shown in [[APACHE Acute Dxs in ICD10 codes]]
-{{Discuss|JALT
-* The list of admit CCI procedures used in combination with the admit ICD10 codes is shown  in
-** There are many questions about that list, I have emailed Julie and Allan for more info. [[User:Ttenbergen|Ttenbergen]] 16:38, 2022 June 15 (CDT)
-*** Allan has provided newest list, but there were version control issues. Allan to sent the current master version to Tina and Julie as of today's JALT. [[User:Ttenbergen|Ttenbergen]] 10:11, 2022 July 27 (CDT)
-}}
+== Implementation in CCMDB ==
+The
+* [[S_ICD10_APACHE_Dx query]]
+draws on the
+* [[S_ICD10_APACHE_Dx_patterns table]] and the [[s_ICD10 table]]
+The contents of the
+* [[S_ICD10_APACHE_Dx query]]
+are then used by the
+* [[L_ICD10_APACHE_Dx query]]
+to provide the list of ICD10 APACHE Acute Diagnoses for patient records.
+For a list of these diagnoses on this wiki, see
+* [[APACHE Acute Dxs in ICD10 codes]]
+For a list of these CCI procedures on this wiki, see
 === Notes from reviewing the list ===
 {{TT | just Tina's working notes:
@@ Line 50: / Line 62: @@
 * one of a * of ICD10s AND (one of * of CCI1 and a * of CCI2)
 ** might be able to do a pattern recognition on that? Or a regular expression?
+}}
+{{TT |
+* I will need to re-think how these are documented on the wiki as well, as the current schema was based on individual dxs meeting criteria and this is quite different. [[User:Ttenbergen|Ttenbergen]] 10:39, 2022 November 15 (CST)
 }}
 Allan updated the original list and documented some reasons for decisions at item 13 in [[Task Team Meeting - Rolling Agenda and Minutes 2022#‎ICU Database Task Group Meeting – July 13, 2022]].
-== Implementation in CCMDB ==
-The
-* [[S_ICD10_APACHE_Dx query]]
-draws on the
-* [[S_ICD10_APACHE_Dx_patterns table]] and the [[s_ICD10 table]]
-The contents of the
-* [[S_ICD10_APACHE_Dx query]]
-are then used by the
-* [[L_ICD10_APACHE_Dx query]]
-to provide the list of ICD10 APACHE Acute Diagnoses for patient records.
-For a list of these diagnoses on this wiki, see
-* [[APACHE Acute Dxs in ICD10 codes]]
-For a list of these CCI procedures on this wiki, see
-* {{ TT| same as above }}
 == Reporting  of the Eight Major Diagnostic Categories ==