S ICD10 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 47: | Line 47: | ||
Then: | Then: | ||
Import the file into a new table. Importing straight into s_icd10 is possible, but if there are errors it is hard to troubleshoot. Importing into new table first has fewer restrictions. | |||
* In CCMDB.mdb, External Data,text file | * In CCMDB.mdb, External Data,text file | ||
* | * insert into new table | ||
* delimited; click advanced button, make sure field delimiter is ; | * delimited; click advanced button, make sure field delimiter is ;, | ||
* file has headers | |||
Copy content into s_icd10 | |||
* empty out s_icd10 | |||
* copy and paste data from new table | |||
Likely problems | |||
* bad data in a column | |||
* duplicate ICD10 codes due to evil twins on wiki | |||
== Related Articles == | == Related Articles == | ||
Revision as of 23:21, 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
To extract data from the wiki to update this table in CCMDB.mdb, click the following link to generate an extract: DSV
Then: Import the file into a new table. Importing straight into s_icd10 is possible, but if there are errors it is hard to troubleshoot. Importing into new table first has fewer restrictions.
- In CCMDB.mdb, External Data,text file
- insert into new table
- delimited; click advanced button, make sure field delimiter is ;,
- file has headers
Copy content into s_icd10
- empty out s_icd10
- copy and paste data from new table
Likely problems
- bad data in a column
- duplicate ICD10 codes due to evil twins on wiki