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. -->
-  |mainlabel=-
+{{#ask: [[Has ICD10exportCat::+]][[Has ICD10Category::!Retired Code]][[Has StopDate::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]]
+  |mainlabel=-
   |?Has ICD10exportCat=
-  |format=list
+  |format=array
- |link=none
+  |limit=5000
-  |limit=10000
+  |sep=<br>
-  |headers=show
+  |manysep=<br>
-  |class=sortable wikitable smwtable
+}}
- |sep=<br>}}
 [[Category:ICD10| *]]