Billing Activity Reporting Engine Activity Purge

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.

Table 1. ARE Activity Purge Attributes
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.

Table 2. ARE Activity Purge Criteria Parameters
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.

Table 3. ARE Activity Purge Statistics
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