Usage Error

Job type: RPG

Archive: None

Selection criteria

Deletes every record where Date Created (AQEJDT) < incoming date parameter and corresponding Usage Error ID = incoming parameter. The parameters are manually entered in CMP Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. Back Office.

The Usage Error ID parameter is optional. If it not populated, the Error ID is ignored in the selection process. The date parameter is entered as a number of days but is converted into a date.

Tables Impacted

Name	Description
CQAQCPP (1)	Usage Error
CQARCPP	Usage Error Detail
CHBKCPP (2)	Usage Error CPP

Notes

1. If the incoming Error ID parameter <> blank, the job deletes matching records from table CQARCPP (Usage Error Detail) first. If no records are left in CQARCPP for this original request/sequence number key, this table can be purged, too. If the incoming Error ID parameter is blank, table is purged immediately.
2. If no records are left in CQARCPP for this original request/sequence number key, this table can be purged too.