SPCM subscriber profile CDR

The SPCM generates a subscriber profile CDR when subscriber profiles are created or updated. The CDR contains a fixed part and a variable part.

Fixed part

The fixed part contains information about the subscriber and a plan if relevant.

Variable part

The variable part contains usage information parent plan and plan precedence. As a plan may have multiple counters, the variable part produce in each CDR provides details of the current status of each counter at the time the CDR was produced.

The variable part of the CDR has a terminating element of 0;0;0;0. Each field in the variable part is prepended with a & and are separated by a ;.
Table 1. fixed part
Field Name Description

1

subscriber ID

The subscriber’s MSISDN in international format.

2

service ID

The Tango CDR Service ID. This is 40 for subscriber profile CDRs.

3

transaction type

The CDR transaction type. This is 0 on a subscriber profile creation and 1 for a subscriber profile update.

4

Tenant Id

Alphanumeric string that displays the ID of the network operator for which the CDR was produced.

5

update cause

The cause of the update.

For a complete list of update causes, see Subscriber profile update causes.

6

CDR generation date

The date the CDR was generated. Format: DD/MM/YY.

7

CDR generation time

The time the CDR was generated. Format: hh:mm:ss.

8

plan name

The name of the plan that trigged the subscriber profile update.

This field is empty if not applicable (profile creation).

9

plan precedence

The precedence of the plan that triggered the subscriber profile update.

If not applicable, you see -1 (profile creation).

10

rule name

The rule name if the update was caused by a rule violation.

This field is empty if the update was not caused by a rule violation.

11

IMSI

The subscriber’s IMSI.
Table 2. variable part
Field Name Description

12

parent plan name

The name of the parent plan of the PCC profile.

13

parent plan precedence

The precedence value for the parent plan of the PCC profile.

14

parent plan ID

The plan ID for the parent plan of the PCC profile.

15

pcc profile name

The name of the PCC profile.

16

pcc profile precedence

The precedence value for the PCC profile.

Subscriber profile update causes

These are the update causes for the SPCM subscriber profile CDR.

Cause Description

-1

not applicable

0

plan activation

1

plan deactivation

2

dynamic profile enabled (plan usage rule violation)

3

plan expiry

4

usage consumed

10

usage available

11

plan terminated

12

dynamic profile disabled (plan usage rule activation)

13

plan activation pending

14

booster applied (validity or volume booster)

Sample

00041000060200000001010001,40,0,tenantb,-1,28/07/2020,14:47:57,,-1,,0001101&TEST_PayPerUse_Postpaid;-1;29624;;&TEST_1MB_1DAY_FUP;2;29625;;&0;0;0;0