| View: dbo.Client_Payroll_Item_View | |||
| View definition | |||
|
CREATE VIEW dbo.Client_Payroll_Item_View AS SELECT CP.*, -- This column is included to support filter formula as well as to handle active and inactive status. active_status_KEY = CP.inactive + 1 FROM dbo.Client_Payroll_Item CP | |||