go to post Scott Beeson · Oct 13, 2016 I'm simply fumbling around in my never ending quest to find holistic queries that answer basic questions. Right now I'm querying the registry. I don't have SQL access to the buses or hsaccess and we have dozens of edges so that isn't convenient Since the ATNA log is 600+ million rows and takes hours and hours to query (and decypher), HSREG is really my only option.
go to post Scott Beeson · Oct 13, 2016 Looks like it's something to do with our custom consent. I don't completely understand it, but if I limit the SourceConfigName to HS.Hub.MPIManager it obviously eliminates the duplicates.
go to post Scott Beeson · Oct 13, 2016 Very good info, thanks! However,"Missing or Invalid Document"also"No matches were found for HEOV_architecture (.000429s)"
go to post Scott Beeson · Oct 12, 2016 I found that half of them have a value in the RequestId column and the other half don't. All other columns are identical. What is the cause/reason for this?
go to post Scott Beeson · Oct 12, 2016 I think that is the literal meaning but I'm wondering what it means functionally, what triggers this "mode".edit: obviously the answer is "Pix or PDQ events", I guess I'm just trying to understand this table better. I'm not really sure what answer I'm looking for.
go to post Scott Beeson · Oct 12, 2016 It looks like "ExportRecords" coincides with an external request and "ViewRecords" is a clinical viewer request.
go to post Scott Beeson · Oct 12, 2016 "Roadmap to Implementing a HealthShare Regional Solution" That was the piece I was missing. I was looking for "Information Exchange".Thanks.
go to post Scott Beeson · Oct 11, 2016 *wish I could post an answer* I found the following in HS.Message.PatientSearchRequest.cls: /// Search modes user - regular patient lookup, admin - mpi patient lookup no consent applied, /// clinician -- mpi patient lookup, no consent applied, limited to patients with a pre-existing relationship with the clinician Property SearchMode As %String(DISPLAYLIST = ",User,Admin,Clinician,Participation,AuditReport,PIXPDQ", VALUELIST = ",user,admin,clinician,participation,AuditReport,PIXPDQ") [ InitialExpression = "user" ]; Still not sure what PIXPDQ means but I assume it's for non-clinicalviewer searches.
go to post Scott Beeson · Oct 11, 2016 I don't know if the documentation search sucks or if I'm an idiot but I still can't find the API docs you are talking about... There is literally one Google result for "Roadmap to Implementing an Information Exchange" and it is https://learning.intersystems.com/course/view.php?id=102I've tried both docs.intersystems.com and the help link on my instance."No matches were found for roadmap information exchange (.004001s)Please try searching for related terms. "
go to post Scott Beeson · Oct 11, 2016 When you say aggregate data, I assume you are referring to the ATNA log? What if it is 600 million rows and takes 24+ hours to query? Is there another option?
go to post Scott Beeson · Oct 11, 2016 edit: I now understand what you meant by "We don't support". I was thinking you meant it wasn't possible, but now I see you meant it literally.I'd still like a link to the API documentation you mentioned if possible.
go to post Scott Beeson · Oct 11, 2016 We are an HIE so I cannot simulate a search from within an EHR system. Can you think of anything I could query on the Registry to do this? Something endpoint-agnostic? For instance, I've discovered this seems to work pretty well for searches without having to worry about ATNA event types and the performance issues related to the size: SELECT TimeProcessed, LastName, FirstName, DOB, AssigningAuthority, MPIID, MRN, SearchMode, RequestingUser, SAMLData_Organization, SessionId FROM Ens.MessageHeader h LEFT JOIN HS_Message.PatientSearchRequest m ON h.MessageBodyId = m.id WHERE h.Invocation = 1 AND h.MessageBodyClassName = 'HS.Message.PatientSearchRequest' ORDER BY SessionId DESC I appreciate your input so far.
go to post Scott Beeson · Oct 11, 2016 "The combined results are about to be loaded into the clinical viewer."What about searches from directly within participant EHR systems? Users that are not using the clinical viewer? ie "on demand" customers. Or other protocols, XDSb, XCA, etc. Also would this exclude patient searches like a PIX query before a document registration?
go to post Scott Beeson · Oct 11, 2016 Ahhh, thanks.What about the date format? Can you confirm that it's only looking for YYYYMMDD?
go to post Scott Beeson · Oct 11, 2016 Yes, the notifications still need a lot of work. This is one of the biggest issues.
go to post Scott Beeson · Oct 11, 2016 Well Chrome now blocked Backspace for navigation, so no risk of leaving the page, but this bug still persists. If you backspace past the last character the text entry box no longer has focus.