_81.radiology_orders

Field	Type	Null	Default	Key	Extra	Comment
rad_id	int(11)	NO		PRI	auto_increment
rad_cus_id	int(11)	NO		MUL
rad_cli_id	int(11)	NO		MUL
rad_pat_id	int(11)	NO		MUL
rad_phy_id	int(11)	NO		MUL
rad_req_num	varchar(20)	NO	0	MUL		Uniquely identifies a radiology order
rad_diag_cs_id	int(11)	NO	2	MUL		master diagnosis coding system id for radiology order
rad_pid	varchar(20)	NO
rad_enc_id	int(11)	NO		MUL
rad_rad_res_id	int(11)	NO
rad_ssn	varchar(11)	NO
rad_mrn	varchar(20)	NO
rad_fname	varchar(40)	NO				First Name
rad_mname	varchar(40)	NO				Middle Name
rad_lname	varchar(40)	NO				Last Name
rad_bill_type	char(1)	NO
rad_dob	varchar(8)	NO
rad_age	varchar(3)	NO
rad_sex	varchar(7)	NO
rad_address1	varchar(40)	NO
rad_address2	varchar(40)	NO
rad_city	varchar(30)	NO
rad_state	varchar(2)	NO
rad_zip	varchar(5)	NO
rad_zip_plus4	varchar(4)	NO
rad_phone	varchar(20)	NO
rad_phone_work	varchar(20)	NO
rad_guarantor	varchar(40)	NO
rad_guarantor_relation	varchar(20)	NO
rad_ins1_irep_id	int(11)	NO	0	MUL		Primary insurance Repository ID#
rad_ins1_id	int(11)	NO
rad_ins1_policy_num	varchar(40)	NO
rad_ins1_group_num	varchar(40)	NO
rad_ins1_insured	varchar(40)	NO
rad_ins1_insured_relation	varchar(20)	NO
rad_ins1_employer_name	varchar(40)	NO
rad_ins1_employer_address	varchar(40)	NO
rad_ins1_employer_city	varchar(30)	NO
rad_ins1_employer_state	varchar(2)	NO
rad_ins1_employer_zip	varchar(5)	NO
rad_ins1_employer_zip_plus4	varchar(4)	NO
rad_ins2_irep_id	int(11)	NO	0	MUL		Secondary insurance Repository ID#
rad_ins2_id	int(11)	NO
rad_ins2_policy_num	varchar(40)	NO
rad_ins2_group_num	varchar(40)	NO
rad_ins2_insured	varchar(40)	NO
rad_ins2_insured_relation	varchar(20)	NO
rad_ins2_employer_name	varchar(40)	NO
rad_ins2_employer_address	varchar(40)	NO
rad_ins2_employer_city	varchar(30)	NO
rad_ins2_employer_state	varchar(2)	NO
rad_ins2_employer_zip	varchar(5)	NO
rad_ins2_employer_zip_plus4	varchar(4)	NO
rad_collected_ts	varchar(12)	NO
rad_status	varchar(20)	NO
rad_psc	char(1)	NO
rad_volume	varchar(10)	NO
rad_duration	varchar(10)	NO
rad_source	varchar(20)	NO
rad_room_num	varchar(10)	NO
rad_fasting	varchar(10)	NO
rad_pregnant	varchar(10)	NO
rad_abn_lang	tinyint(1)	NO	0
rad_standing	tinyint(1)	NO	0
rad_complete	tinyint(1)	NO	0	MUL
rad_manifest	tinyint(1)	NO	0	MUL
rad_received	tinyint(1)	NO	0	MUL
rad_finalized	tinyint(1)	NO	0	MUL
rad_deleted	char(1)	NO	0
rad_fax	char(1)	NO	0
rad_pdf_path	text	NO
rad_pdf_abn_path	text	NO
rad_vendys_atr_value	varchar(5)	NO
rad_vendys_atr_filename	varchar(50)	NO
rad_vendys_atr_path	text	NO
rad_vendys_abi_value	varchar(5)	NO
rad_vendys_abi_filename	varchar(50)	NO
rad_vendys_abi_path	text	NO
rad_patient_education	char(1)	NO
rad_lab_id	int(11)	NO		MUL
rad_loc_id	int(11)	YES
rad_lif_id	int(11)	NO		MUL
rad_sent	char(1)	NO	0
rad_released	char(1)	NO	0
rad_oss_id	char(1)	NO	0
rad_phyod_id	int(11)	YES		MUL
rad_reviewed_by	int(12)	NO
rad_usr_id_created	int(11)	NO	0	MUL		Links to creating user to avoid using audits table
rad_usr_id_modified	int(11)	NO	0	MUL		Links to modifying user to avoid using audits table
rad_reviewed_date	varchar(12)	NO
rad_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
rad_created	timestamp	YES	CURRENT_TIMESTAMP
rad_note	text	NO

References

Local Column

References

rad_id

Table	Column
_1.audits	aud_rad_id
_1.audits_archive	aud_rad_id
_1.radiology_order_notes	radnot_rad_id
_1.radiology_order_test_codes_aoe_values	rtcaoev_rad_id
_1.radiology_orders_dx_test_codes_map	ritcm_rad_id
_1.radiology_orders_icd9_codes	ric_rad_id
_1.radiology_orders_signed	rosig_rad_id
_1.radiology_orders_test_codes_map	rtcm_rad_id
_1.radiology_results	rad_res_rad_id
_1188.audits	aud_rad_id
_1188.audits_archive	aud_rad_id
_1188.radiology_order_notes	radnot_rad_id
_1188.radiology_order_test_codes_aoe_values	rtcaoev_rad_id
_1188.radiology_orders_dx_test_codes_map	ritcm_rad_id
_1188.radiology_orders_icd9_codes	ric_rad_id
_1188.radiology_orders_signed	rosig_rad_id
_1188.radiology_orders_test_codes_map	rtcm_rad_id
_1188.radiology_results	rad_res_rad_id
_1218.audits	aud_rad_id
_1218.audits_archive	aud_rad_id
_1218.radiology_order_notes	radnot_rad_id
_1218.radiology_order_test_codes_aoe_values	rtcaoev_rad_id
_1218.radiology_orders_dx_test_codes_map	ritcm_rad_id
_1218.radiology_orders_icd9_codes	ric_rad_id
_1218.radiology_orders_signed	rosig_rad_id
_1218.radiology_orders_test_codes_map	rtcm_rad_id
_1218.radiology_results	rad_res_rad_id
_1548.audits	aud_rad_id
_1548.audits_archive	aud_rad_id
_1548.radiology_order_notes	radnot_rad_id
_1548.radiology_order_test_codes_aoe_values	rtcaoev_rad_id
_1548.radiology_orders_dx_test_codes_map	ritcm_rad_id
_1548.radiology_orders_icd9_codes	ric_rad_id
_1548.radiology_orders_signed	rosig_rad_id
_1548.radiology_orders_test_codes_map	rtcm_rad_id
_1548.radiology_results	rad_res_rad_id
_435.audits	aud_rad_id
_435.audits_archive	aud_rad_id
_435.radiology_order_notes	radnot_rad_id
_435.radiology_order_test_codes_aoe_values	rtcaoev_rad_id
_435.radiology_orders_dx_test_codes_map	ritcm_rad_id
_435.radiology_orders_icd9_codes	ric_rad_id
_435.radiology_orders_signed	rosig_rad_id
_435.radiology_orders_test_codes_map	rtcm_rad_id
_435.radiology_results	rad_res_rad_id
_436.audits	aud_rad_id
_436.audits_archive	aud_rad_id
_436.radiology_order_notes	radnot_rad_id
_436.radiology_order_test_codes_aoe_values	rtcaoev_rad_id
_436.radiology_orders_dx_test_codes_map	ritcm_rad_id
_436.radiology_orders_icd9_codes	ric_rad_id
_436.radiology_orders_signed	rosig_rad_id
_436.radiology_orders_test_codes_map	rtcm_rad_id
_436.radiology_results	rad_res_rad_id
_436_archive_testing.audits	aud_rad_id
_436_archive_testing.audits_archive	aud_rad_id
_436_archive_testing.radiology_order_notes	radnot_rad_id
_436_archive_testing.radiology_order_test_codes_aoe_values	rtcaoev_rad_id
_436_archive_testing.radiology_orders_dx_test_codes_map	ritcm_rad_id
_436_archive_testing.radiology_orders_icd9_codes	ric_rad_id
_436_archive_testing.radiology_orders_signed	rosig_rad_id
_436_archive_testing.radiology_orders_test_codes_map	rtcm_rad_id
_436_archive_testing.radiology_results	rad_res_rad_id
_437.audits	aud_rad_id
_437.audits_archive	aud_rad_id
_437.radiology_order_notes	radnot_rad_id
_437.radiology_order_test_codes_aoe_values	rtcaoev_rad_id
_437.radiology_orders_dx_test_codes_map	ritcm_rad_id
_437.radiology_orders_icd9_codes	ric_rad_id
_437.radiology_orders_signed	rosig_rad_id
_437.radiology_orders_test_codes_map	rtcm_rad_id
_437.radiology_results	rad_res_rad_id
_8.audits	aud_rad_id
_8.audits_archive	aud_rad_id
_8.radiology_order_notes	radnot_rad_id
_8.radiology_order_test_codes_aoe_values	rtcaoev_rad_id
_8.radiology_orders_dx_test_codes_map	ritcm_rad_id
_8.radiology_orders_icd9_codes	ric_rad_id
_8.radiology_orders_signed	rosig_rad_id
_8.radiology_orders_test_codes_map	rtcm_rad_id
_8.radiology_results	rad_res_rad_id
_81.audits	aud_rad_id
_81.audits_archive	aud_rad_id
_81.radiology_order_notes	radnot_rad_id
_81.radiology_order_test_codes_aoe_values	rtcaoev_rad_id
_81.radiology_orders_dx_test_codes_map	ritcm_rad_id
_81.radiology_orders_icd9_codes	ric_rad_id
_81.radiology_orders_signed	rosig_rad_id
_81.radiology_orders_test_codes_map	rtcm_rad_id
_81.radiology_results	rad_res_rad_id
_999.audits	aud_rad_id
_999.audits_archive	aud_rad_id
_999.radiology_order_notes	radnot_rad_id
_999.radiology_order_test_codes_aoe_values	rtcaoev_rad_id
_999.radiology_orders_dx_test_codes_map	ritcm_rad_id
_999.radiology_orders_icd9_codes	ric_rad_id
_999.radiology_orders_signed	rosig_rad_id
_999.radiology_orders_test_codes_map	rtcm_rad_id
_999.radiology_results	rad_res_rad_id