RTE SOM CDR

The RTE generates CDRs at the end of each traffic event.

There are different Transaction Types for different RTE SOM traffic events. The Transaction Type field contains this transaction type.
All RTE Subscriber Offer Manager (SOM) CDRs contain 25 fields no matter the Transaction Type. However, not all fields in each CDR is populated.

Subsections include:

Field Name Description

1

Subscriber ID

The MSISDN of the handset which initiated the dialogue.

This is in Tango internal format.

2

Service ID

The CDR Service ID. This is set to 63 for RTE SOM CDRs.

3

Transaction Type

Indicates the transaction type for this CDR.

types

  • 1 = No Offer Applicable

  • 2 = Offer Added

  • 3 = Offer Accepted

  • 4 = Offer Expired

  • 5 = Offer Does not Exist

  • 6 = Offer Already Accepted

  • 7 = Subscriber Daily Limit

  • 8 = Subscriber Weekly Limit

  • 9 = Subscriber not in Cache

  • 10 = Offer viewed

  • 11 = Offer acknowledged

  • 12 = Offer cancelled

  • 13 = Offer rejected

  • 14 = Update failed

  • 15 = Offer terminated

4

Tenant ID

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

5

MSISDN

The subscriber’s MSISDN in international format.

6

Date

The date on which the CDR was written. Format: YYYY-MM-DD.

7

Time

The time at which the CDR was written. Format: hh:mm:ss.

8

Trigger

The reason by which the request was triggered.

options

  • BCN = Balance Check Notification

  • EoCN = End of Call Notification

9

Service Code

The USSD Service Code in plan ASCII digits or the internal orchestration code which is configurable per operator.

10

Action

The action that occured.

An example would be addCampaign.

11

Error Code

The Java Service Environment (SE) code.

This is always set to 0.

12

Campaign ID

The ID of the RTE campaign.

13

Campaign Name

The name of the RTE campaign.

14

Campaign Type

The type of campaign.

Some examples include referrals or special offers.

15

Campaign Objective

The objective of the campaign being run.

This is a free text field defined by the operator.

16

Offer External ID

The unique ID number of the instance of the offer.

This is an internal Tango sequence number.

17

Offer Definition External ID

The offer ID number as defined by the operator.

18

Offer Message

The content of the message received by the subscriber.

example

You are eligible for an exciting offer, press # for more details.

19

Cost

The cost of the offer to the business.

example

Four people accept an offer of 10 credits each. The cost is 40 credits.

20

Push Channel

The channel on which the request was triggered.

SMS is an example.

21

Segment

The segment name. Segments refine offers using certain demographic conditions.

example

  • Segment Name = college

  • conditions = M/F, 18-23, >6GB Data Usage

22

HPLMN

The Home Public Land Mobile Network (HPLMN). This is the home network of the subscriber.

MEXMS is MEX for Mexico and MS for the region.

23

VPLMN

The Visited Public Land Mobile Network. This is the PLMN on which the mobile subscriber has roamed when leaving his or her HPLMN.

24

Response Time

The number of seconds elapsed since the referral offer was sent to the referee.

25

Consume Channel

The channel on which the offer was consumed.

SMS is an example.

26

country

The subscriber’s country.

Example: Portugal

27

zone

The subscriber’s zone.

Example: EU


RTE SOM CDR samples

No Offer Applicable sample
000410080604090805030809,63,1,IRLDF,864985389,2017-11-29,17:02:00,EoCN,80,,0,,,,,,,,,,IRLDF,,,Portugal,EU
Offer Added sample
000410080604090805030809,63,2,IRLDF,864985389,2017-11-29,17:02:00,balanceCheck,80,,0,3,CampaignName,0,CampaignObjective,360d2e50-4d28-4858-9a89-2092285631b6,TheOfferEXTID,TheOffermessage,10,SMS,,IRLDF,,,Portugal,EU
Offer Accepted sample
000410080604090805030809,63,3,IRLDF,864985389,2018-04-05,16:48:31,balanceCheck,80,,0,3,CampaignName,0,,c8339e36-a89f-40d3-9b27-d52ec706f9b7,TheOfferExtID,,10,SMS,,IRLDF,,98,USSD,Portugal,EU
Offer Expired sample
000410080604090805030809,63,4,IRLDF,864985389,2018-04-09,15:07:00,balanceCheck,,,0,3,CampaignName,,,3916fafe-b115-4671-820f-5efdd1db264e,TheOfferExtID,,,SMS,,IRLDF,,,Portugal,EU
Offer Does not Exist sample
000410080704090805030809,63,5,IRLDF,874985389,2018-04-09,15:36:10,,80,,0,,,,,2317ce90-1063-4b72-ac0c-67b7036e723b,,,,,,IRLDF,,,USSD,Portugal,EU
Offer Already Accepted sample
000410080604090805030809,63,6,IRLDF,864985389,2018-04-09,15:37:19,balanceCheck,80,,0,3,CampaignName,,,,2317ce90-1063-4b72-ac0c-67b7036e723b,TheOfferExtID,,,,,IRLDF,,,USSD,Portugal,EU
Subscriber Daily Limit sample
000410080604090805030809,63,9,IRLDF,864985389,2017-11-29,17:02:00,EoCN,80,,0,,,,,,,,,,,IRLDF,,,Portugal,EU
Subscriber Weekly Limit sample
000410080604090805030809,63,9,IRLDF,864985389,2017-11-29,17:02:00,EoCN,80,,0,,,,,,,,,,,IRLDF,,,Portugal,EU
Subscriber not in Cache sample
000410080604090805030809,63,9,IRLDF,864985389,2017-11-29,17:02:00,EoCN,80,,0,,,,,,,,,,,IRLDF,,,Portugal,EU