L ICD10 APACHE Dx query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,597 edits
No edit summary
Line 5: Line 5:
{{Discuss | who = Julie | question = * You and Allan discussed what should be on the list. At some point we will need to integrate the result into this query. Did you end up including Acquireds? Since the first 24hrs might include them, but they might happen later, and the difference is not clear from [[Dx_Date]]? Ttenbergen 20:20, 2018 November 24 (CST)
{{Discuss | who = Julie | question = * You and Allan discussed what should be on the list. At some point we will need to integrate the result into this query. Did you end up including Acquireds? Since the first 24hrs might include them, but they might happen later, and the difference is not clear from [[Dx_Date]]? Ttenbergen 20:20, 2018 November 24 (CST)
** is this the list which Allan gave about the APACHE Comorbids conditions namely liver, cardiovascular, respiratory, renal and immunocompromised?  allan said exclude the admits and include only the comorbids.  but we still have to discuss the comparative results. --[[User:JMojica|JMojica]] 16:45, 2022 February 16 (CST)  
** is this the list which Allan gave about the APACHE Comorbids conditions namely liver, cardiovascular, respiratory, renal and immunocompromised?  allan said exclude the admits and include only the comorbids.  but we still have to discuss the comparative results. --[[User:JMojica|JMojica]] 16:45, 2022 February 16 (CST)  
*** No, that is [[L ICD10 APACHE Comorbids query]], this is about the  [[APACHE Acute Diagnoses]] used in [[APACHE Score]]. [[User:Ttenbergen|Ttenbergen]] 19:44, 2022 February 17 (CST)  }}
*** No, that is [[L ICD10 APACHE Comorbids query]], this is about the  [[APACHE Acute Diagnoses]] used in [[APACHE Score]]. [[User:Ttenbergen|Ttenbergen]] 19:44, 2022 February 17 (CST)  
***sent email to Tina today to clarify this. --[[User:JMojica|JMojica]] 17:04, 2022 April 6 (CDT)
  }}


== Related Articles ==
== Related Articles ==

Revision as of 17:04, 6 April 2022

The L_ICD10_APACHE_Comorbids query generates a list of patients ICD10 diagnoses and which APACHE Acute Diagnoses they would contribute to.

The query lists dx records in L_ICD10 table that have a counterpart in S_ICD10_APACHE_Dx query and have Dx_Type = "Admit".

  • You and Allan discussed what should be on the list. At some point we will need to integrate the result into this query. Did you end up including Acquireds? Since the first 24hrs might include them, but they might happen later, and the difference is not clear from Dx_Date? Ttenbergen 20:20, 2018 November 24 (CST)
    • is this the list which Allan gave about the APACHE Comorbids conditions namely liver, cardiovascular, respiratory, renal and immunocompromised? allan said exclude the admits and include only the comorbids. but we still have to discuss the comparative results. --JMojica 16:45, 2022 February 16 (CST)
  • SMW


  • Cargo


  • Categories

Related Articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=L_ICD10_APACHE_Dx_query&oldid=155355"