S ICD10 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m m |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 84: | Line 84: | ||
|| '''Charlson_condition''' || text || charlson condition link to [[S ICD10 Charlson Como conditions table]] | || '''Charlson_condition''' || text || charlson condition link to [[S ICD10 Charlson Como conditions table]] | ||
|} | |} | ||
== Query to populate from wiki == | |||
{{#ask: [[Category:ICD10 Diagnosis]] | |||
|?Has ICD10Code=ICD10_code | |||
|?Has BugRequired= bug_req | |||
|sort=Has ICD10Code | |||
|order=ascending | |||
|limit=0 | |||
|format=broadtable | |||
|link=all | |||
|class=sortable wikitable smwtable | |||
}} | |||
== Related Articles == | == Related Articles == | ||
Revision as of 11:53, 25 October 2017
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) | |
| 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 |
| active_start | date/time | 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 |