View: dbo.Client_Pay_Schedule_Detail_View
View definition
create view dbo.Client_Pay_Schedule_Detail_View
as
select CPSD.*
, client_pay_schedule_displayable_status_KEY =
(
CASE
WHEN CPSD.client_pay_schedule_status_KEY IN (3,4,5,11) THEN 3
ELSE CPSD.client_pay_schedule_status_KEY
END
)
from
dbo.Client_Pay_Schedule_Detail CPSD