S ICD10 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m turns out frequency is not needed after all |
Ttenbergen (talk | contribs) |
||
| Line 49: | Line 49: | ||
* delete the imported table, just takes up extra space | * delete the imported table, just takes up extra space | ||
* '''this will need to be done differently once we go live''' to preserve existing dx codes; chances are by then this will have slowed down, so we can just manually update as needed. | * '''this will need to be done differently once we go live''' to preserve existing dx codes; chances are by then this will have slowed down, so we can just manually update as needed. | ||
Update categories | |||
* [[Re-importing CCI and IDC10 categories from wiki to CCMDB.mdb]] | |||
Likely problems | Likely problems | ||
Revision as of 16:28, 21 August 2019
The S_ICD10 table in CCMDB.mdb contains the possible codes to use with ICD10 collection.
Data Structure
| field | type | description |
|---|---|---|
| ICD10_code | Text(10) | official ICD10 code |
| description | Text(255) | description of dx |
| 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, can use query s_ICD10_from_wiki_appender
- delete the imported table, just takes up extra space
- this will need to be done differently once we go live to preserve existing dx codes; chances are by then this will have slowed down, so we can just manually update as needed.
Update categories
Likely problems
- bad data in a column
- duplicate ICD10 codes due to evil twins on wiki
categories
see ICD10 Categories for CCMDB.mdb