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