_1218.orders

Field	Type	Null	Default	Key	Extra	Comment
ord_id	int(11)	NO		PRI	auto_increment
ord_cus_id	int(11)	NO		MUL
ord_cli_id	int(11)	NO		MUL
ord_cpoet_id	int(11)	NO		MUL
ord_pat_id	int(11)	NO		MUL
ord_phy_id	int(11)	NO		MUL
ord_diag_cs_id	int(11)	NO	2	MUL
ord_pid	varchar(20)	NO
ord_enc_id	int(11)	NO		MUL
ord_acc_id	int(11)	NO		MUL
ord_ssn	varchar(11)	NO
ord_mrn	varchar(20)	NO
ord_fname	varchar(40)	NO				First Name
ord_mname	varchar(40)	NO				Middle Name
ord_lname	varchar(40)	NO				Last Name
ord_suffix	varchar(10)	NO				Patient name suffix
ord_bill_type	char(1)	NO
ord_dob	varchar(8)	NO
ord_age	varchar(3)	NO
ord_sex	varchar(7)	NO
ord_address1	varchar(40)	NO
ord_address2	varchar(40)	NO
ord_city	varchar(30)	NO
ord_state	varchar(2)	NO
ord_zip	varchar(5)	NO
ord_zip_plus4	varchar(4)	NO
ord_phone	varchar(20)	NO
ord_phone_work	varchar(20)	NO
ord_guarantor	varchar(40)	NO
ord_guarantor_relation	varchar(20)	NO
ord_ins1_irep_id	int(11)	NO	0	MUL		Primary insurance Repository ID#
ord_ins1_id	int(11)	NO
ord_ins1_policy_num	varchar(40)	NO
ord_ins1_group_num	varchar(40)	NO
ord_ins1_insured	varchar(40)	NO
ord_ins1_insured_relation	varchar(20)	NO
ord_ins1_employer_name	varchar(40)	NO
ord_ins1_employer_address	varchar(40)	NO
ord_ins1_employer_city	varchar(30)	NO
ord_ins1_employer_state	varchar(2)	NO
ord_ins1_employer_zip	varchar(5)	NO
ord_ins1_employer_zip_plus4	varchar(4)	NO
ord_ins2_irep_id	int(11)	NO	0	MUL		Secondary insurance Repository ID#
ord_ins2_id	int(11)	NO
ord_ins2_policy_num	varchar(40)	NO
ord_ins2_group_num	varchar(40)	NO
ord_ins2_insured	varchar(40)	NO
ord_ins2_insured_relation	varchar(20)	NO
ord_ins2_employer_name	varchar(40)	NO
ord_ins2_employer_address	varchar(40)	NO
ord_ins2_employer_city	varchar(30)	NO
ord_ins2_employer_state	varchar(2)	NO
ord_ins2_employer_zip	varchar(5)	NO
ord_ins2_employer_zip_plus4	varchar(4)	NO
ord_collected_ts	varchar(12)	NO
ord_collectors_initials	varchar(3)	NO
ord_status	varchar(20)	NO
ord_psc	char(1)	NO
ord_workers_comp	char(1)	NO
ord_volume	varchar(10)	NO
ord_duration	varchar(10)	NO
ord_source	varchar(20)	NO
ord_room_num	varchar(10)	NO
ord_fasting	varchar(10)	NO
ord_pregnant	varchar(10)	NO
ord_abn_lang	tinyint(1)	NO	0
ord_standing	tinyint(1)	NO	0
ord_complete	tinyint(1)	NO	0	MUL
ord_manifest	tinyint(1)	NO	0	MUL
ord_received	tinyint(1)	NO	0	MUL
ord_finalized	tinyint(1)	NO	0	MUL
ord_deleted	char(1)	NO	0	MUL
ord_fax	char(1)	NO	0
ord_pdf_path	text	NO
ord_pdf_abn_path	text	NO
ord_vendys_atr_value	varchar(5)	NO
ord_vendys_atr_filename	varchar(50)	NO
ord_vendys_atr_path	text	NO
ord_vendys_abi_value	varchar(5)	NO
ord_vendys_abi_filename	varchar(50)	NO
ord_vendys_abi_path	text	NO
ord_patient_education	char(1)	NO
ord_lab_id	int(11)	NO		MUL
ord_loc_id	int(11)	YES
ord_lif_id	int(11)	NO		MUL
ord_sent	char(1)	NO	0
ord_released	char(1)	NO	0
ord_oss_id	char(1)	NO	0	MUL
ord_phyod_id	int(11)	YES		MUL
ord_reviewed_by	int(12)	NO		MUL
ord_usr_id_created	int(11)	NO	0	MUL		Links to creating user to avoid using audits table
ord_usr_id_modified	int(11)	NO	0	MUL		Links to modifying user to avoid using audits table
ord_reviewed_date	varchar(12)	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