Notifications
Clear all
Topic starter
Hi there,
I work with a vendor and we use a subscription to obtain immunizations out of CPS. We have a client that has noticed some immunizations do not make it to the registry. When digging into the GE db we have a CEM_SubscriptionTypeID = 5 "Send Data to Immunization Registry" HL7-VXU.
Can someone explain what criteria is used to select the immunizations from the database and what all tables are involved? We would like to be able to give them the ability to understand how some records are not being picked up.
Thank you
Posted : November 7, 2017 3:01 am
When an immunization is signed, a trigger fires on the Immunization table. The trigger calls a stored procedure CEM_EnqueueEventQueue which inserts a row into the CEM_EventQueue table. Events are then picked up out of this table by the subscription. You might be able to monitor this table to determine if your immunizations are being lost upstream or downstream of the subscription.
Looking further out, if your interface engine provides logging you may be able to see if a HL7 message was generated for a missing immunization. If a HL7 message was sent but the immunization is not in the registry, it was probably filtered by the registry due to a data error. Look for a response file for the HL7 message.
Posted : November 28, 2017 9:04 am
