How are Termination Customer Costs Calculated?

Created by Kelly Evans, Modified on Thu, 30 Jan at 4:46 PM by Kelly Evans

The following fields from the Call Detail Record (CDR) are used to calculate the cost of Termination Customer (Outbound) Calls.

ORIG RATE = This is the rate that from the rate deck that is associated to the Termination Customer Trunk Group that received the call. The specific rate is found by the longest match of the Prefix to the DNIS and for Prefix Jurisdictional rate decks by also determining if the call is an interstate, intrastate, or indeterminate call.

ORIG BILLED DURATION = This is the number of billed seconds and determined by rounding the REAL DURATION up to the initial increment or to the next subsequent increment if the REAL DURATION is greater than the initial increment. The initial increment and subsequent increment time intervals used are the ones associated with the ORIG RATE in the Rate Deck which is associated to the Termination Customer Trunk Group that received the call. Common values for initial increment and subsequent increment intervals are 6, 6; 1,1; and 60,60. For the example calculations on this page we will use 6, 6.

Example Rate Deck

Prefix
initial increment
subsequent increment
interrate
intrarate
ijrate
effective_date
1204741
6
6
0.00225
0.00225
0.00225
4/17/2023
1204742
6
6
0.00225
0.00225
0.00225
4/17/2023
1204743
6
6
0.00225
0.00225
0.00225
4/17/2023
1204744
6
6
0.002125
0.002125
0.002125
4/17/2023
1204745
6
6
0.0025
0.0025
0.0025
4/17/2023
1204746
6
6
0.0025
0.0025
0.0025
4/17/2023
1204747
6
6
0.002
0.002
0.002
4/17/2023
…
 
 
 
 
 
 

Rounding Digits = This is the number of Rounding Digits selected on the Rate Deck page for the Rate Deck associated to the Termination Customer Trunk Group that received the call. The example below show 4 Rounding Digits.

Example CDRs

The ORIG COST calculation for a Termination Customer call is

ORIG COST = CEILING(ORIG RATE * (ORIG BILLED DURATION / 60)* POWER(10, Rounding Digits)) / POWER(10, Rounding Digits)

Examples
ORIG COST = CEILING(0.005 * (108 / 60)* POWER(10,4)) / POWER(10,4) = 0.0090

ORIG COST = CEILING(0.003 * (72 / 60)* POWER(10,4)) / POWER(10,4) = 0.0036

ORIG COST = CEILING(0.005 * (18 / 60)* POWER(10,4)) / POWER(10,4) = 0.0015

Prefix	initial increment	subsequent increment	interrate	intrarate	ijrate	effective_date
1204741	6	6	0.00225	0.00225	0.00225	4/17/2023
1204742	6	6	0.00225	0.00225	0.00225	4/17/2023
1204743	6	6	0.00225	0.00225	0.00225	4/17/2023
1204744	6	6	0.002125	0.002125	0.002125	4/17/2023
1204745	6	6	0.0025	0.0025	0.0025	4/17/2023
1204746	6	6	0.0025	0.0025	0.0025	4/17/2023
1204747	6	6	0.002	0.002	0.002	4/17/2023
…