_435.orders_test_codes_map

Field	Type	Null	Default	Key	Extra	Comment
otcm_id	int(11)	NO		PRI	auto_increment
otcm_cus_id	int(11)	NO		MUL
otcm_cli_id	int(11)	NO		MUL
otcm_otc_id	int(11)	NO		MUL
otcm_cs_id	int(11)	NO		MUL		Code System ID#
otcm_code_id	bigint(20)	NO		MUL		Code ID#
otcm_tco_id	int(11)	NO		MUL
otcm_lc_id	int(11)	NO
otcm_lab_id	int(11)	NO		MUL
otcm_ord_id	int(11)	NO		MUL
otcm_test_code	varchar(128)	NO
otcm_cpt	text	NO
otcm_reporting_title	text	NO
otcm_abn	tinyint(1)	NO
otcm_req_num	varchar(7)	NO		MUL
otcm_sent	tinyint(1)	NO	0
otcm_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
otcm_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

otcm_id

Table	Column
_1.cpoe_responses_test_codes_map	cpoe_restc_otcm_id
_1.orders_comments	orc_otcm_id
_1.orders_comments	ord_otcm_id
_1.orders_icd9_test_codes_map	oitcm_otcm_id
_1.orders_test_codes_documents_map	otcdm_otcm_id
_1.test_codes_aoe_values	tcaoev_otcm_id
_1188.cpoe_responses_test_codes_map	cpoe_restc_otcm_id
_1188.orders_comments	orc_otcm_id
_1188.orders_comments	ord_otcm_id
_1188.orders_icd9_test_codes_map	oitcm_otcm_id
_1188.orders_test_codes_documents_map	otcdm_otcm_id
_1188.test_codes_aoe_values	tcaoev_otcm_id
_1218.cpoe_responses_test_codes_map	cpoe_restc_otcm_id
_1218.orders_comments	orc_otcm_id
_1218.orders_comments	ord_otcm_id
_1218.orders_icd9_test_codes_map	oitcm_otcm_id
_1218.orders_test_codes_documents_map	otcdm_otcm_id
_1218.test_codes_aoe_values	tcaoev_otcm_id
_1548.cpoe_responses_test_codes_map	cpoe_restc_otcm_id
_1548.orders_comments	orc_otcm_id
_1548.orders_comments	ord_otcm_id
_1548.orders_icd9_test_codes_map	oitcm_otcm_id
_1548.orders_test_codes_documents_map	otcdm_otcm_id
_1548.test_codes_aoe_values	tcaoev_otcm_id
_435.cpoe_responses_test_codes_map	cpoe_restc_otcm_id
_435.orders_comments	ord_otcm_id
_435.orders_icd9_test_codes_map	oitcm_otcm_id
_435.orders_test_codes_documents_map	otcdm_otcm_id
_435.test_codes_aoe_values	tcaoev_otcm_id
_436.cpoe_responses_test_codes_map	cpoe_restc_otcm_id
_436.orders_comments	ord_otcm_id
_436.orders_icd9_test_codes_map	oitcm_otcm_id
_436.orders_test_codes_documents_map	otcdm_otcm_id
_436.test_codes_aoe_values	tcaoev_otcm_id
_436_archive_testing.cpoe_responses_test_codes_map	cpoe_restc_otcm_id
_436_archive_testing.orders_comments	ord_otcm_id
_436_archive_testing.orders_icd9_test_codes_map	oitcm_otcm_id
_436_archive_testing.orders_test_codes_documents_map	otcdm_otcm_id
_436_archive_testing.test_codes_aoe_values	tcaoev_otcm_id
_437.cpoe_responses_test_codes_map	cpoe_restc_otcm_id
_437.orders_comments	ord_otcm_id
_437.orders_icd9_test_codes_map	oitcm_otcm_id
_437.orders_test_codes_documents_map	otcdm_otcm_id
_437.test_codes_aoe_values	tcaoev_otcm_id
_8.cpoe_responses_test_codes_map	cpoe_restc_otcm_id
_8.orders_comments	orc_otcm_id
_8.orders_comments	ord_otcm_id
_8.orders_icd9_test_codes_map	oitcm_otcm_id
_8.orders_test_codes_documents_map	otcdm_otcm_id
_8.test_codes_aoe_values	tcaoev_otcm_id
_81.cpoe_responses_test_codes_map	cpoe_restc_otcm_id
_81.orders_comments	orc_otcm_id
_81.orders_comments	ord_otcm_id
_81.orders_icd9_test_codes_map	oitcm_otcm_id
_81.orders_test_codes_documents_map	otcdm_otcm_id
_81.test_codes_aoe_values	tcaoev_otcm_id
_999.cpoe_responses_test_codes_map	cpoe_restc_otcm_id
_999.orders_comments	orc_otcm_id
_999.orders_comments	ord_otcm_id
_999.orders_icd9_test_codes_map	oitcm_otcm_id
_999.orders_test_codes_documents_map	otcdm_otcm_id
_999.test_codes_aoe_values	tcaoev_otcm_id