_437.audits_new

Field	Type	Null	Default	Key	Extra	Comment
aud_id	int(11)	NO		PRI	auto_increment
aud_cus_id	int(11)	NO	0	MUL		Customer ID
aud_cli_id	int(11)	NO	0	MUL		Client ID
aud_usr_id	int(11)	NO	0	MUL		Logged in user
aud_spoofing_usr_id	int(11)	NO	0	MUL		Acting user if spoofing
aud_action	int(11)	NO	0	MUL		Audit Action ID
aud_pat_id	int(11)	NO	0	MUL		Patient ID
aud_enc_id	int(11)	NO	0	MUL		Encounter ID
aud_area	tinyint(4)	NO	0			Area?
aud_note	varchar(256)	NO				Audit note
aud_data_sha1	varchar(128)	NO				SHA hash of audits_data
aud_audit_sha1	varchar(128)	NO				SHA hash of audits data
aud_components_sha1	varchar(128)	NO				SHA hash of components data
aud_audit_sha_algo	varchar(10)	NO	sha1			Algorithm used for hashes
aud_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
aud_created	timestamp	YES	CURRENT_TIMESTAMP	MUL

References

Local Column

References

aud_id

Table	Column
Azalea.audit_map	am_aud_id
_1.audits_applications	audapp_aud_id
_1.audits_archive_components	audcomp_aud_id
_1.audits_components	audcomp_aud_id
_1.audits_data	ada_aud_id
_1.audits_new_data	ada_aud_id
_1188.audits_applications	audapp_aud_id
_1188.audits_archive_components	audcomp_aud_id
_1188.audits_components	audcomp_aud_id
_1188.audits_data	ada_aud_id
_1188.audits_new_data	ada_aud_id
_1218.audits_applications	audapp_aud_id
_1218.audits_archive_components	audcomp_aud_id
_1218.audits_components	audcomp_aud_id
_1218.audits_data	ada_aud_id
_1218.audits_new_data	ada_aud_id
_1548.audits_applications	audapp_aud_id
_1548.audits_archive_components	audcomp_aud_id
_1548.audits_components	audcomp_aud_id
_1548.audits_data	ada_aud_id
_1548.audits_new_data	ada_aud_id
_435.audits_applications	audapp_aud_id
_435.audits_archive_components	audcomp_aud_id
_435.audits_components	audcomp_aud_id
_435.audits_components_2008	audcomp_aud_id
_435.audits_components_2009	audcomp_aud_id
_435.audits_components_2010	audcomp_aud_id
_435.audits_components_2011	audcomp_aud_id
_435.audits_components_2012	audcomp_aud_id
_435.audits_components_2013	audcomp_aud_id
_435.audits_components_2014	audcomp_aud_id
_435.audits_components_2015	audcomp_aud_id
_435.audits_components_2016	audcomp_aud_id
_435.audits_components_2017	audcomp_aud_id
_435.audits_components_2018	audcomp_aud_id
_435.audits_components_2019	audcomp_aud_id
_435.audits_components_2020	audcomp_aud_id
_435.audits_data	ada_aud_id
_435.audits_data_2008	ada_aud_id
_435.audits_data_2009	ada_aud_id
_435.audits_data_2010	ada_aud_id
_435.audits_data_2011	ada_aud_id
_435.audits_data_2012	ada_aud_id
_435.audits_data_2013	ada_aud_id
_435.audits_data_2014	ada_aud_id
_435.audits_data_2015	ada_aud_id
_435.audits_data_2016	ada_aud_id
_435.audits_data_2017	ada_aud_id
_435.audits_data_2018	ada_aud_id
_435.audits_data_2019	ada_aud_id
_435.audits_data_2020	ada_aud_id
_435.audits_new_data	ada_aud_id
_436.audits_applications	audapp_aud_id
_436.audits_archive_components	audcomp_aud_id
_436.audits_components	audcomp_aud_id
_436.audits_data	ada_aud_id
_436.audits_new_data	ada_aud_id
_436_archive_testing.audits_applications	audapp_aud_id
_436_archive_testing.audits_archive_components	audcomp_aud_id
_436_archive_testing.audits_components	audcomp_aud_id
_436_archive_testing.audits_components_2008	audcomp_aud_id
_436_archive_testing.audits_components_2009	audcomp_aud_id
_436_archive_testing.audits_components_2010	audcomp_aud_id
_436_archive_testing.audits_components_2011	audcomp_aud_id
_436_archive_testing.audits_components_2012	audcomp_aud_id
_436_archive_testing.audits_components_2013	audcomp_aud_id
_436_archive_testing.audits_components_2014	audcomp_aud_id
_436_archive_testing.audits_components_2015	audcomp_aud_id
_436_archive_testing.audits_components_2016	audcomp_aud_id
_436_archive_testing.audits_components_2017	audcomp_aud_id
_436_archive_testing.audits_components_2018	audcomp_aud_id
_436_archive_testing.audits_components_2019	audcomp_aud_id
_436_archive_testing.audits_components_2020	audcomp_aud_id
_436_archive_testing.audits_components_2021	audcomp_aud_id
_436_archive_testing.audits_data	ada_aud_id
_436_archive_testing.audits_data_2008	ada_aud_id
_436_archive_testing.audits_data_2009	ada_aud_id
_436_archive_testing.audits_data_2010	ada_aud_id
_436_archive_testing.audits_data_2011	ada_aud_id
_436_archive_testing.audits_data_2012	ada_aud_id
_436_archive_testing.audits_data_2013	ada_aud_id
_436_archive_testing.audits_data_2014	ada_aud_id
_436_archive_testing.audits_data_2015	ada_aud_id
_436_archive_testing.audits_data_2016	ada_aud_id
_436_archive_testing.audits_data_2017	ada_aud_id
_436_archive_testing.audits_data_2018	ada_aud_id
_436_archive_testing.audits_data_2019	ada_aud_id
_436_archive_testing.audits_data_2020	ada_aud_id
_436_archive_testing.audits_data_2021	ada_aud_id
_436_archive_testing.audits_new_data	ada_aud_id
_437.audits_applications	audapp_aud_id
_437.audits_archive_components	audcomp_aud_id
_437.audits_components	audcomp_aud_id
_437.audits_data	ada_aud_id
_437.audits_new_data	ada_aud_id
_8.audits_applications	audapp_aud_id
_8.audits_archive_components	audcomp_aud_id
_8.audits_components	audcomp_aud_id
_8.audits_components_2020	audcomp_aud_id
_8.audits_data	ada_aud_id
_8.audits_data_2020	ada_aud_id
_8.audits_new_data	ada_aud_id
_81.audits_applications	audapp_aud_id
_81.audits_archive_components	audcomp_aud_id
_81.audits_components	audcomp_aud_id
_81.audits_data	ada_aud_id
_81.audits_new_data	ada_aud_id
_999.audits_applications	audapp_aud_id
_999.audits_archive_components	audcomp_aud_id
_999.audits_components	audcomp_aud_id
_999.audits_data	ada_aud_id
_999.audits_new_data	ada_aud_id