View: dbo.Recorded_Event_Notification_Staff_Portlet_View | |||
View definition | |||
-- $NoKeywords: $ -- turn off keyword expansion in the rest of this file. create view dbo.Recorded_Event_Notification_Staff_Portlet_View as select recorded_event_notification_staff_portlet_KEY = REN.recorded_event_notification_KEY , recorded_event_notification_KEY = REN.recorded_event_notification_KEY , read_date = REN.read_date , dismissed_date = REN.dismissed_date , recorded_event_KEY = REN.recorded_event_KEY , staff_KEY = REN.staff_KEY , recorded_event__create_date = REV.create_date , recorded_event__alert_level_KEY = REV.alert_level_KEY , recorded_event__update__staff_KEY = REV.update__staff_KEY , recorded_event__event_type_KEY = REV.event_type_KEY , recorded_event__event_class_type_KEY = REV.event_class_type_KEY , recorded_event__text = REV.text , recorded_event__details = REV.details , recorded_event__is_system_event = REV.is_system_event , client__client_id = C.client_id , client__description = coalesce(C.description, N'') from dbo.Recorded_Event_Notification REN left outer join dbo.Recorded_Event_View REV on REV.recorded_event_KEY = REN.recorded_event_KEY left outer join dbo.Client C on C.client_KEY = REV.client_KEY | |||