_1218.documents

Field	Type	Null	Default	Key	Extra	Comment
doc_id	int(11)	NO		PRI	auto_increment
doc_cus_id	int(11)	NO
doc_cli_id	int(11)	NO
doc_pic_id	int(11)	NO		MUL
doc_pat_id	int(11)	NO		MUL
doc_comp_id	int(11)	NO
doc_dct_id	int(11)	NO
doc_dc_id	int(11)	NO		MUL
doc_sfax_acc_id	int(11)	YES
doc_dfol_id	int(11)	NO		MUL
doc_fmt_id	int(11)	NO
doc_lbl_id	int(11)	NO		MUL
doc_name	text	NO
doc_desc	text	NO
doc_link	varchar(120)	NO
doc_path	text	NO
dc_size	varchar(120)	NO	0
doc_result_code	varchar(128)	NO				Result code
doc_cs_id	int(11)	YES				Coding system id
doc_result_desc	text	YES				Result description
doc_verified	char(1)	NO
doc_disabled	char(1)	NO
doc_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
doc_created	timestamp	YES	CURRENT_TIMESTAMP
doc_need_sig	char(1)	NO
doc_date	date	YES				Used for client dating of document

References

Local Column

References

doc_id

Table	Column
_1.audits	aud_doc_id
_1.audits_archive	aud_doc_id
_1.documents_signed	dsig_doc_id
_1.encounters_payments_documents_map	epdm_doc_id
_1.encounters_soap_images	espi_doc_id
_1.encounters_soap_images_templates	espit_doc_id
_1.files_validation_errors	fve_doc_id
_1.non_patients_documents	npd_doc_id
_1.orders_test_codes_documents_map	otcdm_doc_id
_1.pi_user_access_map	pi_access_doc_id
_1.radiology_orders_test_codes_documents_map	rtcdm_doc_id
_1.radiology_results_test_codes_documents_map	rrtcdm_doc_id
_1188.audits	aud_doc_id
_1188.audits_archive	aud_doc_id
_1188.documents_signed	dsig_doc_id
_1188.encounters_payments_documents_map	epdm_doc_id
_1188.encounters_soap_images	espi_doc_id
_1188.encounters_soap_images_templates	espit_doc_id
_1188.non_patients_documents	npd_doc_id
_1188.orders_test_codes_documents_map	otcdm_doc_id
_1188.pi_user_access_map	pi_access_doc_id
_1188.radiology_orders_test_codes_documents_map	rtcdm_doc_id
_1188.radiology_results_test_codes_documents_map	rrtcdm_doc_id
_1218.audits	aud_doc_id
_1218.audits_archive	aud_doc_id
_1218.documents_signed	dsig_doc_id
_1218.encounters_payments_documents_map	epdm_doc_id
_1218.encounters_soap_images	espi_doc_id
_1218.encounters_soap_images_templates	espit_doc_id
_1218.non_patients_documents	npd_doc_id
_1218.orders_test_codes_documents_map	otcdm_doc_id
_1218.pi_user_access_map	pi_access_doc_id
_1218.radiology_orders_test_codes_documents_map	rtcdm_doc_id
_1218.radiology_results_test_codes_documents_map	rrtcdm_doc_id
_1548.audits	aud_doc_id
_1548.audits_archive	aud_doc_id
_1548.documents_signed	dsig_doc_id
_1548.encounters_payments_documents_map	epdm_doc_id
_1548.encounters_soap_images	espi_doc_id
_1548.encounters_soap_images_templates	espit_doc_id
_1548.files_validation_errors	fve_doc_id
_1548.non_patients_documents	npd_doc_id
_1548.orders_test_codes_documents_map	otcdm_doc_id
_1548.pi_user_access_map	pi_access_doc_id
_1548.radiology_orders_test_codes_documents_map	rtcdm_doc_id
_1548.radiology_results_test_codes_documents_map	rrtcdm_doc_id
_435.audits	aud_doc_id
_435.audits_archive	aud_doc_id
_435.documents_signed	dsig_doc_id
_435.encounters_payments_documents_map	epdm_doc_id
_435.encounters_soap_images	espi_doc_id
_435.encounters_soap_images_templates	espit_doc_id
_435.files_validation_errors	fve_doc_id
_435.non_patients_documents	npd_doc_id
_435.orders_test_codes_documents_map	otcdm_doc_id
_435.pi_user_access_map	pi_access_doc_id
_435.radiology_orders_test_codes_documents_map	rtcdm_doc_id
_435.radiology_results_test_codes_documents_map	rrtcdm_doc_id
_436.audits	aud_doc_id
_436.audits_archive	aud_doc_id
_436.documents_signed	dsig_doc_id
_436.encounters_payments_documents_map	epdm_doc_id
_436.encounters_soap_images	espi_doc_id
_436.encounters_soap_images_templates	espit_doc_id
_436.files_validation_errors	fve_doc_id
_436.non_patients_documents	npd_doc_id
_436.orders_test_codes_documents_map	otcdm_doc_id
_436.pi_user_access_map	pi_access_doc_id
_436.radiology_orders_test_codes_documents_map	rtcdm_doc_id
_436.radiology_results_test_codes_documents_map	rrtcdm_doc_id
_436_archive_testing.audits	aud_doc_id
_436_archive_testing.audits_archive	aud_doc_id
_436_archive_testing.documents_signed	dsig_doc_id
_436_archive_testing.encounters_payments_documents_map	epdm_doc_id
_436_archive_testing.encounters_soap_images	espi_doc_id
_436_archive_testing.encounters_soap_images_templates	espit_doc_id
_436_archive_testing.files_validation_errors	fve_doc_id
_436_archive_testing.non_patients_documents	npd_doc_id
_436_archive_testing.orders_test_codes_documents_map	otcdm_doc_id
_436_archive_testing.pi_user_access_map	pi_access_doc_id
_436_archive_testing.radiology_orders_test_codes_documents_map	rtcdm_doc_id
_436_archive_testing.radiology_results_test_codes_documents_map	rrtcdm_doc_id
_437.audits	aud_doc_id
_437.audits_archive	aud_doc_id
_437.documents_signed	dsig_doc_id
_437.encounters_payments_documents_map	epdm_doc_id
_437.encounters_soap_images	espi_doc_id
_437.encounters_soap_images_templates	espit_doc_id
_437.files_validation_errors	fve_doc_id
_437.non_patients_documents	npd_doc_id
_437.orders_test_codes_documents_map	otcdm_doc_id
_437.pi_user_access_map	pi_access_doc_id
_437.radiology_orders_test_codes_documents_map	rtcdm_doc_id
_437.radiology_results_test_codes_documents_map	rrtcdm_doc_id
_8.audits	aud_doc_id
_8.audits_archive	aud_doc_id
_8.documents_signed	dsig_doc_id
_8.encounters_payments_documents_map	epdm_doc_id
_8.encounters_soap_images	espi_doc_id
_8.encounters_soap_images_templates	espit_doc_id
_8.files_validation_errors	fve_doc_id
_8.non_patients_documents	npd_doc_id
_8.orders_test_codes_documents_map	otcdm_doc_id
_8.pi_user_access_map	pi_access_doc_id
_8.radiology_orders_test_codes_documents_map	rtcdm_doc_id
_8.radiology_results_test_codes_documents_map	rrtcdm_doc_id
_81.audits	aud_doc_id
_81.audits_archive	aud_doc_id
_81.documents_signed	dsig_doc_id
_81.encounters_payments_documents_map	epdm_doc_id
_81.encounters_soap_images	espi_doc_id
_81.encounters_soap_images_templates	espit_doc_id
_81.non_patients_documents	npd_doc_id
_81.orders_test_codes_documents_map	otcdm_doc_id
_81.pi_user_access_map	pi_access_doc_id
_81.radiology_orders_test_codes_documents_map	rtcdm_doc_id
_81.radiology_results_test_codes_documents_map	rrtcdm_doc_id
_999.audits	aud_doc_id
_999.audits_archive	aud_doc_id
_999.documents_signed	dsig_doc_id
_999.encounters_payments_documents_map	epdm_doc_id
_999.encounters_soap_images	espi_doc_id
_999.encounters_soap_images_templates	espit_doc_id
_999.files_validation_errors	fve_doc_id
_999.non_patients_documents	npd_doc_id
_999.orders_test_codes_documents_map	otcdm_doc_id
_999.pi_user_access_map	pi_access_doc_id
_999.radiology_orders_test_codes_documents_map	rtcdm_doc_id
_999.radiology_results_test_codes_documents_map	rrtcdm_doc_id
common.ahi_audits	aud_doc_id
common.sfaxes	sfax_doc_id
template_library.encounters_soap_images_templates	espit_doc_id

doc_path

Table	Column
_1.patients_document_assembly	pda_doc_path
_1188.patients_document_assembly	pda_doc_path
_1218.patients_document_assembly	pda_doc_path
_1548.patients_document_assembly	pda_doc_path
_435.patients_document_assembly	pda_doc_path
_436.patients_document_assembly	pda_doc_path
_436_archive_testing.patients_document_assembly	pda_doc_path
_437.patients_document_assembly	pda_doc_path
_8.patients_document_assembly	pda_doc_path
_81.patients_document_assembly	pda_doc_path
_999.patients_document_assembly	pda_doc_path

doc_name

Table	Column
common.vis	vis_doc_name