View: dbo.Scheduled_Payroll_Run_Status_View
View definition
-- View for schedule payroll run status values
CREATE VIEW [dbo].[Scheduled_Payroll_Run_Status_View]
AS
SELECT
client_pay_schedule_displayable_status_KEY AS scheduled_payroll_run_status_KEY
, description
FROM
dbo.Client_Pay_Schedule_Displayable_Status
WHERE
client_pay_schedule_displayable_status_KEY != 6 AND client_pay_schedule_displayable_status_KEY != 10
UNION
SELECT
client_pay_schedule_status_KEY AS scheduled_payroll_run_status_KEY
, description
FROM
Client_Pay_Schedule_Status
WHERE
client_pay_schedule_status_KEY = 6
UNION
SELECT *
FROM (VALUES (11, N'Printed'),
(12 , N'Unprinted'),
(13 , N'Partially printed')) V (scheduled_payroll_run_status_KEY, description)