_999.patients_images

Field	Type	Null	Default	Key	Extra	Comment
pi_id	int(11)	NO		PRI	auto_increment
pi_cus_id	int(11)	NO		MUL
pi_cli_id	int(11)	NO		MUL
pi_pat_id	int(11)	NO		MUL
pi_pic_id	int(11)	NO		MUL
pi_lbl_id	int(11)	NO		MUL
pi_pre_id	int(11)	NO		MUL
pi_ins_id	int(11)	NO		MUL
pi_enc_id	int(11)	NO		MUL
pi_fmt_id	int(11)	NO	0			Indicates a special file type for patient documents
pi_usr_id_attached	int(11)	NO		MUL
pi_usr_attached	datetime	YES	CURRENT_TIMESTAMP
pi_ins_link	text	NO
pi_ins_irep_id	int(11)	NO		MUL
pi_path	text	NO
pi_bucket	varchar(40)	NO	ahi_cloudfiles_encrypt			Which bucket in S3 does the path belong to. If empty string, path is on local hard disk.
pi_size	varchar(120)	NO	0
pi_result_code	varchar(128)	NO				Result code
pi_cs_id	int(11)	YES				Coding system id
pi_result_desc	text	YES				Result description
pi_pat_pid	varchar(20)	NO
pi_verified	char(1)	NO		MUL
pi_incorporated	tinyint(1)	YES	0			Indicates whether this document has been incorporated into the patient record (applies to CCDA files only).
pi_disabled	char(1)	NO	0	MUL
pi_name	text	NO
pi_desc	text	NO
pi_date	date	YES				Used for client dating of patient document
pi_id_ext	int(11)	NO		MUL
pi_modified	datetime	YES	CURRENT_TIMESTAMP
pi_created	datetime	YES	CURRENT_TIMESTAMP
pi_viewed_portal	tinyint(1)	YES	0			Indicates whether the document was viewed in the patient portal

References

Local Column

References

pi_id

Table	Column
_1.audits	aud_pi_id
_1.audits_archive	aud_pi_id
_1.documents_signed	dsig_pi_id
_1.files_validation_errors	fve_pi_id
_1.non_patients_documents	npd_pi_id
_1.pi_user_access_map	pi_access_pi_id
_1188.audits	aud_pi_id
_1188.audits_archive	aud_pi_id
_1188.documents_signed	dsig_pi_id
_1188.non_patients_documents	npd_pi_id
_1188.pi_user_access_map	pi_access_pi_id
_1218.audits	aud_pi_id
_1218.audits_archive	aud_pi_id
_1218.documents_signed	dsig_pi_id
_1218.non_patients_documents	npd_pi_id
_1218.pi_user_access_map	pi_access_pi_id
_1548.audits	aud_pi_id
_1548.audits_archive	aud_pi_id
_1548.documents_signed	dsig_pi_id
_1548.files_validation_errors	fve_pi_id
_1548.non_patients_documents	npd_pi_id
_1548.pi_user_access_map	pi_access_pi_id
_435.audits	aud_pi_id
_435.audits_archive	aud_pi_id
_435.documents_signed	dsig_pi_id
_435.files_validation_errors	fve_pi_id
_435.non_patients_documents	npd_pi_id
_435.pi_user_access_map	pi_access_pi_id
_436.audits	aud_pi_id
_436.audits_archive	aud_pi_id
_436.documents_signed	dsig_pi_id
_436.files_validation_errors	fve_pi_id
_436.non_patients_documents	npd_pi_id
_436.pi_user_access_map	pi_access_pi_id
_436_archive_testing.audits	aud_pi_id
_436_archive_testing.audits_archive	aud_pi_id
_436_archive_testing.documents_signed	dsig_pi_id
_436_archive_testing.files_validation_errors	fve_pi_id
_436_archive_testing.non_patients_documents	npd_pi_id
_436_archive_testing.pi_user_access_map	pi_access_pi_id
_437.audits	aud_pi_id
_437.audits_archive	aud_pi_id
_437.documents_signed	dsig_pi_id
_437.files_validation_errors	fve_pi_id
_437.non_patients_documents	npd_pi_id
_437.pi_user_access_map	pi_access_pi_id
_8.audits	aud_pi_id
_8.audits_archive	aud_pi_id
_8.documents_signed	dsig_pi_id
_8.files_validation_errors	fve_pi_id
_8.non_patients_documents	npd_pi_id
_8.pi_user_access_map	pi_access_pi_id
_81.audits	aud_pi_id
_81.audits_archive	aud_pi_id
_81.documents_signed	dsig_pi_id
_81.non_patients_documents	npd_pi_id
_81.pi_user_access_map	pi_access_pi_id
_999.audits	aud_pi_id
_999.audits_archive	aud_pi_id
_999.documents_signed	dsig_pi_id
_999.files_validation_errors	fve_pi_id
_999.non_patients_documents	npd_pi_id
_999.pi_user_access_map	pi_access_pi_id