_1548.interface_messaging_logs

Field Type Null Default Key Extra Comment
iml_id int(11) NO PRI auto_increment
iml_cus_id int(11) NO 0 Customer ID#
iml_cli_id int(11) NO 0 MUL Client ID#
iml_if_id int(11) NO 0 MUL Interface ID#
iml_lif_id int(11) NO 0 MUL Lab Interface ID#
iml_outgoing tinyint(1) NO 0 True indicates outgoing message, false is incoming
iml_message_type varchar(50) NO Indicates the type of HL7 message
iml_trigger varchar(50) NO Indicates the associated trigger type for the message
iml_external_id varchar(50) NO MUL ID the external service uses to map this encounter
iml_control_id varchar(50) NO MUL Control ID of the HL7 message
iml_signature varchar(50) NO A md5 hash-signature of the hl7 message
iml_disabled tinyint(1) NO 0 True indicates the message has been disabled or cancelled for some reason
iml_created datetime YES CURRENT_TIMESTAMP
iml_modified datetime YES CURRENT_TIMESTAMP

References

Local Column References
iml_id
TableColumn
_1.interface_messaging_logs_mapimlm_iml_id
_1188.interface_messaging_logs_mapimlm_iml_id
_1218.interface_messaging_logs_mapimlm_iml_id
_1548.interface_messaging_logs_mapimlm_iml_id
_435.interface_messaging_logs_mapimlm_iml_id
_436.interface_messaging_logs_mapimlm_iml_id
_436_archive_testing.interface_messaging_logs_mapimlm_iml_id
_437.interface_messaging_logs_mapimlm_iml_id
_8.interface_messaging_logs_mapimlm_iml_id
_81.interface_messaging_logs_mapimlm_iml_id
_999.interface_messaging_logs_mapimlm_iml_id