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=;