This purge removes the Billing Activity Reporting Engine transaction data from the system. This reduces the load from frequently accessed tables. To be purged, the Billing Activity Reporting Engine activity should be marked as UPLOADED or CANCELED.
Attributes
The following table illustrates the attributes for the ARE Activity Purge time-triggered transaction.
Common Code Type | Description |
---|---|
Base Transaction ID | PURGE_ARE |
Base Document Type | General |
Base Process Type | General |
Abstract Transaction | No |
APIs Called | None |
User Exits Called | None |
Criteria Parameters
The following table illustrates the criteria parameters for the ARE Activity Purge transaction.
Criteria Parameters | Description |
---|---|
Live | Optional Mode in which to run.
Valid values are: Y - Default value. Moves qualifying records from the regular tables listed under Tables Purged to the corresponding history tables. N - Test mode. Determines the rows that are moved to history tables without actually moving them. |
Purge Code | Required.
Purge Code is set to PURGE_ARE. Used for internal calculations, such as determining retention days. Corresponds with the PurgeCode used in the Business Rules Purge Criteria. |
Statistics Tracked
The following table illustrates the statistics tracked for the ARE Activity Purge transaction.
Statistics Name | Description |
---|---|
NumAREActivityPurged | Number of ARE Activity records purged. |
Pending Job Count
For the ARE Activity Purge transaction, the pending job count is the number of records that can be purged from the YNW_ARE_ACTIVITY_HEADER table.
Events Raised
None.
Tables Purged
YNW_ARE_ACTIVITY_HEADER
YNW_ARE_ACTIVITY_DETAIL
YNW_ARE_ACTIVITY_AUDIT