aurora_standard.chmhl7ic

Field Type Null Default Key Extra Comment
interface_name varchar(30) NO
description varchar(255) YES
company_name varchar(50) YES
company_contact varchar(50) YES
company_email varchar(100) YES
company_phone varchar(20) YES
sending_ip varchar(20) YES
sending_port varchar(6) YES
receiving_port varchar(15) YES
date_live date YES
directory_name_in varchar(50) YES
directory_name_out varchar(50) YES
module varchar(20) YES
message_type varchar(30) YES
user_login varchar(20) YES
hl7_no int(10) unsigned NO PRI auto_increment

References

Local Column References
message_type
TableColumn
AzaleaStats.error_reportserr_message_type
_1.encounters_surveillance_recordsesr_message_type
_1.interface_messaging_logsiml_message_type
_1188.encounters_surveillance_recordsesr_message_type
_1188.interface_messaging_logsiml_message_type
_1218.encounters_surveillance_recordsesr_message_type
_1218.interface_messaging_logsiml_message_type
_1548.encounters_surveillance_recordsesr_message_type
_1548.interface_messaging_logsiml_message_type
_435.encounters_surveillance_recordsesr_message_type
_435.interface_messaging_logsiml_message_type
_436.encounters_surveillance_recordsesr_message_type
_436.interface_messaging_logsiml_message_type
_436_archive_testing.encounters_surveillance_recordsesr_message_type
_436_archive_testing.interface_messaging_logsiml_message_type
_437.encounters_surveillance_recordsesr_message_type
_437.interface_messaging_logsiml_message_type
_8.encounters_surveillance_recordsesr_message_type
_8.interface_messaging_logsiml_message_type
_81.encounters_surveillance_recordsesr_message_type
_81.interface_messaging_logsiml_message_type
_999.encounters_surveillance_recordsesr_message_type
_999.interface_messaging_logsiml_message_type
description
TableColumn
HSPI_Bastrop.devicesdevice_description
HSPI_CURES2015_B1.devicesdevice_description
HSPI_Central_Hospital.devicesdevice_description
HSPI_Dewitt.devicesdevice_description
HSPI_Fulton.devicesdevice_description
HSPI_Inferno.devicesdevice_description
HSPI_MU2015_E1.devicesdevice_description
HSPI_MU2015_G2.devicesdevice_description
HSPI_MU2015_G9.devicesdevice_description
HSPI_Sandbox.devicesdevice_description
HSPI_Summit_General.devicesdevice_description
HSPI_United_Physicians.devicesdevice_description
MPI.devicesdevice_description
_1.adjustment_rulesar_description
_1.cqm_errorscqmer_description
_1.encounters_alert_rulesear_description
_1.patients_implantable_devicespid_device_description
_1188.cqm_errorscqmer_description
_1188.encounters_alert_rulesear_description
_1188.patients_implantable_devicespid_device_description
_1218.adjustment_rulesar_description
_1218.cqm_errorscqmer_description
_1218.encounters_alert_rulesear_description
_1218.patients_implantable_devicespid_device_description
_1548.adjustment_rulesar_description
_1548.cqm_errorscqmer_description
_1548.encounters_alert_rulesear_description
_1548.patients_implantable_devicespid_device_description
_435.adjustment_rulesar_description
_435.cqm_errorscqmer_description
_435.encounters_alert_rulesear_description
_435.patients_implantable_devicespid_device_description
_436.adjustment_rulesar_description
_436.cqm_errorscqmer_description
_436.encounters_alert_rulesear_description
_436.patients_implantable_devicespid_device_description
_436_archive_testing.adjustment_rulesar_description
_436_archive_testing.cqm_errorscqmer_description
_436_archive_testing.encounters_alert_rulesear_description
_436_archive_testing.patients_implantable_devicespid_device_description
_437.adjustment_rulesar_description
_437.cqm_errorscqmer_description
_437.encounters_alert_rulesear_description
_437.patients_implantable_devicespid_device_description
_8.adjustment_rulesar_description
_8.cqm_errorscqmer_description
_8.encounters_alert_rulesear_description
_8.patients_implantable_devicespid_device_description
_81.cqm_errorscqmer_description
_81.encounters_alert_rulesear_description
_81.patients_implantable_devicespid_device_description
_999.adjustment_rulesar_description
_999.cqm_errorscqmer_description
_999.encounters_alert_rulesear_description
_999.patients_implantable_devicespid_device_description
ahiWiki.filearchivefa_description
ahiWiki.imageimg_description
ahiWiki.oldimageoi_description
aurora_standard.medgenix_modulesmodule_description
aurora_standard.stfclondasst_description
aurora_standard.stpapckvacct_description
aurora_standard.stultyprupdate_description
aurora_standard.stxparmdval_description
aurora_standard.stydeddvhome_description
aurora_standard.styincdvhome_description
aurora_standard.styintfcsource_description
aurora_standard.styjobtcjob_description
aurora_standard.styobldvhome_description
aurora_standard.styptodvhome_description
common.data_import_optionsdio_description
common.data_import_value_typesdivt_description
common.dev_requestsdev_description
common.dev_requests_screencastsdrs_description
common.insurances_claim_indicatorsinsci_description
common.smoking_statusesss_description
common.test_codestco_x_specimen_description
common.test_codes_profilestcp_description
company_name
TableColumn
_1.client_contactsclicon_company_name
_1188.client_contactsclicon_company_name
_1218.client_contactsclicon_company_name
_1548.client_contactsclicon_company_name
_435.client_contactsclicon_company_name
_436.client_contactsclicon_company_name
_436_archive_testing.client_contactsclicon_company_name
_437.client_contactsclicon_company_name
_8.client_contactsclicon_company_name
_81.client_contactsclicon_company_name
_999.client_contactsclicon_company_name
module
TableColumn
ahiWiki.module_depsmd_module
aurora_standard.stxackndack_module
aurora_standard.stxerorderr_module
aurora_standard.stxerorherr_module
aurora_standard.stxhelpdhlp_module
aurora_standard.stxhotkdhot_module
aurora_standard.stxmssgrmssg_module
aurora_standard.stxnvgtdnav_module