This purge removes the YFS_AUDIT table data from the system, which reduces the load on frequently accessed tables. It purges records in the YFS_AUDIT and the YFS_AUDIT_HEADER tables that meet the following conditions:
When the enterprise modifies records in the YFS_ITEM table through the Applications Manager, the YFS_ITEM is audited and the audit records are inserted in the YFS_AUDIT table. In order to clean up the audit records, this purge transaction can be used.
Any enterprise using the Console must schedule purge transactions accordingly.
The following are the attributes for this time-triggered transaction:
Attribute | Value |
---|---|
Base Transaction ID | YFS_ITEM_AUDIT_PURGE |
Base Document Type | General |
Base Process Type | General |
Abstract Transaction | No |
APIs Called | None |
User Exits Called | YFSBeforePurgeUE |
The following are the criteria parameters for this transaction:
Parameter | Description |
---|---|
Action | Required. Triggers the transaction. If left blank, the value defaults to Get, the only valid value. |
Number of Records To Buffer | Optional. Number of records to retrieve and process at one time. If left blank or specified as 0 (zero), this value defaults to 5000. |
Live | Optional. Mode in which to run. Valid values are:
|
PurgeCode | Required. Cannot be modified. Used for internal calculations, such as determining retention days. Corresponds with the PurgeCode used in Business Rules Purge Criteria. |
ColonyID | Required in a multi schema deployment where the YFS_AUDIT and YFS_AUDIT_HEADER tables may exist in multiple schemas. Runs the agent for the colony. |
The following statistics are tracked for this transaction:
Statistic Name | Description |
---|---|
NumItemAuditRecords |
Number of item audit records purged. |
For this transaction, the pending job count is the number of records that can be purged from the YFS_AUDIT table that match the criteria values.
None.
YFS_AUDIT, YFS_AUDIT_HEADER