Quarterly Adjust Cheat Sheer

gistfile1.txt

--SELECT QUERY:

select

    EmployeeTaxFormWageExcess.employeeid,
    taxtype.taxpayer,
    taxtype.taxtype,
    EmployeeTaxFormWageExcess.taxtypeid,
    EmployeeTaxFormWageExcess.quarter1_taxowed,
    employee.hiredate,
    employee.terminationdate,
    employee.active,
    employee.includeinpayroll,
    employee.email,
    employee.firstname,
    employee.lastname,
    employee.clientid,
    client.clientname

    from EmployeeTaxFormWageExcess

    join taxtype on taxtype.taxtypeid = EmployeeTaxFormWageExcess.taxtypeid

    join employee on employee.employeeid = EmployeeTaxFormWageExcess.employeeid

    join client on client.clientid = employee.clientid

    where quarter1_taxowed >= 0.05
    and quarter1_taxowed < 5000
    and taxyear = 2019
    and EmployeeTaxFormWageExcess.taxtypeid in (194,114,115,144,200,190,129,156,149,150,131,148,147,121,134,109,39,168,139,195,138,137,132,140,166,103,135,106)

    and client.clientid in ( select distinct clientid from paycycle as pc
      where pc.status = 'Paid' and ismanual = 0 and isytdtotal = 0)


    and client.istestclient = 0

    order by taxtype asc