iNTERFACEWARE™ Inc.

Contains HL7 messages that were processed by that channel. It contains six columns:

• Resubmit Flag: Indicates whether a message has been resubmitted. This will either be true or false.
• Message: Stores the original HL7 message.
• Trace Message: Stores Python output obtained from running log statements in scripts in your VMD file.
• Debug Message: Stores the ACKnowledgment message sent.
• Log Timestamp: Timestamp of the HL7 message.
• Log Key: Record number of a particular message.

The success log table is named channelname_cha_suc_log, where channelname is the name of the channel in Iguana. The information in this table corresponds to the data found in the Logs page in the Successes column in Iguana.

Note that this log must be exported to your database.

Contains information about HL7 messages that were not processed by the destination or source component, as well as other channel error information such as connection errors. It contains six columns:

• Resubmit Flag: Indicates whether a message has been resubmitted. This will either be true or false.
• Message: Stores the original HL7 message.
• Trace Message: Stores Python output obtained from running log statements in scripts in your VMD file.
• Log Timestamp: Timestamp of the error message.
• Debug Message: Contains a description of the error.
• Log Key: Record number of a particular error.

The destination error log table is named channelname_dest1_tochanneltype, where "channelname" is the name of your channel, "dest1" stands for destination component, and "tochanneltype" is the destination of the channel (e.g. "to_dat_err" stands for "to database errors"). The source error log follows a similar naming scheme, with "dest1" being replaced by "source1".

Note that the logs tables are the same and do not depend on the channel being set up. These logs must be exported to your database.

The Database components contain destination or source data tables:

The names and columns of the data tables will be identical to the tables you set up in the VMD file. The defined table columns in the VMD file will also map to the columns defined in the database. Note that you do not have to export these tables if you have existing data tables that you want to use.

The Message Filter contains a single destination data table that must be exported. Its columns are used internally by Iguana for routing purposes and contains only the status table. The original messages are stored in the success logs.

The status table is named channelname_status, where "channelname" is the name of your channel.

Note that the message filter tables do not refer to the columns in the VMD file.