HL7 Importer

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
 
(6 intermediate revisions by one user not shown)
Line 465: Line 465:
 
</table>
 
</table>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
<h2>Message types</h2>
+
<h2>Message Types</h2>
<p>The messages below are examples of messages supported by <strong>MedITEX</strong>.</p>
+
<p>The messages below are examples supported by <strong>MedITEX</strong>.</p>
 
<table style="margin-left: auto; margin-right: auto;" border="0">
 
<table style="margin-left: auto; margin-right: auto;" border="0">
 
<tbody>
 
<tbody>
Line 476: Line 476:
 
</table>
 
</table>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
<h3>Lab values import</h3>
+
<h3>Lab Values Import</h3>
 
<table style="margin-left: auto; margin-right: auto;" border="0" width="100" height="383">
 
<table style="margin-left: auto; margin-right: auto;" border="0" width="100" height="383">
 
<tbody>
 
<tbody>
Line 499: Line 499:
 
</tr>
 
</tr>
 
<tr>
 
<tr>
<td><a href="/images/Standard_ORU-R01-25.hl7"><img src="/images/plus48.png" alt="" width="48" height="48" /></a><a href="/images/Standard_ORU-R01-25.hl7">Download the file here</a>. Right-click <strong>Save link as</strong> to download.</td>
+
<td>[[Image:10HL7.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/10HL7.png|ORU-R01 fields definitions]]</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 +
<table style="margin-left: auto; margin-right: auto;" border="0">
 +
<tbody>
 +
<tr>
 +
<td><a href="/images/Standard_ORU-R01-25.hl7"><img src="/images/plus48.png" alt="" width="48" height="48" /></a></td>
 +
<td><a href="/images/Standard_ORU-R01-25.hl7">Download the file here</a>. Right-click <strong>Save link as</strong> to download.</td>
 +
</tr>
 +
</tbody>
 +
</table>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 +
<h3>Patient Import</h3>
 +
<table style="margin-left: auto; margin-right: auto;" border="0" width="567" height="189">
 +
<tbody>
 +
<tr>
 +
<td>
 +
<h4>ADT-A08-2.5</h4>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>
 +
<p style="text-align: left;">MSH|^~\&amp;|Regional MPI|MPI|Master MPI|Alpha Hospital|20060501140010||ADT^A08|3948375|P^T|2.5|</p>
 +
<p style="text-align: left;">EVN|A08|20060501140008|||000338475^Author^Arthur^^^^^^Regional MPI&amp;2.16.840.1.113883.19.201&amp;ISO^L|20060501140008</p>
 +
<p style="text-align: left;">PID|||000197245^^^National Register&amp;2.00.123.1.123456.55.5&amp;ISO^PN~4532^^^Careful Care Clinic&amp;2.16.840.1.113883.19.2.400566&amp;ISO^PI~3242346^^^Central Clinic&amp;2.16.840.1.113883.19.2.450998&amp;ISO^PI||Miller^Susan^^^^^L||19750103|F|||Randomroad 23a&amp;Randomroad&amp;23a^^Anytown^^1200^^H||001 998877^TEL^PH~001 112233^FAX^FX|001 554433^TEL^PH</p>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td style="margin-left: auto; margin-right: auto;">[[Image:11HL7.png|none|519px|thumb|left|link=http://wiki.meditex-software.com/images/11HL7.png|ADT-A08 fields definitions]]</td>
 +
</tr>
 +
</tbody>
 +
</table>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 +
<table style="margin-left: auto; margin-right: auto;" border="0">
 +
<tbody>
 +
<tr>
 +
<td><a href="/images/Standard_ADT_A08_25.hl7"><img src="/images/plus48.png" alt="" width="48" height="48" /></a></td>
 +
<td><a href="/images/Standard_ADT_A08_25.hl7">Download the file here</a>. Right-click <strong>Save link as</strong> to download.</td>
 +
</tr>
 +
</tbody>
 +
</table>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<table style="float: right;" border="0">
 
<table style="float: right;" border="0">

Latest revision as of 11:51, 12 November 2015

Contents

Scheme

<tbody> </tbody>
MedITEX HL7 Importer - Scheme

 

Configuration

General Settings

<tbody> </tbody>
General On/Off-Switch Activates or deactivates the HL7-Server

MedITEX IVF:

PMI_HL7 active

Indicates whether your IVF tool is preconfigured for the import of additional patients data and therefore provides a special interface.
Protocol Level

Default setting is 'Errors, Hints and Debug Information'.

After the testing phase please switch to 'Only Errors' in order to reduce traffic and data storage.
IP-Address The IP address of the server where Importer is running.
Default is 'localhost' (or 127.0.0.1).
Number of Instances

Defines the number of asynchronous communication queues (threads).

Default is 1.

Number of Interfaces

Defines the number of protocols that can be interpreted.

Default is 1 (HL7).
Listen queue (max) The maximum of entries in the listener buffer (FIFO buffer).
Terminate wait time

Defines the maximum delay in milliseconds to receive messages from the queue.

Default is 10000 msec.

Thread delay

Defines the delay in milliseconds to give work time for other treads.

Default is 100 msec.

Reply ACK delay

Defines the delay in milliseconds to finish a processed message.

Default is 250 msec.
<tbody> </tbody>
<img src="/images/1HL7.png" alt="" width="598" height="404" />

 

 

COM Definitions

<tbody> </tbody>
Tab Item Description
Instances Instance Nr. Automatic counter
Active Yes or No
Port The client - server communications port
Interfaces Interface Nr. Automatic counter
Active Yes or No
Protocol Active protocol (In this version only HL7. In future versions also XML and SOAP)
Version Active version
Libary The name of the DLL which coummunicates with the database (Database-IN module)
<tbody> </tbody>
<img src="/images/2HL7.png" alt="" width="598" height="404" />
<img src="/images/3HL7.png" alt="" width="598" height="401" />

 

 

Additional Settings

Additional settings to save log files, make statistics and check the consistency of incoming data.

Saving

<tbody> </tbody>
Item Description
Save Level

Each processed message can be saved with more or less information.   Default is 'Errors, Hints and Debug Information'.

After the testing phase switch to 'Only Errors'.

Save info for statistics An additional feature to gain statistical information of the processed messages.
Automatically load protocol file An additional feature to display then message processing in the user interface of MexHL7Importer. The output will be according to the selection in section 'Save Level'.
<tbody> </tbody>
<img src="/images/4HL7.png" alt="" width="598" height="401" />

 

 

Patient Conditions

<tbody> </tbody>
Items Description
Minimum Length of Patient Identifier High level check whether the message details are valid to be inserted or updated in the MedITEX IVF database. If the length of the patient’s identifier is less than defined, an insert or update will be refused.

Age Range (min/max)

High level check whether the current age in within the defined range.
Minimum Set of Fields High level check whether the message details are valid to be inserted or updated in the MedITEX IVF database. If the incoming data has no values in the defined fields, an insert or update will be refused.
<tbody> </tbody>
<img src="/images/5HL7.png" alt="" width="598" height="401" />

 

 

LAB Data Conditions

<tbody> </tbody>
Items Description
Use first available Patient ID A HL7 message can provide more than one possible Patient ID because the same message can trigger several target systems wherein a Patient ought to be matched via it’s ID.
Use Patient ID associated with IdentifierTypeCode If provided more than one Patient ID, each of them should be followed by a so called 'Identifier Code'-  which is nothing else than a second match code to decide which of the given Patient IDs is the right one for your system.
Save Parameters as “Something else” if they can not be matched

Laboratory parameters are divided into several parameter groups:

Hormone, Serology, Clinical chemistry, Genetics, Microbiology or 'Something else'. A laboratory parameter consists of a so called short form, a long from, a unit and a value. The short form must be transmitted within the HL7 message and defined in the target system … this is the way parameters are matched. If this matching fails the parameter can be imported as “Something else” - what in each case demands a following manual correction.

Import Notes from NTE Structure Additional information from the examining laboratory – as a non-formatted text - can be imported in memo fields of the target system.
Abnormal Flags Defines whether a given parameter value is inside a normal range or outside. These flags can be used to change flags in the target system.
Date Format

Describes the textual form of date and time information:

YYYY (year) MM (month) DD (day) HH (hour) NN (minute) SS (second).

<tbody> </tbody>
<img src="/images/6HL7.png" alt="" width="598" height="401" />

 

 

DB Access

Connection parameters to access the MedITEX IVF database:

<tbody> </tbody>
Item Description
Alias The database alias. Default is ART.
Server

The server address on which the Firebird server runs.

Default is 'localhost'  (or 127.0.0.1).

Charset

The character set according to your language.

Ask your support for additional help.

Client Library

The name of the Firebird client library.

Default is fbClient.dll (older versions use gds32.dll).

Backup Start If a backup task is defined type in the start time. This leads to a smarter and faster check whether database changings can be processed.
Backup End See description for point above.
Force restart During the processing of HL7 messages the memory usage of the HL7-Server increases continuously … not much, but it does. Therefore the time when backup is running can be used for a save restart of the HL7-Server.
DB Access

Strongly recommended:

No access to database if backup is running should be checked!

<tbody> </tbody>
<img src="/images/7HL7.png" alt="" width="598" height="404" />

 

 

Service

(requires MexHL7Service.exe)

<tbody> </tbody>
Item Description
Install service Requires MexHL7Service.exe and provides a so called background service, with full functionality, no interface, no login necessary. If successfully installed you can see a new entry in your service panel: MexHL7 Service.
Uninstall service Uninstalls the MexHL7 Service.
Start service Starts the MexHL7 Service.
Stop service Stops the MexHL7 Service.
Automatically Interface in notification area

Provides an icon in the taskbar that indicates that the service is running and provides a GUI for configuration and statistics. This won’t work with the new Microsoft UAC technology … older operating systems like Windows XP support this feature.

Try it and if you don’t see the MexHL7 Icon please uncheck this feature.

<tbody> </tbody>
<img src="/images/8HL7.png" alt="" />

 

 

Support

You can send protocol, statistic and log files to your support. Fill this formular in order to provide a smart email generator.

<tbody> </tbody>
Item Description
Your Name Type in any name you want to describe your clinic
Your Email Your email address
Email Body Any email body
Receiver

Default: <a href="mailto:support@critex.de">support@critex.de</a>

<tbody> </tbody>
<img src="/images/9HL7.png" alt="" width="598" height="404" />

 

 

Application

Description of the MedITEX HL7 Importer Application GUI.

To run the MexHL7Importer – after the configuration has been done – it is only necessary to click the 'Start Server' button. The screenshot bellow shows activity and data protocolling. Content depends on what has been defined in the configuration section.

<tbody> </tbody>
<img src="/images/0GUI.png" alt="" width="765" height="990" />

 

Each pair of data (HL7 message & transformation into importable data) is – if configured – saved in a protocol file which has been named with a tamestamp. In this file you have the possibility to check when and which HL7 message data caused which import or change of MedITEX IVF data.

<tbody> </tbody>
<img src="/images/01GUI.png" alt="" width="765" height="993" />

 

Statistical data – if configured – is automatically saved and compiled in order to provide a brief overview and a detailed table (as you can see below). For example:

Since the server was started, a total of 1373 HL7 messages were received, out of which a total of 37 errors occurred and finally 6 modifications of MedITEX IVF data have eventually been made.

<tbody> </tbody>
<img src="/images/02GUI.png" alt="" width="765" height="530" />

 

<tbody> </tbody>
Item Description
DLL Errors Occur if any low level communication fails (tcpIP,  ports , sockets, …).
Data Errors Occur if the consistency check of incoming data discovers missing information (a data field with no value) or invalid information (letters where only numbers were expected or violations of minimum or maximum definitions).
Updates Updates are only triggered if the associated patient already exists in the MedITEX IVF patient table.
Edits Edits are triggered if the associated patient exists in the MedITEX IVF buffer table.
Inserts Inserts into the so called buffer table are processed if the associated patient could not be found in both tables (patient table and buffer table).
Modifies Whether triggered 'Updates' or 'Edits' are finally processed is decided dependent of the data field values. If no modifications of data are found no change of the database is performed.

 

<tbody> </tbody>
<img src="/images/03GUI.png" alt="" width="765" height="990" />

 

Message Types

The messages below are examples supported by MedITEX.

<tbody> </tbody>
<img src="/images/hint48.png" alt="" width="48" height="48" /> Please note that event typs such as, R01 and A08, are ignored. MedITEX will decide what to do with the message.

 

Lab Values Import

<tbody> </tbody>

ORU-R01-2.5

MSH|^~\&|LABOR1|14|LAB|MedITEX|20150109122547||ORU^R01|16216545|P|2.5||||||8859/1

PID||3333|096733119^^^GLIMS||Miller^Susan||19801122000000|F|||Randomroad 10^^Anytown^NY^12345

ORC|NW||10-00740090S^14||CM||^^^20150109112946|||||LOFT1^Loft^John^^^^Dr^^^^GLIMS|||20150109000000

OBR|1||10-00740090S^14||||20150109071000|||||||20150109112946||IVF-Clinic^^^^^^^^MedITEX||||User1||20150109000000|||M|||

OBX|1|SN|lh^LH^GLIMS||8.7|U/l||N|||F||||||

NTE|1|L|2.4 - 12.6  Follicularphase\.br\14.0 - 95.6 Ovulationspeak\.br\1.0 - 11.4  Lutealphase\.br\7.7 - 58.5  Postmenopause

OBX|3|SN|prog^Progesteron^GLIMS||1.7|nmol/l||N|||F||||||

NTE|1|L|0.6 - 4.7  Follicularphase\.br\2.4 - 9.4  Ovulationspeak\.br\5.3 - 86.0 Lutealphase\.br\0.3 - 2.5  Postmenopause

OBX|5|SN|estra^Oestradiol (E2)^GLIMS||166.8|pmol/l||N|||F||||||

NTE|1|L|46 - 607    Follicularphase\.br\315 - 1828  Ovulationspeak\.br\161 - 774   Lutealphase\.br\<18.4 - 201 Postmenopause

ORU-R01 fields definitions

 

<tbody> </tbody>
<a href="/images/Standard_ORU-R01-25.hl7"><img src="/images/plus48.png" alt="" width="48" height="48" /></a> <a href="/images/Standard_ORU-R01-25.hl7">Download the file here</a>. Right-click Save link as to download.

 

 

Patient Import

<tbody> </tbody>

ADT-A08-2.5

MSH|^~\&|Regional MPI|MPI|Master MPI|Alpha Hospital|20060501140010||ADT^A08|3948375|P^T|2.5|

EVN|A08|20060501140008|||000338475^Author^Arthur^^^^^^Regional MPI&2.16.840.1.113883.19.201&ISO^L|20060501140008

PID|||000197245^^^National Register&2.00.123.1.123456.55.5&ISO^PN~4532^^^Careful Care Clinic&2.16.840.1.113883.19.2.400566&ISO^PI~3242346^^^Central Clinic&2.16.840.1.113883.19.2.450998&ISO^PI||Miller^Susan^^^^^L||19750103|F|||Randomroad 23a&Randomroad&23a^^Anytown^^1200^^H||001 998877^TEL^PH~001 112233^FAX^FX|001 554433^TEL^PH

ADT-A08 fields definitions

 

<tbody> </tbody>
<a href="/images/Standard_ADT_A08_25.hl7"><img src="/images/plus48.png" alt="" width="48" height="48" /></a> <a href="/images/Standard_ADT_A08_25.hl7">Download the file here</a>. Right-click Save link as to download.

 

<tbody> </tbody>
<a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a> <a href="#top">Back to top</a>