PI FUNDAMENTALS
An APIG SA Event
10/09/2024 12:30 to 10/09/2024 14:00
Venue: DW Fox Tucker, Level 14, 100 King William Street, DW Fox Tucker Lawyers, Level 14 King William Street, Austral, Australia, ADELAIDE, SA, 5000, AUSTRALIA,
Details:
APIG SA is delighted to welcome APIG National President, Mitchell Spurr of Probitas, to Adelaide to present another of the extremely well- received Fundamentals sessions, this time in Professional Indemnity.
The session will address the fundamental issues in arranging, underwriting and managing professional indemnity risks in Australia.
This session will be invaluable to those new to broking or underwriting professional indemnity risks, and to those new to advising on and/or managing professional indemnity claims. It will also be a very useful refresher for those who have been working in the area for some time.
Book Here
APIG SA | PI FUNDAMENTALS | 10/09/2024 | 12:30 | 10/09/2024 | 14:00 | DW Fox Tucker | Level 14, 100 King William Street, DW Fox Tucker Lawyers, Level 14 King William Street, Austral, Australia, ADELAIDE, SA, 5000, AUSTRALIA, | APIG SA is delighted to welcome APIG National President, Mitchell Spurr of Probitas, to Adelaide to present another of the extremely well- received Fundamentals sessions, this time in Professional Indemnity.
The session will address the fundamental issues in arranging, underwriting and managing professional indemnity risks in Australia.
This session will be invaluable to those new to broking or underwriting professional indemnity risks, and to those new to advising on and/or managing professional indemnity claims. It will also be a very useful refresher for those who have been working in the area for some time. | https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=254 | 254 |
Dynamic Loaded -
Select
'APIG ' + ISNULL(Branch.Name, '') as [Branch Name]
,[Event Name]
,CONVERT(VARCHAR(12),[Event Start Date],103) AS [Event Start Date]
,[Event Start Time]
,CONVERT(VARCHAR(12),[Event End Date],103) AS [Event End Date]
,[Event End Time]
,[Event Venue]
,[Event Venue Address]
,[Event Description]
,'https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=' + CAST([Event Id] AS VARCHAR(5)) AS [Booking URL]
,EventId
FROM EventData
INNER JOIN Event ON EventData.[Event Id] = Event.EventId
LEFT OUTER JOIN Branch ON EVENT.BranchId = Branch.BranchId
WHERE [Event Status] = 'Open'
AND AvailableOnline = 1
Dynamic Alternate Loaded -
Security - Edit Roles set to
Security - Add Roles set to
Security - Delete Roles set to
Using Existing Dynamic Set -
Select
'APIG ' + ISNULL(Branch.Name, '') as [Branch Name]
,[Event Name]
,CONVERT(VARCHAR(12),[Event Start Date],103) AS [Event Start Date]
,[Event Start Time]
,CONVERT(VARCHAR(12),[Event End Date],103) AS [Event End Date]
,[Event End Time]
,[Event Venue]
,[Event Venue Address]
,[Event Description]
,'https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=' + CAST([Event Id] AS VARCHAR(5)) AS [Booking URL]
,EventId
FROM EventData
INNER JOIN Event ON EventData.[Event Id] = Event.EventId
LEFT OUTER JOIN Branch ON EVENT.BranchId = Branch.BranchId
WHERE [Event Status] = 'Open'
AND AvailableOnline = 1
Executed SQL -
Select
'APIG ' + ISNULL(Branch.Name, '') as [Branch Name]
,[Event Name]
,CONVERT(VARCHAR(12),[Event Start Date],103) AS [Event Start Date]
,[Event Start Time]
,CONVERT(VARCHAR(12),[Event End Date],103) AS [Event End Date]
,[Event End Time]
,[Event Venue]
,[Event Venue Address]
,[Event Description]
,'https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=' + CAST([Event Id] AS VARCHAR(5)) AS [Booking URL]
,EventId
FROM EventData
INNER JOIN Event ON EventData.[Event Id] = Event.EventId
LEFT OUTER JOIN Branch ON EVENT.BranchId = Branch.BranchId
WHERE [Event Status] = 'Open'
AND AvailableOnline = 1 AND EventId LIKE '%254%'
Select rows above and then selection an action from below to execute on your data:
Execute Selected Action