Roads Australia > Events

You are here: >>

Back

Roads Australia Event Details


Submit

RA Single Table Luncheon with Leo Coci (Perth)

16/04/2021 12:00 to 16/04/2021 14:30

Venue: Fraser's Restaurant
Details:

BY INVITATION

Join us as we host Leo Coci, Managing Director, Office of Major Transport Infrastructure Delivery (OMTID), for a single table luncheon. This is an ideal opportunity to directly engage in a discussion regarding complex road and bridge infrastructure projects in Western Australia.

Date: Friday 16 April 2021

Time: 12pm pre luncheon drinks for a 12.30pm prompt sit down; 2.30pm close

Where: Fraser's Restaurant, 60 Fraser Avenue, West Perth

Diet: Please inform us if you have special dietary requirements

For booking queries, please contact Director - Events, Rachael Rooney.

OUR SPONSOR

OUR SPEAKER

Leo Coci, Managing Director, Office of Major Transport Infrastructure Delivery (OMTID)

Leo has over 40 years’ experience with Main Roads Western Australia, having gained a variety of experience and expertise in bridge design, road planning, project management and contract management of major projects.

He is a member of the Main Roads Corporate Executive and is currently leading the newly established Office of Major Infrastructure Delivery (OMTID), which is overseeing and facilitating the rapid progress on the delivery of $8b of priority transport infrastructure projects over the next four years.

OMTID is responsible for delivering the State’s largest, complex and high profile road projects and Metronet rail projects such as Thornlie-Cockburn Link, Yanchep Rail Extension, Morley-Ellenbrook Line, Bayswater Station, Byford Rail extension and Level Crossings Removal.

In his roles to date, Leo has been afforded the opportunity to champion and promote the sustainability philosophy in major transport infrastructure projects through leadership and implementation of innovative contract procurement models.

Name

Event Start Date

Start Time

Event End Date

End Time

Venue

Event Description

Booking URL

Event Id

RA Single Table Luncheon with Leo Coci (Perth)

16/04/2021

12:00

16/04/2021

14:30

Fraser's Restaurant

BY INVITATION

Date: Friday 16 April 2021

Time: 12pm pre luncheon drinks for a 12.30pm prompt sit down; 2.30pm close

Where: Fraser's Restaurant, 60 Fraser Avenue, West Perth

Diet: Please inform us if you have special dietary requirements

For booking queries, please contact Director - Events, Rachael Rooney.

OUR SPONSOR

OUR SPEAKER

Leo Coci, Managing Director, Office of Major Transport Infrastructure Delivery (OMTID)

3253

Dynamic Loaded - Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN 'SOLD OUT' ELSE 'Register Now' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN 'Image Gallery' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.Eid WHERE Event.EventId = [QRY-EventId] AND EventStatus <> 'Pending'
Dynamic Alternate Loaded -
Security - Edit Roles set to
Security - Add Roles set to
Security - Delete Roles set to
Using Existing Dynamic Set - Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN 'SOLD OUT' ELSE 'Register Now' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN 'Image Gallery' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.Eid WHERE Event.EventId = [QRY-EventId] AND EventStatus <> 'Pending'
Executed SQL - Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN 'SOLD OUT' ELSE 'Register Now' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN 'Image Gallery' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.Eid WHERE Event.EventId = 3253 AND EventStatus <> 'Pending' AND EventId LIKE '%3253%'