S ICD10 table: Difference between revisions

(17 intermediate revisions by the same user not shown)

Line 1:

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

{{DISPLAYTITLE:s_ICD10 table}}The '''s_ICD10''' table in [[CCMDB.accdb]] contains the possible codes to use with [[ICD10 collection]].

== Data Structure ==

Line 7:

!| type

!| description

|-

~~|| '''[[ICD10_ID]]''' || AutoNumber || unique identifier, links to [[L_ICD10 table|L_ICD10]].ICD10_ID~~

|-

|| '''[[ICD10_code]]''' || Text(10) || official [[ICD10]] code

Line 14:

Line 12:

|| '''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~~

|| '''[[Property:Has StartDate | active_start]]''' || date/time || for enabling and disabling

|-

~~|| '''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

|| '''[[Property:Has StopDate | 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:

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

|?Has ICD10Code=ICD10_code

|?=description

~~|?Has BugRequired=Bug_req~~

~~|?Has MinimumCombinedCodes=min_nr_grouped_with~~

|?Has StartDate#ISO=active_start

|?Has StopDate#ISO=active_end

Line 48:

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 58:

Line 49:

* 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 ==

[[Category: S ICD10 table|*]]

[[Category: S ICD10 table| *]]

[[Category: Data structure]]

[[Category: ICD10/CCI Conversion]]

[[Category: ICD10]]

[[Category: Charlson Comorbid Diagnosis]]

@@ Line 1: / Line 1: @@
-The '''S_ICD10''' table in [[CCMDB.mdb]] contains the possible codes to use with [[ICD10 collection]].
+{{DISPLAYTITLE:s_ICD10 table}}The '''s_ICD10''' table in [[CCMDB.accdb]] contains the possible codes to use with [[ICD10 collection]].
 == Data Structure ==
@@ Line 7: / Line 7: @@
 !| type
 !| description
-|-
-|| '''[[ICD10_ID]]''' || AutoNumber || unique identifier, links to [[L_ICD10 table|L_ICD10]].ICD10_ID
 |-
 || '''[[ICD10_code]]''' || Text(10) || official [[ICD10]] code
@@ Line 14: / Line 12: @@
 || '''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
+|| '''[[Property:Has StartDate | active_start]]''' || date/time || for enabling and disabling
-|-
-|| '''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
+|| '''[[Property:Has StopDate | 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:
+[[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]]
   |?Has ICD10Code=ICD10_code
   |?=description
- |?Has BugRequired=Bug_req
- |?Has MinimumCombinedCodes=min_nr_grouped_with
   |?Has StartDate#ISO=active_start
   |?Has StopDate#ISO=active_end
@@ Line 48: / 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 58: / Line 49: @@
 * 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}}
-[[Category: S ICD10 table|*]]
+[[Category: S ICD10 table| *]]
 [[Category: Data structure]]
 [[Category: ICD10/CCI Conversion]]
 [[Category: ICD10]]
 [[Category: Charlson Comorbid Diagnosis]]