S ICD10 table: Difference between revisions

Line 1:

The '''S_ICD10''' table in [[CCMDB.~~mdb~~]] contains the possible codes to use with [[ICD10 collection]].

The '''S_ICD10''' table in [[CCMDB.accdb]] contains the possible codes to use with [[ICD10 collection]].

== Data Structure ==

Line 19:

== Query to populate s_ICD10 table from wiki ==

[[Category:ICD10 wiki infrastructure]]

To extract data from the wiki to update this table in [[CCMDB.~~mdb~~]], click the following link to generate an extract:

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]]

|?Has ICD10Code=ICD10_code

Line 39:

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.accdb, External Data,text file

* insert into new table

* delimited; click advanced button, make sure field delimiter is ;,

Line 51:

Update categories

* [[Re-importing CCI and IDC10 categories from wiki to CCMDB.~~mdb~~]]

* [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]]

Likely problems

Line 58:

=== categories ===

see [[ICD10 Categories for CCMDB.~~mdb~~]]

see [[ICD10 Categories for CCMDB.accdb]]

== Related Articles ==

@@ Line 1: / Line 1: @@
-The '''S_ICD10''' table in [[CCMDB.mdb]] contains the possible codes to use with [[ICD10 collection]].
+The '''S_ICD10''' table in [[CCMDB.accdb]] contains the possible codes to use with [[ICD10 collection]].
 == Data Structure ==
@@ Line 19: / Line 19: @@
 == Query to populate s_ICD10 table from wiki ==
 [[Category:ICD10 wiki infrastructure]]
-To extract data from the wiki to update this table in [[CCMDB.mdb]], click the following link to generate an extract:
+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]]
   |?Has ICD10Code=ICD10_code
@@ Line 39: / Line 39: @@
 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.accdb, External Data,text file
 * insert into new table
 * delimited; click advanced button, make sure field delimiter is ;,
@@ Line 51: / Line 51: @@
 Update categories
-* [[Re-importing CCI and IDC10 categories from wiki to CCMDB.mdb]]
+* [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]]
 Likely problems
@@ Line 58: / Line 58: @@
 === categories ===
-see [[ICD10 Categories for CCMDB.mdb]]
+see [[ICD10 Categories for CCMDB.accdb]]
 == Related Articles ==