_436_archive_testing.radiology_results

Field	Type	Null	Default	Key	Extra	Comment
rad_res_id	int(11)	NO		PRI	auto_increment
rad_res_cus_id	int(11)	NO		MUL
rad_res_cli_id	int(11)	NO		MUL
rad_res_pat_id	int(11)	NO		MUL
rad_res_lif_id	int(11)	NO	0			Ties the result to a specific interface. Used for grid display and to prevent collision between different vendors.
rad_res_icr_id	int(11)	NO		MUL
rad_res_don_id	int(11)	NO		MUL
rad_res_invper_id	int(11)	NO		MUL
rad_res_invnum_id	int(11)	NO		MUL
rad_res_master_cli_account_num	varchar(20)	NO		MUL
rad_res_cli_account_num	varchar(20)	NO		MUL
rad_res_secondary_index	varchar(20)	NO		MUL
rad_res_pid	varchar(20)	NO		MUL
rad_res_mrn	varchar(20)	NO		MUL
rad_res_ssn	varchar(20)	NO		MUL
rad_res_fname	varchar(40)	NO		MUL		First Name
rad_res_mname	varchar(40)	NO				Middle Name
rad_res_lname	varchar(40)	NO		MUL		Last Name
rad_res_sex	varchar(7)	NO
rad_res_dob	varchar(20)	NO
rad_res_age	varchar(10)	NO
rad_res_room_num	varchar(10)	NO
rad_res_location	varchar(10)	NO		MUL
rad_res_accession_num	varchar(128)	NO		MUL
rad_res_phone	varchar(20)	NO
rad_res_critical	varchar(2)	NO
rad_res_requested_ts	varchar(12)	NO		MUL
rad_res_reported_ts	varchar(12)	NO		MUL
rad_res_req_num	varchar(128)	NO
rad_res_physician	varchar(30)	NO
rad_res_interpreting_phy_id	int(11)	NO		MUL
rad_res_ordering_physician	varchar(30)	NO
rad_res_ordering_phy_id	int(11)	NO
rad_res_status	varchar(20)	NO		MUL
rad_res_chain_of_custody	varchar(20)	NO
rad_res_testing_reason	varchar(20)	NO
rad_res_invalid_to_negative_override	char(1)	NO
rad_res_mro_to_negative_override	char(1)	NO
rad_res_collected_unix_ts	int(10)	NO
rad_res_comments1	varchar(80)	NO
rad_res_comments2	varchar(80)	NO
rad_res_internal_note	text	NO
rad_res_needs_review	tinyint(1)	NO	0
rad_res_mro_reviewed	char(1)	NO
rad_res_invalid_reviewed	char(1)	NO
rad_res_ordering_facility	text	NO
rad_res_desc	varchar(40)	NO
rad_res_path	text	NO
rad_res_web_account	char(1)	NO		MUL
rad_res_pending	char(1)	NO
rad_res_phr_released	char(1)	NO
rad_res_disabled	char(1)	NO
rad_res_usr_id_created	int(11)	NO	0	MUL		Links to creating user to avoid using audits table
rad_res_usr_id_modified	int(11)	NO	0	MUL		Links to modifying user to avoid using audits table
rad_res_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
rad_res_created	timestamp	YES	CURRENT_TIMESTAMP	MUL
rad_res_rad_id	int(11)	NO

References

Local Column

References

rad_res_id

Table	Column
_1.audits	aud_rad_res_id
_1.audits_archive	aud_rad_res_id
_1.radiology_orders	rad_rad_res_id
_1.radiology_orders_test_codes_map	rtcm_rad_res_id
_1.radiology_results_docs	rrdoc_rad_res_id
_1.radiology_results_notes	rrnot_rad_res_id
_1.radiology_results_signed	rrsig_rad_res_id
_1.radiology_results_test_codes_map	rrtcm_rad_res_id
_1.radiology_results_test_codes_results	rrtcres_rad_res_id
_1188.audits	aud_rad_res_id
_1188.audits_archive	aud_rad_res_id
_1188.radiology_orders	rad_rad_res_id
_1188.radiology_orders_test_codes_map	rtcm_rad_res_id
_1188.radiology_results_docs	rrdoc_rad_res_id
_1188.radiology_results_notes	rrnot_rad_res_id
_1188.radiology_results_signed	rrsig_rad_res_id
_1188.radiology_results_test_codes_map	rrtcm_rad_res_id
_1188.radiology_results_test_codes_results	rrtcres_rad_res_id
_1218.audits	aud_rad_res_id
_1218.audits_archive	aud_rad_res_id
_1218.radiology_orders	rad_rad_res_id
_1218.radiology_orders_test_codes_map	rtcm_rad_res_id
_1218.radiology_results_docs	rrdoc_rad_res_id
_1218.radiology_results_notes	rrnot_rad_res_id
_1218.radiology_results_signed	rrsig_rad_res_id
_1218.radiology_results_test_codes_map	rrtcm_rad_res_id
_1218.radiology_results_test_codes_results	rrtcres_rad_res_id
_1548.audits	aud_rad_res_id
_1548.audits_archive	aud_rad_res_id
_1548.radiology_orders	rad_rad_res_id
_1548.radiology_orders_test_codes_map	rtcm_rad_res_id
_1548.radiology_results_docs	rrdoc_rad_res_id
_1548.radiology_results_notes	rrnot_rad_res_id
_1548.radiology_results_signed	rrsig_rad_res_id
_1548.radiology_results_test_codes_map	rrtcm_rad_res_id
_1548.radiology_results_test_codes_results	rrtcres_rad_res_id
_435.audits	aud_rad_res_id
_435.audits_archive	aud_rad_res_id
_435.radiology_orders	rad_rad_res_id
_435.radiology_orders_test_codes_map	rtcm_rad_res_id
_435.radiology_results_docs	rrdoc_rad_res_id
_435.radiology_results_notes	rrnot_rad_res_id
_435.radiology_results_signed	rrsig_rad_res_id
_435.radiology_results_test_codes_map	rrtcm_rad_res_id
_435.radiology_results_test_codes_results	rrtcres_rad_res_id
_436.audits	aud_rad_res_id
_436.audits_archive	aud_rad_res_id
_436.radiology_orders	rad_rad_res_id
_436.radiology_orders_test_codes_map	rtcm_rad_res_id
_436.radiology_results_docs	rrdoc_rad_res_id
_436.radiology_results_notes	rrnot_rad_res_id
_436.radiology_results_signed	rrsig_rad_res_id
_436.radiology_results_test_codes_map	rrtcm_rad_res_id
_436.radiology_results_test_codes_results	rrtcres_rad_res_id
_436_archive_testing.audits	aud_rad_res_id
_436_archive_testing.audits_archive	aud_rad_res_id
_436_archive_testing.radiology_orders	rad_rad_res_id
_436_archive_testing.radiology_orders_test_codes_map	rtcm_rad_res_id
_436_archive_testing.radiology_results_docs	rrdoc_rad_res_id
_436_archive_testing.radiology_results_notes	rrnot_rad_res_id
_436_archive_testing.radiology_results_signed	rrsig_rad_res_id
_436_archive_testing.radiology_results_test_codes_map	rrtcm_rad_res_id
_436_archive_testing.radiology_results_test_codes_results	rrtcres_rad_res_id
_437.audits	aud_rad_res_id
_437.audits_archive	aud_rad_res_id
_437.radiology_orders	rad_rad_res_id
_437.radiology_orders_test_codes_map	rtcm_rad_res_id
_437.radiology_results_docs	rrdoc_rad_res_id
_437.radiology_results_notes	rrnot_rad_res_id
_437.radiology_results_signed	rrsig_rad_res_id
_437.radiology_results_test_codes_map	rrtcm_rad_res_id
_437.radiology_results_test_codes_results	rrtcres_rad_res_id
_8.audits	aud_rad_res_id
_8.audits_archive	aud_rad_res_id
_8.radiology_orders	rad_rad_res_id
_8.radiology_orders_test_codes_map	rtcm_rad_res_id
_8.radiology_results_docs	rrdoc_rad_res_id
_8.radiology_results_notes	rrnot_rad_res_id
_8.radiology_results_signed	rrsig_rad_res_id
_8.radiology_results_test_codes_map	rrtcm_rad_res_id
_8.radiology_results_test_codes_results	rrtcres_rad_res_id
_81.audits	aud_rad_res_id
_81.audits_archive	aud_rad_res_id
_81.radiology_orders	rad_rad_res_id
_81.radiology_orders_test_codes_map	rtcm_rad_res_id
_81.radiology_results_docs	rrdoc_rad_res_id
_81.radiology_results_notes	rrnot_rad_res_id
_81.radiology_results_signed	rrsig_rad_res_id
_81.radiology_results_test_codes_map	rrtcm_rad_res_id
_81.radiology_results_test_codes_results	rrtcres_rad_res_id
_999.audits	aud_rad_res_id
_999.audits_archive	aud_rad_res_id
_999.radiology_orders	rad_rad_res_id
_999.radiology_orders_test_codes_map	rtcm_rad_res_id
_999.radiology_results_docs	rrdoc_rad_res_id
_999.radiology_results_notes	rrnot_rad_res_id
_999.radiology_results_signed	rrsig_rad_res_id
_999.radiology_results_test_codes_map	rrtcm_rad_res_id
_999.radiology_results_test_codes_results	rrtcres_rad_res_id