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