S ICD10 table: Difference between revisions

(13 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 ==

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

|?=description

~~|?Has BugRequired=Bug_req~~

~~|?Has MinimumCombinedCodes=min_nr_grouped_with~~

|?Has StartDate#ISO=active_start

|?Has StopDate#ISO=active_end

Line 49:

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

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

Line 64:

Line 57:

* duplicate ICD10 codes due to evil twins on wiki

== ~~Attempt at exporting with~~ categories ==

=== categories ===

~~Too slow and too big, but here is the start for the code with its template~~

see [[ICD10 Categories for CCMDB.accdb]]

~~{{#ask:~~ [[~~Category:~~ICD10 ~~Diagnosis~~]]

~~|mainlabel=-~~

~~|?Has ICD10Code=ICD10_code~~

~~|?=description~~

~~|?Has ICD10Category~~

~~|limit=0~~

~~|link=none~~

~~|sort=Has ICD10Code~~

~~|order=ascending~~

~~|@deferred~~

~~| format=template~~

~~| template=ICD10 Diagnoses with original categories body~~

~~| introtemplate=ICD10 Diagnoses with original categories header~~

~~| outrotemplate=ICD10 Diagnoses with original categories footer~~

}}

== Related Articles ==

@@ 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 ==
 [[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
   |?=description
- |?Has BugRequired=Bug_req
- |?Has MinimumCombinedCodes=min_nr_grouped_with
   |?Has StartDate#ISO=active_start
   |?Has StopDate#ISO=active_end
@@ Line 49: / 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 59: / 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
@@ Line 64: / Line 57: @@
 * duplicate ICD10 codes due to evil twins on wiki
-== Attempt at exporting with categories ==
+=== categories ===
-Too slow and too big, but here is the start for the code with its template
+see [[ICD10 Categories for CCMDB.accdb]]
-{{#ask: [[Category:ICD10 Diagnosis]]
- |mainlabel=-
- |?Has ICD10Code=ICD10_code
- |?=description
- |?Has ICD10Category
- |limit=0
- |link=none
- |sort=Has ICD10Code
- |order=ascending
- |@deferred
- | format=template
- | template=ICD10 Diagnoses with original categories body
- | introtemplate=ICD10 Diagnoses with original categories header
- | outrotemplate=ICD10 Diagnoses with original categories footer
-}}
 == Related Articles ==