SPCM subscriber plan CDR

The SPCM for the Subscription Manager generates subscriber plan CDRs for events relating to subscriber plans such as plan purchases, plan activation or de-activation, and plan expiry.

Field Name Description

1

Subscriber ID

The MSISDN of the subscriber in Tango format.

2

Service ID

The Tango CDR Service ID. This is 39 for subscriber plan CDRs.

3

Transaction Type

The CDR transaction type. This is 0 on a successful plan purchase.

For a complete list of transaction types, see SPCM Subscriber Plan Transaction Types.

4

Tenant Id

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

5

CDR Generation Date

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

6

CDR Generation Time

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

7

Payment Type

The payment method used for the plan purchase.

possible values

  • -1 = unknown

  • 0 = prepaid

  • 1 = postpaid

8

Cost

The cost of a purchased plan.

This should only be set for transaction type 0 (successful plan purchase).

9

Plan Name

The name of the subscriber’s plan.

10

Plan ID

The plan instance ID for the subscriber plan.

This can be a shared or individual plan; the field is empty if not applicable.

11

Plan Type

The plan type.

possible values

  • 0 = core plan

  • 1 = add-on

12

Shared Plan Flag

A flag that indicates if a plan is shared.

possible values

  • 0 = not a shared plan

  • 1 = shared plan

13

` `

Empty field.

14

Plan Precedence

The plan precedence value where 0 is the highest precendence.

15

Plan State

The state of the subscriber’s plan.

possible values

  • 0 = inactive

  • 1 = charging

  • 2 = purchased

  • 3 = charging failed

  • 4 = active

  • 5 = expired

  • 6 = charging error

  • 7 = parked

  • 8 = refunded

  • 9 = refund deferred

  • 10 = terminated

If the field is blank, it is likely the plan has expired and/or has been removed from the database.

16

Plan Purchase Source

An indicator of the plan purchase source as provided by the SPCM web-service client.

format

<sourceType>-<sourceInfo>

example

pmi-admin = using PMI username as source info

This field is empty if not provided in the plan purchase.

17

Plan Purchase Date

The date of the plan purchase. Format: DD/MM/YYYY.

For recurring plans, this is the latest plan purchase date.

18

Plan Purchase Time

The time of the plan purchase. Format: hh:mm:ss.

For recurring plans, this is the latest plan purchase time.

19

Plan Activation Date

The date the plan was activated. Format: DD/MM/YYYY.

For recurring plans, this is the latest plan activation date.
The field is blank for transaction type 0.

20

Plan Activation Time

The time the plan was activated. Format: hh:mm:ss.

For recurring plans, this is the latest plan activation time.
The field is blank for transaction type 0.

21

Plan Expiry Date

The date the plan expires. Format: DD/MM/YYYY.

22

Plan Expiry Time

The time the plan expired. Format*: hh:mm:ss.

The field is empty if the plan expiry is unlimited.
The field is empty for transaction type 0.

23

Plan Deactivation Count

The number of times the plan has been deactivated.

24

Plan Recurrence Flag

The state of plan recurrence.

values

  • 0 = not recurring

  • 1 = recurring

25

Plan Recurrence Count

The number of times the plan has recurred.

26

Plan Metering Type

The plan metering type.

values

  • 0 = volume

  • 1 = time

  • 2 = combined

27

Plan Volume Limit

The maximum number of bytes of usage allowed for the plan. The Plan Metering Type field determines if this is in bytes or seconds or combined.

The field displays -1 if not applicable.

28

Plan Time Limit

The maximum number of seconds of usage allowed for the plan. The Plan Metering Type field determines if this is in bytes or seconds or combined.

The field displays -1 if not applicable.

29

Plan Purchase Type

The type of plan purchase.

possible values

  • 0 = normal plan purchase.

  • 1 = plan renewal (recurring renew plan)

  • 2 = plan accumulation (repurchase of existing plan - rolled to new instance)

  • 3 = pro-rata plan (applies to subscribers with fixed billing dates)

  • 4 = plan topup

The field is empty if inapplicable.

30

Plan Limit Adjustments

The plan limit adjustment due to a plan purchase, renewal, or top-up.

The value here depends on the Plan Purchase Type field.
values

  • If type 0, this field is also 0.

  • If type 1, this field displays the rolled over usage amount.

  • If type 2, this field displays the plan limit increment due to accumulation.

  • If type 3, this field displays the pro-rata adjustment amount.

  • If type 4, this field displays the plan limit increment due to the topup.

31

Discount Type

The type of discount applied to the plan.

options

  • 0 = none

  • 2 = dynamic (e.g., rate from DPS)

32

Percent Discount

The percent discount applied. If there is no discount applied, this field is set to 0.

The range is 0-100.

33

Plan Recurrency

The state of plan recurrency set by the subscriber.

options

  • 0 = disabled

  • 1 = enabled

34

Billing Day

Denotes the subscriber’s billing day. This is a numeric value between 1 and 31.

This field is empty if not provided or not applicable.

35

Shared Plan State

Indicates whether sharing is enabled.

options

  • 0 = disabled

  • 1 = enabled

Empty if not applicable.

36

Purchased Plan Alias

The original plan alias used during the plan purchase.

37

Discounted Cost

If a percent discount exists, this is the rounded value of the total cost with percent discount included.

discountedCost = Round(cost*(1-(percentDiscount/100)

Postpaid only.


Subscription manager subscriber plan CDR transaction types

Type Description

0

Plan purchase successful.

Celebrate good times, c’mon!

1

Plan purchased failed.

2

Plan activated.

3

Plan deactivated.

4

Usage consumed

5

Plan expiry.

6

Plan cancelled.

7

Plan provisioning failure.

8

Plan terminated.

11

Plan recurrency activation.

12

Plan recurrency cancellation.

13

Billing day changed.

14

QoS downgraded.

15

QoS reset.

16

Plan renewal by usage.

This only applies when subscriber-controlled recurrency is TRUE and the plan instance is recurring.

17

Activate plan sharing mode for subscriber.

18

Deactivate plan sharing mode for subscriber.

19

Plan expiry timestamp updated due to change in the billing day (generated by an SSRV DBI call).