View: dbo.Payroll_Department_View
View definition
create view dbo.Payroll_Department_View
as
select P.*
, active_status_KEY = CASE WHEN P.is_active = 1 THEN 1 ELSE 2 END
from
dbo.Payroll_Department P