A two dimensional rate table with ranges and sub columns consists of:
An example of a rate table of this type is displayed below:
Account Percentage |
New Employer (%) |
Q Rate (%) |
G Rate Employer (%) |
|
|---|---|---|---|---|
Size of Fund Index |
0 : 1001 10000 20000 |
0 : 1001 10000 20000 |
0 : 1001 10000 20000 |
|
Normal Rate |
0:1.5 1:6.3 3 |
1 1.1 1.5 1.6 1.6 1.7 |
2 2.1 2.1 2.2 2.2 2.3 |
2 4 2.1 4.1 2.2 4.2 |
Normal Rate |
0:1.5 1:6.3 3 |
2 2.1 4 4.1 8 8.1 |
2 2.2 4.1 4.2 8.1 8.2 |
2.2 2.3 4.2 4.3 8.2 8.3 |
RESF Rate |
0 : 100 |
0.075 0.075 |
0.075 0.075 |
0.075 0.075 |
In the example above, the size of fund index values are used in addition to the account percentage value to determine the rate for each employer type, e.g. a Q Rate Employer with an account percentage value of 1.9% and a fund index of 9000 will be charged 2.1% for the Normal Rate and 4.1% for the Subsidiary Rate.
The XML string for the whole of this rate table would look like this:
(CT1 implies Account Percentage %, RT1 implies Size of Fund Index, and so on)
<RATES_DATA> <COLUMN INDEX=1 ID=1 TYPE=CT1> <ROW INDEX=1 ID =2 TYPE=RT1 NUM_SUB_ROWS=3> <CELL ID=3 MINIMUM=0.0 MAXIMUM=1.5 COLUMN_INDEX=1/> <CELL ID=4 MINIMUM=1.6 MAXIMUM=3.0 COLUMN_INDEX=2/> <CELL ID=5 VALUE=3.0 COLUMN_INDEX=3/> </ROW> <ROW INDEX=2 ID =6 TYPE=RT2 NUM_SUB_ROWS=3> <CELL ID=7 MINIMUM=0.0 MAXIMUM=1.5 COLUMN_INDEX=1/> <CELL ID=8 MINIMUM=1.6 MAXIMUM=3.0 COLUMN_INDEX=2/> <CELL ID=9 VALUE=3.0 COLUMN_INDEX=3/> </ROW> <ROW INDEX=3 ID =10 TYPE=RT3> <CELL ID=11 MINIMUM=0.0 MAXIMUM=100.0 COLUMN_INDEX=3/> </ROW> </COLUMN> <COLUMN INDEX=2 ID=12 TYPE=CT2> <SUB_COLUMN INDEX=1 ID=13 MAXIMUM=10000.0 MINIMUM=0.0> <ROW INDEX=1 ID =2 TYPE=RT1 NUM_SUB_ROWS=3> <CELL ID=14 VALUE=1 COLUMN_INDEX=1/> <CELL ID=15 VALUE=1.5 COLUMN_INDEX=2/> <CELL ID=16 VALUE=1.6 COLUMN_INDEX=3/> </ROW> <ROW INDEX=2 ID =6 TYPE=RT2 NUM_SUB_ROWS=3>> <CELL ID=17 VALUE=2 COLUMN_INDEX=1/> <CELL ID=18 VALUE=2.1 COLUMN_INDEX=2/> <CELL ID=19 VALUE=2.2 COLUMN_INDEX=3/> </ROW> <ROW INDEX=3 ID =10 TYPE=RT3> <CELL ID=20 VALUE=0.075 COLUMN_INDEX=3/> </ROW> </SUBCOLUMN> <SUB_COLUMN INDEX=2 ID=21 MAXIMUM=20000.0 MINIMUM=10001.0> <ROW INDEX=1 ID =2 TYPE=RT1 NUM_SUB_ROWS=3> <CELL ID=22 VALUE=1.1 COLUMN_INDEX=1/> <CELL ID=23 VALUE=1.6 COLUMN_INDEX=2/> <CELL ID=24 VALUE=1.7 COLUMN_INDEX=3/> </ROW> <ROW INDEX=2 ID =6 TYPE=RT2 NUM_SUB_ROWS=3>> <CELL ID=25 VALUE=2.1 COLUMN_INDEX=1/> <CELL ID=26 VALUE=2.2 COLUMN_INDEX=2/> <CELL ID=27 VALUE=2.3 COLUMN_INDEX=3/> </ROW> <ROW INDEX=3 ID =10 TYPE=RT3> <CELL ID=28 VALUE=0.075 COLUMN_INDEX=3/> </ROW> </SUBCOLUMN> </COLUMN> <COLUMN INDEX=3 ID=29 TYPE=CT3> <SUB_COLUMN INDEX=1 ID=30 MAXIMUM=10000.0 MINIMUM=0.0> <ROW INDEX=1 ID =2 TYPE=RT1 NUM_SUB_ROWS=3> <CELL ID=31 VALUE=2 COLUMN_INDEX=1/> <CELL ID=33 VALUE=2.1 COLUMN_INDEX=2/> <CELL ID=33 VALUE=2.2 COLUMN_INDEX=3/> </ROW> <ROW INDEX=2 ID =6 TYPE=RT2 NUM_SUB_ROWS=3>> <CELL ID=34 VALUE=4 COLUMN_INDEX=1/> <CELL ID=35 VALUE=4.1 COLUMN_INDEX=2/> <CELL ID=36 VALUE=4.2 COLUMN_INDEX=3/> </ROW> <ROW INDEX=3 ID =10 TYPE=RT3> <CELL ID=37 VALUE=0.075 COLUMN_INDEX=3/> </ROW> </SUBCOLUMN> <SUB_COLUMN INDEX=2 ID=38 MAXIMUM=20000.0 MINIMUM=10001.0> <ROW INDEX=1 ID =2 TYPE=RT1 NUM_SUB_ROWS=3> <CELL ID=39 VALUE=2.1 COLUMN_INDEX=1/> <CELL ID=40 VALUE=2.2 COLUMN_INDEX=2/> <CELL ID=41 VALUE=2.3 COLUMN_INDEX=3/> </ROW> <ROW INDEX=2 ID =6 TYPE=RT2 NUM_SUB_ROWS=3>> <CELL ID=42 VALUE=4.1 COLUMN_INDEX=1/> <CELL ID=43 VALUE=4.2 COLUMN_INDEX=2/> <CELL ID=44 VALUE=4.3 COLUMN_INDEX=3/> </ROW> <ROW INDEX=3 ID =10 TYPE=RT3> <CELL ID=45 VALUE=0.075 COLUMN_INDEX=3/> </ROW> </SUBCOLUMN> </COLUMN> </COLUMN> <COLUMN INDEX=4 ID=46 TYPE=CT4> <SUB_COLUMN INDEX=1 ID=47 MAXIMUM=10000.0 MINIMUM=0.0> <ROW INDEX=1 ID =2 TYPE=RT1 NUM_SUB_ROWS=3> <CELL ID=48 VALUE=2 COLUMN_INDEX=1/> <CELL ID=49 VALUE=2.1 COLUMN_INDEX=2/> <CELL ID=50 VALUE=2.2 COLUMN_INDEX=3/> </ROW> <ROW INDEX=2 ID =6 TYPE=RT2 NUM_SUB_ROWS=3>> <CELL ID=51 VALUE=8 COLUMN_INDEX=1/> <CELL ID=52 VALUE=8.1 COLUMN_INDEX=2/> <CELL ID=53 VALUE=8.2 COLUMN_INDEX=3/> </ROW> <ROW INDEX=3 ID =10 TYPE=RT3> <CELL ID=54 VALUE=0.075 COLUMN_INDEX=3/> </ROW> </SUBCOLUMN> <SUB_COLUMN INDEX=2 ID=55 MAXIMUM=20000.0 MINIMUM=10001.0> <ROW INDEX=1 ID =2 TYPE=RT1 NUM_SUB_ROWS=3> <CELL ID=56 VALUE=4 COLUMN_INDEX=1/> <CELL ID=57 VALUE=4.1 COLUMN_INDEX=2/> <CELL ID=58 VALUE=4.2 COLUMN_INDEX=3/> </ROW> <ROW INDEX=2 ID =6 TYPE=RT2 NUM_SUB_ROWS=3>> <CELL ID=59 VALUE=8.1 COLUMN_INDEX=1/> <CELL ID=60 VALUE=8.2 COLUMN_INDEX=2/> <CELL ID=61 VALUE=8.3 COLUMN_INDEX=3/> </ROW> <ROW INDEX=3 ID =10 TYPE=RT3> <CELL ID=62 VALUE=0.075 COLUMN_INDEX=3/> </ROW> </SUBCOLUMN> </COLUMN> </RATES_DATA>