S ICD10 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (23 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The ''' | {{DISPLAYTITLE:s_ICD10 table}}The '''s_ICD10''' table in [[CCMDB.accdb]] contains the possible codes to use with [[ICD10 collection]]. | ||
== Data Structure == | == Data Structure == | ||
| Line 8: | Line 8: | ||
!| description | !| description | ||
|- | |- | ||
|| '''[[ | || '''[[ICD10_code]]''' || Text(10) || official [[ICD10]] code | ||
|- | |- | ||
|| '''description''' || Text(255) || description of dx | || '''description''' || Text(255) || description of dx | ||
|- | |- | ||
|| ''' | || '''[[Property:Has StartDate | active_start]]''' || date/time || for enabling and disabling | ||
|- | |- | ||
|| ''' | || '''[[Property:Has StopDate | active_end]]''' || single || for enabling and disabling | ||
|} | |} | ||
== Query to populate s_ICD10 table from wiki == | == Query to populate s_ICD10 table from wiki == | ||
[[Category:ICD10 wiki infrastructure]] | |||
To extract data from the wiki to update this table in [[CCMDB.accdb]], click the following link to generate an extract: | |||
{{#ask: [[Category:ICD10 Diagnosis]] | {{#ask: [[Category:ICD10 Diagnosis]] | ||
|?Has ICD10Code=ICD10_code | |?Has ICD10Code=ICD10_code | ||
|?=description | |?=description | ||
|?Has | |?Has StartDate#ISO=active_start | ||
|?Has StopDate#ISO=active_end | |||
|format=broadtable | |format=broadtable | ||
|limit= | |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=; | |||
}} | }} | ||
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.accdb, 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 | |||
* [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]] | |||
Likely problems | |||
* bad data in a column | |||
* duplicate ICD10 codes due to evil twins on wiki | |||
=== categories === | |||
see [[ICD10 Categories for CCMDB.accdb]] | |||
== Related Articles == | == Related Articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: S ICD10 table|*]] | [[Category: S ICD10 table| *]] | ||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: ICD10/CCI Conversion]] | [[Category: ICD10/CCI Conversion]] | ||
[[Category: ICD10]] | [[Category: ICD10]] | ||
[[Category: Charlson Comorbid Diagnosis]] | [[Category: Charlson Comorbid Diagnosis]] | ||
Latest revision as of 16:26, 2023 May 17
The s_ICD10 table in CCMDB.accdb 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.accdb, 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.accdb, 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.accdb