Content Comparison

Meg Meador / MH rolling-up final report to CDC

• Currently mid-stream. 

What is the workflow to transition to the data+terminology solution w/ Informatics+CA 

John Gresh - Automation of data intake, baseline analytics, etc. from currently available MH data.

Julia Skapik (Deactivated) - Let's look at MH HE data as raw aggregated data.

Meg Meador - Patient-level data is a huge lift for some partners. Recently received statin data. AMA currently engaged in data cleaning. 

John Gresh and Pedro B Carneiro (Deactivated) Has the Statin data. Let's see what happens for now.

MH data is a monthly extract/submission. 

Use Case:

John Gresh - Currently have value sets / VSAC OIDs.

1. Do these VSets live in Symedical?
   1. Bonnie Bruner (Unlicensed) - "Subscription Portal". All content NACHC are subscribed to will be there. 
2. How do export or connect to the terms in Symedical?
3. Possible to connect through an API?

Cannot write to VSAC via an API. Need to manually export-import to VSAC

Notes from CA:

1. Bonnie Bruner (Unlicensed) asked Raymonde Uy (Unlicensed) about how his demo went on Wednesday.
   1. Raymonde Uy (Unlicensed) said there were two webinars. One went really well. The other had time constraints and he wasn't able to show AW and Waypoint. He gave a shout out to CA during the presentation.
2. Raymonde Uy (Unlicensed) went over last Friday's meeting for Julia and what was discussed, as well as the action items.
3. There was a discussion between Meg Meador and Julia Skapik (Deactivated) about HealthEfficient's data and what that workflow will look like.
4. John Gresh talked about his piece of the process and the automation of data import.
5. Carol asked if John Gresh will be generating what Meg Meador needs. Is this a one-off thing?
   1. John Gresh said it is a monthly extract and doesn't deal with Symedical. 
6. John Gresh asked about how he can take his list of value sets and see if they exist in Symedical, what he can do with it, how to get the terms, can he connect through the API to achieve this?
   1. Is it in Symedical?
      1. Bonnie Bruner (Unlicensed) recommends going into the Symedical user interface. There's a module called Subscription Portal. You can see every piece of content you are subscribed to. In the Subscription Portal, there's a tab called Content Portal and that's where you can see what is publicly available.
      2. Carol mentioned you would be subscribed to VSAC through Symedical and not having to import it into Symedical. Symedical will keep that data up to date. She said John Gresh may need some API training.

• John Gresh asked if he can search the Content Portal by OIDs.
  1. Jill Nunamaker (Unlicensed) showed John how he can go to Catalog Manager, and set the Search to "Standard attribute equals" and enter the OID. If the OID is set as a standard attribute in that catalog, that should bring it up.
  2. Jill Nunamaker (Unlicensed) then showed how he can pull up the Term Search application and go down that route.

1. John Gresh said they are using Databricks technologies, an old SQL database. That's why the JDBC connection will be something they need. He's not sure that Databricks can call out to an API but they can access JDBC connections.
   1. John Gresh said going through the API, he'll somehow have to get that stuff into his database so he can query against it. For example, he wants to be able to access information on a code that may be in patient info - he can do this if he has the value sets in his database. 
2. Raymonde Uy (Unlicensed) has stopped doing anything on VSAC because they'll be doing this in Symedical. He asked if once they've imported into a catalog, it won't make duplicate sets on VSAC - right? Unless they manually publish it out.
   1. John Gresh will be drilling down more into what was covered and his work with the APIs and JDBC connections.
3. Jill Nunamaker (Unlicensed) wanted to show John Gresh his valuesets on Element Set Manager
   1. John Gresh opened Element Set Manager and walked through the Elements. Showed how to show descendants on reference terms.

•  John Gresh will continue working in Symedical, becoming more comfortable with the APIs, and continue working on the JDBC connection.
•  Bonnie Bruner (Unlicensed) CA will be available to provide support to John Gresh when he needs it.
•  Bonnie Bruner (Unlicensed) CA will set up Symedical developer training for John Gresh