# 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..
[](https://wiki.txfannin.org/uploads/images/gallery/2024-09/utility-log-display-form.png)
#### **Sample Output**
The sample output below was produced by leaving the **input field** blank.
**[](https://wiki.txfannin.org/uploads/images/gallery/2024-09/utility-log-display-output.png)**
**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.