Payroll Fica Variation - Calculated vs. Actual - DataScope

This query is good for diagnosing Fica tax discrepencies between withheld amounts and calculated amounts.

select 'A' "AC",CAST(H.DEF_ID AS CHAR(20)) "Def ID",TRX_DATE,DEF_value,EMP_ID from prtempdefhst H
where trx_date between :"Beg Date" and :"End Date"
and def_id in ('SSTAX','MCTAX')  AND EMP_ID BETWEEN :"Beg Emp" and :"End Emp"
UNION 
select 'C' "AC",CAST ('MCTAXCALC' AS CHAR(20)),TRX_DATE,-DEF_value*.0145,EMP_ID from prtempdefhst H
where trx_date between :"Beg Date" and :"End Date"
and def_id in ('MCGROSS') AND EMP_ID BETWEEN :"Beg Emp" and :"End Emp"
UNION 
select 'C' "AC",CAST ('SSTAXCALC' AS CHAR(20)),TRX_DATE,-DEF_value*.062,EMP_ID from prtempdefhst H
where trx_date between :"Beg Date" and :"End Date"
and def_id in ('SSGROSS')  AND EMP_ID BETWEEN :"Beg Emp" and :"End Emp"