Page History

...

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.
For the latest rates click here http://confluence.dev.ultimate.net.au:8090/x/OQC1Aw

SQL

noDataMessage	No Records Found!
columnLabel	true
columnTypes	S,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"
disableAntiXss	true
width	100%
columnAttributes	style="background:#f2f2f2;text-align:center;font-weight:bold",,,,
dataSource	ManufacturerDS

SELECT '<a href="http://confluence.dev.ultimate.net.au:8090/display/HELP/Eclipse+Client+Detail?run_1=run&run_1_EffDate=' + CONVERT( VARCHAR(10), [eff_date], 23) + ' " target="_blank">' + CONVERT( VARCHAR(10), [eff_date], 103)+ '</a>' AS [CTP Fees Effective Date]
FROM [CTP_qld_import_history]
WHERE eff_date > '01/01/2019'
GROUP BY [eff_date]
ORDER BY [eff_date] DESC

Run with a user form and parameters

autoRun	true
inputSize	100
replace	EffDate:2021-07-01:Effective Date:select::2021-07-01:July 2021:2021-04-01:April 2021::
width	500
titleRun	Update Displayed Fees

CTP Fees Effective from: $EffDate

ITCE 12 Month Rates

No Records Found!trueS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"true100%style="background:#f2f2f2;text-align:center;font-weight:bold",,,,ManufacturerDSINLINE