Epic bulk data export or patient list

Day-to-Day Users
1

Hello,

I am trying to fetch bulk data or list of patient to access their data using EPIC FHIR API. I got two ways to attain this based on their documentation

https://fhir.epic.com/Documentation?docId=fhir_bulk_data&section=Kicking_Off_the_Bulk_Data_Request

https://fhir.epic.com/Sandbox?api=880

In both of these methods we need list id and group id. As per their documentation that id is

An internal patient list ID in the format system|id, where ‘system’ is either mylist or systemlist and ‘id’ is an internal ID corresponding to the value of ‘system’. This value must be provided by the healthcare organization to the caller.

Contact the organization you are integrating with to discuss what group of patients to use for your integration and to get the FHIR ID for that group.

My doubt is how the clinic or the provider can get the FHIR ID for patient list or group ??

2

if their patient search mechanism is anything like ours they will allow you to ping that endpoint with a public id aka pubpid :slight_smile:

3

Ok, I will try.
Thank you

4

We have a groups endpoint as well. I don’t know if Epic exposes that, but that would give you the group id.

5

ok. I have contacted epic regrading this endpoints, will update here once I got the reply.
Thank you Stephen.

6

I have the list of the various fields (127 of them or so I believe) supported to upload into patient demographics but I cannot tell which one of them can be used for uploading the patients insurance information. Any advice?

7

hi @gizmodoc , for insurance see the insurance_data, insurance_companies and addresses tables.

1 Like
8

So, I assume that table is located somewhere other than this table:

image
image1257×1035 37.6 KB

Do you know where/how I can find the insurance table? Is there a specific name?

Thanks

9

right, try show tables from the maria prompt to see all of them