_436_archive_testing.hl7_accessions

Field	Type	Null	Default	Key	Extra	Comment
acc_id	int(11)	NO		PRI	auto_increment
acc_cus_id	int(11)	NO	0	MUL
acc_cli_id	int(11)	NO	0	MUL
acc_pat_id	int(11)	NO		MUL
acc_lab_id	int(11)	NO	0	MUL
acc_lif_id	int(11)	NO	0	MUL
acc_don_id	int(11)	NO	0	MUL
acc_invper_id	int(11)	NO	0	MUL
acc_invnum_id	int(11)	NO	0	MUL
acc_master_cli_account_num	varchar(20)	NO		MUL
acc_cli_account_num	varchar(20)	NO		MUL
acc_secondary_index	varchar(20)	NO		MUL
acc_pid	varchar(20)	NO		MUL
acc_mrn	varchar(20)	NO		MUL
acc_ssn	varchar(20)	NO		MUL
acc_fname	varchar(40)	NO		MUL		First Name
acc_mname	varchar(40)	NO				Middle Name
acc_lname	varchar(40)	NO		MUL		Last Name
ord_suffix	varchar(10)	NO				Patient name suffix
acc_sex	varchar(7)	NO
acc_dob	varchar(20)	NO
acc_age	varchar(10)	NO
acc_room_num	varchar(10)	NO
acc_location	varchar(10)	NO		MUL
acc_fasting	varchar(10)	NO
acc_accession_num	varchar(128)	NO		MUL
acc_phone	varchar(20)	NO
acc_critical	varchar(2)	NO	0
acc_collected_timestamp	varchar(12)	NO		MUL
acc_received_timestamp	varchar(12)	NO		MUL
acc_reported_timestamp	varchar(12)	NO		MUL
acc_imported_timestamp	varchar(12)	NO		MUL		Datetime result was imported into azalea. Stored in client's timezone
acc_req_num	varchar(128)	NO
acc_ord_id	int(11)	NO	0	MUL		Points to the orders row ID
acc_physician	varchar(30)	NO
acc_ordering_phy_id	int(11)	YES		MUL
acc_supervising_phy_id	int(11)	NO		MUL
acc_status	char(1)	NO		MUL
acc_chain_of_custody	varchar(20)	NO
acc_testing_reason	varchar(20)	NO
acc_invalid_to_negative_override	char(1)	NO
acc_mro_to_negative_override	char(1)	NO
acc_collected_unix_ts	int(10)	NO
acc_comments1	varchar(80)	NO
acc_comments2	varchar(80)	NO
acc_internal_note	text	NO
acc_needs_review	tinyint(1)	NO	0
acc_mro_reviewed	char(1)	NO
acc_invalid_reviewed	char(1)	NO
acc_ordering_facility	text	NO
acc_desc	varchar(40)	NO
acc_path	text	NO
acc_web_account	char(1)	NO	0	MUL
acc_pending	char(1)	NO
acc_phr_released	char(1)	NO
acc_disabled	int(11)	NO
acc_rac_id	varchar(11)	NO
acc_rac_hl7	varchar(11)	NO
acc_namespace_id	varchar(20)	NO
acc_type_code	varchar(11)	NO
acc_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
acc_created	timestamp	YES	CURRENT_TIMESTAMP	MUL

References

Local Column

References

acc_id

Table	Column
EFaxes.efaxes	efax_acc_id
_1.audits	aud_acc_id
_1.audits_archive	aud_acc_id
_1.documents	doc_sfax_acc_id
_1.hl7_accessions_docs	had_acc_id
_1.hl7_accessions_statuses	accstat_acc_id
_1.hl7_lab_locations	hll_acc_id
_1.hl7_notes	not_acc_id
_1.hl7_orders	ord_acc_id
_1.hl7_results	res_acc_id
_1.lab_results_signed	lrsig_acc_id
_1.orders	ord_acc_id
_1188.audits	aud_acc_id
_1188.audits_archive	aud_acc_id
_1188.documents	doc_sfax_acc_id
_1188.hl7_accessions_docs	had_acc_id
_1188.hl7_accessions_statuses	accstat_acc_id
_1188.hl7_lab_locations	hll_acc_id
_1188.hl7_notes	not_acc_id
_1188.hl7_orders	ord_acc_id
_1188.hl7_results	res_acc_id
_1188.lab_results_signed	lrsig_acc_id
_1188.orders	ord_acc_id
_1218.audits	aud_acc_id
_1218.audits_archive	aud_acc_id
_1218.documents	doc_sfax_acc_id
_1218.hl7_accessions_docs	had_acc_id
_1218.hl7_accessions_statuses	accstat_acc_id
_1218.hl7_lab_locations	hll_acc_id
_1218.hl7_notes	not_acc_id
_1218.hl7_orders	ord_acc_id
_1218.hl7_results	res_acc_id
_1218.lab_results_signed	lrsig_acc_id
_1218.orders	ord_acc_id
_1548.audits	aud_acc_id
_1548.audits_archive	aud_acc_id
_1548.documents	doc_sfax_acc_id
_1548.hl7_accessions_docs	had_acc_id
_1548.hl7_accessions_statuses	accstat_acc_id
_1548.hl7_lab_locations	hll_acc_id
_1548.hl7_notes	not_acc_id
_1548.hl7_orders	ord_acc_id
_1548.hl7_results	res_acc_id
_1548.lab_results_signed	lrsig_acc_id
_1548.orders	ord_acc_id
_435.audits	aud_acc_id
_435.audits_archive	aud_acc_id
_435.documents	doc_sfax_acc_id
_435.hl7_accessions_docs	had_acc_id
_435.hl7_accessions_statuses	accstat_acc_id
_435.hl7_lab_locations	hll_acc_id
_435.hl7_notes	not_acc_id
_435.hl7_orders	ord_acc_id
_435.hl7_results	res_acc_id
_435.lab_results_signed	lrsig_acc_id
_435.orders	ord_acc_id
_436.audits	aud_acc_id
_436.audits_archive	aud_acc_id
_436.documents	doc_sfax_acc_id
_436.hl7_accessions_docs	had_acc_id
_436.hl7_accessions_statuses	accstat_acc_id
_436.hl7_lab_locations	hll_acc_id
_436.hl7_notes	not_acc_id
_436.hl7_orders	ord_acc_id
_436.hl7_results	res_acc_id
_436.lab_results_signed	lrsig_acc_id
_436.orders	ord_acc_id
_436_archive_testing.audits	aud_acc_id
_436_archive_testing.audits_archive	aud_acc_id
_436_archive_testing.documents	doc_sfax_acc_id
_436_archive_testing.hl7_accessions_docs	had_acc_id
_436_archive_testing.hl7_accessions_statuses	accstat_acc_id
_436_archive_testing.hl7_lab_locations	hll_acc_id
_436_archive_testing.hl7_notes	not_acc_id
_436_archive_testing.hl7_orders	ord_acc_id
_436_archive_testing.hl7_results	res_acc_id
_436_archive_testing.lab_results_signed	lrsig_acc_id
_436_archive_testing.orders	ord_acc_id
_437.audits	aud_acc_id
_437.audits_archive	aud_acc_id
_437.documents	doc_sfax_acc_id
_437.hl7_accessions_docs	had_acc_id
_437.hl7_accessions_statuses	accstat_acc_id
_437.hl7_lab_locations	hll_acc_id
_437.hl7_notes	not_acc_id
_437.hl7_orders	ord_acc_id
_437.hl7_results	res_acc_id
_437.lab_results_signed	lrsig_acc_id
_437.orders	ord_acc_id
_8.audits	aud_acc_id
_8.audits_archive	aud_acc_id
_8.documents	doc_sfax_acc_id
_8.hl7_accessions_docs	had_acc_id
_8.hl7_accessions_statuses	accstat_acc_id
_8.hl7_lab_locations	hll_acc_id
_8.hl7_notes	not_acc_id
_8.hl7_orders	ord_acc_id
_8.hl7_results	res_acc_id
_8.lab_results_signed	lrsig_acc_id
_8.orders	ord_acc_id
_81.audits	aud_acc_id
_81.audits_archive	aud_acc_id
_81.documents	doc_sfax_acc_id
_81.hl7_accessions_docs	had_acc_id
_81.hl7_accessions_statuses	accstat_acc_id
_81.hl7_lab_locations	hll_acc_id
_81.hl7_notes	not_acc_id
_81.hl7_orders	ord_acc_id
_81.hl7_results	res_acc_id
_81.lab_results_signed	lrsig_acc_id
_81.orders	ord_acc_id
_999.audits	aud_acc_id
_999.audits_archive	aud_acc_id
_999.documents	doc_sfax_acc_id
_999.hl7_accessions_docs	had_acc_id
_999.hl7_accessions_statuses	accstat_acc_id
_999.hl7_lab_locations	hll_acc_id
_999.hl7_notes	not_acc_id
_999.hl7_orders	ord_acc_id
_999.hl7_results	res_acc_id
_999.lab_results_signed	lrsig_acc_id
_999.orders	ord_acc_id
common.ahi_audits	aud_acc_id
common.faxes	fax_acc_id
common.sfax_accounts	sfax_acc_id
common.sfax_accounts_map	sfam_sfax_acc_id
common.sfaxes	sfax_acc_id
common.users	usr_sfax_acc_id

acc_phone

Table	Column
common.sfax_accounts	sfax_acc_phone

acc_modified

Table	Column
common.sfax_accounts	sfax_acc_modified

acc_created

Table	Column
common.sfax_accounts	sfax_acc_created