Roaming CDR and TAP/RAP File Processing

This dataset provides comprehensive records of international mobile roaming events, including detailed call, SMS, and data usage, associated TAP3 file information, inter-operator tariff pricing, wholesale settlement status, and fraud detection flags. It enables telecom operators and partners to analyze roaming traffic, automate settlement, detect fraud, and optimize tariffs for cross-border mobile services.

  • opened 9 times
  • last updated 1 Nov 2025
  • by GoMask
The brief that made it

Automated wholesale settlement and reconciliation between operators

Sample rows

preview · 8 of 350 rows · all 22 columns
cdr_idstringtap_file_typestringdata_volume_mbfloatnrtrde_flagbooleancurrencystringtap_file_idstringfile_received_datetimedatetimehome_operator_idstringvisited_operator_idstringsubscriber_imsistringsubscriber_msisdnstringcall_typestringcall_start_datetimedatetimecall_end_datetimedatetimeduration_secondsintegercharged_amountfloatiot_tariff_idstringfraud_flagbooleanfraud_detection_reasonstringsettlement_statusstringsettlement_datedaterecord_creation_datetimedatetime
CDR0000001TAPblankfalseUSDTAP20240701A2024-07-01T08:13:44OPRHOME100OPRVISIT20131041012345678912025550101voice2024-07-01T08:10:302024-07-01T08:19:235335.12IOT2024A001falseblankpendingblank2024-07-01T08:19:25
CDR0000002NRTRDE950.8trueGBPNRTRDE20240701B2024-07-01T08:15:21OPRHOME110OPRVISIT211234150987654321447700900202data2024-07-01T08:12:002024-07-01T08:50:47blank24.75IOT2024B014falseblankpendingblank2024-07-01T08:51:00
CDR0000003RAPblankfalseINRRAP20240630C2024-06-30T18:25:13OPRHOME120OPRVISIT221404550987123456919812345678sms2024-06-30T18:22:00blank30.28IOT2024C007falseblanksettled2024-07-022024-06-30T18:25:15
CDR0000004TAPblankfalseUSDTAP20240701A2024-07-01T08:13:44OPRHOME101OPRVISIT20231041098765432112025550102voice2024-07-01T09:11:052024-07-01T09:15:552902.85IOT2024A002falseblankpendingblank2024-07-01T09:15:57
CDR0000005NRTRDE110.6trueGBPNRTRDE20240701B2024-07-01T08:15:21OPRHOME111OPRVISIT212234150123456789447700900203data2024-07-01T08:52:002024-07-01T09:41:17blank8.55IOT2024B015falseblankpendingblank2024-07-01T09:41:20
CDR0000006TAPblankfalseUSDTAP20240701D2024-07-01T11:02:14OPRHOME102OPRVISIT20331041032165498712025550103voice2024-07-01T11:00:112024-07-01T11:03:171861.6IOT2024A003falseblanksettled2024-07-012024-07-01T11:03:18
CDR0000007RAPblankfalseINRRAP20240630E2024-06-30T20:53:31OPRHOME130OPRVISIT231404550789654321919812345679sms2024-06-30T20:51:10blank20.25IOT2024C008falseblanksettled2024-07-022024-06-30T20:53:32
CDR0000008TAPblankfalseUSDTAP20240701D2024-07-01T11:02:14OPRHOME103OPRVISIT20431041078965412312025550104voice2024-07-01T11:05:222024-07-01T11:10:253032.15IOT2024A004falseblankpendingblank2024-07-01T11:10:27

What the 350 rows show

from the 350-row sample

NRTRDE (tap file type) stands out: 98 of its 98 rows have nrtrde_flag = true, against 9 of 252 for the rest.

  • 31%nrtrde_flag = true
  • 720.1median data_volume_mb
  • 4call types
  • 4settlement statuses
  • 176.5median duration_seconds
  • 4.6median charged_amount
Nrtrde flag rate by tap_file_typenrtrde_flag = true
0%50%100%3%TAP5 of 1544%RAP4 of 98100%NRTRDE98 of 98
data_volume_mb109 rows, in bands of 500
0255041332095101,5003,000data_volume_mb →

Median 720.1, from 74.6 to 2,509.

currency350 rows · 7 values
  1. EUR120
  2. GBP119
  3. USD74
  4. AUD17
  5. INR15
  6. BRL3
  7. JPY2
22 columns by typefrom the column list below
  • string 12
  • integer 1
  • float 2
  • date 1
  • datetime 4
  • boolean 2

Columns

22 columns in four groups
blueprint · 22 columns
columntypedescriptionexample
Text 12 columns
cdr_idstringUnique identifier for the Call Detail Record (CDR)uniqueCDR0000001
tap_file_idstringIdentifier for the TAP3 file in which this CDR was includedTAP20240701A
tap_file_typestringType of TAP file (TAP, RAP, NRTRDE)TAP · RAP · NRTRDETAP
home_operator_idstringIdentifier for the home mobile network operator (subscriber's operator)OPRHOME100
visited_operator_idstringIdentifier for the visited mobile network operator (roaming partner)OPRVISIT201
subscriber_imsistringInternational Mobile Subscriber Identity (IMSI) of the roaming user310410123456789
subscriber_msisdnstringMobile Station International Subscriber Directory Number (MSISDN) of the roaming useroptional12025550101
call_typestringType of call or event (voice, sms, data, etc.)voice · sms · data · othervoice
currencystringCurrency code for charged amount (ISO 4217)7 currenciesUSD
iot_tariff_idstringIdentifier for the Inter-Operator Tariff (IOT) pricing appliedoptionalIOT2024A001
fraud_detection_reasonstringReason or code for fraud detection (if flagged)optionalUnusual data volume
settlement_statusstringStatus of wholesale settlement for this eventpending · settled · disputed · rejectedpending
Numbers 3 columns
duration_secondsintegerDuration of the call/event in seconds0 or more · optional533
data_volume_mbfloatVolume of data used in megabytes (for data events)0 or more · optional950.8
charged_amountfloatAmount charged for this event (wholesale settlement, in home operator currency)0 or more5.12
Dates and times 5 columns
file_received_datetimedatetimeDate and time when the TAP/RAP/NRTRDE file was received2024-07-01T08:13:44
call_start_datetimedatetimeStart date and time of the call/event2024-07-01T08:10:30
call_end_datetimedatetimeEnd date and time of the call/eventoptional2024-07-01T08:19:23
settlement_datedateDate when settlement was completed (if applicable)optional2024-07-02
record_creation_datetimedatetimeTimestamp when this record was created in the system2024-07-01T08:19:25
True or false 2 columns
fraud_flagbooleanIndicates if the event is flagged as potential roaming fraudfalse
nrtrde_flagbooleanIndicates if this record was reported via NRTRDE (Near Real-Time Roaming Data Exchange)false

Use it for

  • nrtrde flag31%107 of 350 rowsmean data volume mb b…717.8TAP1.6kRAP810.2NRTRDE

    A telecommunications dashboard

    The nrtrde_flag rate, data_volume_mb by tap_file_type and a breakdown of currency. Excel, Power BI or Tableau.

  • Why do 107 of 350 rows have nrtrde_flag = true?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable cdrs with tap_file_id, tap_file_type and file_received_datetime to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 22 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset350 rows22 columns
Yours1,000 rows22 columns

blueprint · roaming-cdr-and-taprap-file-processing

Behind this dataset

Same schema. As many rows as you need.

These 350 rows came out of a blueprint — 22 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • TAP3 file from visited network PLMN to home network PLMN
  • Call record: MO/MT voice, SMS, data session, supplementary services
  • IMSI of roaming subscriber and visited network details
  • IOT (Inter-Operator Tariff) pricing per service type and destination
  • TAP3 validation: syntax errors, duplicate records, pricing discrepancies
  • RAP (Returned Accounts Procedure) for rejected records
  • NRTRDE for near real-time fraud detection (sub-minute latency)
  • Wholesale vs. retail pricing reconciliation
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
roaming-cdr-and-taprap-file-processing

More in Telecommunications

Browse all
Also in TelecommunicationsMobile Data Session Records (PGW-CDR/SGW-CDR)Telecommunications Equipment Failure LogsTelecom Subscriber Usage PatternsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.