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 also determining if the call is an interstate, intrastate, or indeterminate call.
ORIG BILLED DURATION = This is the number of billed seconds and is based on the initial increment and subsequent increment time intervals associated with the ORIG RATE in the Rate Deck associated to the Origination 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.
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