menu_banner.gif Main Index  PREV  NEXT

MNU_0115L - Display Audit Log details

mnu_0115l.gif

This is part of the Audit Logging suite described in Appendix L: Audit Logging.

This will enable the User to view the Audit Log entries which satisfy the selection citeria entered on the parent form MNU_0115S.

This form uses a database view which combines the two entities AUDIT_HDR (transactions) and AUDIT_DTL (occurrences) into a single unit. This enables the selection criteria to span both of those entities without causing a problem.

There are two scroll bars on this screen which deal with the following:-


Session Id Unique identifier for the session.
User ID Identifies the User.
Tran Seq Transaction Sequence Number - starts at 1 for each session, and is incremented for each transaction.
Transaction Date
Transaction Time
The date and time at which this transaction began.
Form Name The component name from where the User initiated the transaction.
Library Name The name of the Application Library used by Form Name.
Ent Seq No Entity Sequence Number - starts at 1 for each transaction, and is incremented for each entity occurrence that is updated.
Entity Name The name of the entity (database table) that was updated.
Application Model The name of the Application Model to which Entity Name belongs.
Primary Key The unique identity for this occurrence. This is an associative list showing both the items names and their values.
Item Name Identifies which item (field) was updated. If a field label has been defined in the application message file with the id 'L_<fieldname>' then this will be used instead of the actual field name.
Old Value The value before it was updated.
New Value The value after it was updated.

BUTTONS

Close Exit this transaction.

copyright.gif http://www.tonymarston.net