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) | |||