Created
August 8, 2019 17:21
-
-
Save bberman/f139f1926495ccdb19235da17d528e96 to your computer and use it in GitHub Desktop.
Quarterly Adjust Cheat Sheer
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--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 | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment