common.lab_interfaces

Field	Type	Null	Default	Key	Extra	Comment
lif_id	int(11)	NO		PRI	auto_increment
lif_cus_id	int(11)	NO		MUL
lif_cli_id	int(11)	NO		MUL
lif_cli_id_ext	varchar(60)	NO
lif_display_name	varchar(60)	NO
lif_it_id	int(11)	NO		MUL
lif_inbound_path	varchar(100)	NO		MUL
lif_outbound_path	varchar(100)	NO		MUL
lif_archive_path	varchar(100)	NO		MUL
lif_error_path	varchar(100)	NO
lif_ftp_user	varchar(40)	NO
lif_ftp_passwd	varchar(128)	NO
lif_cli_name	varchar(40)	NO				Lab client name override
lif_cli_address1	varchar(40)	NO				Lab client address line 1 override
lif_cli_address2	varchar(40)	NO				Lab client address line 2 override
lif_cli_city	varchar(30)	NO				Lab client city override
lif_cli_state	varchar(2)	NO				Lab client state override
lif_cli_zip	varchar(5)	NO				Lab client zip override
lif_cli_zip_plus4	varchar(4)	NO				Lab client zip extension override
lif_cli_phone1	varchar(20)	YES
lif_cli_fax	varchar(20)	YES
lif_archive_pat_record	tinyint(1)	NO	0			Indicates whether lab results will be archived to patient records when patient is attached
lif_testing	char(1)	NO
lif_disabled	char(1)	NO	0	MUL
lif_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
lif_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

lif_id

Table	Column
_1.clients_test_codes	ctc_lif_id
_1.hl7_accessions	acc_lif_id
_1.interface_messaging_logs	iml_lif_id
_1.orders	ord_lif_id
_1.orders_templates	ordt_lif_id
_1.radiology_orders	rad_lif_id
_1.radiology_results	rad_res_lif_id
_1.test_codes_search_frequency	tcof_lif_id
_1188.clients_test_codes	ctc_lif_id
_1188.hl7_accessions	acc_lif_id
_1188.interface_messaging_logs	iml_lif_id
_1188.orders	ord_lif_id
_1188.orders_templates	ordt_lif_id
_1188.radiology_orders	rad_lif_id
_1188.radiology_results	rad_res_lif_id
_1188.test_codes_search_frequency	tcof_lif_id
_1218.clients_test_codes	ctc_lif_id
_1218.hl7_accessions	acc_lif_id
_1218.interface_messaging_logs	iml_lif_id
_1218.orders	ord_lif_id
_1218.orders_templates	ordt_lif_id
_1218.radiology_orders	rad_lif_id
_1218.radiology_results	rad_res_lif_id
_1218.test_codes_search_frequency	tcof_lif_id
_1548.clients_test_codes	ctc_lif_id
_1548.hl7_accessions	acc_lif_id
_1548.interface_messaging_logs	iml_lif_id
_1548.orders	ord_lif_id
_1548.orders_templates	ordt_lif_id
_1548.radiology_orders	rad_lif_id
_1548.radiology_results	rad_res_lif_id
_1548.test_codes_search_frequency	tcof_lif_id
_435.clients_test_codes	ctc_lif_id
_435.hl7_accessions	acc_lif_id
_435.interface_messaging_logs	iml_lif_id
_435.orders	ord_lif_id
_435.orders_templates	ordt_lif_id
_435.radiology_orders	rad_lif_id
_435.radiology_results	rad_res_lif_id
_435.test_codes_search_frequency	tcof_lif_id
_436.clients_test_codes	ctc_lif_id
_436.hl7_accessions	acc_lif_id
_436.interface_messaging_logs	iml_lif_id
_436.orders	ord_lif_id
_436.orders_templates	ordt_lif_id
_436.radiology_orders	rad_lif_id
_436.radiology_results	rad_res_lif_id
_436.test_codes_search_frequency	tcof_lif_id
_436_archive_testing.clients_test_codes	ctc_lif_id
_436_archive_testing.hl7_accessions	acc_lif_id
_436_archive_testing.interface_messaging_logs	iml_lif_id
_436_archive_testing.orders	ord_lif_id
_436_archive_testing.orders_templates	ordt_lif_id
_436_archive_testing.radiology_orders	rad_lif_id
_436_archive_testing.radiology_results	rad_res_lif_id
_436_archive_testing.test_codes_search_frequency	tcof_lif_id
_437.clients_test_codes	ctc_lif_id
_437.hl7_accessions	acc_lif_id
_437.interface_messaging_logs	iml_lif_id
_437.orders	ord_lif_id
_437.orders_templates	ordt_lif_id
_437.radiology_orders	rad_lif_id
_437.radiology_results	rad_res_lif_id
_437.test_codes_search_frequency	tcof_lif_id
_8.clients_test_codes	ctc_lif_id
_8.hl7_accessions	acc_lif_id
_8.interface_messaging_logs	iml_lif_id
_8.orders	ord_lif_id
_8.orders_templates	ordt_lif_id
_8.radiology_orders	rad_lif_id
_8.radiology_results	rad_res_lif_id
_8.test_codes_search_frequency	tcof_lif_id
_81.clients_test_codes	ctc_lif_id
_81.hl7_accessions	acc_lif_id
_81.interface_messaging_logs	iml_lif_id
_81.orders	ord_lif_id
_81.orders_templates	ordt_lif_id
_81.radiology_orders	rad_lif_id
_81.radiology_results	rad_res_lif_id
_81.test_codes_search_frequency	tcof_lif_id
_999.clients_test_codes	ctc_lif_id
_999.hl7_accessions	acc_lif_id
_999.interface_messaging_logs	iml_lif_id
_999.orders	ord_lif_id
_999.orders_templates	ordt_lif_id
_999.radiology_orders	rad_lif_id
_999.radiology_results	rad_res_lif_id
_999.test_codes_search_frequency	tcof_lif_id
common.interface_status	ifs_lif_id
common.interfaces_config	ic_lif_id
common.lab_interface_mappings	lim_lif_id