View: dbo.Staff_Locator_View
View definition
create view dbo.Staff_Locator_View
as
select
staff_locator_KEY = SLO.staff_locator_KEY
, staff_KEY = SLO.staff_KEY
, staff__staff_id = S1.staff_id
, staff__staff_status_KEY = S1.staff_status_KEY
, staff__office_KEY = S1.office_KEY
, staff__supervisor__staff_KEY = S1.supervisor__staff_KEY
, staff__contact_KEY = S1.contact_KEY
, staff_locator_status_KEY = SLO.staff_locator_status_KEY
, staff_locator_status__description = SLOS.description
, returning = SLO.returning
, comments = coalesce(SLO.comments, N'')
from
dbo.Staff_Locator SLO
left outer join
dbo.Staff S1 on S1.staff_KEY = SLO.staff_KEY
left outer join
dbo.Staff_Locator_Status SLOS on SLOS.staff_locator_status_KEY = SLO.staff_locator_status_KEY