s_ICD10_APACHE_Dx_patterns table

From CCMDB Wiki
Jump to navigation Jump to search

The s_ICD10_APACHE_Dx_patterns table lists the patterns to match to determine which items in the s_ICD10 table and part of the APACHE Acute Diagnoses.

Data Structure

field type description
category Text(50) APACHE dx category this record responds to
ns Text(5) ns name for that category
description Text(50) description of this actual dx
postop yes/no only assess these if "Admitted to ICU postoperatively", i.e. if Previous Location was OR or PACU
only_if_nsA-nsY yes/no if this column is true, only assess this line for patients for whom none of nsA-nsY are true
only_if_none_sA-sS yes/no if this column is true, only assess this line for patients for whom none of s_A-s_S are true
like_match text(20) condition to match ICD10_code by actual match
range_start text(20) condition to match ICD10_code by range, dx code would need to be >= this
range_end text(20) condition to match ICD10_code by range, dx code would need to be < this
summaryrange Text(255) complete conditions for this description as per excel file provided by Allan Garland.
Weight numeric Weights of the Principal Diagnostic Category leading to ICU admission in the Risk Model of Predicting Hospital Death
Index numeric Index number assigned for each APACHE dx category in the SAS program done by Dr. Kendiss Olafson
DxGrp numeric Diagnostic Categories being used for the Director's Report as specified by Dr. Kendiss Olafson
DxGrp_label Text(50) Label of the Diagnostic Categories being used for the Director's Report as specified by Dr. Kendiss Olafson

Allan mainly used this ref: https://rstudio-pubs-static.s3.amazonaws.com/231351_940f14aa51a6427a9e92d5a04daefc3e.html


Related articles

Related articles: