dbmi-pitt / ACT-Network

ACT - Accrual to Clinical Trials Network Repository
3 stars 2 forks source link

Wrong labels in ICD 10 diagnosis ontology #12

Open stacythorson opened 2 years ago

stacythorson commented 2 years ago

Some diagnosis codes have wrong labels. Following are the correct labels for these:

ICD10:C64.1 | Malignant neoplasm of right kidney, except renal pelvis ICD10:C56.1 | Malignant neoplasm of right ovary ICD10:C66.1 | Malignant neoplasm of right ureter ICD10:C65.1 | Malignant neoplasm of right renal pelvis ICD10:G04.01 | Postinfectious acute disseminated encephalitis and encephalomyelitis (postinfectious ADEM) ICD10:G43.D1 | Abdominal migraine, intractable ICD10:G43.D0 | Abdominal migraine, not intractable ICD10:G04.31 | Postinfectious acute necrotizing hemorrhagic encephalopathy ICD10:G40.811 | Lennox-Gastaut syndrome, not intractable, with status epilepticus

mim18 commented 2 years ago

Fixed crumb: -- 5337 FIX STRINGS --select count(*) from ( select first_release_ver, code_str, min_date, max_date, c.str from ICD10CM_WIDE w join umls_combined.mrconso@neptune_read c on c.code = w.code and c.sab = 'ICD10CM' and c.tty = w.last_tty and c.release_ver = w.max_date and code_str <> c.str