I am trying to create a pivot table for particular set of patients by xyz hospital but i cannot see their MPI ids to match the patients required to create the pivot table for the specific patients.

I can access the demographics of patients/ registry gateway on SQL but need to generate clinical reports so need to look into edge gateways of hospitals. i was wondering if there a an easy task to look at all edge gateway information under a single listing or in a table to extract information. Health insight has limitations in regards to the specificity and crashes at times owing to complex queries. SQL explorer too crashes plus has limitation to certain rows so i would run this on a terminal but need assistance in accessing the edge gateways. I hope i was able to define my problem.