Written-Off Calls

Job type: RPG

Archive: Optional

Selection criteria

Deletes every written-off usageClosed The consumption of services, for example a subscriber using call minutes. record where Call Status (EEGTST) = ‘1’ (written-off) and Call Date (EEBEDT) <= incoming date parameter. The incoming parameter is manually entered in CMPClosed Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. Back Office.

The subsequent tables use Original Request Number (EEN2NB) and Original Request Sequence (EEN3NB) as the identifying keys to purge associated records.

Records in table CTBQCPP (Usage Extension) are only purged if there is an active record in table C2B7REP (DISE Application Parm Ext) where B7CNCD = ‘CORE’ and B7OVCD = ‘OFCOMNGCS’ or ‘FUPSURCHG’.

 

Tables Impacted

Name

Description

COEEREP

Call Detail

CQAPCPP

Usage Attribute

CQAICPP

Usage Attribute Unique

C4BGCPP

Usage Cap Detail

CTBQCPP

Usage Extension