**Convergent Charging Tier Table**

**A tier table is a table used for mapping an input field that contains a value range to a set of output columns(sting/number). Tier Table can be queried from the price plan of the charge.**

**The below post shows a simple use case of Tier Table(s).**

**We have the CIT class that passes Duration as one of the attribute.**

**Let’s create a tier table.**

**Provide a name and description. The output column is Price with Computation type as Single Linear. Go to the Table Instance Tab.**

**Create 3 entries.**

**Double click on each range and provide values as below.**

**Now for each row provide a price.**

**Our first tire table is ready which is Single Linear.**

**Create a similar table but with computation type as Cumulative Linear.**

**Create a similar table but with computation type as Single Non-Linear.**

**Create a similar table but with computation type as Cumulative Non-Linear.**

**Now we have 4 Tier Tables with different computation mode.**

**Let’s create a charge and price plan which uses this tier table.**

**Now in below charge the Tier Table- SL_TT (Single Linear) is used.**

**The Usage rate contains a linear function.**

**Now test the price plan.**

**The input Duration is 20 secs. So it falls in the first range of the Tier Table.**

**As the computation is linear. So the amount= 20 * .25 = 5 EUR.**

**The input Duration is 30 secs. So it falls in the first range of the Tier Table.**

**As the computation is linear. So the amount= 30 * .25 = 7.5 EUR.**

**The input Duration is 40 secs. So it falls in the Second range of the Tier Table.**

**As the computation is linear. So the amount= .35 *( 40-30) = 3.5 EUR**

**The input Duration is 50 secs. So it falls in the Second range of the Tier Table.**

**As the computation is linear. So the amount= .35 *( 50-30) = 7EUR**

**The input Duration is 70 secs. So it falls in the Third range of the Tier Table.**

**As the computation is linear. So the amount= .5 *( 70-60) = 5 EUR**

**The input Duration is 90 secs. So it falls in the Third range of the Tier Table.**

**As the computation is linear. So the amount= .5 *( 90-60) = 15 EUR**

**Now lets assign the tier table: SN_TT ( Single Non-Linear) to the price plan and test.**

**The input Duration is 20 secs. So it falls in the First range of the Tier Table.**

**As the computation is non-linear. Amount= .25 EUR**

**The input Duration is 30 secs. So it falls in the First range of the Tier Table.**

**As the computation is non-linear. Amount= .25 EUR**

**The input Duration is 40 secs. So it falls in the Second range of the Tier Table.**

**As the computation is non-linear. Amount= .35 EUR**

**The input Duration is 50 secs. So it falls in the Second range of the Tier Table.**

**As the computation is non-linear. Amount= .35 EUR**

**The input Duration is 70 secs. So it falls in the Third range of the Tier Table.**

**As the computation is non-linear. Amount= .5 EUR**

**The input Duration is 90 secs. So it falls in the Third range of the Tier Table.**

**As the computation is non-linear. Amount= .5 EUR**

**Now assign Cumulative Linear Tier Table and test the price plan.**

**The input Duration is 20 secs. So it falls in the First range of the Tier Table.**

**As the computation is Cumulative linear. Amount= 20 * .25 = 5 EUR**

**The input Duration is 30 secs. So it falls in the First range of the Tier Table.**

**As the computation is Cumulative linear. Amount= 30 * .25 = 7.5 EUR**

**The input Duration is 40 secs. So it falls in the Second range of the Tier Table.**

**As the computation is Cumulative linear. **

**Amount= [ 30 * .25 ] + [ (40-30) * .35] = 7.5 + 3.5 = 11 EUR**

**The input Duration is 50 secs. So it falls in the Second range of the Tier Table.**

**As the computation is Cumulative linear.**

**Amount= [ 30 * .25 ] + [ (50-30) * .35] = 7.5 + 7 = 14.5 EUR**

**The input Duration is 90 secs. So it falls in the Third range of the Tier Table.**

**As the computation is Cumulative linear.**

**Amount= [ 30 * .25 ] + [ (90-60) * .35] + [ (90-60) * .5] = 7.5 + 10.5 + 15= 33 EUR**

**Now lets assign the Cumulative Non-Linear tier table in the price plan and test the price plan.**

**The input Duration is 20 secs. So it falls in the first range of the Tier Table.**

**As the computation is Cumulative non-linear. Amount= .25 EUR**

**The input Duration is 30 secs. So it falls in the first range of the Tier Table.**

**As the computation is Cumulative non-linear. Amount= .25 EUR**

**The input Duration is 55 secs. So it falls in the second range of the Tier Table.**

**As the computation is Cumulative non-linear. Amount= .25 + .35 = .6 EUR**

**The input Duration is 80 secs. So it falls in the third range of the Tier Table.**

**As the computation is Cumulative non-linear. Amount= .25 + .35 + .5 = 1.1 EUR**