S ICD10 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 26: | Line 26: | ||
== Query to populate s_ICD10 table from wiki == | == 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: | |||
{{#ask: [[Category:ICD10 Diagnosis]] | {{#ask: [[Category:ICD10 Diagnosis]] | ||
|?Has ICD10Code=ICD10_code | |?Has ICD10Code=ICD10_code | ||
| Line 31: | Line 32: | ||
|?Has BugRequired=Bug_req | |?Has BugRequired=Bug_req | ||
|?Has MinimumCombinedCodes=min_nr_grouped_with | |?Has MinimumCombinedCodes=min_nr_grouped_with | ||
|?Has StartDate=active_start | |?Has StartDate#ISO=active_start | ||
|?Has StopDate=active_end | |?Has StopDate#ISO=active_end | ||
|format=broadtable | |format=broadtable | ||
|limit=2000 | |limit=2000 | ||
| Line 44: | Line 45: | ||
| sep=; | | sep=; | ||
}} | }} | ||
Then: | |||
* make a structure only copy of s_ICD10 | |||
* In CCMDB.mdb, External Data,text file | |||
* append top the structure only copy table | |||
* delimited; click advanced button, make sure field delimiter is ; | |||
== Related Articles == | == Related Articles == | ||
Revision as of 23:02, 2017 December 5
The S_ICD10 table in CCMDB.mdb contains the possible codes to use with ICD10 collection.
Data Structure
| field | type | description |
|---|---|---|
| ICD10_ID | AutoNumber | unique identifier, links to L_ICD10.ICD10_ID |
| ICD10_code | Text(10) | official ICD10 code |
| 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 |
| 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 |
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: DSV
Then:
- make a structure only copy of s_ICD10
- In CCMDB.mdb, External Data,text file
- append top the structure only copy table
- delimited; click advanced button, make sure field delimiter is ;