Day 1 – The HL7 Standard, Viewing HL7 Messages in HL7Connect and Managing HL7Connect Projects (Optional)

• HL7 Overview
• HL7 Structure
• Main HL7 transaction types
•              ADT         Orders         Results      Other types
• Integration Challenges in Healthcare
•             Differing Interpretations of the Standard        Message Flows:     - Point to Point       -  Integration Engine        Need for flexibility
• Using the HL7 Dictionary in HL7Connect
•             Has different standards and versions built in:     - User-friendly HL7 Manual       - Drill down, view table values, etc.
• Managing HL7Connect Projects
•             Project Planning        Involving all interested parties        Specifications and mapping
•             Keeping the project on track:   - Communication via email and conference calls       - Status meetings and status reporting

Day 2 – HL7Connect Browser Interface, Architecture, Routing/Translation and Message Protocols:

• Overview of Web Browser Interface
•             Logon Button        Status Page         Quick Tour of Tabs and Features

• Viewing HL7 Messages in HL7Connect
•             Stuff You Can Do With Messages (Messages.doc):   - Message Store      - Search for messages       - Filters
• Setting up TCP/IP Interfaces:

•             Video: How to Setup an Incoming TCP/IP Interface
•             Video: How to Setup an Outgoing TCP/IP Interface
•             Video: How to Setup Manual Routing

• Exercise:
•             Set up sending and receiving interfaces (Test to Laptop)        Re-send some messages

• Setting up File Interfaces:
•             Video: How to Setup an Incoming File Interface        Video: How to Setup an Outgoing File Interface

• Setting up Message Routing:
•             Video: How to Setup an Automatic Routing       Routing documentation (Conditional Routing.doc)
• Exercises:

• System administration tools:
•             Administration_Configuration Tab.doc        Alerts        Configuring/Tracking User Accounts        Utilities
•             Saving/documenting your HL7Connect environment (System Documentation.doc)

Day 3 – The HL7Connect Development Environment and VB Script:



• The Development Environment:
•             Development Intro
•             HL7 Message Editor
•                  - Copy and paste      - Click for field number/desc        - Legend /Colors       - HL7 Batch 
•                  - Tree View – Nice for reviewing msg without getting overwhelmed       - Hex View
•             HL7Connect Tutorials:  - Scripting Concepts       - Getting Started with VB Scripting       - Tutorials and examples

• Altering Standard HL7 Acknowledgement Messages (Introduction, Sample Scripts)
• Mapping values using a database

• Referencing HL7 Message Components from your Script
•             A field:    - Extract the value        - Set the value       - Clear a field        A subfield
• Selective routing (Filtering):

•              We use “Conditions” under routing.        Can also use VB script, e.g. SelectiveRouting.vbs (Code Samples)

• Message search and replace:
•             Retrieve the “raw” message        Manipulate the raw message       “Encode” the resulting string:
• Exercises

• Counting/Iterating:
•             Count the number of segments        Loop through each segment       Add a segment, etc.
• Working with Files:
•             Converting back and forth between HL7 and delimited files, Events:
•             Delimited files
•                  - CSV or Tab-delimited – Recognizes either automatically on input
•                  - Output:  aEvent.SeparatorChar optionally used on output (default is .CSV)
  •             Files with HL7 Messages
  • Exercise:
    • Directly updating a SQL database:
    •             Similar to using a DB for mapping
    • VB Script programming Resources:
      • Other features of the HL7Connect Development Environment
      •             HL7 Send Client          HL7 Receive Client
      • HL7Connect Internals – the database
      •             SQL Server vs. Others        Tools, Database Browser        hl7connect tables
      •             Querying the database       Failure recovery – clearing the database
        • Review VB Scripts used at your hospital.
          
          
          • Miscellaneous Stuff to Cover

• IE.7 & 8 support – Firefox
• Cold Standby/Failover


• Certification Exam (Everything Except Clinical Documents)

Day 4 – Clinical Documents in HL7Connect (Optional)

• Overview of Clinical Document Architecture
•             CCR         HL7 Version 3 RIM Model        CCD:  - HITSP C32        CCD/CCR Requirements for HITECH Certification

• Receiving and Parsing Clinical Documents
• Routing Clinical Documents
•             Virtual Queues
• Generating Clinical Documents
•              KScript        Accessing HL7 V2.x message content from KScript        SQL from KScript

Exercises

Certification Exam (Clinical Documents)