NSA Comments

Job type: RPG

Archive: None

Selection criteria

For non-Cellnet networks, this routine deletes every command that belongs to an NSA Batch record where Date Created (AYEJDT) <= incoming date parameter and NetworkClosed In the context of CMP, the infrastructure on which usage of registered customers will be measured – this could be a mobile phone network, broadband network or other non-telecommunications network. Code (AYA7CD) = incoming parameter. The parameters are manually entered in CMPClosed Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. Back Office.

Associated tables are purged using NSA Batch Number (AYOPB9) as the key.

For all other networks, Cellnet Transmission records and associated tables are deleted instead (and associated tables).

Tables Impacted

Name

Description

SFBAREP (1)

NSA Transmission

SFBBREP (2)

NSA Response

SAQZREP (3)

Cellnet Transmission

SES3REP (4)

Cellnet View Responses

TIDAREP (5)

Cellnet View Response Msg

Notes

  1. This is a later version of the table that holds commands that were sent to a network. Records are purged only if the derived network operator ID (obtained from the Network ID table) <> ‘C’ (Cellnet) and NSA Origin (BAKQS9) = incoming parameter.
  2. Uses Action Item Number (BADFNB) from table SFBAREP (NSA Transmission) as the key.
  3. This is the original version of the table that holds commands that were sent to a network. Records are purged only if the Date Created (QZEJDT) <= incoming date parameter and CT Origin = incoming parameter.
  4. Records are purged if CT Service Type (QZBEC9) = ‘V’ (view) and Std Command Name (QZCTCD) = blank. Uses Action Item Number (QZDFNB) and CT SP Job Number (QZB1B9) from table SAQZREP (Cellnet Transmission) as the key.
  5. Records are purged if CT Service Type (QZBEC9) = ‘V’ (view) and Std Command Name (QZCTCD) <> blank. Uses Action Item Number (QZDFNB) from table SAQZREP (Cellnet Transmission) as the key.