CCMDB Wiki

CCI Categories for CCMDB.accdb: Difference between revisions

← Older edit
mNo edit summary
 
(16 intermediate revisions by the same user not shown)
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 [[CCI 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 [[CCI Category]].
The ICD10 counterpart to this page is [[ICD10 Categories for CCMDB.mdb]].  
The ICD10 counterpart to this page is [[ICD10 Categories for CCMDB.accdb]].  


== Import process ==
== Import process ==
# Copy paste contents of this page into text file
see [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]]
# import into [[S_CCI_Categories table]] with semicolon as separator (import will default to that...)
#* for now, there are some blinky heads getting imported, need to sort by code and delete the lines starting with "Interro-01.gif"; this will go away once the code for page [[Chest tube]] is assigned.


== The list ==
== The list ==
<!--List format is he only way to get this one property per line, .csv doesn't cut it. -->
<!--List format is he only way to get this one property per line, .csv doesn't cut it. -->
{{#ask: [[Has ICD10Category::!Retired Code]]
{{#ask: [[Has StopDate::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]][[Has CCI Category::+]][[Has CCI 2 Code::+]]
[[Has CCI Category::+]][[Has CCI 2 Code::+]]
        OR [[Has CCI Category::+]][[Has CCI 1 Code::+]]
        OR [[Has CCI Category::+]][[Has CCI Picklist Code::+]]
  |mainlabel=-  
  |mainlabel=-  
  |?Has_CCIexportCat=  
  |?Has_CCIexportCat=  
  |format=list
  |format=array
|link=none
  |limit=5000
  |limit=5000
  |headers=show
  |sep=<br>
  |class=sortable wikitable smwtable
|manysep=<br>
  |sep=<br>}}
|propsep=
}}<br>
{{#ask:[[Has StopDate::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]][[Has CCI Category::+]][[Has CCI 1 Code::+]]
|mainlabel=-
|?Has_CCIexportCat=
|format=array
  |limit=5000
  |sep=<br>
|manysep=<br>
|propsep=
}}<br>
{{#ask:[[Has StopDate::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]][[Has CCI Category::+]][[Has CCI Picklist Code::+]]
|mainlabel=-
|?Has_CCIexportCat=
|format=array
|limit=5000
|sep=<br>
|manysep=<br>
|propsep=
}}
 




[[Category:CCI| *]]
[[Category:CCI| *]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCI_Categories_for_CCMDB.accdb"