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