S ICD10 table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
No edit summary
mNo edit summary
Line 17: Line 17:
|-
|-
|| '''Bug_req''' || Text(1) ||  
|| '''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 || for sorting only, no meaning
|-
|-
|| '''min_nr_grouped_with''' || integer || min nr of dxs to be coded with this dx as [[Combined ICD10 codes]]
|| '''min_nr_grouped_with''' || integer || min nr of dxs to be coded with this dx as [[Combined ICD10 codes]]
Line 77: Line 23:
|-
|-
|| '''active_end''' || single || for enabling and disabling
|| '''active_end''' || single || for enabling and disabling
|-
|| '''OldDxEquiv''' || long integer || link to [[S AllDiagnoses]] table
|-
|| '''wiki_URL''' || single || link to dx article on this wiki
|-
|| '''Charlson_condition''' || text || charlson condition link to [[S ICD10 Charlson Como conditions table]]
|}
|}


== Query to populate from wiki ==
== Query to populate s_ICD10 table from wiki ==
{{#ask: [[Category:ICD10 Diagnosis]]
{{#ask: [[Category:ICD10 Diagnosis]]
  |?Has ICD10Code=ICD10_code
  |?Has ICD10Code=ICD10_code
  |?=description
  |?=description
  |?Has BugRequired
  |?Has BugRequired
|?Has URL#nowiki
  |format=broadtable
  |format=broadtable
  |limit=2000
  |limit=2
  |link=all
  |link=all
  |sort=Has ICD10Code
  |sort=Has ICD10Code
  |order=ascending
  |order=ascending
  |headers=show
  |headers=show
}}
  | format=dsv
  | format=dsv
  | filename=s_ICD10_wiki_to_table.txt
  | filename=s_ICD10_wiki_to_table.txt
  | sep=;
  | sep=;
}}


== Related Articles ==
== Related Articles ==

Revision as of 21:27, 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

ICD10_codedescriptionHas BugRequired
0No Dx Entered
00Not an Infection (ICD10 pathogen alternative)
... further results
| format=dsv
| filename=s_ICD10_wiki_to_table.txt
| sep=;

Related Articles

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