ICD10 Categories for CCMDB.accdb: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-This page is really only intended to extract the categories from the wiki for import into [[CCMDB.mdb]]. There are better ways to view this content, such as [[ICD10 Category]].
+This page is really only intended to extract the categories from the wiki for import into [[CCMDB.accdb]]. There are better ways to view this content, such as [[ICD10 Category]].
+The ICD10 counterpart to this page is [[CCI Categories for CCMDB.accdb]].
-List format is he only way to get this one property per line, .csv doesn't cut it.
+== Import process ==
+see [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]]
-Then copy paste into text file, and import into spreadsheet with semicolon as separator
 == The list ==
-{{#ask: [[Has ICD10exportCat::+]]
+<!--List format is he only way to get this one property per line, .csv doesn't cut it. -->
+{{#ask: [[Has ICD10exportCat::+]][[Has ICD10Category::!Retired Code]][[Has StopDate::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]]
   |mainlabel=-
   |?Has ICD10exportCat=
- |sort=Has ICD10exportCat
+  |format=array
-  |format=list
- |link=none
   |limit=5000
-  |headers=show
+  |sep=<br>
- |class=sortable wikitable smwtable
+  |manysep=<br>
-  |sep=<br>}}
+}}
 [[Category:ICD10| *]]