Description
Report provides the flexible possibility on displaying various customizable audits. Any view/table existing in the dabase with prefix udfAuditLog can be transformed into the user-friendly format.
Dialog
Audit Dataset - the list of system objects in the database prefixed 'udfAuditLog' to process its data only
Users - to limit modifications made by the selected users only
Date From / To - to limit the period of audits selection
Sample
Fields/ Columns Specification
User ID - internal application identifier for the user
Login Name - user's application login
User Name - name as defined in ACC
Session ID - unique identifier for user's login-session
Session From / To - time stamps for the session start/end
Change Time - time of modification at the server side
Table Name - database table name
PIN - unique identifier of a crew member who was the subject for modification
SEQNO - unique identifier of the modified record in the table
Field Changed - database name of a field that was the subject of modification
Original / New Value - field value before / after modification