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 | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
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 | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
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 | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
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 |