...
Run with a user form and parameters | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
SQL | ||||||||||||
| ||||||||||||
| ||||||||||||
noDataMessage | CTP Fees Effective from: $EffDate select 'CTP Rates Effective From: ' + CONVERT(VARCHAR,MAX(eff_date),103) FROM [ManufacturerDataCentre].[dbo].[CTP_qld_import]ITCE 12 Month Rates | |||||||||||
SQL | ||||||||||||
columnLabel | columnTypes | disableAntiXss | width | columnAttributes | ||||||||
dataSource | ManufacturerDS | noDataMessage | select CASE WHEN class LIKE '%seat%' THEN '+ per adult passenger seat over 7' ELSE REPLACE(classITCE 6 Month Rates | |||||||||
SQL | ||||||||||||
columnLabel | columnTypes | disableAntiXss | width | columnAttributes | ||||||||
dataSource | ManufacturerDS | noDataMessage | ITCE 3 Month Rates | |||||||||
SQL | ||||||||||||
columnLabel | columnTypes | disableAntiXss | width | columnAttributes | dataSource | |||||||
select CASE WHEN class LIKE '%seat%' THEN '+ per adult passenger seat over 7' ELSE REPLACE(class, 'base','') END AS Class, ISNULL(CAST(AAI AS VARCHAR),'n/a') AS [AAI (SUNCORP)],
ISNULL(CAST(ALLIANZ AS VARCHAR),'n/a') AS ALLIANZ ,
ISNULL(CAST(QBE AS VARCHAR),'n/a') AS QBE ,
ISNULL(CAST(RACQ AS VARCHAR),'n/a') AS RACQ
FROM (
select *
from
(
select period, rank, class, [insurer] , [gross_comm] AS premium
from [CTP_qld_import]
) src
pivot
(
SUM([premium])
for [insurer] in ([AAI], [ALLIANZ], [QBE], [RACQ])
) piv
) AS CTP
where period = 3 order by rank | ||||||||||||
noDataMessage | Non ITCE 12 Month Rates | |||||||||||
SQL | ||||||||||||
columnLabel | columnTypes | disableAntiXss | width | columnAttributes | dataSource | |||||||
select CASE WHEN class LIKE '%seat%' THEN '+ per adult passenger seat over 7' ELSE REPLACE(class, 'base','') END AS Class, ISNULL(CAST(AAI AS VARCHAR),'n/a') AS [AAI (SUNCORP)],
ISNULL(CAST(ALLIANZ AS VARCHAR),'n/a') AS ALLIANZ ,
ISNULL(CAST(QBE AS VARCHAR),'n/a') AS QBE ,
ISNULL(CAST(RACQ AS VARCHAR),'n/a') AS RACQ
FROM (
select *
from
(
select period, rank, class, [insurer] , [gross_priv] AS premium
from [CTP_qld_import]
) src
pivot
(
SUM([premium])
for [insurer] in ([AAI], [ALLIANZ], [QBE], [RACQ])
) piv
) AS CTP
where period = 12 order by rank | ||||||||||||
noDataMessage | Non ITCE 6 Month Rates | |||||||||||
SQL | ||||||||||||
columnLabel | columnTypes | disableAntiXss | width | columnAttributes | dataSource | |||||||
select CASE WHEN class LIKE '%seat%' THEN '+ per adult passenger seat over 7' ELSE REPLACE(class, 'base','') END AS Class, ISNULL(CAST(AAI AS VARCHAR),'n/a') AS [AAI (SUNCORP)],
ISNULL(CAST(ALLIANZ AS VARCHAR),'n/a') AS ALLIANZ ,
ISNULL(CAST(QBE AS VARCHAR),'n/a') AS QBE ,
ISNULL(CAST(RACQ AS VARCHAR),'n/a') AS RACQ
FROM (
select *
from
(
select period, rank, class, [insurer] , [gross_priv] AS premium
from [CTP_qld_import]
) src
pivot
(
SUM([premium])
for [insurer] in ([AAI], [ALLIANZ], [QBE], [RACQ])
) piv
) AS CTP
where period = 6 order by rank | ||||||||||||
Non ITCE 3 Month Rates |
...
SQL | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
columnLabel | columnTypes | disableAntiXss | width | columnAttributes | |||||||
dataSource | ManufacturerDS | select CASE WHEN class LIKE '%seat%' THEN '+ per adult passenger seat over 7' ELSE REPLACE(class, 'base','') END AS Class, ISNULL(CAST(AAI AS VARCHAR),'n/a') AS [AAI (SUNCORP)],
ISNULL(CAST(ALLIANZ AS VARCHAR),'n/a') AS ALLIANZ ,
ISNULL(CAST(QBE AS VARCHAR),'n/a') AS QBE ,
ISNULL(CAST(RACQ AS VARCHAR),'n/a') AS RACQ
FROM (
select *
from
(
select period, rank, class, [insurer] , [gross_priv] AS premium
from [CTP_qld_import]
) src
pivot
(
SUM([premium])
for [insurer] in ([AAI], [ALLIANZ], [QBE], [RACQ])
) piv
) AS CTP
where period = 3 order by rank |
CLASS | DESCRIPTION OF CLASS | |
1 | Cars and station wagons | |
2 | Motorised homes (but not if the part of the motor vehicle designed for residence is detachable from the part providing the motive power) | |
3 | Taxis (cars and station wagons only) | |
4 | Vehicles Covered:
Hire vehicles that would otherwise fall within class 1,2 or 6 NOTE: This includes vehicles driven by the hirer, as well as vehicles where a driver is provided, such as a Public Passenger Service (PPSE). Limousines (cars and station wagons) will be automatically converted from Class 4 CTP insurance to Class 26 CTP insurance from 1 October 2017. | |
5 | Motor vehicles (including cycles) for use only as vintage, veteran, historic or street rod motor vehicles | |
6 | Trucks, utilities and vans (including panel vans) with a gross vehicle mass of 4.5t or less | |
7 | Trucks, prime movers and vans with a gross vehicle mass of more than 4.5t | |
8(a) | Buses that are exempt or partially exempt from payment of vehicle registration fees on the basis of use for charitable or community service. | |
8(b) | Buses that are used only for driver tuition | |
8(c) | Buses that are not used for or in connection with a business or commercial purpose (i.e. private use) | |
9(a) | Buses used substantially for transporting -
- to or from school or school events. | |
9(b) | Buses used substantially for transporting persons of any age to or from centres for therapy, rehabilitation, or remedial or other special education; | |
10(a) | Buses that are not within class 8 or 9, but are to be used within 350km of a nominated base with a registration period commencing on or after 01/07/07 | |
10(b) | Buses that are not within class 8 or 9, but are to be used within 150km of a nominated base with a registration period commencing on or after 01/07/07 | |
11 | Buses that are not within class 8, 9 or 10 | |
12 | Motorcycles (with 2 or 3 wheels), including motorcycles for hire, with seating only for the driver | |
13 | Motorcycles (with 2 or 3 wheels), including motorcycles for hire, with either or both of the following: | |
14 | Tractors (with or without attachment) | |
15 | Self-propelled machinery or equipment, fire engines, bush fire brigade vehicles, and other emergency vehicles (other than ambulances) | |
16 | Ambulances | |
17 | Motor vehicles used only for primary production (other than motor vehicles for which a lower premium is prescribed) | |
19 | Motor vehicles with a gross vehicle mass of 1t or less, for which limited use plates have been, or are to be issued | |
20 | Motor vehicles with a gross vehicle mass of more than 1t, for which limited use plate have been, or are to be issued | |
22 | Motor vehicles (other than trailers) for which permits have been, or are to be issued allowing the vehicle to be driven on roads while unregistered | |
23 | Motor vehicles (other then trailers) to be driven with a dealers plate attached in the course of a business for which the dealers plate is issued | |
24 | Trailers registered under the Interstate Road Transport Act 1985 (CWLTH) | |
25 | Other trailers including trailers to be driven with a dealer's (trailer trade) plate attached in the course of a business for which the dealer's (trailer trade) plate is issued. | |
26 | Purpose of Use: Booked Hire, Limousine, Special Purpose Limousine (BKHR, LIMO)
NOTE: Limousines and Special Purpose Limousines for passenger cars only. |
...