common.interfaces

Field Type Null Default Key Extra Comment
if_id int(11) NO PRI auto_increment
if_cus_id int(11) NO MUL
if_cli_id int(11) NO MUL
if_it_id int(11) NO MUL
if_demog_path varchar(100) NO MUL
if_billing_path varchar(100) NO MUL
if_lab_path varchar(100) NO MUL
if_exchange_path text NO
if_inbound_path varchar(100) NO Directory file path for inbound interface messages
if_outbound_path varchar(100) NO Directory file path for outbound interface messages
if_archive_path varchar(100) NO MUL
if_error_path varchar(100) NO
if_ftp_user varchar(128) NO
if_ftp_passwd varchar(128) NO
if_sending_application varchar(156) YES
if_sending_facility varchar(156) YES
if_testing tinyint(1) NO 0 Testing flag
if_disabled char(1) NO 0 MUL
if_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
if_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
if_id
TableColumn
_1.encounter_soap_messaging_logesml_if_id
_1.encounters_soap_messaging_logsesml_if_id
_1.interface_messaging_logsiml_if_id
_1188.interface_messaging_logsiml_if_id
_1218.interface_messaging_logsiml_if_id
_1548.encounter_soap_messaging_logesml_if_id
_1548.encounters_soap_messaging_logsesml_if_id
_1548.interface_messaging_logsiml_if_id
_435.encounter_soap_messaging_logesml_if_id
_435.interface_messaging_logsiml_if_id
_436.encounter_soap_messaging_logesml_if_id
_436.interface_messaging_logsiml_if_id
_436_archive_testing.encounter_soap_messaging_logesml_if_id
_436_archive_testing.interface_messaging_logsiml_if_id
_437.encounter_soap_messaging_logesml_if_id
_437.interface_messaging_logsiml_if_id
_8.encounter_soap_messaging_logesml_if_id
_8.encounters_soap_messaging_logsesml_if_id
_8.interface_messaging_logsiml_if_id
_81.interface_messaging_logsiml_if_id
_999.encounter_soap_messaging_logesml_if_id
_999.encounters_soap_messaging_logsesml_if_id
_999.interface_messaging_logsiml_if_id
common.interface_statusifs_if_id
common.interfaces_configic_if_id