Question Scott Beeson · Feb 7, 2017

I use the HS_IHE_ATNA_Repository.Aggregation table a lot.  Someone just referred me to the HS_IHE_ATNA_Repository.Document table, which has an AggregationId column.  

I assume that column references the ID column in the .Aggregation table.  If so, does this mean that if the same document was requested 1,000 times that there will be 1,000 entries for it in the .Document table?  This seems inefficient to me.  Why not have one record in the document table and have a DocumentId column in the Aggregation table?

7
0 471
Question Scott Beeson · Feb 6, 2017

I have the following query which tells me how many documents were retrieved for each customer, but it only works for the "on-demand" customers:

SELECT PatientFacility, LEFT(LocalDateTime,7) as Mnth, Count(*)
FROM HS_IHE_ATNA_Repository.Aggregation
WHERE EventType IN ('RecordRequest','RecordRequestBreakGlass')
AND LocalDateTime >= '2016-01-01'
AND LocalDateTime < '2017-01-01'
GROUP BY PatientFacility, LEFT(LocalDateTime,7)
4
0 447
Question Scott Beeson · Jan 30, 2017

In the table/class HS_Registry.document there is a column/property named RepositoryUniqueId.  There are about 14 unique values, which pretty much lines up with the number of our "Push" (Provide & Register) participants and thus unique document repositories.  However, these values just look like OIDs.  I've been searching for over an hour and I can't find anywhere that will provide me some context to these "Repository IDs".  

Anyone have ideas or suggestions where I could find this info?

3
0 577
Question Scott Beeson · Jan 12, 2017

Typically the thumbsup/thumbsdown icons are grayed out until you vote for one.  Then it is either red or green depending on which you selected.  I like this behavior.  However, on my own posts, the ones I cannot vote for, the indicators are both colored.  Since the visual queue has already been established that this indicates a selected vote, I think this should be changed.  Perhaps, since we cannot vote on our own posts, completely hide them.

1
0 207
Question Scott Beeson · Nov 18, 2016

I had typed up a large reply and then learned something new so I intended to hit CTRL+A to select everything and delete it.  Can't do that.  Apparently CTRL+A, like backspace, causes the input field to lose focus.

I HATE this editor.

8
0 421
Question Scott Beeson · Nov 18, 2016

I get this on some queries in some namespaces.  For instance, this query:

SELECT TOP 10 SessionId, datediff(s,min(TimeCreated),max(TimeCreated)) as ResponseTime
FROM ens.messageheader
GROUP BY SessionId
ORDER BY ResponseTime DESC

It works fine in HSBUS but in HSREG it throws the error.

Server closed communication device

Does anyone know what would cause this? Would it log something more useful somewhere?

7
0 1111
Question Scott Beeson · Nov 9, 2016

I am looking for a general overview of how you would attach a document to a patient record in healthshare.  For instance, an Advance Directive or Living Will.

Here are some starter questions:

  1. What format is required, if any?  Can it be a PDF or DOC?
  2. How can/should it be submitted?  HL7? XDS.b?  Embedded in a CCD?

Sorry for the open endedness.  Any info would be helpful while I research this.

6
0 541
Article Scott Beeson · Nov 4, 2016 2m read

I've asked a lot of questions leading up to this, so I wanted to share some of my progress.

The blue line represents the number of messages processed.  The background color represents the average response time.  You can see ticks for each hour (and bigger ticks for each day).   Hovering over any point in the graph will show you the numbers for that period in time.

This is super useful for "at a glance" performance monitoring as well as establishing patterns in our utilization.

Here is the query used:

2
0 564
Question Scott Beeson · Oct 18, 2016

This tells me that there is no timezone offset on this table/field:

Select TOP 1 GETDATE() as Now, TimeCreated FROM ens.messageheader ORDER BY TimeCreated DESC;
Now                 TimeCreated         
------------------- ------------------- 
2016-10-18 16:16:49 2016-10-18 16:16:31 

So why is TimeCreated in this resultset 4 hours less than OneMinuteAgo when I'm clearly requesting only records with a TimeCreated greater than OneMinuteAgo?

13
0 887
Question Scott Beeson · Oct 13, 2016

I know this has been requested before, but it's really annoying, especially in the Developer Community.

Here is my typical workflow:

1. Click "Developer Community" forum

2. Click "Post question".

3. Select "Developer Community" in Group dropdown.

4. Select "Developer Community" in Related Topic dropdown.

Yes, 3 out of 4 steps to post a new question here require me to select the same thing.  It's frustrating.  Here I go again!

5
0 289
Question Scott Beeson · Oct 13, 2016

I know this has been suggested before but I wanted to bring it up again.

It would be very nice if we could "accept" an answer to our questions which would result in the question showing "answered" in the index and possibly move the "accepted answer" to the top of the answer chain.

see: Stack Overflow or any other QA site

4
0 309
Question Scott Beeson · Oct 11, 2016

I have a list of about 100 MPI IDs that I would like to run a report on.  I want to list times that any data for these patients were accessed.  Currently in "Managed Reports" we have a "Disclosure Report" which I think was a custom development effort, but it is per-patient.

I have a SQL query for the ATNA log but I'm not confident in its accuracy, so I thought I'd reach out and see how other Information Exchange's might get this data.

7
0 569