S ICD10 table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 29: Line 29:
  |?Has ICD10Code=ICD10_code
  |?Has ICD10Code=ICD10_code
  |?=description
  |?=description
  |?Has BugRequired
  |?Has BugRequired=Bug_req
|?Has MinimumCombinedCodes=min_nr_grouped_with
|?Has StartDate=active_start
|?Has StopDate=active_end
  |format=broadtable
  |format=broadtable
  |limit=2
  |limit=2000
  |link=all
  |link=all
  |sort=Has ICD10Code
  |sort=Has ICD10Code
  |order=ascending
  |order=ascending
  |headers=show
  |headers=show
|mainlabel=-
  | format=dsv
  | filename=s_ICD10_wiki_to_table.txt
  | sep=;
}}
}}
| format=dsv
| filename=s_ICD10_wiki_to_table.txt
| sep=;


== Related Articles ==
== Related Articles ==

Revision as of 22:31, 2017 December 5

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: