OHDSI / Vocabulary-v5.0

Build process for the OHDSI Standardized Vocabularies. Currently not available as independent release.
The Unlicense
219 stars 75 forks source link

C83.0*, C83.1*, C91.1*, D03.*, F03.9*, O99.512 ICD10CM and other concepts mapping improvement #979

Open dimshitc opened 6 months ago

dimshitc commented 6 months ago

https://docs.google.com/spreadsheets/d/1jpCVr1SyTtH_fHXoN0pi9rD_icJVM4ZQ/edit?usp=sharing&ouid=113285728784887787047&rtpof=true&sd=true

TinyRickC137 commented 6 months ago

Thank you, @dimshitc, we will check the mappings.

However, I briefly looked into them and noticed that the metadata fields and the checklist are not populated. Could you finish the file for us, please?

dimshitc commented 6 months ago

Metadata and checklist are populated now. Thank you!

dimshitc commented 6 months ago

While continuing reviewing the vocabulary changes impact, some mapping inaccuracies were found, in order not to create separate documents, the changes are submitted to underlying google sheets table. I'm going to freeze this document by the May, 10th.

dimshitc commented 2 months ago

I noticed typos in this table (occurred due to Excel), so it should be updated before used, let me know if you already did it: update this_table set concept_code_2= 302841002 where concept_code_2 in ('302841004', '302841005') ; update this_table set concept_code_1= '087.9' where concept_code_1 in ('87.9') ; update this_table set concept_code_2= '1080911000119105' where concept_code_2 in ('1080911000119100')

IrynaZherka commented 1 month ago

@dimshitc Thank you so much for your valuable suggestions. We have carefully reviewed them and made changes in line with current conventions. Your input was greatly appreciated!

dimshitc commented 1 month ago

@IrynaZherka thank you for all your great work of maintaining the OHDSI vocabulary!

I noticed that these mappings that were suggested in the contribution are missing in the newest release Is there any reason why? F10.22 ICD10CM Alcohol dependence with intoxication 607208 Acute alcohol intoxication F10.220 ICD10CM Alcohol dependence with intoxication, uncomplicated 607208 Acute alcohol intoxication F10.229 ICD10CM Alcohol dependence with intoxication, unspecified 607208 Acute alcohol intoxication