OHDSI Home | Forums | Wiki | Github

Provider Specialty code set clean up

Friends:

Just talked with the THEMIS 1 folks, and @razzaghih said she may have a solution. So, I retract all I said. :smile:

I do think adding the hierarchies found here would be useful. Also, the crosswalk you linked should be used for mapping to the standard concept_id.

I want to focus on the Provider table here. That is an issue for the appropriate THEMIS WG.

Yes. A “certification/license/title/level” *_source_value, *_source_concept_id and *_concept_id would be added to the Provider table. I think many of these values are represented in the NUCC code set (very American representation). Community members with non-US data @Rijnbeek @rwpark @MaximMoinat @nicolepratt @leenad @SCYou and others I missed, should review the NUCC code set for comprehensiveness. We may need to utilize another code set for these values.

Friends:

Could we sit down, take all the NUCC, ABMS, HES Specialty and Specialty-CMS and make a definitive list with a hierarchy and no duplicates?

1 Like

All,

This was tied to this Vocabulary issue:

I know I’m part of THEMIS but I haven’t heard much on this topic. Was there some resolution here?

Yes, we’re removing all the duplicates. And are creating a hierarchy, which is even cooler :smile:

1 Like

Please go here: Care sites and specialty, specialty code clean-up

Let’s close this one.

@aostropolets, @Christian_Reich, @Dymshyts,

This has come up in THEMIS. However based on this thread it looks like this might already be covered. Do we need to remove duplicates as part of this work?

Could you provide an update?

Sorry. Tried to find all places where we discussed this. So, yes, thanks.

And no, NUCC doesn’t trump everything. It is OMOP>Specialty>Place of Service>NUCC>ABMS>HES Specialty>UB04. But it really doesn’t matter. The other ones will be mapped over in case of duplicates.

@Christian_Reich. @aostropolets, & @Dymshyts,

But has the integration into the Vocabulary been completed or is it still work in progress? Or do people need to still discuss how this needs to be done.

Seems like Christian is done with showing how the approach is better than any other. If so, we need to put it into the vocabularies in January after the holidays are over.

@aostropolets

Is there a Vocabulary ticket that I can reference so I can close out the THEMIS ticket?

I just want to connect all the dots.:smiling_face_with_three_hearts:

Sure it is!
(Ok, just created it; probably we’re too spoiled by Erica keeping an eye on the vocabularies issue page :))
Here

Thanks. I was looking for that ticket as well.

Christian I think is done. Folks don’t seem to have objections. I will send over to the vocab team. We can always improve. And add.

Team - is there an interest in providing longer descriptive synonyms to some/all of these concepts? I am imagining populating the concept_synonym table for each of the concept_id being worked on.

Because we will populate a vocabulary table - standardized softwares like ATLAS can now use these fields and show the results as part of the vocabulary search (making the guess work lesser).

Yes. EHR data has many custom codes. A description of each would make it easier for those mapping source to concept.

1 Like

Do you have them?

No. It’s an idea. Would it be possible to use concept_synonym to maintain 1:n synonyms? If yes, then maybe we could work on it together.

Yes, you can have as many synonyms as you want. Yes, let’s do that, but we should still roll out the current set of concepts if no other improvements are found.

@Christian_Reich @Dymshyts - here are some ideas for concept_synonym

1 Like

Regarding mappings: These mappings are already done by external sources, and we need to import them into OMOP. Some of these mappings are already in ATHENA may only need updating/validation for accuracy.

  • We can map NUCC to CMS specialty codes here
  • We can map CMS specialty codes to ABMS
  • We can map ABMS to NUCC
t