Prepaid Real-Time Charging (OCS/OFCS)

This dataset provides comprehensive records of prepaid subscribers' real-time charging sessions, including balance deductions, quota management, session terminations, recharge transactions, and detailed Diameter protocol messaging. It enables granular analysis of subscriber behavior, charging system performance, and network operations, making it invaluable for telecom billing, fraud detection, and regulatory compliance.

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

Telecom billing and revenue assurance

Sample rows

preview · 8 of 450 rows · all 20 columns
session_idstringservice_typestringquota_consumedfloatsession_terminated_due_to_insufficient_fundsbooleancurrencystringsubscriber_idstringsession_start_timedatetimesession_end_timedatetimequota_allocatedfloatbalance_beforefloatbalance_afterfloatrecharge_transaction_idstringrecharge_amountfloatrecharge_timedatetimediameter_interfacestringdiameter_request_typestringdiameter_request_timedatetimediameter_response_codeintegercharging_resultstringnetwork_node_idstring
SESS-00001data478.4falseINR9198123450012024-06-01T08:15:23Z2024-06-01T08:35:46Z50075.674.12blankblankblankGyCCR2024-06-01T08:15:24Z2001successNODE-DEL-01
SESS-00002voice117.2falseGBP4477009000022024-06-01T09:02:11Z2024-06-01T09:04:17Z12032.131.85RCHG-0001202024-06-01T09:03:02ZRoCCA2024-06-01T09:02:12Z2001successNODE-LON-04
SESS-00003sms1falseUSD151055500032024-06-01T10:21:45Z2024-06-01T10:22:03Z110.210.15blankblankblankRoCCR2024-06-01T10:21:46Z2001successNODE-NYC-02
SESS-00004data1024trueINR9198123450042024-06-01T11:02:35Z2024-06-01T11:42:36Z10248.450blankblankblankGyRAR2024-06-01T11:02:36Z4012insufficient_fundsNODE-MUM-03
SESS-00005voice55falseGBP4477009000052024-06-01T12:01:12Z2024-06-01T12:09:44Z608079.68blankblankblankRoCCR2024-06-01T12:01:13Z2001successNODE-LON-01
SESS-00006sms2falseUSD151055500062024-06-01T13:15:26Z2024-06-01T13:16:20Z20.150.1blankblankblankRoRAA2024-06-01T13:15:27Z2001successNODE-NYC-04
SESS-00007data1789.6falseINR9198123450072024-06-01T14:17:34Z2024-06-01T14:45:19Z2048150147.5RCHG-00021002024-06-01T14:25:00ZGyCCR2024-06-01T14:17:36Z2001successNODE-DEL-02
SESS-00008other8.4falseGBP4477009000082024-06-01T15:22:18Z2024-06-01T15:28:01Z109089.3blankblankblankRoCCA2024-06-01T15:22:19Z2001successNODE-LON-02

What the 450 rows show

from the 450-row sample

Data (service type) stands out: mean quota_consumed is 359.5, against 55.4 for the rest.

  • 14%session_terminated_due_to_insufficient_funds = true
  • 60.0median quota_consumed
  • 2diameter interfaces
  • 3charging results
  • 4diameter request types
  • 60median quota_allocated
Mean quota_consumed by service_type450 rows
020040099.3voice148 rows9.8sms115 rows359.5data150 rows21.9other37 rows
quota_consumed450 rows, in bands of 250
0185370370481359112101,2502,250quota_consumed →

Median 60.0, from 0.0 to 2,048.

currency450 rows · 7 values
  1. INR206
  2. GBP81
  3. USD70
  4. EUR59
  5. AUD20
  6. JPY8
  7. ZAR6
20 columns by typefrom the column list below
  • string 9
  • integer 1
  • float 5
  • datetime 4
  • boolean 1

Columns

20 columns in four groups
blueprint · 20 columns
columntypedescriptionexample
Text 9 columns
session_idstringUnique identifier for each charging session.uniqueSESS-00001
subscriber_idstringUnique identifier for the prepaid subscriber (e.g., MSISDN or IMSI).919812345001
service_typestringType of service being charged (e.g., voice, SMS, data).voice · sms · data · otherdata
recharge_transaction_idstringUnique identifier for the recharge transaction, if applicable.optionalRCHG-0001
diameter_interfacestringDiameter interface used for the session (Ro or Gy).Ro · GyGy
diameter_request_typestringType of Diameter request message (e.g., CCR, CCA, RAR, RAA).CCR · CCA · RAR · RAACCR
charging_resultstringResult of the charging operation (e.g., success, failed, quota_exhausted, insufficient_funds).success · failed · quota_exhausted · insufficient_fundssuccess
currencystringCurrency code used for charging (e.g., USD, EUR, INR).7 currenciesINR
network_node_idstringIdentifier for the network node handling the session.optionalNODE-DEL-01
Numbers 6 columns
quota_allocatedfloatAmount of quota allocated for the session (e.g., MB for data, seconds for voice).0 or more · optional500
quota_consumedfloatAmount of quota consumed during the session.0 or more · optional478.4
balance_beforefloatSubscriber's account balance before session start.0 or more75.6
balance_afterfloatSubscriber's account balance after session end.0 or more74.12
recharge_amountfloatAmount recharged during the session, if applicable.0 or more · optional20
diameter_response_codeintegerDiameter response code received (e.g., 2001 for success).1,000 to 5,9992001
Dates and times 4 columns
session_start_timedatetimeTimestamp when the charging session started.2024-06-01T08:15:23Z
session_end_timedatetimeTimestamp when the charging session ended.optional2024-06-01T08:35:46Z
recharge_timedatetimeTimestamp of the recharge transaction, if applicable.optional2024-06-01T09:03:02Z
diameter_request_timedatetimeTimestamp when the Diameter request was sent.2024-06-01T08:15:24Z
True or false 1 column
session_terminated_due_to_insufficient_fundsbooleanIndicates if the session was terminated due to insufficient funds.false

Use it for

  • session termin…14%63 of 450 rowsmean quota consumed b…99.3voice9.8sms359.5data21.9other

    A telecommunications dashboard

    The session_terminated_due_to_insufficient_funds rate, quota_consumed by service_type and a breakdown of currency. Excel, Power BI or Tableau.

  • Why do the 150 data rows have a mean quota_consumed of 359.5?

    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 sessions with subscriber_id, session_start_time and session_end_time to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 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 dataset450 rows20 columns
Yours1,000 rows20 columns

blueprint · prepaid-real-time-charging-ocsofcs

Behind this dataset

Same schema. As many rows as you need.

These 450 rows came out of a blueprint — 20 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
  • Subscriber MSISDN and account balance in currency or units
  • Service request: voice call, data session, SMS with estimated cost
  • Quota granted (units or time) and quota threshold monitoring
  • Real-time balance check and deduction via Diameter Ro (IMS) or Gy (PGW)
  • Recharge transactions: voucher, mobile money, bank transfer
  • Service termination on zero balance with grace period rules
  • Bonus/promotional credits and validity periods
  • Multi-service quotas: voice minutes, data MB, SMS count
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
prepaid-real-time-charging-ocsofcs

More in Telecommunications

Browse all
Also in TelecommunicationsSpectrum Utilization and Efficiency MetricsTelecom Subscriber Usage PatternsNetwork Outage Incident LogsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.