Versions Compared

Old Version 43

changes.mady.by.user Dean Marriott

Saved on

compared with

New Version 44

changes.mady.by.user Dean Marriott

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SQL
heading0
dataSourceManufacturerDS
tablefalse
select 'Rate Effective From: ' + CONVERT(VARCHAR,MAX(eff_date),103) FROM [ManufacturerDataCentre].[dbo].[CTP_qld_import]


ITCE 12 Month Rates

SQL
noDataMessageNo Records Found!
columnLabeltrue
columnTypesS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"
disableAntiXsstrue
width100%
columnAttributesstyle="background:#f2f2f2;text-align:center;font-weight:bold"
dataSourceManufacturerDS
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 = 12 order by rank

...


ITCE 6 Month Rates

SQL
noDataMessageNo Records Found!
columnLabeltrue
columnTypesS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"
disableAntiXsstrue
width100%
columnAttributesstyle="background:#f2f2f2;text-align:center;font-weight:bold"
dataSourceManufacturerDS
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 = 6 order by rank

ITCE 3 Month Rates

SQL
noDataMessageNo Records Found!
columnLabeltrue
columnTypesS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"
disableAntiXsstrue
width100%
columnAttributesstyle="background:#f2f2f2;text-align:center;font-weight:bold"
dataSourceManufacturerDS
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


Non ITCE 12 Month Rates

SQL
noDataMessageNo Records Found!
columnLabeltrue
columnTypesS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"
disableAntiXsstrue
width100%
columnAttributesstyle="background:#f2f2f2;text-align:center;font-weight:bold"
dataSourceManufacturerDS
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

Non ITCE 6 Month Rates

SQL
noDataMessageNo Records Found!
columnLabeltrue
columnTypesS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"
disableAntiXsstrue
width100%
columnAttributesstyle="background:#f2f2f2;text-align:center;font-weight:bold"
dataSourceManufacturerDS
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
noDataMessageNo Records Found!
columnLabeltrue
columnTypesS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"
disableAntiXsstrue
width100%
columnAttributesstyle="background:#f2f2f2;text-align:center;font-weight:bold"
dataSourceManufacturerDS
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

Hire vehicles that would otherwise fall within class 1,2 or 6

 

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 -

  • Children
  • Mature age students
  • Teachers
  • Other school employees
  • Parents

 - 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;
(but a bus is not taken to be used substantially for transporting passengers of these classes if it carries a number of passengers of some other class or classes that is more than 10% of its adult passenger seating capacity)

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:
o seating for a pillion passenger;
o a sidecar

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)

16Ambulances
17Motor vehicles used only for primary production (other than motor vehicles for which a lower premium is prescribed)
19Motor vehicles with a gross vehicle mass of 1t or less, for which limited use plates have been, or are to be issued
20Motor vehicles with a gross vehicle mass of more than 1t, for which limited use plate have been, or are to be issued
22Motor vehicles (other than trailers) for which permits have been, or are to be issued allowing the vehicle to be driven on roads while unregistered
23Motor 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
24Trailers registered under the Interstate Road Transport Act 1985 (CWLTH)
25Other 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.

...