cv304
9/10/2017 - 4:43 PM

Sick time used

Ajera-employee-sickused.sql
content_copyfile_download
(Select isnull(SUM(tunits),0.00) from AxTransaction 
JOIN AxProject on tproject = prjkey
JOIN AxVEC on temployee = veckey
where veckey = [Employee Key]
and tiscurrent = 1
and tpay = 7
and tdate between {STARTDATE} and {ENDDATE})