View: dbo.Employee_Primary_Work_Location_Payroll_Department_View | |||
View definition | |||
--Creating a view for Primary Location and Primary Department options in Employee Filter CREATE VIEW dbo.Employee_Primary_Work_Location_Payroll_Department_View AS SELECT employee_primary_work_location_payroll_department_KEY = W.employee_work_location_payroll_department_KEY ,W.work_location_KEY ,W.payroll_department_KEY ,W.employee_KEY ,W.pay_distribution_percent ,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 Where W.is_primary = 1 | |||