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)
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

Query to populate s_ICD10 table from wiki

ICD10_code	description	Has BugRequired
0	No Dx Entered
00	Not an Infection (ICD10 pathogen alternative)
... further results

| format=dsv
| filename=s_ICD10_wiki_to_table.txt
| sep=;