SMS Session ID

Job type: RPG

Archive: None

Selection criteria

Deletes every record where Date Created (ANEJDT) <= incoming date parameter and it is an orphan An orphan record means that there is no parent in COEEREP, COK7CPP or billed/archived COEEREP, using Original Request Number (ANN2NB) and Original Request Sequence (ANN3NB) as the key. record .

The incoming parameter is manually entered in CMP Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. Back Office as a number of days, which is converted into a date.

Tables Impacted

Name	Description
TWANCPP	9SMS Session ID Dup Check