_8.hl7_orders

Field	Type	Null	Default	Key	Extra
ord_id	int(11)	NO		PRI	auto_increment
ord_cus_id	int(11)	NO	0	MUL
ord_cli_id	int(11)	NO	0	MUL
ord_acc_id	int(11)	NO	0	MUL
ord_seq_num	tinyint(4)	NO	0
ord_order_id	varchar(128)	NO		MUL
ord_order_name	varchar(128)	NO
ord_status	char(1)	NO
ord_lo_list_price	varchar(7)	NO
ord_test_type	varchar(60)	NO
ord_tot_vol	varchar(10)	NO
ord_clinical_info	varchar(65)	NO
ord_specimen_source	varchar(60)	NO
ord_specimen_condition	varchar(60)	NO
ord_specimen_reject_reason	varchar(60)	NO
ord_group_number	varchar(20)	NO
ord_action_code	char(1)	NO
ord_namespace_id	varchar(20)	NO
ord_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
ord_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

ord_id

Table	Column
_1.audits	aud_ord_id
_1.audits_archive	aud_ord_id
_1.hl7_accessions	acc_ord_id
_1.hl7_notes	not_ord_id
_1.hl7_results	res_ord_id
_1.lab_orders_signed	losig_ord_id
_1.orders_afps	oafp_ord_id
_1.orders_comments	orc_ord_id
_1.orders_icd9_codes	oic_ord_id
_1.orders_icd9_test_codes_map	oitcm_ord_id
_1.orders_paps	opap_ord_id
_1.orders_standing	ost_ord_id
_1.orders_standing_dates	osd_ord_id
_1.orders_test_codes	otc_ord_id
_1.orders_test_codes_map	otcm_ord_id
_1.requisition_numbers	req_ord_id
_1.test_codes_aoe_values	tcaoev_ord_id
_1188.audits	aud_ord_id
_1188.audits_archive	aud_ord_id
_1188.hl7_accessions	acc_ord_id
_1188.hl7_notes	not_ord_id
_1188.hl7_results	res_ord_id
_1188.lab_orders_signed	losig_ord_id
_1188.orders_afps	oafp_ord_id
_1188.orders_comments	orc_ord_id
_1188.orders_icd9_codes	oic_ord_id
_1188.orders_icd9_test_codes_map	oitcm_ord_id
_1188.orders_paps	opap_ord_id
_1188.orders_standing	ost_ord_id
_1188.orders_standing_dates	osd_ord_id
_1188.orders_test_codes	otc_ord_id
_1188.orders_test_codes_map	otcm_ord_id
_1188.requisition_numbers	req_ord_id
_1188.test_codes_aoe_values	tcaoev_ord_id
_1218.audits	aud_ord_id
_1218.audits_archive	aud_ord_id
_1218.hl7_accessions	acc_ord_id
_1218.hl7_notes	not_ord_id
_1218.hl7_results	res_ord_id
_1218.lab_orders_signed	losig_ord_id
_1218.orders_afps	oafp_ord_id
_1218.orders_comments	orc_ord_id
_1218.orders_icd9_codes	oic_ord_id
_1218.orders_icd9_test_codes_map	oitcm_ord_id
_1218.orders_paps	opap_ord_id
_1218.orders_standing	ost_ord_id
_1218.orders_standing_dates	osd_ord_id
_1218.orders_test_codes	otc_ord_id
_1218.orders_test_codes_map	otcm_ord_id
_1218.requisition_numbers	req_ord_id
_1218.test_codes_aoe_values	tcaoev_ord_id
_1548.audits	aud_ord_id
_1548.audits_archive	aud_ord_id
_1548.hl7_accessions	acc_ord_id
_1548.hl7_notes	not_ord_id
_1548.hl7_results	res_ord_id
_1548.lab_orders_signed	losig_ord_id
_1548.orders_afps	oafp_ord_id
_1548.orders_comments	orc_ord_id
_1548.orders_icd9_codes	oic_ord_id
_1548.orders_icd9_test_codes_map	oitcm_ord_id
_1548.orders_paps	opap_ord_id
_1548.orders_standing	ost_ord_id
_1548.orders_standing_dates	osd_ord_id
_1548.orders_test_codes	otc_ord_id
_1548.orders_test_codes_map	otcm_ord_id
_1548.requisition_numbers	req_ord_id
_1548.test_codes_aoe_values	tcaoev_ord_id
_435.audits	aud_ord_id
_435.audits_archive	aud_ord_id
_435.hl7_accessions	acc_ord_id
_435.hl7_notes	not_ord_id
_435.hl7_results	res_ord_id
_435.lab_orders_signed	losig_ord_id
_435.orders_afps	oafp_ord_id
_435.orders_comments	orc_ord_id
_435.orders_icd9_codes	oic_ord_id
_435.orders_icd9_test_codes_map	oitcm_ord_id
_435.orders_paps	opap_ord_id
_435.orders_standing	ost_ord_id
_435.orders_standing_dates	osd_ord_id
_435.orders_test_codes	otc_ord_id
_435.orders_test_codes_map	otcm_ord_id
_435.requisition_numbers	req_ord_id
_435.test_codes_aoe_values	tcaoev_ord_id
_436.audits	aud_ord_id
_436.audits_archive	aud_ord_id
_436.hl7_accessions	acc_ord_id
_436.hl7_notes	not_ord_id
_436.hl7_results	res_ord_id
_436.lab_orders_signed	losig_ord_id
_436.orders_afps	oafp_ord_id
_436.orders_comments	orc_ord_id
_436.orders_icd9_codes	oic_ord_id
_436.orders_icd9_test_codes_map	oitcm_ord_id
_436.orders_paps	opap_ord_id
_436.orders_standing	ost_ord_id
_436.orders_standing_dates	osd_ord_id
_436.orders_test_codes	otc_ord_id
_436.orders_test_codes_map	otcm_ord_id
_436.requisition_numbers	req_ord_id
_436.test_codes_aoe_values	tcaoev_ord_id
_436_archive_testing.audits	aud_ord_id
_436_archive_testing.audits_archive	aud_ord_id
_436_archive_testing.hl7_accessions	acc_ord_id
_436_archive_testing.hl7_notes	not_ord_id
_436_archive_testing.hl7_results	res_ord_id
_436_archive_testing.lab_orders_signed	losig_ord_id
_436_archive_testing.orders_afps	oafp_ord_id
_436_archive_testing.orders_comments	orc_ord_id
_436_archive_testing.orders_icd9_codes	oic_ord_id
_436_archive_testing.orders_icd9_test_codes_map	oitcm_ord_id
_436_archive_testing.orders_paps	opap_ord_id
_436_archive_testing.orders_standing	ost_ord_id
_436_archive_testing.orders_standing_dates	osd_ord_id
_436_archive_testing.orders_test_codes	otc_ord_id
_436_archive_testing.orders_test_codes_map	otcm_ord_id
_436_archive_testing.requisition_numbers	req_ord_id
_436_archive_testing.test_codes_aoe_values	tcaoev_ord_id
_437.audits	aud_ord_id
_437.audits_archive	aud_ord_id
_437.hl7_accessions	acc_ord_id
_437.hl7_notes	not_ord_id
_437.hl7_results	res_ord_id
_437.lab_orders_signed	losig_ord_id
_437.orders_afps	oafp_ord_id
_437.orders_comments	orc_ord_id
_437.orders_icd9_codes	oic_ord_id
_437.orders_icd9_test_codes_map	oitcm_ord_id
_437.orders_paps	opap_ord_id
_437.orders_standing	ost_ord_id
_437.orders_standing_dates	osd_ord_id
_437.orders_test_codes	otc_ord_id
_437.orders_test_codes_map	otcm_ord_id
_437.requisition_numbers	req_ord_id
_437.test_codes_aoe_values	tcaoev_ord_id
_8.audits	aud_ord_id
_8.audits_archive	aud_ord_id
_8.hl7_accessions	acc_ord_id
_8.hl7_notes	not_ord_id
_8.hl7_results	res_ord_id
_8.lab_orders_signed	losig_ord_id
_8.orders_afps	oafp_ord_id
_8.orders_comments	orc_ord_id
_8.orders_icd9_codes	oic_ord_id
_8.orders_icd9_test_codes_map	oitcm_ord_id
_8.orders_paps	opap_ord_id
_8.orders_standing	ost_ord_id
_8.orders_standing_dates	osd_ord_id
_8.orders_test_codes	otc_ord_id
_8.orders_test_codes_map	otcm_ord_id
_8.requisition_numbers	req_ord_id
_8.test_codes_aoe_values	tcaoev_ord_id
_81.audits	aud_ord_id
_81.audits_archive	aud_ord_id
_81.hl7_accessions	acc_ord_id
_81.hl7_notes	not_ord_id
_81.hl7_results	res_ord_id
_81.lab_orders_signed	losig_ord_id
_81.orders_afps	oafp_ord_id
_81.orders_comments	orc_ord_id
_81.orders_icd9_codes	oic_ord_id
_81.orders_icd9_test_codes_map	oitcm_ord_id
_81.orders_paps	opap_ord_id
_81.orders_standing	ost_ord_id
_81.orders_standing_dates	osd_ord_id
_81.orders_test_codes	otc_ord_id
_81.orders_test_codes_map	otcm_ord_id
_81.requisition_numbers	req_ord_id
_81.test_codes_aoe_values	tcaoev_ord_id
_999.audits	aud_ord_id
_999.audits_archive	aud_ord_id
_999.hl7_accessions	acc_ord_id
_999.hl7_notes	not_ord_id
_999.hl7_results	res_ord_id
_999.lab_orders_signed	losig_ord_id
_999.orders_afps	oafp_ord_id
_999.orders_comments	orc_ord_id
_999.orders_icd9_codes	oic_ord_id
_999.orders_icd9_test_codes_map	oitcm_ord_id
_999.orders_paps	opap_ord_id
_999.orders_standing	ost_ord_id
_999.orders_standing_dates	osd_ord_id
_999.orders_test_codes	otc_ord_id
_999.orders_test_codes_map	otcm_ord_id
_999.requisition_numbers	req_ord_id
_999.test_codes_aoe_values	tcaoev_ord_id
common.ahi_audits	aud_ord_id
common.faxes	fax_ord_id