The following fields from the 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 Termination Customer call is
ORIG COST = CEILING(ORIG RATE * (ORIG BILLED DURATION / 60))* POWER(10, Rounding Digits),1) / 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