Where can I find the new W-4 Amounts in the CRE PR Tables?

I am trying to figure out where the new W-4 Amounts are stored in the CRE database tables.  The new amounts such as deductions, other income show up as only a single character field in the master 'PR Employee' table.  There must be a table that ties to these amounts using the employee as the primary key.  I'm working on a report to send to employees so they can verify the information in our file and I'd like to pull the new 'W-4 Amounts' onto the report.  Any ideas would be appreciated!

  • 0

    Hi Jason,  The settings associated with the Employee's elections documented on Federal form W-4 are recorded and stored primarily on the PR Employee record in 4 fields: Use W-4 Amounts is a check box field, when checked indicates employee has submitted the 2020 W-4 form and enables three additional fields to be populated named:  Dependents, Other Income and Deduuctions.  If the Use W-4 Amounts check box is not marked, the additional 3 boxes are greyed out. Payroll uses these settings in conjunction with the Filing status to calculate federal withholding.  If the Use W-4 amounts box is checked the Exemption box on the setup of the employee is ignored, and tells Payroll to calculate the exempttions and credits based on the information using the new fields based on the formula set on the FWH tax rate asociated with the filing status set on the employee.  There are additional settings stored in the PR Employee tax to set an adjustment method for the tax, for example when employee elects an additional withholding amount for the tax.