View: dbo.Employee_Work_Location_Payroll_Department_View
View definition
create view dbo.Employee_Work_Location_Payroll_Department_View
as
select
employee_work_location_payroll_department_KEY = W.employee_work_location_payroll_department_KEY
, employee_KEY = W.employee_KEY
, payroll_department_KEY = W.payroll_department_KEY
, is_primary = W.is_primary
, work_location_KEY = W.work_location_KEY
, pay_distribution_percent = W.pay_distribution_percent
, employee_work_location_payroll_department_guid = W.employee_work_location_payroll_department_guid
, department__active_status_KEY = CASE WHEN D.is_active = 1 THEN 1 WHEN D.is_active = 0 THEN 2 ELSE NULL END
from dbo.Employee_Work_Location_Payroll_Department W
Left outer join dbo.Payroll_Department D
on W.payroll_department_KEY = D.payroll_department_KEY