S ICD10 table

The S_ICD10 table in CCMDB.mdb contains the possible codes to use with ICD10 collection.

Data Structure

field	type	description
ICD10_ID	AutoNumber	unique identifier, links to L_ICD10.ICD10_ID
ICD10_code	Text(10)	official ICD10 code
description	Text(255)	description of dx
important_wiki_info	yes/no	if true then the link to the wiki in CCMDB.mdb will be boldened
Bug_req	Text(1)
c_Past_Medical_History	yes/no
c_Infectious Disease	yes/no
c_Cardiovascular	yes/no
c_Resp	yes/no
c_GI	yes/no
c_Neuro	yes/no
c_Skin	yes/no
c_MSK_Soft_tissues	yes/no
c_Renal_Urinary	yes/no
c_Eye	yes/no
c_ENT	yes/no
c_Hematology_Immunology	yes/no
c_Metabolic_Nutrion	yes/no
c_Reproductive	yes/no
c_Endocrinology	yes/no
c_Neoplastic	yes/no
c_Psych	yes/no
c_Hereditary_Congenital	yes/no
c_Peripartum	yes/no
c_Testing	yes/no
c_Symptoms	yes/no
c_Iatrogenic	yes/no
c_Healthcare_Contact	yes/no
c_Injury_Poisoning	yes/no
c_Misc	yes/no
c_Mechanism	yes/no
OrderedNum	single	for sorting only, no meaning
min_nr_grouped_with	integer	min nr of dxs to be coded with this dx as Combined ICD10 codes
active_start	date/time	for enabling and disabling
active_end	single	for enabling and disabling
OldDxEquiv	long integer	link to S AllDiagnoses table
wiki_URL	single	link to dx article on this wiki
Charlson_condition	text	charlson condition link to S ICD10 Charlson Como conditions table

Query to populate from wiki

DSV