Versions Compared

Old Version 36

changes.mady.by.user Dean Marriott

Saved on

compared with

New Version 37

changes.mady.by.user Dean Marriott

Saved on

Key

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

Please Note:

  • Transport (and Main Roads TMR) collects Compulsory Third Party insurance premiums on behalf of licensed Insurers. It is not TMR's role to provide information on Insurers' premiums. Customers must contact the Insurers for any further information regarding these rates.

  • CTP premium rates are inclusive of Stamp Duty and the Goods and Services Tax.


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