Email audit records
IBM PEM records information about all outgoing mail in the
VCH_MAIL_AUDIT table.
The VCH_MAIL_AUDIT database table contains information about every email. There is an audit record for each IBM PEM email that is sent out. Comments for email notifications are recorded for recent comments only.
The following information is included in each audit record:
| VCH_MAIL_AUDIT fields | Description |
|---|---|
| CREATE_TS | The audit record creation time stamp. |
| CREATED_BY | The user key responsible for generating the email. |
| SPONSOR_KEY | The sponsor key indicates the sponsor organization from which the email was generated. |
| SENDER | The email address of the sender. |
| RECIPIENTS | The email IDs of the recipients. |
| SUBJECT | The subject of the email. |
| CONTENT | The email content. |
| MODIFYTS | The audit record creation time stamp. It contains the same value that is stored in CREATE_TS. |
| MODIFYBY | The user key responsible for generating the email. It contains the same value that is stored in CREATED_BY. |