Transaction Log Display - New

Purpose

This module displays records from the Database transaction table. Occasionally, it might be necessary to determine when a memorials record was last updated and/or by which user. The transaction table is a log of all memorial transactions. Included in the record is the actual mySQL test string submitted. Thus, if needed, a record that might have been accidentally deleted can be recovered.

Utility Form

To create a report use one of the two options:

1. Enter a single Grayson Id to display all of the transaction table for the indicated Id.
2. Leave the field blank to display all transaction table records for the past 30 days..

Sample Output

The sample output below was produced by leaving the input field blank.

Information displayed includes…

1. Ind Name - Name of the individual associated with the memorials record.
2. Grayson Id - Id number of the record.
3. Type - The type of update preformed (Add, Edt, Del) on the particular record.
4. User Name - Name of the user who made the transaction.
5. Timestamp - The computer generated date-time that the transaction was made.