S ICD10 APACHE Dx query

 This is not about the S_ICD10_APACHE_Comorbids query.

The s_ICD10_APACHE_Dx query generates a list of ICD10 diagnoses and which APACHE Acute Diagnoses they would contribute to. The results of the query are used to refresh the page APACHE Acute Dxs in ICD10 codes.

The query lists records in s_ICD10 table that match the patterns in s_ICD10_APACHE_Dx_patterns table.