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