S ICD10 table

From CCMDB Wiki
Jump to navigation Jump to search

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

DSV

Related Articles

Related articles: