Retrieving Information From a Database

In this scenario, the goal is to set the PV1.AdmitSource field on an HL7 v2.3 ADTA01 message based on the value of the PV1.PatientClass field. Using a database lookup filter will be the easiest way to achieve this.

A route may be setup as shown in the following diagram, where System A sends the message through the Database Lookup filter to System B.

XML Configuration File

The database lookup filter runs a select query based on the value in PV1.AdmitSource in the message, and retrieves a value from the database which populates the @PV1.PatientClass field in the message.