S ICD10 table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
structure
mNo edit summary
 
(49 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The '''L CCI''' table in [[CCMDB.mdb]] contains the possible codes to use with [[CCI collection]].  
{{DISPLAYTITLE:s_ICD10 table}}The '''s_ICD10''' table in [[CCMDB.accdb]] contains the possible codes to use with [[ICD10 collection]].  


== Data Structure ==
== Data Structure ==
Line 8: Line 8:
!| description
!| description
|-
|-
|| '''ICD10_ID''' || AutoNumber || unique identifier
|| '''[[ICD10_code]]''' || Text(10) || official [[ICD10]] code
|-
|-
|| '''ICD10_code''' || Text(10) ||  
|| '''description''' || Text(255) || description of dx
|-
|-
|| '''description''' || Text(255) ||  
|| '''[[Property:Has StartDate | active_start]]''' || date/time || for enabling and disabling
|-
|-
|| '''SC''' || Text(255) ||
|| '''[[Property:Has StopDate | active_end]]''' || single || for enabling and disabling
|-
|| '''comment''' || Text(255) ||
|-
|| '''Bug_req''' || Text(1) ||
|-
|| '''c_Past_Medical_History''' || yes/no ||
|-
|| '''c_Infectious Disease''' || yes/no ||
|-
|| '''c_Cardiovascular''' || yes/no ||
|-
|| '''c_Resp''' || yes/no ||
|-
|| '''c_GI''' || yes/no ||
|-
|| '''c_Neuro''' || yes/no ||
|-
|| '''c_Skin''' || yes/no ||
|-
|| '''c_MSK_Soft_tissues''' || yes/no ||
|-
|| '''c_Renal_Urinary''' || yes/no ||
|-
|| '''c_Eye''' || yes/no ||
|-
|| '''c_ENT''' || yes/no ||
|-
|| '''c_Hematology_Immunology''' || yes/no ||
|-
|| '''c_Metabolic_Nutrion''' || yes/no ||
|-
|| '''c_Reproductive''' || yes/no ||
|-
|| '''c_Endocrinology''' || yes/no ||
|-
|| '''c_Neoplastic''' || yes/no ||
|-
|| '''c_Psych''' || yes/no ||
|-
|| '''c_Hereditary_Congenital''' || yes/no ||
|-
|| '''c_Peripartum''' || yes/no ||
|-
|| '''c_Testing''' || yes/no ||
|-
|| '''c_Symptoms''' || yes/no ||
|-
|| '''c_Iatrogenic''' || yes/no ||
|-
|| '''c_Healthcare_Contact''' || yes/no ||
|-
|| '''c_Injury_Poisoning''' || yes/no ||
|-
|| '''c_Misc''' || yes/no ||
|-
|| '''c_Mechanism''' || yes/no ||
|-
|| '''OrderedNum''' || single ||  
|}
|}
== Query to populate s_ICD10 table from wiki ==
[[Category:ICD10 wiki infrastructure]]
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 StartDate#ISO=active_start
|?Has StopDate#ISO=active_end
|format=broadtable
|limit=2000
|link=all
|sort=Has ICD10Code
|order=ascending
|headers=show
|mainlabel=-
  | format=dsv
  | filename=s_ICD10_wiki_to_table.txt
  | sep=;
}}
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.accdb, External Data,text file
* insert into new table
* delimited; click advanced button, make sure field delimiter is ;,
* file has headers
Copy content into s_icd10
* empty out s_icd10
* copy and paste data from new table, can use query ''s_ICD10_from_wiki_appender''
* 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
* bad data in a column
* duplicate ICD10 codes due to evil twins on wiki
=== categories ===
see [[ICD10 Categories for CCMDB.accdb]]


== Related Articles ==
== Related Articles ==
{{Related Articles}}
{{Related Articles}}


[[Category: S ICD10 table| *]]
[[Category: Data structure]]
[[Category: Data structure]]
[[Category: ICD10/CCI Conversion]]
[[Category: ICD10/CCI Conversion]]
[[Category: ICD10]]
[[Category: Charlson Comorbid Diagnosis]]

Latest revision as of 15:26, 2023 May 17

The s_ICD10 table in CCMDB.accdb contains the possible codes to use with ICD10 collection.

Data Structure

field type description
ICD10_code Text(10) official ICD10 code
description Text(255) description of dx
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.accdb, click the following link to generate an extract: DSV

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.accdb, External Data,text file
  • insert into new table
  • delimited; click advanced button, make sure field delimiter is ;,
  • file has headers

Copy content into s_icd10

  • empty out s_icd10
  • copy and paste data from new table, can use query s_ICD10_from_wiki_appender
  • 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

Likely problems

  • bad data in a column
  • duplicate ICD10 codes due to evil twins on wiki

categories

see ICD10 Categories for CCMDB.accdb

Related Articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=S_ICD10_table&oldid=159417"