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