S ICD10 table: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (2 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 19: | Line 19: | ||
== Query to populate s_ICD10 table from wiki == | == Query to populate s_ICD10 table from wiki == | ||
[[Category:ICD10 wiki infrastructure]] | [[Category:ICD10 wiki infrastructure]] | ||
To extract data from the wiki to update this table in [[CCMDB. | 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 | ||
| Line 39: | Line 39: | ||
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. | 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. | * In CCMDB.accdb, External Data,text file | ||
* insert into new table | * insert into new table | ||
* delimited; click advanced button, make sure field delimiter is ;, | * delimited; click advanced button, make sure field delimiter is ;, | ||
| Line 51: | Line 51: | ||
Update categories | Update categories | ||
* [[Re-importing CCI and IDC10 categories from wiki to CCMDB. | * [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]] | ||
Likely problems | Likely problems | ||
| Line 58: | Line 58: | ||
=== categories === | === categories === | ||
see [[ICD10 Categories for CCMDB. | 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]] | ||