Update the Health Insghts table (HSAA.Patient) based on a changed assigning authority code

Question

Question

Joseph Thottungal · Nov 2, 2016

I have recently updated assigning authority in the Registry . How can I update the existing patient records in Health Insights with new code? (HSAA.Patient.PatientNumbers)

Discussion (3)0

Log in or sign up to continue

Alex MacLeod · Nov 3, 2016

Hi Joseph,

this is a problem that really needs to be fixed on the Information Exchange side that will then propagate over to Health Insight. However we do not support directly editing the existing streamlets - I believe in later versions there will be a tool to assist with editing existing data but the product team will have to comment on that. So did the AA stay the same but just the OID changed? I'm still not quite clear what the change was and what you mean by custom SQL to pull just the code. Maybe it helps to see a before and after?

Thanks,

-- Alex

0 0

score 0 · Answer 1 · 2016-11-02T12:46:49-04:00

Hi Joseph,

how did you update the AA exactly? Did you manually go into the Registry or was it updated by feeding new data into Information Exchange?

score 0 · Answer 2 · 2016-11-02T13:06:55-04:00

Hi Alex,

I added a new entry in OID registry under AA. So based on OID the code will be populated in the Patient Number field. I have a written a Custom SQL code to pull just the code for our downstream systems. The issue that I have is there are existing data in the DB with the OID instead of Code in the Patient Numbers field and I am looking for a way to update them without reprocessing all the files.

Regards

Joseph