all data is live and searchable



« Back . [new search - developer's notebook] . [new search - adilas community funded projects]
Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Yellow
Created By: Shannon Scoffield
Created Date/Time: 4/2/2015 12:14 pm
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
 
Time Id: 3677
Template/Type: Other Documentation
Title/Caption: Tech - Calculating State Withholding Taxes
Start Date: 3/5/2014
Main Status: Active
click to enlarge - photo by: Shannon Scoffield -
click to enlarge - photo by: Shannon Scoffield -
 

Notes:
Calculating State Withholding Taxes:
Input Values:
- State withholding initials
- Pay frequency id
- Adjusted gross pay
- Filing status id
- Pay year
- Payee allowance
- Payee dependents
- Federal adjusted amount
- State adjusted amount
Output Values:
- My ending numbers_st.statewithholding

Start with CO

Database Tables:
- Fed state allowance
- Federal tax tables
- State tax tables
- Payee
- Payee to department
- Departments
- General table

Pay frequency ids:
- 1 = Dummy
- 2 = Weekly
- 3 = Bi-weekly
- 4 = Semi-Monthly
- 5 = Monthly
- 6 = Annually
- 7 = Daily
- 8 = Quarterly
- 9 = Semi-Annually

Allowances:
Quarterly:
- 975
- 1950
- 2925
- 3900
- 4875
- 5850
- 6825
- 7800
- 8775
- 9750
Semi-Annual:
- 1950
- 3900
- 5850
- 7800
- 9750
- 11700
- 13650
- 15600
- 17550
- 19500
Single:
- Quarterly – 550
- Semi-annual – 1100
Married:
- Quarterly – 2075
- Semi-annual – 4150
State tax calcs