CCMDB Wiki

S ICD10 table: Difference between revisions

← 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 ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=S_ICD10_table"